fldavidallsop Posted September 6, 2015 Share Posted September 6, 2015 I am running a CC v5.2.16 and my system error log database table is filling up with the following entry, any ideas on how to stop this? File: [gui.class.php] Line: [1073] "SELECT `product_id`,`description`,`name`, `price`-`sale_price` AS `saving` FROM `ve_CubeCart_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 Quote Link to comment Share on other sites More sharing options...
havenswift-hosting Posted September 6, 2015 Share Posted September 6, 2015 Hi If you have copied that error message in full then the error is that you dont have a parameter for the LIMIT Clause - it takes either one or two parameters and you have none.Ian Quote Link to comment Share on other sites More sharing options...
bsmither Posted September 6, 2015 Share Posted September 6, 2015 The LIMIT clause comes from this part of line 1073 in /classes/gui.class.php:... LIMIT '.$GLOBALS['config']->get('config', 'catalogue_sale_items')The configuration setting for this is found in admin, Store Settings, Features tab, "Number of sale items to display". The value for this setting must be an integer greater than zero. Quote Link to comment Share on other sites More sharing options...
fldavidallsop Posted September 6, 2015 Author Share Posted September 6, 2015 Okay I will look into this further, thanks for the information. 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.