There was an error processing your order. Please contact us or try again later


#1

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}


#2

The error is telling you RWW-100001402 already exists in the table sales_flat_order. SQL databases cannot have duplicate IDs in primary keys and Magento is trying to create a record with that ID again. Did you migrate this database from another server? This will cause this almost everytime with Magento if you do not reset your primary key for that table, a workaround would be to change that ID to something else that does not exist, you may have to do this multiple times until the error clears.

A more efficient method would be to export your DB (or just the table if you know how with something like MySQL Workbench). and edit the SQL file to include:

SET FOREIGN_KEY_CHECKS=0;

or similar at the top and this line to the bottom:

SET FOREIGN_KEY_CHECKS=1;

Then dump the DB (or just the table) and import the one you just modified with the two lines, then try again. That should clear up your issue.