title: Magento - Can't Reindex Product Prices
body: <p>strong textI was trying to add new products to my store but they weren't showing up. I did everything I could but when trying to reindex all the data, the product prices generated an error. I got the "There was a problem with reindexing process." I tried deleting var/cache and var/locks(but i can't actually seem to empty /cache - i don't know if it should be like this). The output I got from the reindex is as follows: </p>
  
  <blockquote>
    <p>Product 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
    /chroot/home/xsmokeco/xsmoke.com/html/lib/Zend/Db/Statement/Pdo.php:228
    Stack trace:</p>
    
    <p>0
    /chroot/home/xsmokeco/xsmoke.com/html/lib/Zend/Db/Statement/Pdo.php(228):
    PDOStatement->execute(Array)</p>
    
    <p>1
    /chroot/home/xsmokeco/xsmoke.com/html/lib/Varien/Db/Statement/Pdo/Mysql.php(110):
    Zend_Db_Statement_Pdo->_execute(Array)</p>
    
    <p>2
    /chroot/home/xsmokeco/xsmoke.com/html/lib/Zend/Db/Statement.php(300):
    Varien_Db_Statement_Pdo_Mysql->_execute(Array)</p>
    
    <p>3
    /chroot/home/xsmokeco/xsmoke.com/html/lib/Zend/Db/Adapter/Abstract.php(479):
    Zend_Db_Statement->execute(Array)</p>
    
    <p>4
    /chroot/home/xsmokeco/xsmoke.com/html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238):
    Zend_Db_Adapter_Abstract->query('INSERT INTO `ca...', Array)</p>
    
    <p>5
    /chroot/home/xsmokeco/xsmoke.com/html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419):
    Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `ca...', Array)</p>
    
    <p>6
    /chroot/home/xsmokeco/xsmoke.com/html/app/code/local/Innoexts/StorePricing/Model/Mysql4/Downloadable/Indexer/Price.php(125):
    Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `ca...')</p>
    
    <p>7
    /chroot/home/xsmokeco/xsmoke.com/html/app/code/core/Mage/Downloadable/Model/Resource/Indexer/Price.php(47):
    Innoexts_StorePricing_Model_Mysql4_Downloadable_Indexer_Price->_prepareFinalPriceData()</p>
    
    <p>8
    /chroot/home/xsmokeco/xsmoke.com/html/app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Price.php(385):
    Mage_Downloadable_Model_Resource_Indexer_Price->reindexAll()</p>
    
    <p>9
    /chroot/home/xsmokeco/xsmoke.com/html/app/code/core/Mage/Index/Model/Indexer/Abstract.php(143):
    Mage_Catalog_Model_Resource_Product_Indexer_Price->reindexAll()</p>
    
    <p>10
    /chroot/home/xsmokeco/xsmoke.com/html/app/code/core/Mage/Index/Model/Process.php(209):
    Mage_Index_Model_Indexer_Abstract->reindexAll()</p>
    
    <p>11
    /chroot/home/xsmokeco/xsmoke.com/html/app/code/core/Mage/Index/Model/Process.php(255):
    Mage_Index_Model_Process->reindexAll()</p>
    
    <p>12 /chroot/home/xsmokeco/xsmoke.com/html/shell/indexer.php(158):
    Mage_Index_Model_Process->reindexEverything()</p>
    
    <p>13 /chroot/home/xsmokeco/xsmoke.com/html/shell/indexer.php(198):
    Mage_Shell_Compiler->run()</p>
    
    <p>14 {main}</p>
    
    <p>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/xsmokeco/xsmoke.com/html/lib/Zend/Db/Statement/Pdo.php:234
    Stack trace:</p>
    
    <p>0
    /chroot/home/xsmokeco/xsmoke.com/html/lib/Varien/Db/Statement/Pdo/Mysql.php(110):
    Zend_Db_Statement_Pdo->_execute(Array)</p>
    
    <p>1
    /chroot/home/xsmokeco/xsmoke.com/html/lib/Zend/Db/Statement.php(300):
    Varien_Db_Statement_Pdo_Mysql->_execute(Array)</p>
    
    <p>2
    /chroot/home/xsmokeco/xsmoke.com/html/lib/Zend/Db/Adapter/Abstract.php(479):
    Zend_Db_Statement->execute(Array)</p>
    
    <p>3
    /chroot/home/xsmokeco/xsmoke.com/html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238):
    Zend_Db_Adapter_Abstract->query('INSERT INTO `ca...', Array)</p>
    
    <p>4
    /chroot/home/xsmokeco/xsmoke.com/html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419):
    Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `ca...', Array)</p>
    
    <p>5
    /chroot/home/xsmokeco/xsmoke.com/html/app/code/local/Innoexts/StorePricing/Model/Mysql4/Downloadable/Indexer/Price.php(125):
    Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `ca...')</p>
    
    <p>6
    /chroot/home/xsmokeco/xsmoke.com/html/app/code/core/Mage/Downloadable/Model/Resource/Indexer/Price.php(47):
    Innoexts_StorePricing_Model_Mysql4_Downloadable_Indexer_Price->_prepareFinalPriceData()</p>
    
    <p>7
    /chroot/home/xsmokeco/xsmoke.com/html/app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Price.php(385):
    Mage_Downloadable_Model_Resource_Indexer_Price->reindexAll()</p>
    
    <p>8
    /chroot/home/xsmokeco/xsmoke.com/html/app/code/core/Mage/Index/Model/Indexer/Abstract.php(143):
    Mage_Catalog_Model_Resource_Product_Indexer_Price->reindexAll()</p>
    
    <p>9
    /chroot/home/xsmokeco/xsmoke.com/html/app/code/core/Mage/Index/Model/Process.php(209):
    Mage_Index_Model_Indexer_Abstract->reindexAll()</p>
    
    <p>10
    /chroot/home/xsmokeco/xsmoke.com/html/app/code/core/Mage/Index/Model/Process.php(255):
    Mage_Index_Model_Process->reindexAll()</p>
    
    <p>11 /chroot/home/xsmokeco/xsmoke.com/html/shell/indexer.php(158):
    Mage_Index_Model_Process->reindexEverything()</p>
    
    <p>12 /chroot/home/xsmokeco/xsmoke.com/html/shell/indexer.php(198):
    Mage_Shell_Compiler->run()</p>
    
    <p>13 {main}</p>
  </blockquote>
  
  <p>I am kinda afraid to alter anything in the database, therefore I wanted to ask here for some help. I am using magento 1.7, I never updated it.Thanks in advance</p>