Page 1 of 1
DB irregularity
Posted: Thu Dec 30, 2010 2:17 pm
by 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.
Re: DB irregularity
Posted: Thu Dec 30, 2010 2:48 pm
by browneyedgirl
Yep---had to login again!
No big deal.
Database irregular? Maybe it should try Ex-Lax!
Re: DB irregularity
Posted: Thu Dec 30, 2010 2:57 pm
by 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.
Re: DB irregularity
Posted: Thu Dec 30, 2010 3:35 pm
by JensJohansson
Michael Jordan wrote: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(p.post_time) + INTERVAL 12 MONTH < NOW()
AND t.topic_status = 0
Success, 3807 row(s) affected. ( Query took 0.0615 sec )
Re: DB irregularity
Posted: Thu Dec 30, 2010 10:26 pm
by ggonza43
JensJohansson wrote: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
Re: DB irregularity
Posted: Thu Dec 30, 2010 11:12 pm
by hiro23
ah I see now, thanks for letting us know
Re: DB irregularity
Posted: Fri Dec 31, 2010 1:55 am
by ext0l
JensJohansson wrote:
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(p.post_time) + INTERVAL 12 MONTH < NOW()
AND t.topic_status = 0
Success, 3807 row(s) affected. ( Query took 0.0615 sec )
Does this lock topics older than 1 year?
Re: DB irregularity
Posted: Fri Dec 31, 2010 5:26 am
by NeverendingAbyss
Re: DB irregularity
Posted: Sat Jan 01, 2011 12:47 am
by Susie
NeverendingAbyss wrote:
:w00t:
-----------------------
Oh, no wonder the forum was being kind of rabid dog yesterday...
Re: DB irregularity
Posted: Sun Jan 02, 2011 2:07 am
by 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.
Re: DB irregularity
Posted: Sun Jan 02, 2011 6:10 pm
by ggonza43
NeonVomit wrote:Ok, no I haven't even been on the forum in about a week or so, nothing important lost.
WTF?! And Elysium
?!
