[email protected] Posted October 18, 2012 Share Posted October 18, 2012 setting a sale price i get hundreds of system errors: - all the same error logged a few minutes apart. and a similar thing happens when i enable Global percentage discount, so i have switch them off. Is there just a setting i have wrong? File: [gui.class.php] Line: [1025] "SELECT `product_id`,`description`,`name`, `price`-`sale_price` AS `saving` FROM `cc5CubeCart_inventory` WHERE `price` > `sale_price` AND `sale_price` > 0 AND `status` = '1' LIMIT " - 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 '' at line 1 Thanks Quote Link to comment Share on other sites More sharing options...
bsmither Posted October 18, 2012 Share Posted October 18, 2012 I am going to guess that you have specified a Sales Mode (other than Disabled), yet did not include a number in the "Number of sale items to display". In this case, leaving this field blank does not mean to show all the sale items. Quote Link to comment Share on other sites More sharing options...
[email protected] Posted October 18, 2012 Author Share Posted October 18, 2012 yes the "Number of sale items to display" is blank. Thats probably it then . i will give that field a value and try again. Thanks for that. Quote Link to comment Share on other sites More sharing options...
[email protected] Posted October 18, 2012 Author Share Posted October 18, 2012 yep that was it... silly me. thanks bsmithers! 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.