Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Got error 127 from table handler


Guest

Recommended Posts

My shopping cart was working fine today, while I was entering in New products I received this error and I can not add any new items or attributes. Nothing was changed on my end.

 

Got error 127 from table handler

 

What do I do to fix this?

 

Your help is greatly appreciated!

Link to comment
Share on other sites

1. Best choice, but longest to implement: get your host to update to MySQL 4.015 or to update their client services (as per posts by wizardsandwars).

 

2. In the meantime, you may want to look up Burt's MYI fix in Tips & Tricks.

 

3. In the very shortest term, try issuing

repair products_descriptions;

in MySQL and see if that helps.

 

Hth,

Matt

Link to comment
Share on other sites

Hi

 

Thank you for responding

 

I tried to enter

 

repair products_descriptions

 

got this error

 

MySQL said:

 

 

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'products_descriptions' at line 1

Back

 

and now it gave me a new error 1016

 

Oh the nightmare my store is now completly shutdown.

 

I already have MySQL 4.015

 

When I look in my database structure it shows the products_descriptions as in use

what would happen if I drop the table?

Link to comment
Share on other sites

If you drop and recreate the table from backup, it will fix the problem. However, you will lose any changes that you have made since the backup.

 

Good luck,

Matt

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...