Search the Community

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

Hi all I've set up some coupons to give a 10% discount. But I don't want these to apply to sales items otherwise I'll be out of pocket. Is there a way of stopping coupons applying to sales items? I know you can assign products to coupons but I have nearly 400 products and several coupons so this isn't ideal. Any help much appreciated. Thanks