Zen Cart Logo
Forums / General Questions / Entire website down probably due to SQL Error or something

Entire website down probably due to SQL Error or something

Locked

Views: 561

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
13 May 2010, 2:34 AM
#1
nicknasz avatar

nicknasz

New Zenner

Join Date:
May 2010
Posts:
2
Plugin Contributions:
0

Entire website down probably due to SQL Error or something

Hi,

Im having a problem here. My client's website http://www.ctshop.sg/ faces some SQL and scripting problem.
Im not sure how this problem initiated. All i know is that it has got something to do with SQL and the Zencart script incompatibility issue or something close to that. :censored:
The site is totalled! Cant access to admin page or anything at all!
I was told that all they wanted to do were to click on the "update zencart thingy" and then the problem arises. Will there be a possible chance to restore/recover the products and major customer's information if i reinstall the Zencart Script and use the backed up SQL restore-file (the backup file which they've done few months back)?
They've got around 1000+ products and it'll take months to re-insert the products. Please assist! this is pretty urgent as they need the websites to be up :(

13 May 2010, 3:29 AM
#2
website_rob avatar

website_rob

Inactive

Join Date:
Oct 2006
Location:
Alberta, Canada
Posts:
4,572
Plugin Contributions:
0

Re: Entire website down probably due to SQL Error or something

"I was told that all they wanted to do were to click on the "update zencart thingy" and then the problem arises."

If the "update zencart thingy" was within their Hosting Control Panel and called Fantastico then they overwrote their previous Zen Cart installation. And if that was the case talk to their Hoster as they may have a recent backup they can install and put everything back the way it was. If not, doing a manual reinstall is the only other option.

14 May 2010, 5:43 AM
#3
nicknasz avatar

nicknasz

New Zenner

Join Date:
May 2010
Posts:
2
Plugin Contributions:
0

Re: Entire website down probably due to SQL Error or something

I dont think thats gonna work. They'll only screw everything up even more. The hosting company (which my client refuses to switch to other hosting provider and i dont know why) which they farmed their web files only keep backups which only lasted for about a day or so, and it'll be updated and'll be replaced daily. Ideas off about the hosting company as i always find their services are pretty much useless.

So... I am thinking of reinstalling the Zencart Files manually and overwrite the new zencart SQL which will then be replaced with the backed up SQL files to the server (backed-up around 3 months ago). Will that work somehow? All i need is to get all the 1900+ products and the customers database back to the server....