developer need urgently
have tried a number of way to reindex catalog_product_price, been running reindex via ssh but have the following error:
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 /var/www/vhosts//httpdocs/lib/Zend/Db/Statement/[url removed, login to view]
i think i may need Magento Database Repair Tool taking a look it...but this is on a LIVE server and this needs to be fixed quickly!