Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

error after loading module


hotpointer

Recommended Posts

i have just added a modeul to my site which would give me specials in the centre

 

but i now get this error

 

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 'MAX_DISPLAY_PRODUCT_SPECIALS' at line 1

 

select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status='1' and p.products_id=s.products_id and p.products_id=pd.products_id and pd.language_id='1' and s.status='1' order by rand() limit MAX_DISPLAY_PRODUCT_SPECIALS

 

 

Thanks in advance

Ps I dont really know what i am doing so no tec speak

Link to comment
Share on other sites

there is no such definition. So its best to locate which php file the error comes from and search for the string there. Probably it should been

MAX_DISPLAY_SPECIAL_PRODUCTS

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...