I upgraded my Magento platform and everything is working in the admin and the front end except the shopping cart. When I try to add an item to cart, the cart won’t add the product. See following
query was: SELECT `main_table`.*, `rule_coupons`.`code`, GROUP_CONCAT(extra_coupon.code) AS `extra` FROM `salesrule` AS `main_table`
LEFT JOIN `salesrule_coupon` AS `rule_coupons` ON main_table.rule_id = rule_coupons.rule_id AND rule_coupons.is_primary = 1
LEFT JOIN `salesrule_coupon` AS `extra_coupon` ON extra_coupon.rule_id = main_table.rule_id AND extra_coupon.is_primary IS NULL WHERE (is_active=1) AND (find_in_set(1, website_ids)) AND (find_in_set(0, customer_group_ids)) AND (from_date is null or from_date<=’2014-12-05′) AND (to_date is null or to_date>=’2014-12-05′)
GROUP BY `main_table`.`rule_id` HAVING ( primary_coupon.code IN (”) OR FIND_IN_SET(”, extra))
ORDER BY `sort_order` ASC
Try to use this Magento Database Repair Tool, it should help you http://www.magentocommerce.com/wiki/1_-_installation_and_configuration/db-repair-tool