Integrity constraint violation: 1062 Duplicate entry - After theme change“Cannot save shipment.” error with non-sample orders. 1062 Duplicate entry * for key 'UNQ_SALES_FLAT_SHIPMENT_INCREMENT_ID'Magento not finding theme in local instance after MYSQL importDatabase Error: Integrity constraint violation: 1062 Duplicate entryCSS broken for the fresh magento ver 1.9.2.0 installSite randomly redirecting to localhostIntegrity constraint violation: 1062 Duplicate entry for key 'UNQ_SALES_FLAT_INVOICE_INCREMENT_ID'ESI processing not enabled error only on Product detail page Varnish and Magento 1.9SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'Good and afordable Magento hosting solution for small business? Is it possible to setup on a new host with a full Cpanel backup?Order saving error: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry for key 'UNQ_SALES_FLAT_ORDER_INCREMENT_ID'
Does friction always oppose motion?
Could you fall off a planet if it was being accelerated by engines?
How can I know if a PDF file was created via LaTeX or XeLaTeX?
List Manipulation : a,b,c,d,e,f,g,h into a,b,c,d,e,f,g,h
How can I deal with extreme temperatures in a hotel room?
Can I use Alchemist's fire to turn my sword into a virtual Flame Blade?
Avoiding repetition when using the "snprintf idiom" to write text
Copy group of files (Filename*) to backup (Filename*.bak)
List manipulation: conditional result based on variable-length sublists
/etc/hosts not working
Is ALTER TABLE ... DROP COLUMN really a metadata only operation?
Closest Proximity of Oceans to Freshwater Springs
Do home values typically rise and fall consistently across different price ranges?
How did they film the Invisible Man being invisible, in 1933?
What election rules and voting rights are guaranteed by the US Constitution?
How could an armless race establish civilization?
If a USA citizen marries a foreign citizen who has a kid from a previous marriage
Why were the first airplanes "backwards"?
Can dual citizens open crypto exchange accounts where U.S. citizens are prohibited?
Adjective for 'made of pus' or 'corrupted by pus' or something of something of pus
How can combining souls together not increase its volume?
A quine of sorts
Have any large aeroplanes been landed — safely and without damage — in locations that they could not be flown away from?
Are Valenar elves and Aereni elves different races of elves?
Integrity constraint violation: 1062 Duplicate entry - After theme change
“Cannot save shipment.” error with non-sample orders. 1062 Duplicate entry * for key 'UNQ_SALES_FLAT_SHIPMENT_INCREMENT_ID'Magento not finding theme in local instance after MYSQL importDatabase Error: Integrity constraint violation: 1062 Duplicate entryCSS broken for the fresh magento ver 1.9.2.0 installSite randomly redirecting to localhostIntegrity constraint violation: 1062 Duplicate entry for key 'UNQ_SALES_FLAT_INVOICE_INCREMENT_ID'ESI processing not enabled error only on Product detail page Varnish and Magento 1.9SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'Good and afordable Magento hosting solution for small business? Is it possible to setup on a new host with a full Cpanel backup?Order saving error: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry for key 'UNQ_SALES_FLAT_ORDER_INCREMENT_ID'
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
0
After I changed my theme I am getting error messages in Magento log and also the checkout is working correctly if I use my previous theme. The other thing is it's saying Duplicate entry '63' for key 'UNQ_SALES_FLAT_ORDER_INCREMENT_ID'. I have checked the Magento database - there the increment invoice is in thousands. Could it be conflicting with an extension?
ANY Help will be appreciated. I have already checked all other answers regarding Integrity Constraints on Magento and tried all the solutions but it didn't work
Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '63' 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`, `auctaneapi_discounts`, `fee_amount`, `base_fee_amount`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '2018-01-23 23:17:07', '2018-01-23 23:17:07', ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' in /home/template/public_html/lib/Zend/Db/Statement/Pdo.php:235
Stack trace:
/home/template/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
/home/template/public_html/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
/home/template/public_html/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
/home/template/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `sa...', Array)
/home/template/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `sa...', Array)
/home/template/public_html/lib/Zend/Db/Adapter/Abstract.php(576): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `sa...', Array)
/home/template/public_html/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(453): Zend_Db_Adapter_Abstract->insert('sales_flat_orde...', Array)
/home/template/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))
/home/template/public_html/app/code/core/Mage/Core/Model/Abstract.php(318): Mage_Sales_Model_Resource_Order_Abstract->save(Object(Mage_Sales_Model_Order))
/home/template/public_html/app/code/core/Mage/Core/Model/Resource/Transaction.php(151): Mage_Core_Model_Abstract->save()
/home/template/public_html/app/code/core/Mage/Sales/Model/Service/Quote.php(189): Mage_Core_Model_Resource_Transaction->save()
/home/template/public_html/app/code/core/Mage/Sales/Model/Service/Quote.php(249): Mage_Sales_Model_Service_Quote->submitOrder()
/home/template/public_html/app/code/core/Mage/Checkout/Model/Type/Onepage.php(812): Mage_Sales_Model_Service_Quote->submitAll()
/home/template/public_html/app/code/core/Mage/Checkout/controllers/OnepageController.php(579): Mage_Checkout_Model_Type_Onepage->saveOrder()
/home/template/public_html/app/code/local/WP/OnePageCheckout/controllers/OnepageController.php(7): Mage_Checkout_OnepageController->saveOrderAction()
/home/template/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(418): WP_OnePageCheckout_OnepageController->saveOrderAction()
/home/template/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('saveOrder')
/home/template/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))
/home/template/public_html/app/code/core/Mage/Core/Model/App.php(365): Mage_Core_Controller_Varien_Front->dispatch()
/home/template/public_html/app/Mage.php(684): Mage_Core_Model_App->run(Array)
/home/template/public_html/index.php(90): Mage::run('', 'store')
main
magento-1.9 checkout database orders onepage-checkout
edited Apr 7 '18 at 6:49
Teja Bhagavan Kollepara
2,9994 gold badges20 silver badges51 bronze badges
asked Jan 23 '18 at 23:32
Piyush SharmaPiyush Sharma
12 bronze badges
add a comment |
0
After I changed my theme I am getting error messages in Magento log and also the checkout is working correctly if I use my previous theme. The other thing is it's saying Duplicate entry '63' for key 'UNQ_SALES_FLAT_ORDER_INCREMENT_ID'. I have checked the Magento database - there the increment invoice is in thousands. Could it be conflicting with an extension?
ANY Help will be appreciated. I have already checked all other answers regarding Integrity Constraints on Magento and tried all the solutions but it didn't work
Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '63' 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`, `auctaneapi_discounts`, `fee_amount`, `base_fee_amount`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '2018-01-23 23:17:07', '2018-01-23 23:17:07', ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' in /home/template/public_html/lib/Zend/Db/Statement/Pdo.php:235
Stack trace:
/home/template/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
/home/template/public_html/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
/home/template/public_html/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
/home/template/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `sa...', Array)
/home/template/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `sa...', Array)
/home/template/public_html/lib/Zend/Db/Adapter/Abstract.php(576): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `sa...', Array)
/home/template/public_html/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(453): Zend_Db_Adapter_Abstract->insert('sales_flat_orde...', Array)
/home/template/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))
/home/template/public_html/app/code/core/Mage/Core/Model/Abstract.php(318): Mage_Sales_Model_Resource_Order_Abstract->save(Object(Mage_Sales_Model_Order))
/home/template/public_html/app/code/core/Mage/Core/Model/Resource/Transaction.php(151): Mage_Core_Model_Abstract->save()
/home/template/public_html/app/code/core/Mage/Sales/Model/Service/Quote.php(189): Mage_Core_Model_Resource_Transaction->save()
/home/template/public_html/app/code/core/Mage/Sales/Model/Service/Quote.php(249): Mage_Sales_Model_Service_Quote->submitOrder()
/home/template/public_html/app/code/core/Mage/Checkout/Model/Type/Onepage.php(812): Mage_Sales_Model_Service_Quote->submitAll()
/home/template/public_html/app/code/core/Mage/Checkout/controllers/OnepageController.php(579): Mage_Checkout_Model_Type_Onepage->saveOrder()
/home/template/public_html/app/code/local/WP/OnePageCheckout/controllers/OnepageController.php(7): Mage_Checkout_OnepageController->saveOrderAction()
/home/template/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(418): WP_OnePageCheckout_OnepageController->saveOrderAction()
/home/template/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('saveOrder')
/home/template/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))
/home/template/public_html/app/code/core/Mage/Core/Model/App.php(365): Mage_Core_Controller_Varien_Front->dispatch()
/home/template/public_html/app/Mage.php(684): Mage_Core_Model_App->run(Array)
/home/template/public_html/index.php(90): Mage::run('', 'store')
main
magento-1.9 checkout database orders onepage-checkout
edited Apr 7 '18 at 6:49
Teja Bhagavan Kollepara
2,9994 gold badges20 silver badges51 bronze badges
asked Jan 23 '18 at 23:32
Piyush SharmaPiyush Sharma
12 bronze badges
Did you create new store for new theme?
– A.Maksymiuk
Jan 24 '18 at 7:32
yes i have install this theme for separate store... where as in my default store where my previous theme is installed.. the checkout is working correctly....
– Piyush Sharma
Jan 24 '18 at 20:05
add a comment |
0
0
0
0
After I changed my theme I am getting error messages in Magento log and also the checkout is working correctly if I use my previous theme. The other thing is it's saying Duplicate entry '63' for key 'UNQ_SALES_FLAT_ORDER_INCREMENT_ID'. I have checked the Magento database - there the increment invoice is in thousands. Could it be conflicting with an extension?
ANY Help will be appreciated. I have already checked all other answers regarding Integrity Constraints on Magento and tried all the solutions but it didn't work
Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '63' 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`, `auctaneapi_discounts`, `fee_amount`, `base_fee_amount`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '2018-01-23 23:17:07', '2018-01-23 23:17:07', ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' in /home/template/public_html/lib/Zend/Db/Statement/Pdo.php:235
Stack trace:
/home/template/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
/home/template/public_html/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
/home/template/public_html/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
/home/template/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `sa...', Array)
/home/template/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `sa...', Array)
/home/template/public_html/lib/Zend/Db/Adapter/Abstract.php(576): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `sa...', Array)
/home/template/public_html/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(453): Zend_Db_Adapter_Abstract->insert('sales_flat_orde...', Array)
/home/template/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))
/home/template/public_html/app/code/core/Mage/Core/Model/Abstract.php(318): Mage_Sales_Model_Resource_Order_Abstract->save(Object(Mage_Sales_Model_Order))
/home/template/public_html/app/code/core/Mage/Core/Model/Resource/Transaction.php(151): Mage_Core_Model_Abstract->save()
/home/template/public_html/app/code/core/Mage/Sales/Model/Service/Quote.php(189): Mage_Core_Model_Resource_Transaction->save()
/home/template/public_html/app/code/core/Mage/Sales/Model/Service/Quote.php(249): Mage_Sales_Model_Service_Quote->submitOrder()
/home/template/public_html/app/code/core/Mage/Checkout/Model/Type/Onepage.php(812): Mage_Sales_Model_Service_Quote->submitAll()
/home/template/public_html/app/code/core/Mage/Checkout/controllers/OnepageController.php(579): Mage_Checkout_Model_Type_Onepage->saveOrder()
/home/template/public_html/app/code/local/WP/OnePageCheckout/controllers/OnepageController.php(7): Mage_Checkout_OnepageController->saveOrderAction()
/home/template/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(418): WP_OnePageCheckout_OnepageController->saveOrderAction()
/home/template/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('saveOrder')
/home/template/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))
/home/template/public_html/app/code/core/Mage/Core/Model/App.php(365): Mage_Core_Controller_Varien_Front->dispatch()
/home/template/public_html/app/Mage.php(684): Mage_Core_Model_App->run(Array)
/home/template/public_html/index.php(90): Mage::run('', 'store')
main
magento-1.9 checkout database orders onepage-checkout
edited Apr 7 '18 at 6:49
Teja Bhagavan Kollepara
2,9994 gold badges20 silver badges51 bronze badges
asked Jan 23 '18 at 23:32
Piyush SharmaPiyush Sharma
12 bronze badges
After I changed my theme I am getting error messages in Magento log and also the checkout is working correctly if I use my previous theme. The other thing is it's saying Duplicate entry '63' for key 'UNQ_SALES_FLAT_ORDER_INCREMENT_ID'. I have checked the Magento database - there the increment invoice is in thousands. Could it be conflicting with an extension?
ANY Help will be appreciated. I have already checked all other answers regarding Integrity Constraints on Magento and tried all the solutions but it didn't work
Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '63' 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`, `auctaneapi_discounts`, `fee_amount`, `base_fee_amount`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '2018-01-23 23:17:07', '2018-01-23 23:17:07', ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' in /home/template/public_html/lib/Zend/Db/Statement/Pdo.php:235
Stack trace:
/home/template/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
/home/template/public_html/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
/home/template/public_html/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
/home/template/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `sa...', Array)
/home/template/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `sa...', Array)
/home/template/public_html/lib/Zend/Db/Adapter/Abstract.php(576): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `sa...', Array)
/home/template/public_html/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(453): Zend_Db_Adapter_Abstract->insert('sales_flat_orde...', Array)
/home/template/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))
/home/template/public_html/app/code/core/Mage/Core/Model/Abstract.php(318): Mage_Sales_Model_Resource_Order_Abstract->save(Object(Mage_Sales_Model_Order))
/home/template/public_html/app/code/core/Mage/Core/Model/Resource/Transaction.php(151): Mage_Core_Model_Abstract->save()
/home/template/public_html/app/code/core/Mage/Sales/Model/Service/Quote.php(189): Mage_Core_Model_Resource_Transaction->save()
/home/template/public_html/app/code/core/Mage/Sales/Model/Service/Quote.php(249): Mage_Sales_Model_Service_Quote->submitOrder()
/home/template/public_html/app/code/core/Mage/Checkout/Model/Type/Onepage.php(812): Mage_Sales_Model_Service_Quote->submitAll()
/home/template/public_html/app/code/core/Mage/Checkout/controllers/OnepageController.php(579): Mage_Checkout_Model_Type_Onepage->saveOrder()
/home/template/public_html/app/code/local/WP/OnePageCheckout/controllers/OnepageController.php(7): Mage_Checkout_OnepageController->saveOrderAction()
/home/template/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(418): WP_OnePageCheckout_OnepageController->saveOrderAction()
/home/template/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('saveOrder')
/home/template/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))
/home/template/public_html/app/code/core/Mage/Core/Model/App.php(365): Mage_Core_Controller_Varien_Front->dispatch()
/home/template/public_html/app/Mage.php(684): Mage_Core_Model_App->run(Array)
/home/template/public_html/index.php(90): Mage::run('', 'store')
main
magento-1.9 checkout database orders onepage-checkout
magento-1.9 checkout database orders onepage-checkout
edited Apr 7 '18 at 6:49
Teja Bhagavan Kollepara
2,9994 gold badges20 silver badges51 bronze badges
asked Jan 23 '18 at 23:32
Piyush SharmaPiyush Sharma
12 bronze badges
edited Apr 7 '18 at 6:49
Teja Bhagavan Kollepara
2,9994 gold badges20 silver badges51 bronze badges
asked Jan 23 '18 at 23:32
Piyush SharmaPiyush Sharma
12 bronze badges
edited Apr 7 '18 at 6:49
Teja Bhagavan Kollepara
2,9994 gold badges20 silver badges51 bronze badges
edited Apr 7 '18 at 6:49
Teja Bhagavan Kollepara
2,9994 gold badges20 silver badges51 bronze badges
edited Apr 7 '18 at 6:49
Teja Bhagavan Kollepara
2,9994 gold badges20 silver badges51 bronze badges
2,9994 gold badges20 silver badges51 bronze badges
asked Jan 23 '18 at 23:32
Piyush SharmaPiyush Sharma
12 bronze badges
asked Jan 23 '18 at 23:32
Piyush SharmaPiyush Sharma
12 bronze badges
asked Jan 23 '18 at 23:32
Piyush SharmaPiyush Sharma
12 bronze badges
12 bronze badges
Did you create new store for new theme?
– A.Maksymiuk
Jan 24 '18 at 7:32
yes i have install this theme for separate store... where as in my default store where my previous theme is installed.. the checkout is working correctly....
– Piyush Sharma
Jan 24 '18 at 20:05
add a comment |
Did you create new store for new theme?
– A.Maksymiuk
Jan 24 '18 at 7:32
yes i have install this theme for separate store... where as in my default store where my previous theme is installed.. the checkout is working correctly....
– Piyush Sharma
Jan 24 '18 at 20:05
Did you create new store for new theme?
– A.Maksymiuk
Jan 24 '18 at 7:32
Did you create new store for new theme?
– A.Maksymiuk
Jan 24 '18 at 7:32
yes i have install this theme for separate store... where as in my default store where my previous theme is installed.. the checkout is working correctly....
– Piyush Sharma
Jan 24 '18 at 20:05
yes i have install this theme for separate store... where as in my default store where my previous theme is installed.. the checkout is working correctly....
– Piyush Sharma
Jan 24 '18 at 20:05
add a comment |
1 Answer
1
active
oldest
votes
0
Something is wrong for your last_increment_id for this store.
There is "64" value for store id 11, should be something like 11000064.
answered Jan 25 '18 at 6:50
A.MaksymiukA.Maksymiuk
4735 silver badges13 bronze badges
Hi thanks for the comments where as it has nothing to do with that store. The template which i set up is for store no 6 where as i have find the issue. The issue is i am adding item in cart on store 6 where as when i jump to checkout it automatically set another store in session, that's why the store id is conflicting and i am unable to create a order.
– Piyush Sharma
Jan 26 '18 at 13:04
I will check it again that i am facing this situation because of this error which is auto set another store when i jump on checkout page else i will wait for correct answer.
– Piyush Sharma
Jan 26 '18 at 13:06
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f210737%2fintegrity-constraint-violation-1062-duplicate-entry-after-theme-change%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
0
Something is wrong for your last_increment_id for this store.
There is "64" value for store id 11, should be something like 11000064.
answered Jan 25 '18 at 6:50
A.MaksymiukA.Maksymiuk
4735 silver badges13 bronze badges
Hi thanks for the comments where as it has nothing to do with that store. The template which i set up is for store no 6 where as i have find the issue. The issue is i am adding item in cart on store 6 where as when i jump to checkout it automatically set another store in session, that's why the store id is conflicting and i am unable to create a order.
– Piyush Sharma
Jan 26 '18 at 13:04
I will check it again that i am facing this situation because of this error which is auto set another store when i jump on checkout page else i will wait for correct answer.
– Piyush Sharma
Jan 26 '18 at 13:06
add a comment |
0
Something is wrong for your last_increment_id for this store.
There is "64" value for store id 11, should be something like 11000064.
answered Jan 25 '18 at 6:50
A.MaksymiukA.Maksymiuk
4735 silver badges13 bronze badges
Hi thanks for the comments where as it has nothing to do with that store. The template which i set up is for store no 6 where as i have find the issue. The issue is i am adding item in cart on store 6 where as when i jump to checkout it automatically set another store in session, that's why the store id is conflicting and i am unable to create a order.
– Piyush Sharma
Jan 26 '18 at 13:04
I will check it again that i am facing this situation because of this error which is auto set another store when i jump on checkout page else i will wait for correct answer.
– Piyush Sharma
Jan 26 '18 at 13:06
add a comment |
0
0
0
Something is wrong for your last_increment_id for this store.
There is "64" value for store id 11, should be something like 11000064.
answered Jan 25 '18 at 6:50
A.MaksymiukA.Maksymiuk
4735 silver badges13 bronze badges
Something is wrong for your last_increment_id for this store.
There is "64" value for store id 11, should be something like 11000064.
answered Jan 25 '18 at 6:50
A.MaksymiukA.Maksymiuk
4735 silver badges13 bronze badges
answered Jan 25 '18 at 6:50
A.MaksymiukA.Maksymiuk
4735 silver badges13 bronze badges
answered Jan 25 '18 at 6:50
A.MaksymiukA.Maksymiuk
4735 silver badges13 bronze badges
answered Jan 25 '18 at 6:50
A.MaksymiukA.Maksymiuk
4735 silver badges13 bronze badges
4735 silver badges13 bronze badges
Hi thanks for the comments where as it has nothing to do with that store. The template which i set up is for store no 6 where as i have find the issue. The issue is i am adding item in cart on store 6 where as when i jump to checkout it automatically set another store in session, that's why the store id is conflicting and i am unable to create a order.
– Piyush Sharma
Jan 26 '18 at 13:04
I will check it again that i am facing this situation because of this error which is auto set another store when i jump on checkout page else i will wait for correct answer.
– Piyush Sharma
Jan 26 '18 at 13:06
add a comment |
Hi thanks for the comments where as it has nothing to do with that store. The template which i set up is for store no 6 where as i have find the issue. The issue is i am adding item in cart on store 6 where as when i jump to checkout it automatically set another store in session, that's why the store id is conflicting and i am unable to create a order.
– Piyush Sharma
Jan 26 '18 at 13:04
I will check it again that i am facing this situation because of this error which is auto set another store when i jump on checkout page else i will wait for correct answer.
– Piyush Sharma
Jan 26 '18 at 13:06
Hi thanks for the comments where as it has nothing to do with that store. The template which i set up is for store no 6 where as i have find the issue. The issue is i am adding item in cart on store 6 where as when i jump to checkout it automatically set another store in session, that's why the store id is conflicting and i am unable to create a order.
– Piyush Sharma
Jan 26 '18 at 13:04
Hi thanks for the comments where as it has nothing to do with that store. The template which i set up is for store no 6 where as i have find the issue. The issue is i am adding item in cart on store 6 where as when i jump to checkout it automatically set another store in session, that's why the store id is conflicting and i am unable to create a order.
– Piyush Sharma
Jan 26 '18 at 13:04
I will check it again that i am facing this situation because of this error which is auto set another store when i jump on checkout page else i will wait for correct answer.
– Piyush Sharma
Jan 26 '18 at 13:06
I will check it again that i am facing this situation because of this error which is auto set another store when i jump on checkout page else i will wait for correct answer.
– Piyush Sharma
Jan 26 '18 at 13:06
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Magento Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f210737%2fintegrity-constraint-violation-1062-duplicate-entry-after-theme-change%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Did you create new store for new theme?
– A.Maksymiuk
Jan 24 '18 at 7:32
yes i have install this theme for separate store... where as in my default store where my previous theme is installed.. the checkout is working correctly....
– Piyush Sharma
Jan 24 '18 at 20:05