cancel
Showing results for 
Search instead for 
Did you mean: 

Magento: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '100000001' for key '

SOLVED

Magento: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '100000001' for key '

I am new to the magento. When we are trying to place the order we are getting the below error message for one store view.
If im switching to another store view its working perfectly. How do i resolve the problem.. Is there any max orderid range configuration for store specific in magento admin panel can i resolve the problem from magento admin panel.
Magento: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '100000001' for key 'UNQ_SALES_FLAT_ORDER_IN
1 ACCEPTED SOLUTION

Accepted Solutions

Re: Magento: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '100000001' for k

Hi @janavi_g

 

Please check following https://magento.stackexchange.com/a/105531/3895 url it may help you.

 

You should also check eav_entity_store table for the increment_id value it may be overlapping with the existing order id present in the sales_flat_order table

---
Problem Solved Click Accept as Solution!:Magento Community India Forum

View solution in original post

1 REPLY 1

Re: Magento: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '100000001' for k

Hi @janavi_g

 

Please check following https://magento.stackexchange.com/a/105531/3895 url it may help you.

 

You should also check eav_entity_store table for the increment_id value it may be overlapping with the existing order id present in the sales_flat_order table

---
Problem Solved Click Accept as Solution!:Magento Community India Forum