douchen5971 2014-08-20 14:02
浏览 27

不能在magento中复制产品

my ideas where to search for the error are decreasing any minute.

If i try to duplicate products from the admin panel i get this error:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'attribute_id' in 'where clause'

In the exception.log i find:

Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'attribute_id' in 'where clause'' in /data/webs/128/12312/public_html/lib/Zend/Db/Statement/Pdo.php:234
Stack trace:
#0 /data/webs/128/12312/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /data/webs/128/12312/public_html/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /data/webs/128/12312/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /data/webs/128/12312/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('DELETE FROM `ca...', Array)
#4 /data/webs/128/12312/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query('DELETE FROM `ca...', Array)
#5 /data/webs/128/12312/public_html/lib/Zend/Db/Adapter/Abstract.php(661): Varien_Db_Adapter_Pdo_Mysql->query('DELETE FROM `ca...')
#6 /data/webs/128/12312/public_html/app/code/core/Mage/Catalog/Model/Resource/Abstract.php(236): Zend_Db_Adapter_Abstract->delete('catalog_product...', Array)
#7 /data/webs/128/12312/public_html/app/code/core/Mage/Catalog/Model/Resource/Product/Action.php(78): Mage_Catalog_Model_Resource_Abstract->_saveAttributeValue(Object(Varien_Object), Object(Mage_Catalog_Model_Resource_Eav_Attribute), '0000000003636')
#8 /data/webs/128/12312/public_html/app/code/core/Mage/Catalog/Model/Product/Action.php(72): Mage_Catalog_Model_Resource_Product_Action->updateAttributes(Array, Array, 0)
#9 /data/webs/128/12312/public_html/app/code/community/MDN/BarcodeLabel/Helper/Generation.php(36): Mage_Catalog_Model_Product_Action->updateAttributes(Array, Array, 0)
#10 /data/webs/128/12312/public_html/app/code/community/MDN/BarcodeLabel/Model/Observer.php(50): MDN_BarcodeLabel_Helper_Generation->storeBarcode('363')
#11 /data/webs/128/12312/public_html/app/code/core/Mage/Core/Model/App.php(1338): MDN_BarcodeLabel_Model_Observer->model_save_after(Object(Varien_Event_Observer))
#12 /data/webs/128/12312/public_html/app/code/core/Mage/Core/Model/App.php(1317): Mage_Core_Model_App->_callObserverMethod(Object(MDN_BarcodeLabel_Model_Observer), 'model_save_afte...', Object(Varien_Event_Observer))
#13 /data/webs/128/12312/public_html/app/Mage.php(447): Mage_Core_Model_App->dispatchEvent('model_save_afte...', Array)
#14 /data/webs/128/12312/public_html/app/code/core/Mage/Core/Model/Abstract.php(465): Mage::dispatchEvent('model_save_afte...', Array)
#15 /data/webs/128/12312/public_html/app/code/core/Mage/Catalog/Model/Product.php(548): Mage_Core_Model_Abstract->_afterSave()
#16 /data/webs/128/12312/public_html/app/code/community/MDN/AdvancedStock/Model/Catalog/Product.php(23): Mage_Catalog_Model_Product->_afterSave()
#17 /data/webs/128/12312/public_html/app/code/core/Mage/Core/Model/Abstract.php(319): MDN_AdvancedStock_Model_Catalog_Product->_afterSave()
#18 /data/webs/128/12312/public_html/app/code/core/Mage/Catalog/Model/Product.php(1142): Mage_Core_Model_Abstract->save()
#19 /data/webs/128/12312/public_html/app/code/core/Mage/Adminhtml/controllers/Catalog/ProductController.php(767): Mage_Catalog_Model_Product->duplicate()
#20 /data/webs/128/12312/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(419): Mage_Adminhtml_Catalog_ProductController->duplicateAction()
#21 /data/webs/128/12312/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('duplicate')
#22 /data/webs/128/12312/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#23 /data/webs/128/12312/public_html/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#24 /data/webs/128/12312/public_html/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#25 /data/webs/128/12312/public_html/index.php(89): Mage::run('', 'store')
#26 {main}

I checked the database and the field attribute_id is there, if i try to just remove the association from the code it says there is no field shop_id and so on. They all do exist.

It seems to have something todo with the zend framework, as tablename and attributes seem correct as far as i can tell.

Any ideas how this can happen?

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 Arcgis相交分析无法绘制一个或多个图形
    • ¥15 seatunnel-web使用SQL组件时候后台报错,无法找到表格
    • ¥15 fpga自动售货机数码管(相关搜索:数字时钟)
    • ¥15 用前端向数据库插入数据,通过debug发现数据能走到后端,但是放行之后就会提示错误
    • ¥30 3天&7天&&15天&销量如何统计同一行
    • ¥30 帮我写一段可以读取LD2450数据并计算距离的Arduino代码
    • ¥15 飞机曲面部件如机翼,壁板等具体的孔位模型
    • ¥15 vs2019中数据导出问题
    • ¥20 云服务Linux系统TCP-MSS值修改?
    • ¥20 关于#单片机#的问题:项目:使用模拟iic与ov2640通讯环境:F407问题:读取的ID号总是0xff,自己调了调发现在读从机数据时,SDA线上并未有信号变化(语言-c语言)