Magento Forum

   
“There was a problem with reindexing process.”
 
Rovisoft
Jr. Member
 
Total Posts:  1
Joined:  2009-02-20
 

We have recently upgraded magento to version 1.6 and we are now receiving this error “There was a problem with reindexing process.” when trying to index the product prices, anybody knows how to fix this issue?

We have tried the repair database magento script with no luck…

 
Magento Community Magento Community
Magento Community
Magento Community
 
kab8609
Enthusiast
 
Avatar
Total Posts:  813
Joined:  2009-04-07
Cleveland
 

First, clear out the folder var/locks/*

Second, using ssh, use this command “php shell/indexer.php --reindexall”

Wait for it to finish. If you get a error message, post the error message on this forum post (itll be like 20 lines long).

 
Magento Community Magento Community
Magento Community
Magento Community
 
Kbroeren
Jr. Member
 
Total Posts:  5
Joined:  2011-09-21
 

Here is the error in the log file. I have the same issue!

2012-07-12T22:02:49+00:00 DEBUG (7): Exception messageSQLSTATE[21S01]Insert value list does not match column list: 1136 Column count doesn\\\'t match value count at row 1
Trace: #0 /home/admin/domains/fxwinkel.nl/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/admin/domains/fxwinkel.nl/public_html/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /home/admin/domains/fxwinkel.nl/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /home/admin/domains/fxwinkel.nl/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(\\\'
INSERT INTO `ma...\\\', Array)
#4 /home/admin/domains/fxwinkel.nl/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query(\\\'INSERT INTO 
`ma...\\\', Array)
#5 /home/admin/domains/fxwinkel.nl/public_html/app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Price/Default.php(287): Varien_Db_Adapter_Pdo_Mysql->query(\\\'
INSERT INTO `ma...\\\')
#6 /home/admin/domains/fxwinkel.nl/public_html/app/code/core/Mage/Downloadable/Model/Resource/Indexer/Price.php(47): Mage_Catalog_Model_Resource_Product_Indexer_Price_Default->_prepareFinalPriceData()
#7 /home/admin/domains/fxwinkel.nl/public_html/app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Price.php(385): Mage_Downloadable_Model_Resource_Indexer_Price->reindexAll()
#8 /home/admin/domains/fxwinkel.nl/public_html/app/code/core/Mage/Index/Model/Indexer/Abstract.php(143): Mage_Catalog_Model_Resource_Product_Indexer_Price->reindexAll()
#9 /home/admin/domains/fxwinkel.nl/public_html/app/code/core/Mage/Index/Model/Process.php(209): Mage_Index_Model_Indexer_Abstract->reindexAll()
#10 /home/admin/domains/fxwinkel.nl/public_html/app/code/core/Mage/Index/Model/Process.php(255): Mage_Index_Model_Process->reindexAll()
#11 /home/admin/domains/fxwinkel.nl/public_html/app/code/core/Mage/Index/controllers/Adminhtml/ProcessController.php(124): Mage_Index_Model_Process->reindexEverything()
#12 /home/admin/domains/fxwinkel.nl/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(419): Mage_Index_Adminhtml_ProcessController->reindexProcessAction()
#13 /home/admin/domains/fxwinkel.nl/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch(\\\'reindexProcess\\\')
#14 /home/admin/domains/fxwinkel.nl/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))
#15 /home/admin/domains/fxwinkel.nl/public_html/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#16 /home/admin/domains/fxwinkel.nl/public_html/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#17 /home/admin/domains/fxwinkel.nl/public_html/index.php(87): Mage::run(\\\'\\\', \\\'store\\\')
#18 {main}

Thank you!
Kevin Broeren

 
Magento Community Magento Community
Magento Community
Magento Community
 
CoenPonsen
Jr. Member
 
Total Posts:  8
Joined:  2010-12-17
 

Same issue here..

 
Magento Community Magento Community
Magento Community
Magento Community
 
Kbroeren
Jr. Member
 
Total Posts:  5
Joined:  2011-09-21
 

Fixed it with database repair tool, great tool!

 
Magento Community Magento Community
Magento Community
Magento Community
 
CoenPonsen
Jr. Member
 
Total Posts:  8
Joined:  2010-12-17
 

Database repair tool didnt work for me:

Lots of foreign keys mising??

 
Magento Community Magento Community
Magento Community
Magento Community
 
webmacster
Jr. Member
 
Total Posts:  9
Joined:  2011-08-15
 

roduct Prices index process unknown error:
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 /home/mydomain.com/html/lib/Zend/Db/Statement/Pdo.php:228
Stack trace:
#0 /chroot/home/mydomain.com/html/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#1 /chroot/home/mydomain.com/html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#2 /chroot/home/mydomain.com/html/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#3 /chroot/home/mydomain.com/html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#4 /chroot/home/mydomain.com/html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(\'
INSERT INTO `ca...\', Array)
#5 /chroot/home/mydomain.com/html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query(\'INSERT INTO 
`ca...\', Array)
#6 /chroot/home/mydomain.com/html/app/code/community/OrganicInternet/SimpleConfigurableProducts/Catalog/Model/Resource/Eav/Mysql4/Product/Indexer/Price/Configurable.php(133): Varien_Db_Adapter_Pdo_Mysql->query(\'
INSERT INTO `ca...\')
#7 /chroot/home/mydomain.com/html/app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Price/Configurable.php(48): OrganicInternet_SimpleConfigurableProducts_Catalog_Model_Resource_Eav_Mysql4_Product_Indexer_Price_Configurable->_prepareFinalPriceData()
#8 /chroot/home/mydomain.com/html/app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Price.php(385): Mage_Catalog_Model_Resource_Product_Indexer_Price_Configurable->reindexAll()
#9 /chroot/home/mydomain.com/html/app/code/core/Mage/Index/Model/Indexer/Abstract.php(143): Mage_Catalog_Model_Resource_Product_Indexer_Price->reindexAll()
#10 /chroot/home/mydomain.com/html/app/code/core/Mage/Index/Model/Process.php(209): Mage_Index_Model_Indexer_Abstract->reindexAll()
#11 /chroot/home/mydomain.com/html/app/code/core/Mage/Index/Model/Process.php(255): Mage_Index_Model_Process->reindexAll()
#12 /chroot/home/mydomain.com/html/shell/indexer.php(158): Mage_Index_Model_Process->reindexEverything()
#13 /chroot/home/mydomain.com/html/shell/indexer.php(198): Mage_Shell_Compiler->run()
#14 {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 /chroot/home/mydomain.com/html/lib/Zend/Db/Statement/Pdo.php:234
Stack trace:
#0 /chroot/home/mydomain.com/html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /chroot/home/mydomain.com/html/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /chroot/home/mydomain.com/html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /chroot/home/mydomain.com/html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(\'INSERT INTO 
`ca...\', Array)
#4 /chroot/home/mydomain.com/html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query(\'
INSERT INTO `ca...\', Array)
#5 /chroot/home/mydomain.com/html/app/code/community/OrganicInternet/SimpleConfigurableProducts/Catalog/Model/Resource/Eav/Mysql4/Product/Indexer/Price/Configurable.php(133): Varien_Db_Adapter_Pdo_Mysql->query(\'INSERT INTO 
`ca...\')
#6 /chroot/home/mydomain.com/html/app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Price/Configurable.php(48): OrganicInternet_SimpleConfigurableProducts_Catalog_Model_Resource_Eav_Mysql4_Product_Indexer_Price_Configurable->_prepareFinalPriceData()
#7 /chroot/home/mydomain.com/html/app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Price.php(385): Mage_Catalog_Model_Resource_Product_Indexer_Price_Configurable->reindexAll()
#8 /chroot/home/mydomain.com/html/app/code/core/Mage/Index/Model/Indexer/Abstract.php(143): Mage_Catalog_Model_Resource_Product_Indexer_Price->reindexAll()
#9 /chroot/home/mydomain.com/html/app/code/core/Mage/Index/Model/Process.php(209): Mage_Index_Model_Indexer_Abstract->reindexAll()
#10 /chroot/home/mydomain.com/html/app/code/core/Mage/Index/Model/Process.php(255): Mage_Index_Model_Process->reindexAll()
#11 /chroot/home/mydomain.com/html/shell/indexer.php(158): Mage_Index_Model_Process->reindexEverything()
#12 /chroot/home/mydomain.com/html/shell/indexer.php(198): Mage_Shell_Compiler->run()
#13 {main}
Catalog URL Rewrites index was rebuilt successfully
Product Flat Data index was rebuilt successfully
Category Flat Data index was rebuilt successfully
Category Products index was rebuilt successfully
Catalog Search Index index was rebuilt successfully
Tag Aggregation Data index was rebuilt successfully
Stock Status index was rebuilt successfully

I\’m having the same issue. I\’ve tried the instructions:

First, clear out the folder var/locks/*

Second, using ssh, use this command “php shell/indexer.php --reindexall”

Wait for it to finish. If you get a error message, post the error message on this forum post (itll be like 20 lines long).

I also tried the Database Repair Tool and still getting above error.

Please help.

Image Attachments
Picture 14.png
 
Magento Community Magento Community
Magento Community
Magento Community
 
furnitureforyoultd
Enthusiast
 
Total Posts:  833
Joined:  2009-03-09
 

Your problem is coming from the Simple Configurable Products extension - disable it and try to reindex again.

Have you made any changes to the extension since you installed it? There are some bug fixes on github which might not be in the magento connect release, so you should update some files manually.

https://github.com/organicinternet/magento-configurable-simple/pull/100

 
Magento Community Magento Community
Magento Community
Magento Community
 
joshuajarman
Member
 
Avatar
Total Posts:  72
Joined:  2009-04-08
 
furnitureforyoultd - 28 July 2012 11:54 AM

Your problem is coming from the Simple Configurable Products extension - disable it and try to reindex again.

Had this issue with a client’s magento site.  this fixed it.  looks like even with the patched in github the module is still not fully magento 1.7.2 compatible and is no longer officially maintained.

 
Magento Community Magento Community
Magento Community
Magento Community
 
junaid_magento
Jr. Member
 
Total Posts:  1
Joined:  2012-12-21
 

1. Please open
/app/community/OrganicInternet/SimpleConfigurableProducts/Catalog/Model\Resource/Eav/Mysql4/Product/Indexer/Price/Configurable.php

Or copy the Configurable.php to your local folder
/app/local/OrganicInternet/SimpleConfigurableProducts/Catalog/Model\Resource/Eav/Mysql4/Product/Indexer/Price/Configurable.php

2. Goto line

132 :: $query $outerSelect->insertFromSelect($this->_getDefaultFinalPriceTable());
Replace it with
$query $outerSelect->insertFromSelect($this->_getDefaultFinalPriceTable(), array('entity_id','customer_group_id','website_id','tax_class_id','orig_price','price','min_price','max_price','tier_price','base_tier'));

3. Save, Done!

 
Magento Community Magento Community
Magento Community
Magento Community
 
plumbingsc
Jr. Member
 
Total Posts:  1
Joined:  2013-01-07
 
junaid_magento - 18 February 2013 03:31 AM

1. Please open
/app/community/OrganicInternet/SimpleConfigurableProducts/Catalog/Model\Resource/Eav/Mysql4/Product/Indexer/Price/Configurable.php

Or copy the Configurable.php to your local folder
/app/local/OrganicInternet/SimpleConfigurableProducts/Catalog/Model\Resource/Eav/Mysql4/Product/Indexer/Price/Configurable.php

2. Goto line

132 :: $query $outerSelect->insertFromSelect($this->_getDefaultFinalPriceTable());
Replace it with
$query $outerSelect->insertFromSelect($this->_getDefaultFinalPriceTable(), array('entity_id','customer_group_id','website_id','tax_class_id','orig_price','price','min_price','max_price','tier_price','base_tier'));


3. Save, Done!

This worked for me! Thanks!

 
Magento Community Magento Community
Magento Community
Magento Community
 
alxh28
Jr. Member
 
Total Posts:  30
Joined:  2011-12-11
 
junaid_magento - 18 February 2013 03:31 AM

1. Please open
/app/community/OrganicInternet/SimpleConfigurableProducts/Catalog/Model\Resource/Eav/Mysql4/Product/Indexer/Price/Configurable.php

Or copy the Configurable.php to your local folder
/app/local/OrganicInternet/SimpleConfigurableProducts/Catalog/Model\Resource/Eav/Mysql4/Product/Indexer/Price/Configurable.php

2. Goto line

132 :: $query $outerSelect->insertFromSelect($this->_getDefaultFinalPriceTable());
Replace it with
$query $outerSelect->insertFromSelect($this->_getDefaultFinalPriceTable(), array('entity_id','customer_group_id','website_id','tax_class_id','orig_price','price','min_price','max_price','tier_price','base_tier'));


3. Save, Done!

It worked for me too, thank you!

 
Magento Community Magento Community
Magento Community
Magento Community
 
zmaupin
Jr. Member
 
Total Posts:  1
Joined:  2013-06-09
 
kab8609 - 03 July 2012 01:07 PM

First, clear out the folder var/locks/*

Second, using ssh, use this command “php shell/indexer.php --reindexall”

Wait for it to finish. If you get a error message, post the error message on this forum post (itll be like 20 lines long).

This fixed my problem. Thank you!

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