DB irregularity

[JensJohansson]

The forum database became corrupt in some mysterious way, and I had to go back to a snapshot which was 24 hours in the past. Thus, basically anything that happened the last 24 hours is not visible anymore.

I do have a copy also of the last 24h of activity but inserting this data is a bit messy, so tough cookies. It looks something like (very appx) 180 posts, one new topic and 6 PM's. If you changed your avatar or put someone on ignore the last 24h you may have to redo it. (And of course other shit like the sessions/ session cookies might be all fucked up so you may have to log in again.)

If anyone feels there was anything super important in any of this data that you would like to recover, send me an email.

[browneyedgirl]

Yep---had to login again! No big deal.

Database irregular? Maybe it should try Ex-Lax!

[Michael Jordan]

It looks like Arnold Layne bumped 30 threads from 6 or 7 years ago.(2 times in a row) Maybe it's his fault.

[JensJohansson]

It looks like Arnold Layne bumped 30 threads from 6 or 7 years ago.(2 times in a row) Maybe it's his fault.

Naw. But anyway maybe

Code: Select all

UPDATE phpbb_posts AS p, phpbb_topics AS t
  SET t.topic_status = 1
WHERE p.post_id = t.topic_last_post_id
  AND FROM_UNIXTIME&#40;p.post_time&#41; + INTERVAL 12 MONTH < NOW&#40;&#41;
  AND t.topic_status = 0

Success, 3807 row&#40;s&#41; affected. &#40; Query took 0.0615 sec &#41;

[ggonza43]

The forum database became corrupt in some mysterious way, and I had to go back to a snapshot which was 24 hours in the past. Thus, basically anything that happened the last 24 hours is not visible anymore.

Ah! That's why, thanks for the info Jens . And you know, for being an administrator you are a great keyboardist . But seriously, I know it's a pain in the ass when that happens

[hiro23]

ah I see now, thanks for letting us know

[ext0l]

Code: Select all

UPDATE phpbb_posts AS p, phpbb_topics AS t
  SET t.topic_status = 1
WHERE p.post_id = t.topic_last_post_id
  AND FROM_UNIXTIME&#40;p.post_time&#41; + INTERVAL 12 MONTH < NOW&#40;&#41;
  AND t.topic_status = 0
Success, 3807 row&#40;s&#41; affected. &#40; Query took 0.0615 sec &#41;

Does this lock topics older than 1 year?

[NeverendingAbyss]

[Susie]

:w00t:
-----------------------

Oh, no wonder the forum was being kind of rabid dog yesterday...

[NeonVomit]

Ok, no I haven't even been on the forum in about a week or so, nothing important lost. I've just been waiting for a chance to use that picture.

[ggonza43]

Ok, no I haven't even been on the forum in about a week or so, nothing important lost.

WTF?! And Elysium ?!