You have an error in your SQL syntax

[odracirjf]

Hello ,

I have a Oscommerce web page with the following configuration:

 

WEBSERVER :

• APACHE
  
• DATABASE CLIENT VERSION 5.5.31
  
• PHP EXTENSION MYSQLi
  
• modular_ front_ page version : 1.4
  
• oscommerce 2.3.3
  

 

When I select the "featured" option on the "scroller" The next message appears

 

 

 

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 ') order by rand() limit ' at line 13

 

select p.products_id, p.products_image, pd.products_name from products p join products_description pd on pd.products_id = p.products_id where p.products_status = '1' and pd.language_id = '2' and p.products_id in () order by rand() limit 20

I

 

Could you please help me?

Thank you very much!!

[♥bruyndoncx]

I'm guessing you haven't flagged any featured items.

 

the scroller you are referring too is probably a modular front page module ?

if so, better find that thread, and post there

 

edit: on second thought, don't you just have to supply a comma separated list of product ids in the admin for that ?

[odracirjf]

Hello Carine!

Thank you for the response , I, using the modular front page ...... I have selected more than 10 products in the featured products module. the featured products is not empty.

[♥bruyndoncx]

You should post in the support thread for that contribution, Jim @@kymation is really good in supporting his contributions ...