Every time I update my products in /admin I get this sql error

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2-0-0-1-1-375-0' for key 'EAA51B56FF092A0DCB795D1CEF812B7B', query was: INSERT INTO catalogrule_product (rule_id,from_time,to_time,website_id,customer_group_id,product_id,action_operator,action_amount,action_stop,sort_order,sub_simple_action,sub_discount_amount) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

It doesn't seem to actually affect anything but it kind of worries me.

  • 1
    Have you cleared your cache and re-indexed? – brentwpeterson Oct 24 '15 at 14:02

Backup the table catalogrule_product.
Truncate it.
Run the reindex process from the command line.
If something goes wrong, just restore you table.

  • 1
    What is the use for this table ? I'm really weary of truncating a table that I don't know much about. Also, should I also truncate table like catalogrule_product_price and other catalogrule_* tables ? – Ebpo Nov 19 '15 at 17:33
  • @Marus I have the same issue but not getting resolved after doing above the steps.Can you help out on this. – Charul Tyagi Jan 31 '19 at 11:18
  • @CharulTyagi I have no other ideas – Marius Jan 31 '19 at 11:36
  • This trick doesn't solve the problem at all! – Michelangelo Nov 12 '19 at 11:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.