I'm having the following exception on EE 1.13.1
Zend_Db_Statement_Exception' with message 'SQLSTATE: Integrity constraint violation: 1062 Duplicate entry 'xxxxxxx' for key '5B1C775075460366570ABDA2839BC68A' in /lib/Zend/Db/Statement/Pdo.php:234
It looks something goes wrong with the Category Rules index:
- According to the exception information the issue starts from
5B1C775075460366570ABDA2839BC68Ais actually an index of this table
Any Idea ?
I'm actually debugging the above issue and I will share more info if I find something.
I have provided a solution below. It will be great if someone with more experience can confirm if try catch is fine ( usually it is not advisable to use try catch in the business logic ) or transaction is better.