Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Please Help !


Recommended Posts

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


select p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, products_description pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '4' order by p.products_date_added desc limit MAX_DISPLAY_PRODUCTS_FIRST_PAGE






i have such a error how can i fix it please help :(:(:(

Link to comment
Share on other sites

Capital letters in an error mean a definition is missing. That definition, 'MAX_DISPLAY_PRODUCTS_FIRST_PAGE', doesn't appear to be a standard oscommerce one so you must have a made a mistake on an installation of some conttribution or it is a mistake in the template you are using, assuming you are using one.

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

All of My Addons

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites


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

  • Create New...