Site Rollback Information, please read!

Discussion in 'Featured News' started by Fr0Z3nR, Jun 13, 2012.

  1. tyler

    aa tyler

    Messages:
    5,101
    Positive Ratings:
    4,600
    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.
     
  2. Fr0Z3nR

    aa Fr0Z3nR Creator of blackholes & memes. Destroyer of forums

    Messages:
    6,392
    Positive Ratings:
    5,469
    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: Jun 13, 2012
  3. tyler

    aa tyler

    Messages:
    5,101
    Positive Ratings:
    4,600
    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.
     
  4. drp

    aa drp

    Messages:
    2,264
    Positive Ratings:
    2,603
    In my defense, Froz3n is a pikmin.
     
    • Thanks Thanks x 1
  5. Fr0Z3nR

    aa Fr0Z3nR Creator of blackholes & memes. Destroyer of forums

    Messages:
    6,392
    Positive Ratings:
    5,469
    [​IMG]

    Me, after realizing what I had done.

    I do wish there was a "are you sure you want to move X threads" Prompt
     
    • Thanks Thanks x 1
    Last edited: Jun 13, 2012
  6. EArkham

    aa EArkham Necromancer

    Messages:
    1,599
    Positive Ratings:
    2,354
    Eh, these things happen. It's no big de-

    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. :)
     
  7. Fr0Z3nR

    aa Fr0Z3nR Creator of blackholes & memes. Destroyer of forums

    Messages:
    6,392
    Positive Ratings:
    5,469
    UPDATE: Included in the current loss is member registration. Might be able to get that back.
     
  8. pl

    pl L5: Dapper Member

    Messages:
    248
    Positive Ratings:
    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?
     
  9. Deodorant

    Deodorant L6: Sharp Member

    Messages:
    263
    Positive Ratings:
    214
    So I just lost all the thanks I received by posting that layout sketch dong? Damn. I guess I just have to start being helpful or make cool stuff or something. Sigh.
     
  10. Fr0Z3nR

    aa Fr0Z3nR Creator of blackholes & memes. Destroyer of forums

    Messages:
    6,392
    Positive Ratings:
    5,469
    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.
     
    • Thanks Thanks x 1
  11. drp

    aa drp

    Messages:
    2,264
    Positive Ratings:
    2,603
    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 :(
     
  12. grazr

    aa grazr Old Man Mutant Ninja Turtle

    Messages:
    5,437
    Positive Ratings:
    3,780
    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.
     
    • Thanks Thanks x 1
  13. Fr0Z3nR

    aa Fr0Z3nR Creator of blackholes & memes. Destroyer of forums

    Messages:
    6,392
    Positive Ratings:
    5,469
    NOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO
     
    • Thanks Thanks x 1
  14. Tom Hoen

    Tom Hoen L6: Sharp Member

    Messages:
    320
    Positive Ratings:
    306
    Judge reviews coming soonish? I'd like to re-read them and start repairing frostfell.
     
    • Thanks Thanks x 1
  15. henke37

    aa henke37

    Messages:
    2,023
    Positive Ratings:
    487
    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.
     
    • Thanks Thanks x 1
  16. Boylee

    aa Boylee pew pew pew

    Messages:
    1,068
    Positive Ratings:
    696
    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.
     
  17. zpqrei

    aa zpqrei Theme Changer Extraordinaire

    Messages:
    1,067
    Positive Ratings:
    1,141
    I'm just glad I wasn't given this level of power when I was staff. This shit would've happened regularly.
     
  18. drp

    aa drp

    Messages:
    2,264
    Positive Ratings:
    2,603
    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.
     
    • Thanks Thanks x 1
  19. grazr

    aa grazr Old Man Mutant Ninja Turtle

    Messages:
    5,437
    Positive Ratings:
    3,780
    Do you mean on the front page? Not all forum areas show up there.
     
  20. Pocket

    aa Pocket Ya like Jazz?

    Messages:
    4,511
    Positive Ratings:
    2,398
    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.