Hard Light Productions Forums

Site Management => Site Support / Feedback => Topic started by: Zacam on November 30, 2012, 02:15:23 am

Title: Broken Posts? Link them here!
Post by: Zacam on November 30, 2012, 02:15:23 am
So, as a side effect of the announced unexpected downtime that was either caused by or not helped by the database corruption, the restoration and upgrade process apparently aet some post content.

If you find such a post, link to it here and we'll follow up with getting it restored.

(Admins: If you could be so kind if you handle one to edit the report post to strike it through to prevent duplication for no reason, that would be great!)
Title: Re: Broken Posts? Link them here!
Post by: Mongoose on November 30, 2012, 02:58:57 am
Mentioned these in the Announcements thread, but just to get everything in one place:

Link 1 (http://www.hard-light.net/forums/index.php?topic=79476.msg1572967#msg1572967)
Link 2 (http://www.hard-light.net/forums/index.php?topic=74745.msg1477326#msg1477326)

Thank you! Done. Z
Title: Re: Broken Posts? Link them here!
Post by: FreeSpaceFreak on November 30, 2012, 11:33:41 am
The interview board was hit pretty bad. See here (http://www.hard-light.net/forums/index.php?topic=79008.0), here (http://www.hard-light.net/forums/index.php?topic=75629.0) and here (http://www.hard-light.net/forums/index.php?topic=68100.0), and quite probably more.

Grabbed. Thank you. Z
Title: Re: Broken Posts? Link them here!
Post by: The_Force on November 30, 2012, 11:46:06 am
There's one or two in the HLP-Xcom threads.
Title: Re: Broken Posts? Link them here!
Post by: Scourge of Ages on November 30, 2012, 02:15:39 pm
There's one or two in the HLP-Xcom threads.

Woah! About 70% of my posts from this thread (http://www.hard-light.net/forums/index.php?topic=79806.0) have been truncated (you can tell because there's no punctuation on the end). Is that enough to go by, or would you like links to every post?

Took a while, but I got them. I think. Z
Title: Re: Broken Posts? Link them here!
Post by: MatthTheGeek on November 30, 2012, 02:25:59 pm
This one too. (http://www.hard-light.net/forums/index.php?topic=74974.msg1482674#msg1482674)

Arigato. Z
Title: Re: Broken Posts? Link them here!
Post by: FreeSpaceFreak on December 01, 2012, 05:33:02 am
And here (http://www.hard-light.net/forums/index.php?topic=77153.msg1532395#msg1532395), it seems.

Corrected, thank you. Z
Title: Re: Broken Posts? Link them here!
Post by: mjn.mixael on December 04, 2012, 09:01:10 am
This (http://www.hard-light.net/forums/index.php?topic=79560.msg1576825#msg1576825) one needs help.

Should be OK now. - Rev
Title: Re: Broken Posts? Link them here!
Post by: Lucika on December 04, 2012, 11:40:48 am
This (http://www.hard-light.net/forums/index.php?topic=71940.msg1421672#msg1421672) and this (http://www.hard-light.net/forums/index.php?topic=72523.msg1432880#msg1432880).

Both should be good to go.  - Rev
Title: Re: Broken Posts? Link them here!
Post by: mjn.mixael on December 04, 2012, 01:40:25 pm
This (http://www.hard-light.net/forums/index.php?topic=79560.msg1576825#msg1576825) one needs help.
How is that?
Fixed.
Title: Re: Broken Posts? Link them here!
Post by: FreeSpaceFreak on December 09, 2012, 10:36:33 am
Here (http://www.hard-light.net/forums/index.php?topic=79501.0), on one of the internal mod boards.

Is a restore-all solution in the works?

Edit:  Should be fixed now, and I believe goober was looking at a way to try and do a compare and fix thing - Rev
Title: Re: Broken Posts? Link them here!
Post by: jg18 on December 10, 2012, 12:24:17 am
This is admittedly pretty minor :nervous: but my "Whatcha Listenin' To? (http://www.hard-light.net/forums/index.php?topic=79535.0)" thread used to be called "Whatcha Listenin' To? © 2012". I guess the "© 2011" similarly went missing from Bob-san's thread from last year (http://www.hard-light.net/forums/index.php?topic=73654.0).

Edit:  Fixed titles on both - Rev
Title: Re: Broken Posts? Link them here!
Post by: Goober5000 on December 12, 2012, 12:56:12 am
In order to do a compare-and-fix, I need copies of both the backed-up table and the current table. :nervous:  I was going to download them myself, but was wary of freezing the forums.  If you can send me just smf_messages, Rev, I can start something.
Title: Re: Broken Posts? Link them here!
Post by: mobcdmoc3 on December 14, 2012, 10:25:10 am
http://www.hard-light.net/forums/index.php?topic=81319.0

This should be good now - Rev
Title: Re: Broken Posts? Link them here!
Post by: rev_posix on December 17, 2012, 12:32:31 pm
In order to do a compare-and-fix, I need copies of both the backed-up table and the current table. :nervous:  I was going to download them myself, but was wary of freezing the forums.  If you can send me just smf_messages, Rev, I can start something.
I would have to pull a copy of the DB just like you would.  I would say your best bet would be to ssh in and get a dump via mysqldump then scp it to your local machine.  No matter how you slice it, it's 'prolly going to lag things a bit, but mysqldump should be the least impacting.
Title: Re: Broken Posts? Link them here!
Post by: Goober5000 on December 17, 2012, 05:23:59 pm
When is the least active time of day, then?
Title: Re: Broken Posts? Link them here!
Post by: rev_posix on December 17, 2012, 08:00:13 pm
When is the least active time of day, then?
Your guess is as good as mine on that one, being that the community is international, therefore 24/7
Title: Re: Broken Posts? Link them here!
Post by: niffiwan on December 17, 2012, 08:26:31 pm
ionice -c3 mysqldump?
rsync --bwlimit=512 -avP? (or scp -l if pscp.exe or similar support it)

Those are some of the tricks I use when I need to pull large amounts of data from a "sensitive" server... although obviously it can take ages to complete.

Title: Re: Broken Posts? Link them here!
Post by: The_Force on December 18, 2012, 02:51:22 pm
Shdow wolf's gimpscapeing tutorial is gone http://www.hard-light.net/forums/index.php?topic=81249.0

Edit: fixed - Rev
Title: Re: Broken Posts? Link them here!
Post by: MatthTheGeek on December 30, 2012, 08:52:11 am
Some internal BP thread. (http://www.hard-light.net/forums/index.php?topic=82357.msg1642431#msg1642431)
Title: Re: Broken Posts? Link them here!
Post by: The E on December 30, 2012, 08:52:44 am
This rather important post (http://www.hard-light.net/forums/index.php?topic=63783.0) is also broken.
Title: Re: Broken Posts? Link them here!
Post by: Black Wolf on January 05, 2013, 11:13:33 am
My release threads first post here - http://www.hard-light.net/forums/index.php?topic=81207.msg1618202#msg1618202
Title: Re: Broken Posts? Link them here!
Post by: Mongoose on January 06, 2013, 09:03:58 pm
Just found a bunch of borked posts in a BP thread, starting with this one (http://www.hard-light.net/forums/index.php?topic=72393.msg1635971#msg1635971) and followed by several others that quote it.
Title: Re: Broken Posts? Link them here!
Post by: Goober5000 on January 07, 2013, 10:18:30 pm
It turns out there are over 19,000 broken posts total.  A solution is in progress.
Title: Re: Broken Posts? Link them here!
Post by: Goober5000 on January 20, 2013, 02:01:08 am
All broken posts should now be restored.  See the announcement (http://www.hard-light.net/forums/index.php?topic=83466.0) for more details.