Error with SQL database import

[LadySyren]

I'd like to import my products from one database into another as I've been setting up a new shop. However, I keep getting this error:

Error

SQL query:

INSERT INTO `zen_products`
VALUES ( 1, 1, 0, '37351', 'products/37351.gif', 99.9500, 0, '2006-09-14 16:56:02', '2006-09-14 17:04:39', NULL , 0, 1, 1, 0, 0, 1, 1, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 99.9500, 24, 1, 0, 0, 0, 0, 0 ) ;

MySQL said: Documentation
#1136 - Column count doesn't match value count at row 1


Is there a way I can fix this so I can import my products? The thought of having to add over 4000 items by hand is not a fun thought to have.

[LadySyren]

I posted this in the wrong forum, didn't I.

[DrByte]

It sounds like you're attempting to import from a database designed for a different version of Zen Cart or one on which you had installed a contribution that had altered the structure of the table you're importing.

Thus, since you're only specifying the data to import, and not the columns into which the data should be placed, and you have more columns in your data list than the database you're importing into contains, you're getting the error message indicated.

Try exporting your backup database using "complete inserts".
At least that way when you do the import you'll get an error telling you which column is not acceptable in the new database.

Better yet, resolve the structural differences between your databases, and then the import will run smoothly.

You might find some tidbits in this article:
https://www.zen-cart.com/tutorials/index.php?article=10

[LadySyren]

Thank you :)