Forums / General Questions / YIKES I blew up my database!

YIKES I blew up my database!

Locked

Views: 577

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
15 Sep 2009, 9:05 PM
#1
debiwebi avatar

debiwebi

New Zenner

Join Date:
Aug 2009
Location:
Highlands Ranch, Colorado
Posts:
84
Plugin Contributions:
0

YIKES I blew up my database!

Hi, I've been working on this shopping cart for a few weeks now, just about have it done. I needed to delete all the countries since the client only wants to ship to the US. I decided to follow a thread on how to do it thru the database. I deleted all countries except for the US, then my entire shopping cart disappeared and I get the "there seems to be a problem connecting to our database" page. My Admin is also gone and I get this "0 DB_ERROR_NOT_CONNECTED
in:
[select * from zen_project_version WHERE project_version_key = 'Zen-Cart Database' ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields."

I went back into the db and restored a prior version. When looking thru it it looks like the countries are back in there and my product seems to be there.

What happened, what did I do wrong? How do I fix this? PLEASE HELP!

The web site is http://www.herdoos.com/shop

15 Sep 2009, 9:28 PM
#2
debiwebi avatar

debiwebi

New Zenner

Join Date:
Aug 2009
Location:
Highlands Ranch, Colorado
Posts:
84
Plugin Contributions:
0

Re: YIKES I blew up my database!

BTW I changed my password for the database because I wasn't able to get in at first. Could that be the problem?

15 Sep 2009, 9:50 PM
#3
debiwebi avatar

debiwebi

New Zenner

Join Date:
Aug 2009
Location:
Highlands Ranch, Colorado
Posts:
84
Plugin Contributions:
0

Re: YIKES I blew up my database!

Oh boy I figured it out myself. I did cause it when I changed the password. I tracked down configure.php files located in admin/includes and includes/ and changed the password on those to the new ones. All is well. Sigh.