Time Machine

The forum · September 2003 – July 2004 › NEWS

Forum DB messed up! (Back on track!)

DB Crash after minor update...

Started by Alle · 16 posts · 145 views · this thread in the Internet Archive

  1. Alle13 Oct 2003, 21:48
    As you probably noticed the forum went down the drain AGAIN! :throwup:

    The reason for this is partially me and also due to disfunctional add-on.

    I was installing a modification that would add a pretty funny looking shop allowing users to gain credits from posts & misc activity, using the credits to buy 'forum functions' - Trust me, it would've been hillarious.

    Anyways - what happend was that when the manual installation was done, the SQL entries for the new modification jamed up the DataBase. Naturally, I backed up the whole forum before I started the installation, and also afterwards. So when the forum wouldn't work after the installation I started to reverse the process - And when that wouldn't work I re-installed the forum, and started to re-create the DB from the backups I made.

    Now here's what really fucked things up... The backup tool timed out due to a database time-out, right after the skin_templates table, and not only once but for both my backups! It's allright to loose the skins as they're easy to install, however I lost the all important 'topic name / id' data wich is very much needed.

    All 890 posts where saved along with all member & pm data, however the post data is of no use unless you have the topic id data (post data is related with topic_id and needed to view topic content).


    I'm not sure what to do next, but I do know for sure that I was on my way to jump out the window when I found out what's been lost...

    I'm sorry guys but I simply can't re-create what's been lost... Surely I can recreate the topic ID's but I can't assign them to the correct category, forum, topic starter, topic start date, number of replies, number of views... etc. Making this rather pointless...

    Skins will be re-installed ASAP, however I'm about to burst right now from anger & disapointment... And I'll surely get in touch with the 'genious' who created the mod I was trying to install.

    Best,

    Alex
  2. DJ Bluey13 Oct 2003, 22:15
    :o Aww, I'm sorry that all this crap always has to happen. :angry: But it's not like we haven't had to "start over" before. I don't see it as a horribly devastating loss, but maybe that's because I don't post as often as other members do. So yeah, whatever, just give that 'genius' a talking to.

    -Dj Bluey
  3. DjDaed13 Oct 2003, 23:02
    Great to hear your back up and running again Alle.
  4. MiGhTy-MaX14 Oct 2003, 01:02
    Indeed... the twerp needs a good talking to. Obviously the SOB hasn't worked out all of the bugs in his coding... And that's why you never release something that hasn't been reviewed or tested... Regardless, it's good to see the quick action taken by you. Cheers!
  5. Alle14 Oct 2003, 01:07
    A simple reply to the topic seem to work to make it go online!!!

    Help me out there guys!

    Post a reply to the topic with where it's supposed to be and what topic it should have...

    LOCATION: General, News, Off Topic, Music Talk etc...

    //Alex
  6. Alle14 Oct 2003, 02:09
    And oh! Let me know if you want to become a moderator and help out with renaming and moving all the topics to the right place...
  7. Alle14 Oct 2003, 02:46
    Skins Re-Installed, let me know of any problems or missing skins...

    //Alex
  8. Alle14 Oct 2003, 04:40
    FORUM BACK ON TRACK!

    With the great help from the moderating team the forum is now back as it where... We found a way to recover lost topics and been working on this for several hours now. Many of your topics may not have the same name they had in the first place, or even be in the same part of the forum... However I think you as a user have the right to change the name of the topics you started...

    With this I also deeply want to thank the guys who helped me out during the night:

    Ballistic Solution
    Mighty Max
    Trancefuzion

    If I could I'd give you a medal for your work!

    Best,


    Alex
  9. OldDude14 Oct 2003, 04:48
    Alle,

    Glad to see the forum up and running again. You can add my thanks to you, Ballistic Solution, Mighty Max and Trancefuzion. But don't feel too bad about having it crash. You know the old saying "To err is human to really screw up takes a computer". Or a dude who sends out programs that aren't fully tested. Be sure you really give the guy an earfull when you get a chance.

    :devil2: Rick :devil:
  10. Alle14 Oct 2003, 04:51
    Yeah, well I can't just send all the blame to the kid who wrote the add-on for the board - I'm pretty sure I made my share of misstakes as well.

    Either way, we're back now and I'm happy once more ;)
  11. Digital Beat14 Oct 2003, 06:36
    Well, now the forum is up again and looking great :)
  12. Alle14 Oct 2003, 06:37
    I know, I just want a daily DB Backup in case something goes wrong again...
  13. BALLISTIC SOLUTION14 Oct 2003, 06:48
    OldDude wrote:Alle,

    Glad to see the forum up and running again.  You can add my thanks to you, Ballistic Solution, Mighty Max and Trancefuzion.  But don't feel too bad about having it crash.  You know the old saying "To err is human to really screw up takes a computer".  Or a dude who sends out programs that aren't fully tested.  Be sure you really give the guy an earfull when you get a chance.

    :devil2: Rick  :devil:

    you're very welcome rick B) i tell you what, it was a fairly long couple of hours, but a very rewarding experience :D . hope i got your post right :)
  14. MiGhTy-MaX14 Oct 2003, 07:54
    Well, I can only say that I did what I could. I've done this for a living, so I'm used to it. Great to have the forum on track, and hopefully all will be well in days to come. May we enjoy the forum once again!
  15. TranceSynthVania14 Oct 2003, 08:05
    Believe me, I would be more than happy to help out, but I couldn't access the forum while it was down! I got quite a variety of errors while I was desperately trying to get in, but after some time I gave up :P
    But good you other guys could fix it! Thanks!
  16. Trancefuzion14 Oct 2003, 15:52
    OldDude wrote: Alle,

    Glad to see the forum up and running again. You can add my thanks to you, Ballistic Solution, Mighty Max and Trancefuzion. But don't feel too bad about having it crash. You know the old saying "To err is human to really screw up takes a computer". Or a dude who sends out programs that aren't fully tested. Be sure you really give the guy an earfull when you get a chance.

    :devil2: Rick :devil:

    You're welcome. Always glad to help when i can! B)