Repair a magento table's structure

when reindexing a magento database with php shell/[login to view URL] reindexall an SQL error is thrown: SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1 here is the full error message: [login to view URL] this happens, when indexing the product price index. This is a somewhat known problem after a botched update from 1.6 to 1.7 and this is very probable the reason, but, some repairs have been tried and have not been successful. The solution will be along these lines: [login to view URL] You will be required to find the table which has the problem and fix it in a way, that the indexing process runs through. I know that it is hard to guess how long this will take, so I will reimburse you for trying - up to a point. You get full access to the broken magento installation (which is functioning beside the indexing problem) on a dev server, so you are not in danger of breaking something. you get also remote access to the database and every other tool you need. access requires a public SSH key from you. From time to time I have such problems on hand, so this could be the start of a business relationship.