piccolina Posted May 26, 2016 Share Posted May 26, 2016 I had a look at my error log just now (which I never normally do) and saw the following error below, repeated for over 1000 pages. Can anyone shed some light on this for me please? Thanks in advance for any assistance. Geoff `CubeCart_inventory` WHERE `price` > `sale_price` AND `sale_price` > 0 AND ((CubeCart_inventory.stock_level > 0 AND CubeCart_inventory.use_stock_level = 1) OR CubeCart_inventory.use_stock_level = 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...
bsmither Posted May 26, 2016 Share Posted May 26, 2016 Please verify in admin, Store Settings, Features tab, Sales section, that there is an actual numerical value entered here. It cannot be blank, make sure there isn't any spaces in the field, and probably cannot be 0. Quote Link to comment Share on other sites More sharing options...
piccolina Posted May 26, 2016 Author Share Posted May 26, 2016 Sales Mode set to " per product" Global percentage discount is blank. Number of sale items to display is blank Thanks Brian. Quote Link to comment Share on other sites More sharing options...
piccolina Posted May 26, 2016 Author Share Posted May 26, 2016 I've changed the "number of sale items to display to "0". and all seems to be well. Thanks again, Geoff 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.