paullgr Posted August 8, 2011 Share Posted August 8, 2011 Hi, I have major trouble since I installed 'Quick edit product options" - "Custom product sort" and "Force selection of product option" from Estelle When I add to basket a product that has options to choose then when I view basket I get this message MySQL Error Occured 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 'CubeCart_options_bot.option_id, CubeCart_options_bot.value_id, option_price, opt' at line 1 QUERY = CubeCart_options_bot.option_id, CubeCart_options_bot.value_id, option_price, option_symbol, value_name, option_name, assign_id FROM `CubeCart_options_bot` INNER JOIN `CubeCart_options_mid` ON CubeCart_options_mid.value_id = CubeCart_options_bot.value_id INNER JOIN `CubeCart_options_top` ON CubeCart_options_bot.option_id = CubeCart_options_top.option_id WHERE assign_id = '8' When I try to buy items that does not have any options to choose (men's jewelry collection for example) it goes normal. I installed them twice I don't know what is going wrong. Please help I have customers waiting to fix it I've mailed to Estelle but I was wondering if anyone is familiar with this to point me exactly where to look. My shop is www.tesoro-jewelry.com/shop Thank you in advance , Paul Quote Link to comment Share on other sites More sharing options...
bsmither Posted August 8, 2011 Share Posted August 8, 2011 Welcome paullgr! Glad to see you made it to the forums. Maybe in the mod, a query got messed up. But, since it's not core code, I sent a Private Message explaining where to look. Quote Link to comment Share on other sites More sharing options...
paullgr Posted August 8, 2011 Author Share Posted August 8, 2011 Thank you for your time!! 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.