Magento Forum

Product Price Indexes does not worl
 
mbembenek8674
Jr. Member
 
Total Posts:  2
Joined:  2012-07-09
 

Hello, I´ve update my Magento CE to Version1.7 -
After that, i can not Update the Indexes for Product Price:

Error Message:

Product Prices index process unknown error:
exception 'PDOException' with message 'SQLSTATE[21S01]: Insert value list does n
ot match column list: 1136 Column count doesn'
t match value count at row 1' in M
:\xampp\htdocs\domain\lib\Zend\Db\Statement\Pdo.php:228
Stack trace:
#0 M:\xampp\htdocs\domain\lib\Zend\Db\Statement\Pdo.php(228): PDOStatement->ex
ecute(Array)
#1 M:\xampp\htdocs\domain\lib\Varien\Db\Statement\Pdo\Mysql.php(110): Zend_Db_
Statement_Pdo->_execute(Array)
#2 M:\xampp\htdocs\domain\lib\Zend\Db\Statement.php(300): Varien_Db_Statement_
Pdo_Mysql->_execute(Array)
#3 M:\xampp\htdocs\domain\lib\Zend\Db\Adapter\Abstract.php(479): Zend_Db_State
ment->execute(Array)
#4 M:\xampp\htdocs\domain\lib\Zend\Db\Adapter\Pdo\Abstract.php(238): Zend_Db_A
dapter_Abstract->query('
INSERT INTO `ca...', Array)
#5 M:\xampp\htdocs\domain\lib\Varien\Db\Adapter\Pdo\Mysql.php(419): Zend_Db_Ad
apter_Pdo_Abstract->query('INSERT INTO 
`ca...', Array)
#6 M:\xampp\htdocs\domain\app\code\local\Innoexts\StorePricing\Model\Mysql4\Do
wnloadable\Indexer\Price.php(125): Varien_Db_Adapter_Pdo_Mysql->query('
INSERT IN
TO 
`ca...')
#7 M:\xampp\htdocs\domain\app\code\core\Mage\Downloadable\Model\Resource\Index
er\Price.php(47): Innoexts_StorePricing_Model_Mysql4_Downloadable_Indexer_Price-
>_prepareFinalPriceData()
#8 M:\xampp\htdocs\domain\app\code\core\Mage\Catalog\Model\Resource\Product\In
dexer\Price.php(385): Mage_Downloadable_Model_Resource_Indexer_Price->reindexAll
()
#9 M:\xampp\htdocs\domain\app\code\core\Mage\Index\Model\Indexer\Abstract.php(
143): Mage_Catalog_Model_Resource_Product_Indexer_Price->reindexAll()
#10 M:\xampp\htdocs\domain\app\code\core\Mage\Index\Model\Process.php(209): Ma
ge_Index_Model_Indexer_Abstract->reindexAll()
#11 M:\xampp\htdocs\domain\app\code\core\Mage\Index\Model\Process.php(255): Ma
ge_Index_Model_Process->reindexAll()
#12 M:\xampp\htdocs\domain\shell\indexer.php(158): Mage_Index_Model_Process->r
eindexEverything()
#13 M:\xampp\htdocs\domain\shell\indexer.php(198): Mage_Shell_Compiler->run()
#14 {main}

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 M:\xampp\htdocs\domain\lib\Zend\Db\Statement\Pdo.php:234
Stack trace:
#0 M:\xampp\htdocs\domain\lib\Varien\Db\Statement\Pdo\Mysql.php(110): Zend_Db_
Statement_Pdo->_execute(Array)
#1 M:\xampp\htdocs\domain\lib\Zend\Db\Statement.php(300): Varien_Db_Statement_
Pdo_Mysql->_execute(Array)
#2 M:\xampp\htdocs\domain\lib\Zend\Db\Adapter\Abstract.php(479): Zend_Db_State
ment->execute(Array)
#3 M:\xampp\htdocs\domain\lib\Zend\Db\Adapter\Pdo\Abstract.php(238): Zend_Db_A
dapter_Abstract->query('INSERT INTO 
`ca...', Array)
#4 M:\xampp\htdocs\domain\lib\Varien\Db\Adapter\Pdo\Mysql.php(419): Zend_Db_Ad
apter_Pdo_Abstract->query('
INSERT INTO `ca...', Array)
#5 M:\xampp\htdocs\domain\app\code\local\Innoexts\StorePricing\Model\Mysql4\Do
wnloadable\Indexer\Price.php(125): Varien_Db_Adapter_Pdo_Mysql->query('INSERT IN
TO 
`ca...')
#6 M:\xampp\htdocs\domain\app\code\core\Mage\Downloadable\Model\Resource\Index
er\Price.php(47): Innoexts_StorePricing_Model_Mysql4_Downloadable_Indexer_Price-
>_prepareFinalPriceData()
#7 M:\xampp\htdocs\domain\app\code\core\Mage\Catalog\Model\Resource\Product\In
dexer\Price.php(385): Mage_Downloadable_Model_Resource_Indexer_Price->reindexAll
()
#8 M:\xampp\htdocs\domain\app\code\core\Mage\Index\Model\Indexer\Abstract.php(
143): Mage_Catalog_Model_Resource_Product_Indexer_Price->reindexAll()
#9 M:\xampp\htdocs\domain\app\code\core\Mage\Index\Model\Process.php(209): Mag
e_Index_Model_Indexer_Abstract->reindexAll()
#10 M:\xampp\htdocs\domain\app\code\core\Mage\Index\Model\Process.php(255): Ma
ge_Index_Model_Process->reindexAll()
#11 M:\xampp\htdocs\domain\shell\indexer.php(158): Mage_Index_Model_Process->r
eindexEverything()
#12 M:\xampp\htdocs\domain\shell\indexer.php(198): Mage_Shell_Compiler->run()
#13 {main}

I´ve tried something but i did not found an solution that will for me work fine.
Did you have an Idea? Thanks a lot

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

I have the same problem here after upgrading from 1.5 to 1.7

 
Magento Community Magento Community
Magento Community
Magento Community
 
eddetollenaer
Jr. Member
 
Avatar
Total Posts:  21
Joined:  2011-10-26
 

Same problem here from 1.6.0.2 to 1.7.0.2

I just copied all the files from 1.7.0.2 and pointed them to the existing database. Did I need to run an update script?

 
Magento Community Magento Community
Magento Community
Magento Community
 
justinthomsony
Jr. Member
 
Total Posts:  3
Joined:  2012-07-25
 

It’s really looking just same problem! I have really heard so much about it.

 
Magento Community Magento Community
Magento Community
Magento Community
 
colourgraphics
Jr. Member
 
Total Posts:  3
Joined:  2010-11-22
 

Same problem for me, any ideas?

 
Magento Community Magento Community
Magento Community
Magento Community
 
GetMagented
Jr. Member
 
Avatar
Total Posts:  6
Joined:  2012-08-12
Eindhoven
 

Most easy fix for this is to use the Database repair tool:

1. Set up a new and fresh Magento 1.7 installation
2. Download the database repair tool:
http://www.magentocommerce.com/download
3. Let the repair tool compare & fix your database with the fresh database
4. Don’t forget to refresh caches and you should be up and running

Note: Best advice is to backup your current database and create a duplicate (e.g. database2). Use the repair tool on database2 and if the fix is succesful you can use that database instead of the original one. This way you always have a copy of it, which is important because the database repair tool may change many tables and columns, and there is no way back.

Let me know if you have any problems or questions.

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