Customer error, possibly database related ?

Locked

Results 1 to 5 of 5

This thread is locked. New replies are disabled.

15 Nov 2006, 01:37

pauls

Zen Follower

Join Date:: Feb 2006
Posts:: 300
Plugin Contributions:: 0

Customer error, possibly database related ?

I have suddenly gained the following error, I have no idea why it occured and have done nothing other than decide to checck on a few customers ... and this is the error I get ... with no customer listing showing.

1030 Got error 127 from storage engine
in:
[select count(*) as total from zen_customers c left join zen_customers_info ci on c.customers_id= ci.customers_info_id left join zen_address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id ]
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.

Thanks for any help

15 Nov 2006, 01:43

ajeh

Oba-san

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

Re: Customer error, possibly database related ?

Sounds like you may have had a MySQL database crash ...

Try running the Repair on the database table ...

15 Nov 2006, 12:59

pauls

Zen Follower

Join Date:: Feb 2006
Posts:: 300
Plugin Contributions:: 0

Re: Customer error, possibly database related ?

Ajeh:
Sounds like you may have had a MySQL database crash ...

Try running the Repair on the database table ...

Thanks for the advice Linda, it has now developed further and there is no site there and no admin there either, I guess I need to log into the database itself to do this repair that you mention?

15 Nov 2006, 20:37

ajeh

Oba-san

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

Re: Customer error, possibly database related ?

It does sound like you need to repair the database via phpMyAdmin ...

15 Nov 2006, 22:30

pauls

Zen Follower

Join Date:: Feb 2006
Posts:: 300
Plugin Contributions:: 0

Re: Customer error, possibly database related ?

Thanks Ajeh, I mentioned it to my hosts, and they fixed whatever it was, they didn't tell me what the problem was, but they fixed it so all is now well again, thanks for pointing me in the right direction, and responding promptly and accurately as ever, I appreciate your efforts.