magento:无法将产品添加到购物车-主键
magento:无法将产品添加到购物车-主键
提问于 2014-09-04 16:44:12
所以昨天，我的magento ishop坏了，我不能在购物车里添加任何产品。
当我点击“添加到购物车”时，它会将我重定向到购物车，并说：
“无法将项目添加到购物车。”
这是我的日志：
/*
* 提示：该行代码过长，系统自动注释不进行高亮。一键复制会移除系统注释
* exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'' in /var/www/clients/client23/web66/web/tests/lib/Zend/Db/Statement/Pdo.php:228 Stack trace: #0 /var/www/clients/client23/web66/web/tests/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array) #1 /var/www/clients/client23/web66/web/tests/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array) #2 /var/www/clients/client23/web66/web/tests/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array) #3 /var/www/clients/client23/web66/web/tests/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array) #4 /var/www/clients/client23/web66/web/tests/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `sa...', Array) #5 /var/www/clients/client23/web66/web/tests/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `sa...', Array) #6 /var/www/clients/client23/web66/web/tests/lib/Zend/Db/Adapter/Abstract.php(574): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `sa...', Array) #7 /var/www/clients/client23/web66/web/tests/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(453): Zend_Db_Adapter_Abstract->insert('sales_flat_quot...', Array) #8 /var/www/clients/client23/web66/web/tests/app/code/core/Mage/Core/Model/Abstract.php(318): Mage_Core_Model_Resource_Db_Abstract->save(Object(Mage_Sales_Model_Quote)) #9 /var/www/clients/client23/web66/web/tests/app/code/core/Mage/Sales/Model/Quote.php(1898): Mage_Core_Model_Abstract->save() #10 /var/www/clients/client23/web66/web/tests/app/code/core/Mage/Checkout/Model/Cart.php(465): Mage_Sales_Model_Quote->save() #11 /var/www/clients/client23/web66/web/tests/app/code/core/Mage/Checkout/controllers/CartController.php(198): Mage_Checkout_Model_Cart->save() #12 /var/www/clients/client23/web66/web/tests/app/code/core/Mage/Core/Controller/Varien/Action.php(419): Mage_Checkout_CartController->addAction() #13 /var/www/clients/client23/web66/web/tests/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('add') #14 /var/www/clients/client23/web66/web/tests/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http)) #15 /var/www/clients/client23/web66/web/tests/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch() #16 /var/www/clients/client23/web66/web/tests/app/Mage.php(683): Mage_Core_Model_App->run(Array) #17 /var/www/clients/client23/web66/web/tests/index.php(89): Mage::run('', 'store') #18 {main} Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'' in /var/www/clients/client23/web66/web/tests/lib/Zend/Db/Statement/Pdo.php:234 Stack trace: #0 /var/www/clients/client23/web66/web/tests/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array) #1 /var/www/clients/client23/web66/web/tests/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array) #2 /var/www/clients/client23/web66/web/tests/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array) #3 /var/www/clients/client23/web66/web/tests/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `sa...', Array) #4 /var/www/clients/client23/web66/web/tests/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `sa...', Array) #5 /var/www/clients/client23/web66/web/tests/lib/Zend/Db/Adapter/Abstract.php(574): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `sa...', Array) #6 /var/www/clients/client23/web66/web/tests/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(453): Zend_Db_Adapter_Abstract->insert('sales_flat_quot...', Array) #7 /var/www/clients/client23/web66/web/tests/app/code/core/Mage/Core/Model/Abstract.php(318): Mage_Core_Model_Resource_Db_Abstract->save(Object(Mage_Sales_Model_Quote)) #8 /var/www/clients/client23/web66/web/tests/app/code/core/Mage/Sales/Model/Quote.php(1898): Mage_Core_Model_Abstract->save() #9 /var/www/clients/client23/web66/web/tests/app/code/core/Mage/Checkout/Model/Cart.php(465): Mage_Sales_Model_Quote->save() #10 /var/www/clients/client23/web66/web/tests/app/code/core/Mage/Checkout/controllers/CartController.php(198): Mage_Checkout_Model_Cart->save() #11 /var/www/clients/client23/web66/web/tests/app/code/core/Mage/Core/Controller/Varien/Action.php(419): Mage_Checkout_CartController->addAction() #12 /var/www/clients/client23/web66/web/tests/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('add') #13 /var/www/clients/client23/web66/web/tests/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http)) #14 /var/www/clients/client23/web66/web/tests/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch() #15 /var/www/clients/client23/web66/web/tests/app/Mage.php(683): Mage_Core_Model_App->run(Array) #16 /var/www/clients/client23/web66/web/tests/index.php(89): Mage::run('', 'store') #17 {main}
*/我真的希望，有人会想出一些东西来。
(我在谷歌上搜索了几个小时，什么也没找到。)
在此，iddi margšing
回答 1
Stack Overflow用户
发布于 2014-09-04 18:05:48
我以前见过这个问题。在Magento API之外写入数据库时发生了此问题，并且出现了一些错误。一个简单的解决方案是打开sql日志来记录所有MySQL查询。在命令行上，通过使用尾部程序和尾部标志(如-f -f general.log )实时查看mysql常规日志。
现在尝试执行违反完整性约束的操作，您应该在日志中看到尝试的sql查询。有了这些信息，您应该能够更好地跟踪问题，并在需要时删除数据库中的错误条目。
有时它也是由于与产品相关的扩展而发生的。在这种情况下，禁用所有第三方扩展，然后尝试添加产品。
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/25661004
复制相关文章
相似问题
腾讯云开发者
