Coupon is not working while select category
Posted: Wed Feb 13, 2013 1:48 pm
Hi
I wanted to add a Coupon for a special promotion. When I select the Category and Save the Coupon. I test it but it display the error problem :
Notice: Undefined index: left in /home/sssssssscx/public_html/eshoppy.org/opencart/catalog/model/checkout/coupon.php on line 60Notice: Undefined index: right in /home/ssssssscx/public_html/eshoppy.org/opencart/catalog/model/checkout/coupon.php on line 60Notice: Error: Unknown column 'c.left' in 'where clause'
Error No: 1054
SELECT COUNT(*) AS total FROM `oc_product_to_category` p2c LEFT JOIN `oc_category` c ON (p2c.category_id = c.category_id) WHERE p2c.`product_id` = '10245' AND c.`left` BETWEEN '0' AND '0' in /home/rapbaycx/public_html/eshoppy.org/opencart/system/database/mysql.php on line 50
When i donot use categort, coupons is working fine, but it apply to all the items. whereas when i select the name of the products it works fine. Main Problem is when i want to select only special category , it donot works, ie example as above.
Is here problem with coupon bug.. but the way i am using version 1.5.5.1
Anyone please help it out.
Thanks
I wanted to add a Coupon for a special promotion. When I select the Category and Save the Coupon. I test it but it display the error problem :
Notice: Undefined index: left in /home/sssssssscx/public_html/eshoppy.org/opencart/catalog/model/checkout/coupon.php on line 60Notice: Undefined index: right in /home/ssssssscx/public_html/eshoppy.org/opencart/catalog/model/checkout/coupon.php on line 60Notice: Error: Unknown column 'c.left' in 'where clause'
Error No: 1054
SELECT COUNT(*) AS total FROM `oc_product_to_category` p2c LEFT JOIN `oc_category` c ON (p2c.category_id = c.category_id) WHERE p2c.`product_id` = '10245' AND c.`left` BETWEEN '0' AND '0' in /home/rapbaycx/public_html/eshoppy.org/opencart/system/database/mysql.php on line 50
When i donot use categort, coupons is working fine, but it apply to all the items. whereas when i select the name of the products it works fine. Main Problem is when i want to select only special category , it donot works, ie example as above.
Is here problem with coupon bug.. but the way i am using version 1.5.5.1
Anyone please help it out.
Thanks
