Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Star Products v1.4, table_... doesn't exist


cpthyland2

Recommended Posts

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.

Link to comment
Share on other sites

  • 7 months later...
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.

 

 

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.

REMEMBER BACKUP, BACKUP AND BACKUP

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...