Magento：完整性约束违反：1062键2的重复条目“100002112” [英] Magento: Integrity constraint violation: 1062 Duplicate entry '100002112' for key 2

问题描述

嘿，我是一个完整的magento noob，但我们升级我们的版本到最新，现在当你完成结帐并完成付款，你会看到这个错误。

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.

我已经截断日志表，像大家似乎建议，我检查了重复skus。我已经考虑重新索引我们的产品价格，因为它说它需要重新索引，但当我这样做，我被提出这样：重建索引过程有一个问题。

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.'.

这是结帐错误。

处理您的请求时出现错误
SQLSTATE [23000]：完整性约束违规：1062重复条目'100002112 'for key

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

推荐答案

尝试增加表eav_entity_store中的increment_last_id。请确保该值大于当前的增量id现有订单。

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.

这篇关于Magento：完整性约束违反：1062键2的重复条目“100002112”的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！