: Database errors


Kooldino
09-04-2008, 03:20 AM
In case you're wondering where we've been for the past couple of days, we've been dealing with database issues due to a server catastrophe from dreamhost.com

They somehow hosed all of our backups since June 5th, so we're currently running on a 3 month old backup.

You may have to sign up again, and 3 months of posts have been lost.

I'm doing everything I possibly can to resolve these issues and get our data back. I'll keep everyone posted.

Nero
09-04-2008, 03:43 AM
damn them all!


keep up the work dino, we'll keep postin'

MEVOX
09-04-2008, 03:54 AM
Good luck to us all.:bowlol:

ak47m203
09-04-2008, 05:33 AM
yeah that sucks because this is my only active evo forum, sometimes evo m. good to be back. i think were back to stoneage.

USLegalTender
09-04-2008, 06:30 AM
Wow, this is my first post in nerely a month (or so it's felt) and I have to say I'm somewhat releived! This is the ONLY forum that I read all posts in, so seeing that there's only 2 pages of unviewed threads, I feel great!

Good luck with all of the lost info/users though Kool. Sorry to hear about the troubles.

DirectorSe7en
09-04-2008, 06:32 AM
lolz

on2it
09-04-2008, 06:37 AM
hey I feel like a new man with only 900 posts... :) Good luck Dino. Kick their butts.

on2it
09-04-2008, 06:49 AM
Dino if a restore is possible, would that mean loosing whatever posts we post btwn now and then as well?

Nero
09-04-2008, 06:54 AM
man i was almost an x-phile....i jus thought about it...damn them!

kodlan
09-04-2008, 08:16 AM
hey I feel like a new man with only 900 posts... :) Good luck Dino. Kick their butts.
900 posts... :bowlol:. I've lost my few posts, and I had to register again

DirectorSe7en
09-04-2008, 09:13 AM
I had 1,300-ish.

Saotome9
09-04-2008, 09:56 AM
wtf I had 1,900

on2it
09-04-2008, 10:00 AM
coming up to 2000..

X-MAN
09-04-2008, 12:00 PM
I was at 3999, look at me now.lol

X-Dan
09-04-2008, 01:37 PM
DAMN....

GoKimiGo!
09-04-2008, 01:39 PM
Thank god I didn't have to register again, hope we get the info back.

BluesunsXIV
09-04-2008, 02:24 PM
wtf... 3 posts now, x-man had 4000 now 170, is that even possible? lol

BluesunsXIV
09-04-2008, 02:27 PM
wow all of our shits gone...sigh

ddawg1130
09-04-2008, 02:30 PM
WOW, seriously. WTF I was at almost 1 million posts, muhahahaha.

Actually just glad the forum is back, I was all confused about where to go the past couple days.

dcasandman
09-04-2008, 02:37 PM
I was a mod now Im just a memeber lol. Also lost a solid 1200 posts.

xPRimNT
09-04-2008, 02:45 PM
Shit happens.

Good luck Dino!

EVO-R
09-04-2008, 02:57 PM
I'm back to the future...

B1GHAM
09-04-2008, 03:07 PM
Just checking in....

that sucked

Mr. Win
09-04-2008, 03:36 PM
Hmm... not much change for me. It really cleaned out the Marketplace. lol

Tunerhead
09-04-2008, 03:47 PM
Had some dealing with database errors in the past...............No Fun! :mad:

Rosshole
09-04-2008, 03:59 PM
wow, good to be back.

jamdread
09-04-2008, 03:59 PM
Pretty sure I had well over a million posts, admin privileges, and a salary from the site. Dino hook a brother up

thegame
09-04-2008, 06:51 PM
Post count check, lol

thegame
09-04-2008, 06:51 PM
Geez, I'm down to 18???

