Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Error in Oscommerce 2.2 - Help me please !!!!


Guest

Recommended Posts

I have this error and I don't understand why !

 

1030 - Got error 127 from table handler

 

select p.products_image, p.products_model, pd.products_name, m.manufacturers_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '4' and p2c.categories_id = '148' order by pd.products_name limit 0, 20

 

[TEP STOP]

Link to comment
Share on other sites

I have this error and I don't understand why !

 

1030 - Got error 127 from table handler

 

[TEP STOP]

 

There is a problem with your database and it needs repairing

 

see the following from the MySQL website

 

http://www.mysql.com/doc/en/Repair.html

Mark Evans

osCommerce Monkey & Lead Guitarist for "Sparky + the Monkeys" (Album on sale in all good record shops)

 

---------------------------------------

Software is like sex: It's better when it's free. (Linus Torvalds)

Link to comment
Share on other sites

your host may need restart or reinstall mySQL, or could this be an issue of an incorrect database version, old 2.1 or early 2.2 database being used with newer catalog and admin scripts?

 

Tell us about your install, are you upgrading, is this a new install, please provide us more information.

Best Regards,

 

Salvatore Iozzia

 

Loaded Commerce - Oscommerce - All Loaded Up.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...