cancel
Showing results for 
Search instead for 
Did you mean: 

Error on when place the order

   Did you know you can see the translated content as per your choice?

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?