http://www.magentocommerce.com/bug-tracking/ en MagentoCommerce Copyright {gmt_date format="%Y"} {gmt_date format="%Y-%m-%dT%H:%i:%s%Q"} http://www.magentocommerce.com/bug-tracking/issue?issue=14682 Posted: 2013-01-29 04:43:16
Category: Orders
Version: 1.7.0.2
Priority: urgent
Status: assigned
Reported By: wormhit

After upgrade we started to receive a lot of these exceptions:

exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'C01744029' for key 'UNQ_SALES_FLAT_ORDER_INCREMENT_ID'' in ..../lib/Zend/Db/Statement/Pdo.php:241

After googling around I found no working fix for this.
So I found a bug in magento code.

app/code/core/Mage/Sales/Model/Resource/Quote.php line 165
$bind = array(':increment_id' => (int)$orderIncrementId);
needs to be:
$bind = array(':increment_id' => $orderIncrementId);

Please fix so we don't need to override this method anymore. ;)

Cheers!

---

]]>