Forums / General Questions / Data Base error HELP!

Data Base error HELP!

Locked

Started by shannda on 14 Sep 2006, 5:38 PM · Views: 2,739

Results 1 to 12 of 12
This thread is locked. New replies are disabled.
14 Sep 2006, 5:38 PM
#1
shannda avatar

shannda

New Zenner

Join Date:
Dec 2005
Posts:
46
Plugin Contributions:
0

Data Base error HELP!

Last night my data base disapeared from the server and now my whole site is gone. this is the error I get when I go to my admin.

0 DB_ERROR_NOT_CONNECTED
in:
[select * from 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.

my host says there trying to figure it out but I was wondering if anyone had had this issue before.

17 Sep 2006, 1:51 AM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Data Base error HELP!

Were you able to resolve this? Sounds like an issue with your server if you did not make any changes and this "just happened" all on its own self ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

17 Sep 2006, 2:46 AM
#3
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,511
Plugin Contributions:
176

Re: Data Base error HELP!

0 DB_ERROR_NOT_CONNECTEDThis error means that the database settings in your configure.php file cannot be used to successfully connect to your database.

check:

  1. database-name -- is it correct? does it exist?
  2. username/password
  3. servername/host
  4. does the "username" have full rights to access the "database"-name ?

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

22 Sep 2006, 11:07 PM
#4
shannda avatar

shannda

New Zenner

Join Date:
Dec 2005
Posts:
46
Plugin Contributions:
0

Re: Data Base error HELP!

Fortunetly, we had a back up. When we logged into phpmyadmin the database was gone. Not sure if it was hacked or if we just had a glitch. The host couldn't locate a back up. After some additional errors and glitches with the server, we have finally moved hosts. So far so good on the new host. i'm a back up junky now.

24 Sep 2006, 9:53 AM
#5
peanut77 avatar

peanut77

Zen Follower

Join Date:
Feb 2005
Posts:
266
Plugin Contributions:
0

Re: Data Base error HELP!

This has just happened to one of my sites - seems to have fallen overnight. I can see my database in myphp (and I backed this up completely yesterday as well ) I have also checked permissions and my configure files - and everything is is fine.

Is this a server issue with my hosts rather than a problem with the site running 1.32 on a linux server - total nightmare ...

24 Sep 2006, 10:26 AM
#6
peanut77 avatar

peanut77

Zen Follower

Join Date:
Feb 2005
Posts:
266
Plugin Contributions:
0

Re: Data Base error HELP!

Is there anything I can do to fix this ?

30 Sep 2006, 3:21 AM
#7
shannda avatar

shannda

New Zenner

Join Date:
Dec 2005
Posts:
46
Plugin Contributions:
0

Re: Data Base error HELP!

We moved to http://www.sashbox.net/ and things have been outstanding since. Its nice to deal with a host that knows way more about ZenCart. The we're able to get us moved over within a couple of hours. No more errors. One less headache.

27 Dec 2006, 5:55 PM
#8
designbydemeter avatar

designbydemeter

Zen Follower

Join Date:
Jun 2006
Location:
Taos,NM
Posts:
225
Plugin Contributions:
0

Re: Data Base error HELP!

I am having a similar problem. Last night all A-OK. This morning:

0 DB_ERROR_NOT_CONNECTED
in:
[select * from 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.

Host swears its not them (don't believe them). Front end of store is fine. Only admin is the problem.

Tried to go to myPHP admin and repair as per an Ajeh post, but couldn't locate the REPAIR functionality.

OS: Linux
Apache: 1.3.37 (Linux)
PHP: 4.4.4
MySQL: 4.1.21-standard

Thanks & Happy Holidays!
Laura

Laura M Collins Invitation Designs

"The best way to navigate in a new area is to first get totally lost in it."...Mike L. Stein

27 Dec 2006, 7:37 PM
#9
designbydemeter avatar

designbydemeter

Zen Follower

Join Date:
Jun 2006
Location:
Taos,NM
Posts:
225
Plugin Contributions:
0

Re: Data Base error HELP!

Oh - I just installed a fresh spankin' new 1.3.6~ with regards to above. Host techie says he ran REPAIR on the db and everything came up as OK. Still can't get past the error.

Laura M Collins Invitation Designs

"The best way to navigate in a new area is to first get totally lost in it."...Mike L. Stein

27 Dec 2006, 7:55 PM
#10
Kim avatar

Kim

Obaa-san

Join Date:
Jun 2003
Location:
West Coast, North America
Posts:
26,739
Plugin Contributions:
0

Re: Data Base error HELP!

Check the admin/includes.configure.php Make sure it is there and contains the correct information.

Please do not PM for support issues: a private solution doesn't benefit the community.

Be careful with unsolicited advice via email or PM - Make sure the person you are talking to is a reliable source.

27 Dec 2006, 8:16 PM
#11
designbydemeter avatar

designbydemeter

Zen Follower

Join Date:
Jun 2006
Location:
Taos,NM
Posts:
225
Plugin Contributions:
0

Re: Data Base error HELP!

Thanks Kim, didn't change anything from last night though, so I dont' know why it would break this morning. Here is the pertinent text:

// NOTE: be sure to leave the trailing '/' at the end of these lines if you make changes!
// * DIR_WS_* = Webserver directories (virtual/URL)
// these paths are relative to top of your webspace ... (ie: under the public_html or httpdocs folder)
define('DIR_WS_ADMIN', 'zen/admin/');
define('DIR_WS_CATALOG', 'zen/');
define('DIR_WS_HTTPS_ADMIN', 'zen/admin/');
define('DIR_WS_HTTPS_CATALOG', 'zen/');

and

// * DIR_FS_* = Filesystem directories (local/physical)
//the following path is a COMPLETE path to your Zen Cart files. eg: /var/www/vhost/accountname/public_html/store/
define('DIR_FS_ADMIN', '/home/xxxxx/public_html/zen/admin/');
define('DIR_FS_CATALOG', '/home/xxxxx/public_html/zen/');

of course, I changed the admin name, but changed it back for the sake of troubleshooting.

Thanks in advance for any help,
Laura

Laura M Collins Invitation Designs

"The best way to navigate in a new area is to first get totally lost in it."...Mike L. Stein

28 Dec 2006, 3:20 PM
#12
designbydemeter avatar

designbydemeter

Zen Follower

Join Date:
Jun 2006
Location:
Taos,NM
Posts:
225
Plugin Contributions:
0

Re: Data Base error HELP!

Okay,

Since I couldn't figure out what broke in the first place-these are the steps I took in fixing it. Pretty painless.

  1. In host's CPanel, did db backup. Make your config files writeable again.
  2. Uploaded zc_install folder from desktop to host (Always keep a pristine copy of original upload files on hand! Has saved my butt on numerous occasions)
  3. typed in https://www.mywebsite.com/store/zc_install to start installer again (of course, use your webstite's name and location of your store)
  4. do a complete install that will OVERRIDE the database; not to worry, you just did a backup, right?
  5. All is loved & light afterwards, and all data and customizations are in tact.
  6. Remember to delete your installer folder on host, and return your config files to 644 (un-writeable).

Whew~:thumbsup:

Laura M Collins Invitation Designs

"The best way to navigate in a new area is to first get totally lost in it."...Mike L. Stein