title: Magento 1.6.2 can't reindex product prices
body: <p>Dear community i am in need of your help.</p>
  
  <p>Spending to much time on a problem that looks quite easy to fix. Can't reindex the pricing. Prices will change on productview page but not on the categorie view. </p>
  
  <p>The error only effects the category view price of configeruble products.</p>
  
  <p>I did:</p>
  
  <ul>
  <li>Use magento-cleanup.php </li>
  <li>Delete all stores</li>
  <li>Delete all pruducts</li>
  <li>Repeare the database (php myadmin)</li>
  </ul>
  
  <p>Tried to find the database repair tool but it seems not to be available anymore from the magento site???</p>
  
  <p>Below the exception log:</p>
  
  <p>2012-03-31T12:02:12+00:00 DEBUG (7): Exception message: SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1</p>
  
  <p>Trace: </p>
  
  <pre><code>#0 C:\xampp\htdocs\lib\Varien\Db\Statement\Pdo\Mysql.php(110): Zend_Db_Statement_Pdo-&gt;_execute(Array)
  #1 C:\xampp\htdocs\lib\Zend\Db\Statement.php(300): Varien_Db_Statement_Pdo_Mysql-&gt;_execute(Array)
  
  
  #2 C:\xampp\htdocs\lib\Zend\Db\Adapter\Abstract.php(479): Zend_Db_Statement-&gt;execute(Array)
  
  
  #3 C:\xampp\htdocs\lib\Zend\Db\Adapter\Pdo\Abstract.php(238): Zend_Db_Adapter_Abstract-&gt;query('INSERT INTO `ca...', Array)
  
  #4 C:\xampp\htdocs\lib\Varien\Db\Adapter\Pdo\Mysql.php(389): Zend_Db_Adapter_Pdo_Abstract-&gt;query('INSERT INTO `ca...', Array)
  
  
  #5 C:\xampp\htdocs\app\code\core\Mage\Catalog\Model\Resource\Product\Indexer\Price\Default.php(278): Varien_Db_Adapter_Pdo_Mysql-&gt;query('INSERT INTO `ca...')
  
  
  #6 C:\xampp\htdocs\app\code\core\Mage\Downloadable\Model\Resource\Indexer\Price.php(47): Mage_Catalog_Model_Resource_Product_Indexer_Price_Default-&gt;_prepareFinalPriceData()
  
  
  #7 C:\xampp\htdocs\app\code\core\Mage\Catalog\Model\Resource\Product\Indexer\Price.php(381): Mage_Downloadable_Model_Resource_Indexer_Price-&gt;reindexAll()
  
  
  #8 C:\xampp\htdocs\app\code\core\Mage\Index\Model\Indexer\Abstract.php(143): Mage_Catalog_Model_Resource_Product_Indexer_Price-&gt;reindexAll()
  
  
  #9 C:\xampp\htdocs\app\code\core\Mage\Index\Model\Process.php(207): Mage_Index_Model_Indexer_Abstract-&gt;reindexAll()
  #10 C:\xampp\htdocs\app\code\core\Mage\Index\Model\Process.php(253): Mage_Index_Model_Process-&gt;reindexAll()
  
  
  #11 C:\xampp\htdocs\app\code\core\Mage\Index\controllers\Adminhtml\ProcessController.php(124): Mage_Index_Model_Process-&gt;reindexEverything()
  
  
  #12 C:\xampp\htdocs\app\code\core\Mage\Core\Controller\Varien\Action.php(420): Mage_Index_Adminhtml_ProcessController-&gt;reindexProcessAction()
  
  
  #13 C:\xampp\htdocs\app\code\core\Mage\Core\Controller\Varien\Router\Standard.php(250): Mage_Core_Controller_Varien_Action-&gt;dispatch('reindexProcess')
  
  
  #14 C:\xampp\htdocs\app\code\core\Mage\Core\Controller\Varien\Front.php(176): Mage_Core_Controller_Varien_Router_Standard-&gt;match(Object(Mage_Core_Controller_Request_Http))
  
  #15 C:\xampp\htdocs\app\code\core\Mage\Core\Model\App.php(349): Mage_Core_Controller_Varien_Front-&gt;dispatch()
  
  
  #16 C:\xampp\htdocs\app\Mage.php(640): Mage_Core_Model_App-&gt;run(Array)
  
  
  #17 C:\xampp\htdocs\index.php(83): Mage::run('', 'store')
  
  
  #18 {main}
  </code></pre>
  
  <p>Can somebody shed some light on this? </p>
  
  <p>THX!</p>