Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Featured Products


susanp951

Recommended Posts

I installed the Featured Product Contribution and when i uploaded the new database, I got this error message:

 

1064 - 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 ') and p.products_status = '1' and f.status = '1' order by rand(

 

select distinct p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from products p left join specials s on p.products_id = s.products_id, products_to_categories p2c, categories c left join featured f on p.products_id = f.products_id where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id in () and p.products_status = '1' and f.status = '1' order by rand() DESC limit 6

 

[TEP STOP]

 

What do I do to fix this? Thank you!!

 

Susan

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...