PDA

View Full Version : **BIG PROBLEMS (solved)***


bi11i
04-27-2005, 11:36 AM
Beloved Opiophile.org Members,

Those of you who logged in yesterday may have noticed a post made by me concerning the upgrading of the board and some changes made to the database on which the board sits. We had lost a handful of posts because of a backup/restore issue at the fault of no one but ourselves.

So yesterday, starting at about 10amMST, the board went live again and carried on as usual. Last night, before I went to sleep I checked on the status of the database and everything looked great. No errors, no problems, nothing.

This morning when I logged in there were over 100 errors and anyone who had registered (only about 10 people) had corrupt registrations. Uploaded avatars were distorted and reputation was totally fuckered up. I shut the board off and turned to our software provider for help and found that there additional problems that we had overlooked in upgrading (bugs on the side of mySQL, which have gone on unresolved.)

In order to make board cost-effective, we run on the freely distributed mySQL database server. The benefit of this is that we don't have to pay a dime for what Microsoft otherwise charges a few hundred bucks. The downside to this and that it can be buggy, and instable.

So, on to the bullshit and bad news. The only way to absolutely ensure that our forum data is safe now and also months down the line is to restore from a copy of the database dated two days ago. This means that any posts made since 10am yesterday have been deleted (plus the posts that were deleted because of our original fuckup.)

These posts are not lost! We still have a copy of them in the rawest of forms; in a text file surrounded by other code and that sort of thing. We know how frustrating it is to have to rewrite what they had already written, so if you had posted something in the last 24 hours that you absolutely can't write again, please PM me and I'll go through the database, find your post, and email it to you in text form so you can repost it. This is the best we can do.

So I'm sure most of you are asking. "So what about tomorrow? Are you going to fuck us over again then, too?" The answer is no; I'm told and have read elsewhere (by others who have had the same problem) that we'll be ok. Can you trust us? (what did WSB say? Never trust a junky?) Sure you can, right? (right?) This should be it, I'll be kicking some ass if it isn't.

Our apologies,

Opiophile.org

p.s. -- if you're so unbelievable pissed off that you're going to blow your top, get in touch with me via PM and I'll see what i can do....

SuperJunky
04-27-2005, 03:25 PM
I know it would be time consuming but could you please just email every one thier post to redo, I can't remember what I posted, my opiated brain just dosn't keep track of things like that. Another thought would be to email every ones posts to every one so it would be easier, every one could just copy and paste they're post back up

Peripat
04-27-2005, 05:41 PM
bi11i, if there's anything I can do to help on this end (even if it's just copying and pasting everyone's posts back up), PM me. I'm going out in just over an hour, I'll be back online within eight hours (this not having a car right now business really bites the big one) but after that, I'm yours to command.

bi11i
04-27-2005, 09:17 PM
know it would be time consuming but could you please just email every one thier post to redo, I can't remember what I posted, my opiated brain just dosn't keep track of things like that. Another thought would be to email every ones posts to every one so it would be easier, every one could just copy and paste they're post back upUnfortunately, this I cannot do. Sorry.bi11i, if there's anything I can do to help on this end (even if it's just copying and pasting everyone's posts back up), PM me. I'm going out in just over an hour, I'll be back online within eight hours (this not having a car right now business really bites the big one) but after that, I'm yours to command.I wish I could do this also, but all of my management tools are setup to be made available only to me, so the outside world is shit out of luck when the time comes to start hacking...

Thanks for the offer, though!

bi11i
04-28-2005, 09:58 AM
And today, not a single problem or error. We're good to go and I can get some easier sleep.

Again, my apologies to all an thanks for hanging in there with us!

Peripat
04-28-2005, 10:10 AM
Again, my apologies to all an thanks for hanging in there with us!

It's all good, bi11i. A techie's work is never done, etc etc... ;)

Besides, why on earth would we leave - things are getting interesting! :D

bi11i
04-28-2005, 01:35 PM
Sorry for the downtime. I haven't yet finished the final phase of my expansion project, and the server took a big dive earlier today.

Data is safe though, yes? Good, good bi11i...

bi11i
04-30-2005, 02:45 AM
For those of you that noticed, the board was down tonight for another couple of hours. I was rebuilding the main server so this is now out of the way.....