Site Rollback Information, please read!

Fruity Snacks

Creator of blackholes & memes. Destroyer of forums
aa
Sep 5, 2010
6,394
5,571
Yeah, but... what was the error. I'm interested in the specifics. It's not a big deal, don't worry about it. It was just passing curiosity.

Basically, I was merging the 2 CSGO subforums together, then have them redirect to the new csgomaps.net. Somewhere in the process, it thought that I had checked ALL of the subforums (not just 2 of them), and as such, moved all their threads into the CSGO Mapping discussion subforum.

Don't know what happened, all I know is that I was doing something right (according to the instructions I was doing it right) and it came out wrong.

Completely an accident on my end, and as such I'll help clean up the mess the best I can.
In retrospect though, it is kind of funny.
 
Last edited:

tyler

aa
Sep 11, 2013
5,102
4,621
Ah, okay. Thanks for that and thanks for helping to fix it. Kind of crazy that there's no "Are you sure you want to move twenty thousand threads together?" warning popup. I'm glad it was user error though and not like, some horrible bug that can occur when someone deletes a post or whatever.
 

drp

aa
Oct 25, 2007
2,273
2,628
Ah, okay. Thanks for that and thanks for helping to fix it. Kind of crazy that there's no "Are you sure you want to move twenty thousand threads together?" warning popup. I'm glad it was user error though and not like, some horrible bug that can occur when someone deletes a post or whatever.
In my defense, Froz3n is a pikmin.
 

Fruity Snacks

Creator of blackholes & memes. Destroyer of forums
aa
Sep 5, 2010
6,394
5,571
Blue_Pikmin.jpg

Me, after realizing what I had done.

I do wish there was a "are you sure you want to move X threads" Prompt
 
Last edited:

EArkham

Necromancer
aa
Aug 14, 2009
1,625
2,773
Eh, these things happen. It's no big de-

[*]We will not be able to update your post count nor your thanks/thanked count.

AW HELL NO. Sh*t just got real. I will hate you until the heat death of the universe!!!



No, really, it happens. Not like actual map work was lost or something. Thanks for your continued work at restoring. :)
 

pl

L5: Dapper Member
Mar 6, 2009
248
55
Thanks for letting us know what happened! Hope restoration goes well, and I hope it won't be too painful also :)

No idea if you've thought of this, but each thread's record in the DB might give hints as to what subforum they're in?
 

Fruity Snacks

Creator of blackholes & memes. Destroyer of forums
aa
Sep 5, 2010
6,394
5,571
Thanks for letting us know what happened! Hope restoration goes well, and I hope it won't be too painful also :)

No idea if you've thought of this, but each thread's record in the DB might give hints as to what subforum they're in?

I have a relatively good idea of what goes where based on topics, but we'll just be getting the major stuff back where it belongs. From there, we'll see about doing specifics.
 

drp

aa
Oct 25, 2007
2,273
2,628
Everyone who PM'd me about VIP. You should be set.

If you sent me something and i haven't responded. Please do so again.

If you still haven't sent me anything to begin with, please send it!

Thanks again and sorry about this :(
 

grazr

Old Man Mutant Ninja Turtle
aa
Mar 4, 2008
5,441
3,814
FYI As punishment we've banned Frozen from the apple pie we keep stocked in the staff area.

We're hoping this'll make him think twice before doing what ever it was he did that made stuff happen how we didn't want it to happen.
 

Fruity Snacks

Creator of blackholes & memes. Destroyer of forums
aa
Sep 5, 2010
6,394
5,571

henke37

aa
Sep 23, 2011
2,075
515
I still think that my solution of automatically moving things back with a SQL query would have been better. A few weeks worth of posts is easily sorted as opposed to everything ever made.
 

drp

aa
Oct 25, 2007
2,273
2,628
Judge reviews coming soonish? I'd like to re-read them and start repairing frostfell.
Today after work, i will start setting up a copy of the forum as it existed 2 days ago. Froz3n will start pasting some stuff back.
 

grazr

Old Man Mutant Ninja Turtle
aa
Mar 4, 2008
5,441
3,814
Quick question: How come this thread doesn't appear in the today's posts section? I ask I know a few people didn't spot the announcement.

Do you mean on the front page? Not all forum areas show up there.
 

Pocket

Half a Lambert is better than one.
aa
Nov 14, 2009
4,694
2,579
Basically, I was merging the 2 CSGO subforums together, then have them redirect to the new csgomaps.net. Somewhere in the process, it thought that I had checked ALL of the subforums (not just 2 of them), and as such, moved all their threads into the CSGO Mapping discussion subforum.

Ah. So it sounds like my guess was partially right; the column that holds the "what forum does this thread go in" ID had all of its values set to the same number. I bet that could have been fixed with a little SQL-fu without resorting to rolling back the whole forum, honestly. It would just be a matter of copying the associations from the backup and then moving the leftover threads manually.