Unable to apply Rules in magento
Store has thousands of Products and Catalog Price Rules. The rules weren’t being applied, and after debugging cron and other things that have been a problem in the past, I took a look at the
catalogrule_product_price
table to see what was there. I saw a single entry:
Notice the value for rule_product_price_id
— Indeed, the max value for an INT(10)
field. Reset your auto-increment and you should be good.
you change data type int(10) to bigint(15)