2

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
  • 1
    Have you cleared your cache and re-indexed? Oct 24, 2015 at 14:02

1 Answer 1

1

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

4
  • 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, 2015 at 17:33
  • @Marus I have the same issue but not getting resolved after doing above the steps.Can you help out on this. Jan 31, 2019 at 11:18
  • @CharulTyagi I have no other ideas
    – Marius
    Jan 31, 2019 at 11:36
  • 1
    This trick doesn't solve the problem at all! Nov 12, 2019 at 11:43

This site is temporarily in read-only mode and not accepting new answers.

Not the answer you're looking for? Browse other questions tagged .