Forum Forum Magento Theme SNS Codia – Magento Theme "Cannot save shipment" error

  • Author
    Posts
  • #22366

    sennon
    Participant

    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}

You must be logged in to reply to this topic. Click here to login or register