Guest loki951510 Posted September 3, 2012 Share Posted September 3, 2012 when changeing a order to compleate it get this error in system error log File: [gui.class.php] Line: [1001] "SELECT `I`.`product_id`,`I`.`description`,`I`.`name`, `G`.`price`-`G`.`sale_price` AS `saving` FROM `CubeCart_pricing_group` AS `G` INNER JOIN `CubeCart_inventory` AS `I` ON `G`.`product_id` = `I`.`product_id` WHERE `G`.`price` > `G`.`sale_price` AND `G`.`sale_price` > 0 AND `G`.`group_id` IN(1) AND `I`.`status` = '1' LIMIT 3 OFFSET -3" - 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 '-3' at line 1 Quote Link to comment Share on other sites More sharing options...
bsmither Posted September 28, 2012 Share Posted September 28, 2012 This could be bug #364. In the file /classes/db/database.class.db at around line 446, find: public function query($query, $maxRows = false, $page = 0, $cache = true) Change to: public function query($query, $maxRows = false, $page = false, $cache = true) 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.