i have created a shopping cart price rule with a coupon code "xxx". Then i deleted the coupon code from admin side. The again i created the shopping cart price rule with the same coupon id then the error "Coupon with the same code already exists." comes.
When i check the database table the entry is deleted from the salesrule_coupon table but the entry of the coupon code is not deleted from the salesrule_coupon, this causes the above error.
Why this happening ? i use magento 1.9.2.0