astermont Posted January 22, 2012 Posted January 22, 2012 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 [TEP STOP] i have such a error how can i fix it please help :(:(:(
Jack_mcs Posted January 22, 2012 Posted January 22, 2012 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
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.