Coupon is not working while select category

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

The same problem here!!!
What is going on?

Hey,............
I am also facing exactly same problem.
Did you get any solution of it.

Please help

Same problem here.

Same thing !!

same problem here

THE SAME PROBLEM HERE!
ANYONE PLEASE?!

Did you guys ever figure out what the issue is and how it can be solved?