Magento: Integrity constraint violation: 1062 Dupl

2019-08-18 03:15发布

问题:

Hey I'm a complete magento noob, but we upgraded our version to the latest and now when you finish checking out and finish payment, you are presented with this error.

I've truncated the log tables like everyone seems to suggest, I've checked for duplicate skus. I've looked into reindexing our product prices as it says it needs to be reindexed, but when I do, i'm presented with this: 'There was a problem with reindexing process.'.

Here's the error from the checkout. Any help or direction would be greatly appreciated!

There has been an error processing your request SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '100002112' for key

回答1:

Try increasing the increment_last_id in the table eav_entity_store.Make sure that the value is greater than the increment id of currently existing orders.