Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn’t match value count at row 1
 
greggel
Jr. Member
 
Total Posts:  2
Joined:  2012-02-20
 

Magento 1.5.1.0-rc1
Errors Indexing Product Prices as well as,
SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn’t match value count at row 1

2012-02-22T20:29:16+00:00 ERR (3):
exception ‘PDOException’ with message ‘SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn’t match value count at row 1’ in /data/17/2/114/139/2603465/user/2855550/htdocs/lib/Zend/Db/Statement/Pdo.php:228
Stack trace:
#0 /data/17/2/114/139/2603465/user/2855550/htdocs/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#1 /data/17/2/114/139/2603465/user/2855550/htdocs/lib/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array)
#2 /data/17/2/114/139/2603465/user/2855550/htdocs/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /data/17/2/114/139/2603465/user/2855550/htdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(’INSERT INTO `ca...’, Array)
#4 /data/17/2/114/139/2603465/user/2855550/htdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php(337): Zend_Db_Adapter_Pdo_Abstract->query(’INSERT INTO `ca...’, Array)
#5 /data/17/2/114/139/2603465/user/2855550/htdocs/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Product/Indexer/Price/Grouped.php(122): Varien_Db_Adapter_Pdo_Mysql->query(’INSERT INTO `ca...’)
#6 /data/17/2/114/139/2603465/user/2855550/htdocs/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Product/Indexer/Price/Grouped.php(58): Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Indexer_Price_Grouped->_prepareGroupedProductPriceData(Array)
#7 /data/17/2/114/139/2603465/user/2855550/htdocs/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Product/Indexer/Price.php(311): Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Indexer_Price_Grouped->reindexEntity(Array)
#8 /data/17/2/114/139/2603465/user/2855550/htdocs/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Product/Indexer/Price.php(242): Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Indexer_Price->reindexProductIds(Array)
#9 /data/17/2/114/139/2603465/user/2855550/htdocs/app/code/core/Mage/Index/Model/Indexer/Abstract.php(144): Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Indexer_Price->catalogProductMassAction(Object(Mage_Index_Model_Event))
#10 /data/17/2/114/139/2603465/user/2855550/htdocs/app/code/core/Mage/Catalog/Model/Product/Indexer/Price.php(256): Mage_Index_Model_Indexer_Abstract->callEventHandler(Object(Mage_Index_Model_Event))
#11 /data/17/2/114/139/2603465/user/2855550/htdocs/app/code/core/Mage/Index/Model/Indexer/Abstract.php(85): Mage_Catalog_Model_Product_Indexer_Price->_processEvent(Object(Mage_Index_Model_Event))
#12 /data/17/2/114/139/2603465/user/2855550/htdocs/app/code/core/Mage/Index/Model/Process.php(186): Mage_Index_Model_Indexer_Abstract->processEvent(Object(Mage_Index_Model_Event))
#13 /data/17/2/114/139/2603465/user/2855550/htdocs/app/code/core/Mage/Index/Model/Indexer.php(252): Mage_Index_Model_Process->processEvent(Object(Mage_Index_Model_Event))
#14 /data/17/2/114/139/2603465/user/2855550/htdocs/app/code/core/Mage/Index/Model/Indexer.php(154): Mage_Index_Model_Indexer->_runAll(Array, Array)
#15 /data/17/2/114/139/2603465/user/2855550/htdocs/app/code/core/Mage/Index/Model/Indexer.php(219): Mage_Index_Model_Indexer->indexEvent(’processEvent’, Array)
#16 /data/17/2/114/139/2603465/user/2855550/htdocs/app/code/core/Mage/CatalogInventory/Model/Mysql4/Indexer/Stock.php(86): Mage_Index_Model_Indexer->processEntityAction(Object(Mage_Index_Model_Event))
#17 /data/17/2/114/139/2603465/user/2855550/htdocs/app/code/core/Mage/Index/Model/Indexer/Abstract.php(144): Mage_CatalogInventory_Model_Mysql4_Indexer_Stock->cataloginventoryStockItemSave(Object(Varien_Object), ‘catalog_product’, ‘mass_action’)
#18 /data/17/2/114/139/2603465/user/2855550/htdocs/app/code/core/Mage/CatalogInventory/Model/Indexer/Stock.php(333): Mage_Index_Model_Indexer_Abstract->callEventHandler(Object(Mage_Index_Model_Event))
#19 /data/17/2/114/139/2603465/user/2855550/htdocs/app/code/core/Mage/Index/Model/Indexer/Abstract.php(85): Mage_CatalogInventory_Model_Indexer_Stock->_processEvent(Object(Mage_Index_Model_Event))
#20 /data/17/2/114/139/2603465/user/2855550/htdocs/app/code/core/Mage/Index/Model/Process.php(186): Mage_Index_Model_Indexer_Abstract->processEvent(Object(Mage_Index_Model_Event))
#21 /data/17/2/114/139/2603465/user/2855550/htdocs/app/code/core/Mage/Index/Model/Indexer.php(246): Mage_Index_Model_Process->processEvent(Object(Mage_Index_Model_Event))
#22 /data/17/2/114/139/2603465/user/2855550/htdocs/app/code/core/Mage/Index/Model/Indexer.php(154): Mage_Index_Model_Indexer->_runAll(Object(Mage_Index_Model_Event))
#23 /data/17/2/114/139/2603465/user/2855550/htdocs/app/code/core/Mage/Index/Model/Indexer.php(219): Mage_Index_Model_Indexer->indexEvent(Array, Array)
#24 /data/17/2/114/139/2603465/user/2855550/htdocs/app/code/core/Mage/CatalogInventory/Model/Stock/Item.php(717): Mage_Index_Model_Indexer->processEntityAction(’processEvent’, Array)
#25 /data/17/2/114/139/2603465/user/2855550/htdocs/app/code/core/Mage/Core/Model/Resource/Abstract.php(104): Mage_CatalogInventory_Model_Stock_Item->afterCommitCallback(Object(Mage_Index_Model_Event))
#26 /data/17/2/114/139/2603465/user/2855550/htdocs/app/code/core/Mage/Core/Model/Abstract.php(322): Mage_Core_Model_Resource_Abstract->commit(Object(Mage_CatalogInventory_Model_Stock_Item), ‘cataloginventor...’, ‘save’)
#27 /data/17/2/114/139/2603465/user/2855550/htdocs/app/code/core/Mage/Adminhtml/controllers/Catalog/ProductController.php(691): Mage_Core_Model_Abstract->save()
#28 /data/17/2/114/139/2603465/user/2855550/htdocs/app/code/core/Mage/Core/Controller/Varien/Action.php(420): Mage_Adminhtml_Catalog_ProductController->saveAction(Array)
#29 /data/17/2/114/139/2603465/user/2855550/htdocs/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(253): Mage_Core_Controller_Varien_Action->dispatch()
#30 /data/17/2/114/139/2603465/user/2855550/htdocs/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match()
#31 /data/17/2/114/139/2603465/user/2855550/htdocs/app/code/core/Mage/Core/Model/App.php(340): Mage_Core_Controller_Varien_Front->dispatch()
#32 /data/17/2/114/139/2603465/user/2855550/htdocs/app/Mage.php(627): Mage_Core_Model_App->run(’save’)
#33 /data/17/2/114/139/2603465/user/2855550/htdocs/index.php(80): Mage::run(Object(Mage_Core_Controller_Request_Http))
#34 {main}

Next exception ‘Zend_Db_Statement_Exception’ with message ‘SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn’t match value count at row 1’ in /data/17/2/114/139/2603465/user/2855550/htdocs/lib/Zend/Db/Statement/Pdo.php:234
Stack trace:

.. these are the error preventing me from finishing my work and it is urgent that I fix them.  I was not sure how much of the exception log to copy and paste but there was a bit more.

I am new at this company and just now have gained access to the SQL as well as the correct FTP address so I am ready to take any steps necessary if anybody can help me with this.

I am pretty sure this happened after installing some modules from magento connect but I had hoped that deleting them would fix the problem and it did not.  I would really appreciate the help if any of you could assist me with this.  Thank you.

 
Magento Community Magento Community
Magento Community
Magento Community
 
EthanMcFenton
Jr. Member
 
Total Posts:  7
Joined:  2013-04-24
 

Hey, did you ever get this sorted?

We are having the exact same issue, out of no where!

Ethan.

 
Magento Community Magento Community
Magento Community
Magento Community
 
lemax
Guru
 
Total Posts:  318
Joined:  2008-04-03
Nantes, France
 

Hi
Anyone has ever solved this reindexing problem ?
Thanks

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top