cancel
Showing results for 
Search instead for 
Did you mean: 

Error on when place the order

Error on when place the order

when i place the order this this error will show There was an error processing your order. Please contact us or try again later.

 

Next exception ‘Zend_Db_Statement_Exception’ with message ‘SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘RWW-100001402’ for key ‘UNQ_SALES_FLAT_ORDER_INCREMENT_ID’, query was: INSERT INTO sales_flat_order (coupon_code, protect_code, shipping_description, is_virtual, store_id, customer_id, base_discount_amount, base_grand_total, base_shipping_amount, base_shipping_tax_amount, base_subtotal, base_tax_amount, base_to_global_rate, base_to_order_rate, discount_amount, grand_total, shipping_amount, shipping_tax_amount, store_to_base_rate, store_to_order_rate, subtotal, tax_amount, total_qty_ordered, customer_is_guest, customer_note_notify, customer_group_id, quote_id, base_shipping_discount_amount, base_subtotal_incl_tax, shipping_discount_amount, subtotal_incl_tax, weight, customer_dob, increment_id, applied_rule_ids, base_currency_code, customer_email, customer_firstname, customer_lastname, customer_middlename, customer_prefix, customer_suffix, customer_taxvat, discount_description, global_currency_code, order_currency_code, remote_ip, shipping_method, store_currency_code, store_name, x_forwarded_for, customer_note, created_at, updated_at, total_item_count, customer_gender, hidden_tax_amount, base_hidden_tax_amount, shipping_hidden_tax_amount, base_shipping_hidden_tax_amnt, shipping_incl_tax, base_shipping_incl_tax, gift_message_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ‘2018-06-06 15:40:31’, ‘2018-06-06 15:40:31’, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ in /home/179917.cloudwaysapps.com/amqczkzesw/public_html/lib/Zend/Db/Statement/Pdo.php:235
Stack trace:
#0 /home/179917.cloudwaysapps.com/amqczkzesw/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/179917.cloudwaysapps.com/amqczkzesw/public_html/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /home/179917.cloudwaysapps.com/amqczkzesw/public_html/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /home/179917.cloudwaysapps.com/amqczkzesw/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(‘INSERT INTO sa...', Array) #4 /home/179917.cloudwaysapps.com/amqczkzesw/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTOsa…’, Array)
#5 /home/179917.cloudwaysapps.com/amqczkzesw/public_html/lib/Zend/Db/Adapter/Abstract.php(576): Varien_Db_Adapter_Pdo_Mysql->query(‘INSERT INTO `sa…’, Array)
#6/home/179917.cloudwaysapps.com/amqczkzesw/public_html/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(453): Zend_Db_Adapter_Abstract->insert(‘sales_flat_orde…’, Array)
#7/home/179917.cloudwaysapps.com/amqczkzesw/public_html/app/code/core/Mage/Sales/Model/Resource/Order/Abstract.php(425): Mage_Core_Model_Resource_Db_Abstract->save(Object(Mage_Sales_Model_Order))
#8/home/179917.cloudwaysapps.com/amqczkzesw/public_html/app/code/core/Mage/Core/Model/Abstract.php(318): Mage_Sales_Model_Resource_Order_Abstract->save(Object(Mage_Sales_Model_Order))
#9/home/179917.cloudwaysapps.com/amqczkzesw/public_html/app/code/core/Mage/Core/Model/Resource/Transaction.php(151): Mage_Core_Model_Abstract->save()
#10/home/179917.cloudwaysapps.com/amqczkzesw/public_html/app/code/core/Mage/Sales/Model/Service/Quote.php(189): Mage_Core_Model_Resource_Transaction->save()
#11/home/179917.cloudwaysapps.com/amqczkzesw/public_html/app/code/core/Mage/Sales/Model/Service/Quote.php(249): Mage_Sales_Model_Service_Quote->submitOrder()
#12/home/179917.cloudwaysapps.com/amqczkzesw/public_html/app/code/core/Mage/Checkout/Model/Type/Onepage.php(812): Mage_Sales_Model_Service_Quote->submitAll()
#13/home/179917.cloudwaysapps.com/amqczkzesw/public_html/app/code/core/Mage/Checkout/controllers/OnepageController.php(579): Mage_Checkout_Model_Type_Onepage->saveOrder()
#14/home/179917.cloudwaysapps.com/amqczkzesw/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Checkout_OnepageController->saveOrderAction()
#15/home/179917.cloudwaysapps.com/amqczkzesw/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch(‘saveOrder’)
#16/home/179917.cloudwaysapps.com/amqczkzesw/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#17/home/179917.cloudwaysapps.com/amqczkzesw/public_html/app/code/core/Mage/Core/Model/App.php(365): Mage_Core_Controller_Varien_Front->dispatch()
#18 /home/179917.cloudwaysapps.com/amqczkzesw/public_html/app/Mage.php(684): Mage_Core_Model_App->run(Array)
#19 /home/179917.cloudwaysapps.com/amqczkzesw/public_html/index.php(83): Mage::run(’’, ‘store’)
#20 {main}Screenshot_1.png

1 REPLY 1

Re: Error on when place the order

Hi @ibashir,

 

Is that happening with different users/registered/guests customers?