RF Generation.  The Classic and Modern Gaming Databases.RF Generation.  The Classic and Modern Gaming Databases.

Posted on Nov 26th 2011 at 08:32:18 PM by (Shadow Kisuragi)
Posted under Site Downtime, Site Issues

Sorry for the site downtime last night. I was editing the database directly and looking for a Variation Tie-in that I wanted to delete. Instead of deleting the one particular tie-in though, I ended up deleting every Variation Tie-In! When I tried to fix it, the server freaked out and died.

Fortunately, Dave (TraderJake) and Eddie (St0rmTK421) were able to properly restore the Variation Tie-Ins from an old backup and bring the site back online. Unfortunately, the data backup for this was from February, which means that we've lost a total of ~4500 tie-ins.

I'm going to talk with Dave and Eddie on how we can prevent this from happening in the future. In the meantime, I'll work on updating all of the tie-ins in the database over the next month while in my own little corner of shame...

Sorry for the inconvenience, everyone.

- Shadow

Permalink | Comments [11] | Digg This Article |

Recent Entries
Why Do We Collect Video Games In 2018? (6/18/2018)
Perfect Sequels: Zone of the Enders l Review The PS2 (6/15/2018)
Where are all the mothers in video games? (6/13/2018)
All Our News Are Belong To You: June 2018 Edition (6/11/2018)
Dramatic Readings Ep 019 - Pit-Fighter (6/9/2018)

Why I oughtta...

Ah well Shadow, we all screw up. Stuff happens.
That would be funny if it werent so darn sad
That funny part is that I first contacted Tynstar and told him I deleted all the variations. He was happy up until the part where I told him the server died as a result.
Sheesh... you guys try to add that type-of-release feature to the database, and all hell breaks loose.

Kinda makes me wonder if you shouldn't just leave well enough alone... ;p
Hmmm, I don't really remember much of database classes anymore. I guess a simple rollback was out of the question?

Whatever the case, there should probably be more than 1 backup every 10 months or so...or there should be a warning system in place that says "Hey! You there! You're trying to remove more than 100 entries in the DB at once! Are you sure about that?"
...Ouch.  Oh well.  Guess I need to go back through the 64 database again.  Smiley
It warned me, but it warns about any destructive action, so you learn to ignore those warnings. I just missed the command it was running. If I had done it by hand, this wouldn't have happened...therefore, I'm doing everything by hand now.

As for a backup, Eddie's looking into it.

It's just Variation Tie-Ins that you need to concern yourself with in that case. N64 only really had regional Variation Tie-Ins and Best Seller Tie-Ins, and there weren't that many titles, so it would likely only take a couple hours to fix.
@Shadow Kisuragi: Don't worry too much about it. As you say they're only Variation Tie-Ins and not actual variants/games. And you can just re-do the work, I guess. Doing everything by hand seems like a good idea.

Making a big mistake is always the best lesson to never make the same mistake again, so I'm this won't happen to you again. Tongue

Perhaps there should be a better warning system though, because who knows another staff member might have the same thing happen to them?
Still not as bad as me driving over the count them, not one, but two stall dividers on Halloween...
@diedraneous - Very true lead foot
Oh god, I'm sorry. :[ That kind of shit can be heartbreaking.

Don't worry. We can rebuild it. Stronger, better, faster...etc. etc.

Yeah, the warnings fading into the background are an issue. At my friend's workplace, posters with important messages are changed and moved periodically to prevent just that. Turns out that people pay attention to the posters...so long as they change. Otherwise, they become part of the background scenery.

 Login or register to comment
It appears as though you are not a member of our site, or are not logged in.
It appears as though you can not comment currently. Becoming able to comment though is easy! All you need to do is register for the site! Not only will you be able to access any other site features including the forum and collection tools. If you are a registered user and just need to login then you can do so here.

Comment! It's easy, thoughtful, and who knows you might just enjoy it!
Login / Register
Not a member? Register!
Database Search
Site Statistics
Total Games:
Total Hardware:
Total Scans:
Total Screenshots:
[More Stats]
Our Friends
Digital Press Video Game Console Library NES Player The Video Game Critic Game Rave Game Gavel Cartridge Club Android app on Google Play RF Generation on Discord
Updated Entries


North America

North America

France, Germany, Italy, United Kingdom


North America

Region Free
Updated Collections
New Forum Topics
New on the Blogs
Nielsen's Favorite Articles

Site content Copyright © rfgeneration.com unless otherwise noted. Oh, and keep it on channel three.