-
- fabianborg
 -
Total Posts: 34
Joined: 2011-05-10
|
Hi,
I had to resolve in a fresh install and basically started to dump data into the db physically. I have managed to keep up quite well, yet I ran into #1136 - Column count doesn’t match value count at row 1 for example the code below taken from a v1.5.1 backup:
LOCK TABLES `tax_calculation` WRITE;
/*!40000 ALTER TABLE `tax_calculation` DISABLE KEYS */;
INSERT INTO `tax_calculation` VALUES ('4','1',3,2),('5','1',3,2),('6','1',3,2),('7','1',3,2),('8','1',3,2),('9','1',3,2),('10','1',3,2),('11','1',3,2),('12','1',3,2),('13','1',3,2),('14','1',3,2),('15','1',3,2),('16','1',3,2),('17','1',3,2),('18','1',3,2),('19','1',3,2),('20','1',3,2),('21','1',3,2),('22','1',3,2),('23','1',3,2),('24','1',3,2),('25','1',3,2),('26','1',3,2),('27','1',3,2),('28','1',3,2),('29','1',3,2),('30','1',3,2);
/*!40000 ALTER TABLE `tax_calculation` ENABLE KEYS */;
UNLOCK TABLES;
For the following tables:
catalog_product_flat_1
catalog_product_flat_2
catalog_product_flat_3
catalog_product_flat_4
catalogsearch_fulltext
core_url_rewrite
sales_flat_quote
sales_flat_quote_payment
tax_calculation
I am aware, that the v1.6 table structure is different for the above tables than v1.5.1, hence can someone illuminate me on how to over come these errors and load the data with the db successfully.
With best regards
Fabian
|
