Guest Posted September 16, 2002 Posted September 16, 2002 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]
Mark Evans Posted September 16, 2002 Posted September 16, 2002 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)
♥Loaded Commerce Posted September 18, 2002 Posted September 18, 2002 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.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.