cpthyland2 Posted August 27, 2004 Share Posted August 27, 2004 I just installed the Star Products v1.4 and now I get a tep stop error on my main page. 1146 - Table 'clubhousegolf.table_star_product' doesn't exist select substring(pd.products_description, 1, 598) as products_description, p.products_id, p.products_image, p.manufacturers_id, p.products_price, 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, p.products_tax_class_id, sp.product_id from products p, products_description pd, TABLE_STAR_PRODUCT sp left join specials s on p.products_id = s.products_id where p.products_id = pd.products_id and p.products_status = '1' and pd.products_description != '' and p.products_id=sp.product_id and pd.language_id = '1' [TEP STOP] I checked in the database, there is a table there called star_product, and from the admin screen when I change the star product, the record ID does get updated in the database, however from the catalog mainpage, i get the above database error. Please help. Quote Link to comment Share on other sites More sharing options...
♥14steve14 Posted April 20, 2005 Share Posted April 20, 2005 I just installed the Star Products v1.4 and now I get a tep stop error on my main page.1146 - Table 'clubhousegolf.table_star_product' doesn't exist select substring(pd.products_description, 1, 598) as products_description, p.products_id, p.products_image, p.manufacturers_id, p.products_price, 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, p.products_tax_class_id, sp.product_id from products p, products_description pd, TABLE_STAR_PRODUCT sp left join specials s on p.products_id = s.products_id where p.products_id = pd.products_id and p.products_status = '1' and pd.products_description != '' and p.products_id=sp.product_id and pd.language_id = '1' [TEP STOP] I checked in the database, there is a table there called star_product, and from the admin screen when I change the star product, the record ID does get updated in the database, however from the catalog mainpage, i get the above database error. Please help. <{POST_SNAPBACK}> I had a similar problem in that a database was not being found. I went through the install instructions again and found a line i had missed. As the error was different all i can suggest is that you carefully retrace the install instructions and hopefully find what you did wrong. Quote REMEMBER BACKUP, BACKUP AND BACKUP Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.