| Topic: Sucks that the Site is Messed. |
| ||
|
We have lost an entire year of data. Hope we can recover all of it. |
Posted: May 3 2008 2:23PM
| ||
|
Here's my conversation with the support chat room people, keep in mind this has taken place over 2.5 hours and is still going. ----------- Please wait for a site operator to respond. Chat InformationYou are now chatting with '聲gel' 聲gel: Hello. How may I assist you? you: Hello? you: Hi, I had an issue with my domain 聲gel: hi you: www.vancouverfoosball.com 聲gel: may i have the domain namw 聲gel: ok you: I sent a support ticket a few days ago about some issue with the database, we were getting error 500 internal server errors you: They said they fixed it, and the site worked fine. However after further inspection, it looks like we lost a lot of valuable information. The database has been rolled back to April 2007 you: lost* you: It looks like they restored a year old copy of the database which really breaks a lot of things on our site and we have no other way to recover that data. 聲gel: please hold on 聲gel: lemme check you: ok you: Any idea roughly how long it will take? 聲gel: 10 mins 聲gel: m doing 聲gel: check now you: checking 聲gel: k you: Friday, April 20, 2007 you: that's the last entry i'm seeing in the database you: and there should be one going back to April 2008 you: missing hundreds of entries from the database you: it's almost like you're restoring the right month but wrong year 聲gel: sir , thats what we have you: well that's not correct you: http://vancouverfoosball.com/ you: go to the front page, look at the most recent news item for yourself 聲gel: ? you: do you see the date? you: we would normally have 1 news item every Friday, and every Sunday 聲gel: yeah you: how often did you guys do backups? 聲gel: Saturday, April 14, 2007 you: right, 1 year, 2 weeks ago you: I want the April 2008 backup, not 2007 聲gel: sir , lemme check Chat InformationPlease wait while I transfer the chat to 'Cathy Jones'. Chat InformationYou are now chatting with 'Cathy Jones' Cathy Jones: hi sir you: hello you: Out of curiosity why was I transferred to you? you: I've been in this chatroom for over an hour, maybe even two hours you: the last person couldn't seem to help me you: My domain is www.vancouverfoosball.com, I had internal server error 500s happening all of a sudden last week, I submitted an email to the support team and they "fixed" the issue, but that involved restoring a database backup from late April 2007. That means we lost all of our data from April 2007 to April 2008 which is important data that we have no way of recovering. you: I was hoping you guys could correct the error and restore the proper database and not the year old database. Cathy Jones: yes Cathy Jones: tell me which database you r using Cathy Jones: MSACCESS or MSSQL ? you: I believe it's MSSQL Cathy Jones: which version of mssql ? Cathy Jones: it's a mssql 2000 or mssql 2005? Cathy Jones: tell me the dsn name? you: i am not certain of the version of MSSQL to be honest Cathy Jones: tell me the login details of your mssql database Cathy Jones: & DSN name also Cathy Jones: plz you: I didn't code it so I'm not too familiar with the details... let me see if I can look at the files on the FTP. The last people who restored it seemed to be able to find it themselves though... it was the right database they were restoring, just to the wrong time Cathy Jones: your site is working fine you: yes, but it is 1 year old you: the backup you guys restoerd was from April 2007 you: I lost 1 year of data you: I need April 2008 Cathy Jones: ok |
| ||
|
They don't seem to understand the fact that even though the site is working, it's old data. Morons... grrr... Onur |
| ||
|
Ok, I think we're back up now. We may have lost 1 or 2 weeks but I'm not certain. Can someone run through the tournament list and see if we're good? Thanks, Onur |
| ||
|
I cant find it )-; |
| ||
|
Son of a.... We really need to get off this server. Go figure, site is broken again within a day. Emailing support again. http://www.vancouverfoosball.com is the site if you meant you don't know the domain. Onur |
| ||
|
Yes we need to move the site. It is important that we get the data but I'm sure that we would survive starting people at the midpoints as it has been done in the past. Peter |
| ||
|
Wow that sucks, and that is some really weak tech support for the company. Thanks for putting in the time Onur and if you need some help with anything let me know. |
| ||
|
great scott!!.. The site is messed again! it was working almost 100% fine yesterday..where do we stand now Onur? |
| ||
|
You've gotta be kidding me.... they changed it again? I thought that was the end of it, grrrrr.... I don't know why they went and changed it after the issue was resolved. I'll file another ticket when I get home tonight... sigh. Onur |
| ||
|
Onur wats your phone number. Email or post it. But let me know if u email it |
| ||
|
I have your number, I'll text you in the morning, battery is dead right now and charger is at the office. Onur |
The last post to this thread is more than 30 days old.