Forum › Forum › Magento Theme › SNS Codia – Magento Theme › "Cannot save shipment" error
-
AuthorPosts
-
July 22, 2016 at 11:27 am #22366
Hello,
Thank you for always help me a lot.When I submit shipment from admin, “Cannot save shipment” error occurs
And also “Unable to save the invoice” error occurs when I try “submit invoice” with the shipping information by creating shipment.It is strange that when I try submit shipment for codia’s sample data, the error doesn’t occur.
I checked exception.log and the following is the error log for “cannot save shipment” error.
Do you support this? If you don’t, would you please teach me which file I should check?2016-07-18T13:11:08+00:00 ERR (3):
exception ‘PDOException’ with message ‘SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘400000001’ for key ‘UNQ_SALES_FLAT_SHIPMENT_INCREMENT_ID” in /mydomain.com/lib/Zend/Db/Statement/Pdo.php:228
Stack trace:
/mydomain.com/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
/mydomain.com/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
/mydomain.com/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
/mydomain.com/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
/mydomain.com/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(‘INSERT INTO `sa…’, Array)
/mydomain.com/lib/Varien/Db/Adapter/Pdo/Mysql.php(428): Zend_Db_Adapter_Pdo_Abstract->query(‘INSERT INTO `sa…’, Array)
/mydomain.com/lib/Zend/Db/Adapter/Abstract.php(576): Varien_Db_Adapter_Pdo_Mysql->query(‘INSERT INTO `sa…’, Array)
/mydomain.com/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(453): Zend_Db_Adapter_Abstract->insert(‘sales_flat_ship…’, Array)
/mydomain.com/app/code/core/Mage/Sales/Model/Resource/Order/Abstract.php(425): Mage_Core_Model_Resource_Db_Abstract->save(Object(Mage_Sales_Model_Order_Shipment))
/mydomain.com/app/code/core/Mage/Core/Model/Abstract.php(318): Mage_Sales_Model_Resource_Order_Abstract->save(Object(Mage_Sales_Model_Order_Shipment))
/mydomain.com/app/code/core/Mage/Core/Model/Resource/Transaction.php(151): Mage_Core_Model_Abstract->save()
/mydomain.com/app/code/core/Mage/Adminhtml/controllers/Sales/Order/ShipmentController.php(120): Mage_Core_Model_Resource_Transaction->save()
/mydomain.com/app/code/core/Mage/Adminhtml/controllers/Sales/Order/ShipmentController.php(220): Mage_Adminhtml_Sales_Order_ShipmentController->_saveShipment(Object(Mage_Sales_Model_Order_Shipment))
/mydomain.com/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Adminhtml_Sales_Order_ShipmentController->saveAction()
/mydomain.com/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch(‘save’)
/mydomain.com/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
/mydomain.com/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
/mydomain.com/app/Mage.php(684): Mage_Core_Model_App->run(Array)
/mydomain.com/index.php(87): Mage::run(”, ‘store’)
{main}Next exception ‘Zend_Db_Statement_Exception’ with message ‘SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘400000001’ for key ‘UNQ_SALES_FLAT_SHIPMENT_INCREMENT_ID’, query was: INSERT INTO
sales_flat_shipment
(store_id
,total_qty
,email_sent
,order_id
,customer_id
,shipping_address_id
,billing_address_id
,increment_id
,created_at
,updated_at
) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ‘2016-07-18 13:11:08’, ‘2016-07-18 13:11:08′)’ in /mydomain.com/lib/Zend/Db/Statement/Pdo.php:235
Stack trace:
/mydomain.com/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
/mydomain.com/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
/mydomain.com/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
/mydomain.com/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(‘INSERT INTO `sa…’, Array)
/mydomain.com/lib/Varien/Db/Adapter/Pdo/Mysql.php(428): Zend_Db_Adapter_Pdo_Abstract->query(‘INSERT INTO `sa…’, Array)
/mydomain.com/lib/Zend/Db/Adapter/Abstract.php(576): Varien_Db_Adapter_Pdo_Mysql->query(‘INSERT INTO `sa…’, Array)
/mydomain.com/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(453): Zend_Db_Adapter_Abstract->insert(‘sales_flat_ship…’, Array)
/mydomain.com/app/code/core/Mage/Sales/Model/Resource/Order/Abstract.php(425): Mage_Core_Model_Resource_Db_Abstract->save(Object(Mage_Sales_Model_Order_Shipment))
/mydomain.com/app/code/core/Mage/Core/Model/Abstract.php(318): Mage_Sales_Model_Resource_Order_Abstract->save(Object(Mage_Sales_Model_Order_Shipment))
/mydomain.com/app/code/core/Mage/Core/Model/Resource/Transaction.php(151): Mage_Core_Model_Abstract->save()
/mydomain.com/app/code/core/Mage/Adminhtml/controllers/Sales/Order/ShipmentController.php(120): Mage_Core_Model_Resource_Transaction->save()
/mydomain.com/app/code/core/Mage/Adminhtml/controllers/Sales/Order/ShipmentController.php(220): Mage_Adminhtml_Sales_Order_ShipmentController->_saveShipment(Object(Mage_Sales_Model_Order_Shipment))
/mydomain.com/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Adminhtml_Sales_Order_ShipmentController->saveAction()
/mydomain.com/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch(‘save’)
/mydomain.com/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
/mydomain.com/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
/mydomain.com/app/Mage.php(684): Mage_Core_Model_App->run(Array)
/mydomain.com/index.php(87): Mage::run(”, ‘store’)
{main} -
AuthorPosts
You must be logged in to reply to this topic. Click here to login or register
Useful
Recent Topics
Support Policy
- Official hour: Mon-Fri / 9am-5pm
- Location time: GMT + 7