Hi we have taken the plunge and updating magento to a fresh install.
I’ve taken all the product and category tables from our 1.6 install and gone to a fresh install of 1.7
All seems to be ok, but we have some problems with the pricing index and with the import/export functions.
I get the exception.
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 /home/vhosts/xxxxxxxxx/subdomains/2013/lib/Zend/Db/Statement/Pdo.php:228
When I attempt to reindex, and the error invalid website id when I import/export.
I have tried the database repair tool but it seems to do nothing and just goes blank when I enter the database details.
I’m putting the corrupt/original database in Corrupted Database Connection and a fresh db in Reference Database Connection - which is right I think?
I’ve tried truncating the flat product tables which doesn’t seem to have worked.
Is there any other ideas out there?