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

Magento 1.6.2 > 1.7 Cannot initialize the indexer process. Product Price
 
skymind
Jr. Member
 
Total Posts:  24
Joined:  2009-09-27
 

Hi,

I have to following error message after upgrade from Magento 1.6.2 > 1.7 Cannot initialize the indexer process. Product Price

Can anybody help to point out what has gone wrong and where i should start looking to correct this?

Next exception ‘Zend_Db_Statement_Exception’ with message ‘SQLSTATE[21S01]: Inse rt value list does not match column list: 1136 Column count doesn’t match value count at row 1’ in /home/partyera/public_html/lib/Zend/Db/Statement/Pdo.php:234
Stack trace:
#0 /home/partyera/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_D b_Statement_Pdo->_execute(Array)
#1 /home/partyera/public_html/lib/Zend/Db/Statement.php(300): Varien_Db_Statemen t_Pdo_Mysql->_execute(Array)
#2 /home/partyera/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Sta tement->execute(Array)
#3 /home/partyera/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db _Adapter_Abstract->query(’INSERT INTO `ca...’, Array)
#4 /home/partyera/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_ Adapter_Pdo_Abstract->query(’INSERT INTO `ca...’, Array)
#5 /home/partyera/public_html/app/code/core/Mage/Index/Model/Resource/Abstract.p hp(179): Varien_Db_Adapter_Pdo_Mysql->query(’INSERT INTO `ca...’)
#6 /home/partyera/public_html/app/code/core/Mage/Index/Model/Resource/Helper/Mys ql4.php(48): Mage_Index_Model_Resource_Abstract->insertFromSelect(Object(Varien_ Db_Select), ‘catalog_product...’, Array, false)
#7 /home/partyera/public_html/app/code/core/Mage/Index/Model/Resource/Abstract.p hp(153): Mage_Index_Model_Resource_Helper_Mysql4->insertData(Object(Mage_Catalog _Model_Resource_Product_Indexer_Price), Object(Varien_Db_Select), ‘catalog_produ ct...’, Array, false)
#8 /home/partyera/public_html/app/code/core/Mage/Index/Model/Resource/Abstract.p hp(113): Mage_Index_Model_Resource_Abstract->insertFromTable(’catalog_product… ‘, ‘catalog_product...’, false)
#9 /home/partyera/public_html/app/code/core/Mage/Catalog/Model/Resource/Product/ Indexer/Price.php(388): Mage_Index_Model_Resource_Abstract->syncData()
#10 /home/partyera/public_html/app/code/core/Mage/Index/Model/Indexer/Abstract.p hp(143): Mage_Catalog_Model_Resource_Product_Indexer_Price->reindexAll()
#11 /home/partyera/public_html/app/code/core/Mage/Index/Model/Process.php(209):  Mage_Index_Model_Indexer_Abstract->reindexAll()
#12 /home/partyera/public_html/app/code/core/Mage/Index/Model/Process.php(255):  Mage_Index_Model_Process->reindexAll()
#13 /home/partyera/public_html/shell/indexer.php(158): Mage_Index_Model_Process- >reindexEverything()
#14 /home/partyera/public_html/shell/indexer.php(198): Mage_Shell_Compiler->run( )
#15 {main}

 
Magento Community Magento Community
Magento Community
Magento Community
 
skymind
Jr. Member
 
Total Posts:  24
Joined:  2009-09-27
 

Resolved on it’s own after truncate, or empty:

dataflow_batch_export
dataflow_batch_import
log_url
log_url_info
log_visitor
log_visitor_info
report_event

hope some of you find this useful!

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