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

[janavi_g]

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

[Agarwal Aman · Accepted solution]

Try this solution. This would definitely help you.

The order number 100000001 (i.e. increment ID or increment_id) already exists in your order table, sales_flat_order, and it's failing the order save when someone checks out because increment_idsmust be unique.

First, verify that you have these order numbers you see in the error messages are indeed already present in the sales_flat_order.increment column. Then, you need to modify the eav_entity_store.increment_id value(s), so that new increment IDs will never overlap with your the already existing order numbers.

Check the maximum value in sales_flat_order.increment_id, and update eav_entity_store.increment_id with a value greater than that. Example 100000002

Problem solved? Click Kudos & Accept as Solution!