Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Address book problem


metricbikes

Recommended Posts

Posted

Hello All,

 

Someone in IT 'repaired' my address_book. They opened mysql, saw a warning and hit repair. THis is the result:

 

I cannot get to my address book through the admin screen.

 

Warning: mysql_query(): Unable to save result set in /public_html/admin/includes/functions/database.php on line 45

1030 - Got error 127 from table handler

 

select count(*) as total from customers c left join address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id

 

 

Has this happened to anyone before? Is there a solution?

 

Thanks.

Steve

Posted

Hi Steve,

Uhhhh.. sounds bad bro'.

This error mean: MySQL error: 127 = Record-file is crashed

 

Normally, you should be able to repair it through the phpmyadmin interface, but I guess that what your IT-geeks made.

 

Try maybe to export your address_book as sql, check if everything is OK (that all your records are in)

Rename the adress_book table, create a new one with the sql request.

It may help.

 

Ciao.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...