Hello Magento Friends,
Welcome to Magento 2 Tutorials by MageComp. Today’s subject matter is How to Fix Unique Constraint Violation Found in Magento 2.
Magento 2 store merchants generally come across errors like “Unique constraint violation found” in the backend. Look at the below image.
The Unique Constraint Violation Found error usually occurs while adding categories, products, items, or creating new orders. The reason for this error can be the creation of duplicate values in the database table.
Let find out the solution for, How to Fix Unique Constraint Violation Found in Magento 2.
Steps to Fix Unique Constraint Violation Found in Magento 2:
The issue is related to the sequences table. So check the table of sequence_order_0 and sequence_order_1.
sequence_value column should be auto_increment and set primary key.
Conclusion:
Hence, this way you can Fix Unique Constraint Violation Found in Magento 2. In case of any issue, reach out to me via the comment section. Share the article and help your friends to fix the problem.
Happy Reading!
Hi,
I tried what you suggested but continue to get the same error still.
Unique constraint violation found
Running Magento 2.3.5 version and the table sequence_order_1 did have the problem so on making it auto increment and primary key thought it would solve the problem. Also applied Analyze table operation that fixed the cardinality value to the correct count but still the same error.
So admin login not working and giving same error. Any help would be appreciated.
Thanks.
Confirm you have done the things properly and check into private browser once.