{"id":5715,"date":"2014-04-06T10:28:56","date_gmt":"2014-04-06T10:28:56","guid":{"rendered":"https:\/\/unknownerror.org\/index.php\/2014\/04\/06\/magento-1-6-2-1-7-upgrade-leads-to-price-index-corruption-collection-of-common-programming-errors\/"},"modified":"2022-08-30T15:50:19","modified_gmt":"2022-08-30T15:50:19","slug":"magento-1-6-2-1-7-upgrade-leads-to-price-index-corruption-collection-of-common-programming-errors","status":"publish","type":"post","link":"https:\/\/unknownerror.org\/index.php\/2014\/04\/06\/magento-1-6-2-1-7-upgrade-leads-to-price-index-corruption-collection-of-common-programming-errors\/","title":{"rendered":"Magento 1.6.2 -&gt; 1.7 Upgrade leads to price index corruption-Collection of common programming errors"},"content":{"rendered":"<p>I&#8217;ve updated magento from 1.6.2 to 1.7, everthing went smooth, apparently the site is working just fine. However I can&#8217;t reidex the product prices, it looks like one of the tables is missing columns. I&#8217;ve tried the shell tool that&#8217;s what I get:<\/p>\n<pre><code>Product Prices index process unknown error:\nexception '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\/thelittl\/public_html\/asia\/lib\/Zend\/Db\/Statement\/Pdo.php:228\nStack trace:\n#0 \/home\/thelittl\/public_html\/asia\/lib\/Zend\/Db\/Statement\/Pdo.php(228): PDOStatement-&gt;execute(Array)\n#1 \/home\/thelittl\/public_html\/asia\/lib\/Varien\/Db\/Statement\/Pdo\/Mysql.php(110): Zend_Db_Statement_Pdo-&gt;_execute(Array)\n#2 \/home\/thelittl\/public_html\/asia\/lib\/Zend\/Db\/Statement.php(300): Varien_Db_Statement_Pdo_Mysql-&gt;_execute(Array)\n#3 \/home\/thelittl\/public_html\/asia\/lib\/Zend\/Db\/Adapter\/Abstract.php(479): Zend_Db_Statement-&gt;execute(Array)\n#4 \/home\/thelittl\/public_html\/asia\/lib\/Zend\/Db\/Adapter\/Pdo\/Abstract.php(238): Zend_Db_Adapter_Abstract-&gt;query('INSERT INTO `ca...', Array)\n#5 \/home\/thelittl\/public_html\/asia\/lib\/Varien\/Db\/Adapter\/Pdo\/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract-&gt;query('INSERT INTO `ca...', Array)\n#6 \/home\/thelittl\/public_html\/asia\/app\/code\/community\/Brim\/Groupedoptions\/Model\/Resource\/Eav\/Mysql4\/Product\/Indexer\/Price\/Grouped.php(76): Varien_Db_Adapter_Pdo_Mysql-&gt;query('INSERT INTO `ca...')\n#7 \/home\/thelittl\/public_html\/asia\/app\/code\/core\/Mage\/Catalog\/Model\/Resource\/Product\/Indexer\/Price\/Grouped.php(48): Brim_Groupedoptions_Model_Resource_Eav_Mysql4_Product_Indexer_Price_Grouped-&gt;_prepareGroupedProductPriceData()\n#8 \/home\/thelittl\/public_html\/asia\/app\/code\/core\/Mage\/Catalog\/Model\/Resource\/Product\/Indexer\/Price.php(385): Mage_Catalog_Model_Resource_Product_Indexer_Price_Grouped-&gt;reindexAll()\n#9 \/home\/thelittl\/public_html\/asia\/app\/code\/core\/Mage\/Index\/Model\/Indexer\/Abstract.php(143): Mage_Catalog_Model_Resource_Product_Indexer_Price-&gt;reindexAll()\n#10 \/home\/thelittl\/public_html\/asia\/app\/code\/core\/Mage\/Index\/Model\/Process.php(209): Mage_Index_Model_Indexer_Abstract-&gt;reindexAll()\n#11 \/home\/thelittl\/public_html\/asia\/app\/code\/core\/Mage\/Index\/Model\/Process.php(255): Mage_Index_Model_Process-&gt;reindexAll()\n#12 \/home\/thelittl\/public_html\/asia\/shell\/indexer.php(158): Mage_Index_Model_Process-&gt;reindexEverything()\n#13 \/home\/thelittl\/public_html\/asia\/shell\/indexer.php(198): Mage_Shell_Compiler-&gt;run()\n#14 {main}\n\nNext 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 \/home\/thelittl\/public_html\/asia\/lib\/Zend\/Db\/Statement\/Pdo.php:234\nStack trace:\n#0 \/home\/thelittl\/public_html\/asia\/lib\/Varien\/Db\/Statement\/Pdo\/Mysql.php(110): Zend_Db_Statement_Pdo-&gt;_execute(Array)\n#1 \/home\/thelittl\/public_html\/asia\/lib\/Zend\/Db\/Statement.php(300): Varien_Db_Statement_Pdo_Mysql-&gt;_execute(Array)\n#2 \/home\/thelittl\/public_html\/asia\/lib\/Zend\/Db\/Adapter\/Abstract.php(479): Zend_Db_Statement-&gt;execute(Array)\n#3 \/home\/thelittl\/public_html\/asia\/lib\/Zend\/Db\/Adapter\/Pdo\/Abstract.php(238): Zend_Db_Adapter_Abstract-&gt;query('INSERT INTO `ca...', Array)\n#4 \/home\/thelittl\/public_html\/asia\/lib\/Varien\/Db\/Adapter\/Pdo\/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract-&gt;query('INSERT INTO `ca...', Array)\n#5 \/home\/thelittl\/public_html\/asia\/app\/code\/community\/Brim\/Groupedoptions\/Model\/Resource\/Eav\/Mysql4\/Product\/Indexer\/Price\/Grouped.php(76): Varien_Db_Adapter_Pdo_Mysql-&gt;query('INSERT INTO `ca...')\n#6 \/home\/thelittl\/public_html\/asia\/app\/code\/core\/Mage\/Catalog\/Model\/Resource\/Product\/Indexer\/Price\/Grouped.php(48): Brim_Groupedoptions_Model_Resource_Eav_Mysql4_Product_Indexer_Price_Grouped-&gt;_prepareGroupedProductPriceData()\n#7 \/home\/thelittl\/public_html\/asia\/app\/code\/core\/Mage\/Catalog\/Model\/Resource\/Product\/Indexer\/Price.php(385): Mage_Catalog_Model_Resource_Product_Indexer_Price_Grouped-&gt;reindexAll()\n#8 \/home\/thelittl\/public_html\/asia\/app\/code\/core\/Mage\/Index\/Model\/Indexer\/Abstract.php(143): Mage_Catalog_Model_Resource_Product_Indexer_Price-&gt;reindexAll()\n#9 \/home\/thelittl\/public_html\/asia\/app\/code\/core\/Mage\/Index\/Model\/Process.php(209): Mage_Index_Model_Indexer_Abstract-&gt;reindexAll()\n#10 \/home\/thelittl\/public_html\/asia\/app\/code\/core\/Mage\/Index\/Model\/Process.php(255): Mage_Index_Model_Process-&gt;reindexAll()\n#11 \/home\/thelittl\/public_html\/asia\/shell\/indexer.php(158): Mage_Index_Model_Process-&gt;reindexEverything()\n#12 \/home\/thelittl\/public_html\/asia\/shell\/indexer.php(198): Mage_Shell_Compiler-&gt;run()\n#13 {main}\n<\/code><\/pre>\n<p>Can&#8217;t tell how this is affecting the site, IF it&#8217;s affecting it somehow.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I&#8217;ve updated magento from 1.6.2 to 1.7, everthing went smooth, apparently the site is working just fine. However I can&#8217;t reidex the product prices, it looks like one of the tables is missing columns. I&#8217;ve tried the shell tool that&#8217;s what I get: Product Prices index process unknown error: exception &#8216;PDOException&#8217; with message &#8216;SQLSTATE[21S01]: Insert [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,1],"tags":[],"class_list":["post-5715","post","type-post","status-publish","format-standard","hentry","category-magento","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/5715","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/comments?post=5715"}],"version-history":[{"count":1,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/5715\/revisions"}],"predecessor-version":[{"id":9021,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/5715\/revisions\/9021"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=5715"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=5715"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=5715"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}