MrPurpleEvo
09-04-2008, 06:59 PM
lol damn....lol there goes my post numbers :(

UFO
09-04-2008, 09:58 PM
I was wondering why I couldn't log in.... Thought I'd been banned!

ddawg1130
09-04-2008, 10:03 PM
I was wondering why I couldn't log in.... Thought I'd been banned!

you had been, but the server crash errased the ban. don't worry, the ban is coming again.

DaemonSadi
09-04-2008, 10:17 PM
So sad! I wonder if i get to be at 666 posts again?

EvoX08
09-04-2008, 10:50 PM
i too was on my journy to x-phile,lol anyways, looks like the big green weenie has struck again. godspeed to us all on this site.and to a speedy recovery,lol

fatalwishes
09-04-2008, 11:25 PM
Hopefully things are in the works to get some, if not all the data back. Keep your fingers crossed. I only had 200 posts but a lot of my bookmarks are worthless now.

on2it
09-04-2008, 11:40 PM
bugger. all the latest Avatars are gone.

Jackygor
09-04-2008, 11:48 PM
its all a BAD BAD DREAM!

fatalwishes
09-04-2008, 11:52 PM
Just got a phone call, things are looking hopeful. Ya'll hang in there. Help is on the way.

on2it
09-05-2008, 12:50 AM
yep.. all your personal CP settings would be gone too.. so if you have turned off email notifications in the last 3 months.. you need to go back in and turn them off.... all pms also lost.. :(

fatalwishes
09-05-2008, 12:55 AM
I'm not sure the PM's will be saved. Posts and Users are what Dino is most concerned about at this time. However, I would love to be able to get the pms recovered as well. There are some big guns working on this project. Keep your fingers crossed.

Kooldino
09-05-2008, 04:14 PM
Well, so far I have some good news. I have a copy of the crashed database from the other day, and while most of the tables are filled with zeros, there are two tables that contain a lot of information.

The BIGGIE is the POST table. Not the thread table, not the forum table, etc...just a list of the raw posts.

For example, here's one of the later posts in the table:


Alright guys here's my pics from the 1st Annual EvoXForums BBQ. It was an awesome time, thanks again to Dino and crew!!! A big hello to all the cool people I met down there, hopefully we can all get together again soon, stay safe all!

http://i403.photobucket.com/albums/pp113/GoKimiGo/DSCF2184.jpg

http://i403.photobucket.com/albums/pp113/GoKimiGo/DSCF2185.jpg

http://i403.photobucket.com/albums/pp113/GoKimiGo/DSCF2188.jpg

http://i403.photobucket.com/albums/pp113/GoKimiGo/DSCF2189.jpg

http://i403.photobucket.com/albums/pp113/GoKimiGo/DSCF2190.jpg

http://i403.photobucket.com/albums/pp113/GoKimiGo/DSCF2192.jpg

http://i403.photobucket.com/albums/pp113/GoKimiGo/DSCF2196.jpg

http://i403.photobucket.com/albums/pp113/GoKimiGo/DSCF2201.jpg

http://i403.photobucket.com/albums/pp113/GoKimiGo/DSCF2203.jpg


I also have a lot of the PM table.

The issue is that some tables that depend on each other are corrupt, which prevents us simply from importing what's good out of the corrupt tables.

My thought at this point is to basically make a bot that reads in all of the PMs and posts and makes NEW posts in the system with the data we have, and to have that bot act as the user who posted it. If we could pull this off, the posts would exist, but the post dates would be wrong (since they would be new posts), but that's minor. My main concern is gathering chunks of posts and making complete threads out of them, and getting those threads to the proper subforum. That may have to be done manually.

Time will tell. But at minimum, we have a lot of post and PM information. The post information is my #1 priority.

SpicyMchaggis
09-05-2008, 04:24 PM
Thats actually a really good idea.

SATimko
09-05-2008, 04:33 PM
Glad to hear there's progress coming.

Yxd68
09-05-2008, 05:06 PM
On, Wayne!

RGory477
09-05-2008, 05:36 PM
I was getting closer to my 1000th post....now its 510...ouch haha o well, only thing that sucks is loosing all those pics and vids and good info!

EvoXstylin
09-05-2008, 07:58 PM
Oh damn I consider myself lucky I only had about 80. I think I would have some major issues if I lost thousands.

flagg77
09-05-2008, 08:02 PM
Nice. Gets back some of the content that makes this such a valuable site / community.

/preaches to choir
seriously though, whole tables full of 0's? Jesus F'ing.... can your hosting company take some initiative and do some root cause analysis? If it happened once, it can happen again unless the root cause is determined and addressed. I work in the financial industry in a hosting facility type environment. If we filled a customers database with 0's.....

:whipping:


^ and that would be them just warming up.

kevo-x
09-05-2008, 08:42 PM
wow... this sucks! it's like i never existed... do i get to do an intro thread again? ;)

p.s. do you uh, want a new host? i do happen to work for an ISP/co-location provider :) I have a pretty sweet FreeBSD box I could put this site on, let me know if interested.

Kev

Jackygor
09-05-2008, 11:05 PM
Progress is good! I heard a lot of people lost their un-read PMs!

GoKimiGo!
09-05-2008, 11:25 PM
Woo Hoo!!! That was my post! Hehe :godance:

I lost a lot of PMs with information but it isn't a big deal. The important thing is that we are back up and running, if it isn't possible to recover all that data it isn't the end of the world. We appreciate all your hard work Dino!

flagg77
09-06-2008, 01:40 AM
Woo Hoo!!! That was my post! Hehe :godance:

I lost a lot of PMs with information but it isn't a big deal. The important thing is that we are back up and running, if it isn't possible to recover all that data it isn't the end of the world. We appreciate all your hard work Dino!


:+1:

Exactly.

on2it
09-06-2008, 09:39 AM
+2

jamdread
09-06-2008, 04:15 PM
post check

Kooldino
09-06-2008, 05:53 PM
Thanks for the support guys.

Regarding a new server - I have a few opitons I'll be looking into as soon as I get this worked out.

Regarding the data, we're currently having a hard time parsing the data out of the files, since it's not formatted in a totally consistent way.

EvoX08
09-06-2008, 09:52 PM
good work either way dino, you putting alot of effort into this, thanks for everything.

RGory477
09-09-2008, 07:33 AM
If I were Dino I woulda ripped out my hair then smashed my keyboard on the hosts face like in wanted...

DirectorSe7en
09-09-2008, 07:36 AM
Post check?

Saotome9
09-09-2008, 09:16 AM
my post are gooooooone nooooooo