steffanih Posted November 24, 2010 Share Posted November 24, 2010 Hello, I am receiving this error on my product info page after installing the latest release of XSell - Cross Sell and not finding much information on how to resolve it. Any ideas? 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_XSELL_PRODUCTS' at line 1 select distinct p.products_id, p.products_image, pd.products_name, p.products_tax_class_id, products_price from products_xsell xp, products p, products_description pd where p.products_id not in(33) and xp.products_id = '215' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = '1' order by rand(15818) DESC limit MAX_DISPLAY_XSELL_PRODUCTS [TEP STOP] Thanks! Quote Link to comment Share on other sites More sharing options...
web-project Posted November 25, 2010 Share Posted November 25, 2010 You need add the MAX_DISPLAY_XSELL_PRODUCTS variable into configures table Try the following sql: insert into `configuration` (`configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) values('Cross Sell Products','MAX_DISPLAY_XSELL_PRODUCTS','6','Maximum number of cross sell products to display in products page','3','15',NULL,'2009-05-20 20:10:05',NULL,NULL); Quote Please read this line: Do you want to find all the answers to your questions? click here. As for contribution database it's located here! 8 people out of 10 don't bother to read installation manuals. I can recommend: if you can't read the installation manual, don't bother to install any contribution yourself. Before installing contribution or editing/updating/deleting any files, do the full backup, it will save to you & everyone here on the forum time to fix your issues. Any issues with oscommerce, I am here to help you. Link to comment Share on other sites More sharing options...
steffanih Posted November 29, 2010 Author Share Posted November 29, 2010 Thanks so much, everything is lovely B) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.