magento 1.6 reindex issue: Product Prices index (1136) - URGENT

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/[login to view URL] Stack trace: 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!