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

Tags (2)
1 REPLY

Re: Error on when place the order

Hi @ibashir,

 

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

--
If you've found one of my answers useful, please give "Kudos" or "Accept as Solution"