In some cases, customer orders and registered gives me this error when you reorder.
SQLSTATE : Integrity constraint violation: 1062 Duplicate entry 'T00008286' for key 'UNQ_SALES_FLAT_ORDER_INCREMENT_ID'
My Magento version is 1.6.2 and I have installed a onestepcheckout (I think that its not related with the bug).
It only happens on clients who have already made a previous order. I can not confirm if those customers have canceled orders and that somehow have been left hanging. But the problem is clearly in those cases Magento is not increasing the ID of the orders and each time you want to place another order get this error of duplicate entry.
Any solution? I’m pretty desperate on this topic. I’ve seen on google that there are people with similar errors, even the same mistake in customer orders registered but have not found solution.
I’ve tried some things proposed in the net as: increasing the final value of the id in the DB, or set logs removing every day, but nothing seems to fix the problem.
Is there anybody could help me with that?