: 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.
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?
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 :(
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
| |