Zen Cart Logo
Forums / General Questions / DB Error from nowhere in Admin

DB Error from nowhere in Admin

Locked

Views: 703

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
28 Oct 2010, 5:12 PM
#1
philip937 avatar

philip937

Totally Zenned

Join Date:
Aug 2009
Location:
Bedford, England
Posts:
968
Plugin Contributions:
0

DB Error from nowhere in Admin

Please can someone advise me on this?

I'm confused, all of a sudden I have this error message under the menu in admin

1034 Incorrect key file for table 'zen_customers'; try to repair it
in:
[select count(*) as count from zen_customers]
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.

Nothing has been changed on the site. just one day logged in and this message was there....

???

Phil

28 Oct 2010, 5:19 PM
#2
philip937 avatar

philip937

Totally Zenned

Join Date:
Aug 2009
Location:
Bedford, England
Posts:
968
Plugin Contributions:
0

Re: DB Error from nowhere in Admin

philip937:

Please can someone advise me on this?

I'm confused, all of a sudden I have this error message under the menu in admin

1034 Incorrect key file for table 'zen_customers'; try to repair it
in:
[select count(*) as count from zen_customers]
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.

Nothing has been changed on the site. just one day logged in and this message was there....

???

Phil

Just thought

had this a while back from the hosts, could that be whats affected it?

MySQL will be updated from 5.0 to 5.1 series to keep the most currently
available version for cPanel for our customers.

28 Oct 2010, 11:30 PM
#3
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: DB Error from nowhere in Admin

"1034 Incorrect key file" means you've got a damaged database. If you know how to repair tables using phpMyAdmin, you can do it yourself. Or, since this may be a sign of more serious problems, contact your hosting company for specific help.

28 Oct 2010, 11:49 PM
#4
ebaobao avatar

ebaobao

Zen Follower

Join Date:
Jul 2008
Posts:
495
Plugin Contributions:
0

Re: DB Error from nowhere in Admin

philip did you try repair and then optimize using phpmyadmin? Maybe that may help. Its pretty easy, just select all tables from zen and drop-down-arrow for repair and then the same for optimize.