Guest Posted December 21, 2003 Share Posted December 21, 2003 After installing, I'm receiving 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_PRODUCTS_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 s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and s.status = '1' order by rand() DESC limit MAX_DISPLAY_PRODUCTS_SPECIALS [TEP STOP] Link to comment Share on other sites More sharing options...
Guest Posted December 22, 2003 Share Posted December 22, 2003 Anyone??? Link to comment Share on other sites More sharing options...
Guest Posted December 22, 2003 Share Posted December 22, 2003 This is missing from your db configuration table - what version are you running or contributions have you installed. My configuration define is: MAX_DISPLAY_SPECIAL_PRODUCTS Matti Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.