Magento2.2 manually changed order increment id breaks checkout

by user1739740   Last Updated January 19, 2018 15:09 PM

I have a magento 2.2.0 based website and I manually changed the incriment id for orders to be a higher number

Now my checkout does not work and i get the below error

 main.CRITICAL: Exception message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '4294967295' for key 'PRIMARY', query was: INSERT INTO `sequence_order_1` () VALUES ()
 Trace: #0 /var/www/html/ Magento\Framework\DB\Adapter\Pdo\Mysql->_query('INSERT INTO `se...', Array)
#1 /var/www/html/ Magento\Framework\DB\Adapter\Pdo\Mysql->query('INSERT INTO `se...', Array)
#2 /var/www/html/ Zend_Db_Adapter_Abstract->insert('sequence_order_...', Array)
#3 /var/www/html/ Magento\SalesSequence\Model\Sequence->getNextValue()
#4 /var/www/html/ Magento\Quote\Model\ResourceModel\Quote->getReservedOrderId(Object(Magento\Quote\Model\Quote))
#5 /var/www/html/ Magento\Quote\Model\Quote->reserveOrderId()

Related Questions

Unable to add form in magento 2 custom checkout step

Updated September 28, 2017 17:09 PM