Easy Populate SQL Error 1136 Help!!!!

[CRYSTALDOLL]

I am running into roadblock after roadblock with easy populate. Now I have spent a hole two days on trying to figure why this error is happening, and I simply don't know and am seeking the expertise in others now. When uploading I receive this error in my sql error log. I have used Excel and Calc saved as txt file. I also added an msrp field which I thought went smoothly beings how I was able to download the easy populate complete tab delimited file without errors. I am new to this and need someone to tell me what is going on, im not sure if this has to do with Excel problems or the mrsp field I put in easy populate. I followed all directions from the forum on this site for adding additional fields to easy populate, so I dont understand what is wrong..Help!!!

MySQL error 1136: Column count doesn't match value count at row 1
When executing:
INSERT INTO products (
products_image,
products_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
manufacturers_id)
VALUES (
'435864_MED.jpg.jpg','435864',
'2.99',

'',
'1',
CURRENT_TIMESTAMP,
"2009-08-13 09:00:00",
NULL,
'1',
'',
'500',
'151')

MySQL error 1136: Column count doesn't match value count at row 1
When executing:
INSERT INTO products (
products_image,
products_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
manufacturers_id)
VALUES (
'435864_MED.jpg.jpg','435864',
'2.99',

'',
'1',
CURRENT_TIMESTAMP,
"2009-08-13 09:00:00",
NULL,
'1',
'',
'500',
'151')

MySQL error 1136: Column count doesn't match value count at row 1
When executing:
INSERT INTO products (
products_image,
products_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
manufacturers_id)
VALUES (
'435864_MED.jpg.','435864',
'2.99',

'',
'1',
CURRENT_TIMESTAMP,
"2009-08-13 09:00:00",
NULL,
'1',
'',
'500',
'151')

MySQL error 1136: Column count doesn't match value count at row 1
When executing:
INSERT INTO products (
products_image,
products_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
manufacturers_id)
VALUES (
'435864_MED.jpg.','435864',
'2.99',

'',

'',
'1',
CURRENT_TIMESTAMP,
"2009-08-13 09:00:00",
NULL,
'1',

'',
'',
'500',
'151')

MySQL error 1136: Column count doesn't match value count at row 1
When executing:
INSERT INTO products (
products_image,
products_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
manufacturers_id)
VALUES (
'435864_MED.jpg.','435864',
'2.99',

'',

'',
'1',
CURRENT_TIMESTAMP,
"2009-08-13 09:00:00",
NULL,
'1',

'',
'',
'500',
'151')

MySQL error 1136: Column count doesn't match value count at row 1
When executing:
INSERT INTO products (
products_image,
products_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
manufacturers_id)
VALUES (
'435864_MED.jpg.','435864',
'2.99',

'',

'',
'1',
CURRENT_TIMESTAMP,
"2009-08-13 09:00:00",
NULL,
'1',

'',
'',
'500',
'151')

MySQL error 1136: Column count doesn't match value count at row 1
When executing:
INSERT INTO products (
products_image,
products_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
manufacturers_id)
VALUES (
'435864_MED.jpg','435864',
'2.99',

'',

'',
'1',
CURRENT_TIMESTAMP,
"2009-08-13 10:00:00",
NULL,
'1',

'',
'',
'1',
'486')

MySQL error 1136: Column count doesn't match value count at row 1
When executing:
INSERT INTO products (
products_image,
products_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
manufacturers_id)
VALUES (
'435864_MED.jpg','435864',
'2.99',

'',

'',
'1',
CURRENT_TIMESTAMP,
"2009-08-13 10:00:00",
NULL,
'1',

'',
'',
'1',
'486')

MySQL error 1136: Column count doesn't match value count at row 1
When executing:
INSERT INTO products (
products_image,
products_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
manufacturers_id)
VALUES (
'no_picture.gif','435864',
'2.99',

'',

'',
'1',
CURRENT_TIMESTAMP,
"2009-08-13 10:00:00",
NULL,
'1',

'',
'',
'1',
'486')

MySQL error 1136: Column count doesn't match value count at row 1
When executing:
INSERT INTO products (
products_image,
products_model,
products_price, products_msrp,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
manufacturers_id)
VALUES (
'no_picture.gif','435864',
'2.99',

'',

'',
'1',
CURRENT_TIMESTAMP,
"2009-08-13 10:00:00",
NULL,
'1',

'',
'',
'1',
'486')

MySQL error 1136: Column count doesn't match value count at row 1
When executing:
INSERT INTO products (
products_image,
products_model,
products_price, products_msrp,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
manufacturers_id)
VALUES (
'435864_MED.jpg','435864',
'2.99',

'',

'',
'1',
CURRENT_TIMESTAMP,
"200-0-0 09:00:00",
NULL,
'1',

'',
'',
'500',
'486')

MySQL error 1136: Column count doesn't match value count at row 1
When executing:
INSERT INTO products (
products_image,
products_model,
products_price, products_msrp,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
manufacturers_id)
VALUES (
'435864_MED.jpg','435864',
'2.99',

'',

'',
'1',
CURRENT_TIMESTAMP,
"2000-07-18 12:00",
NULL,
'1',

'',
'',
'500',
'486')

MySQL error 1136: Column count doesn't match value count at row 1
When executing:
INSERT INTO products (
products_image,
products_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
manufacturers_id)
VALUES (
'435864_MED.jpg','435864',
'2.99',

'',

'',
'1',
CURRENT_TIMESTAMP,
CURRENT_TIMESTAMP,
NULL,
'1',

'',
'',
'1',
'486')

MySQL error 1136: Column count doesn't match value count at row 1
When executing:
INSERT INTO products (
products_image,
products_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
manufacturers_id)
VALUES (
'no_picture.gif','435864',
'2.99',

'',

'',
'1',
CURRENT_TIMESTAMP,
CURRENT_TIMESTAMP,
NULL,
'1',

'',
'',
'1',
'486')

MySQL error 1136: Column count doesn't match value count at row 1
When executing:
INSERT INTO products (
products_image,
products_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
manufacturers_id)
VALUES (
'no_picture.gif','435864',
'2.99',
'',
'',
'1',
CURRENT_TIMESTAMP,
CURRENT_TIMESTAMP,
NULL,
'1',
'',
'',
'1',
'486')

MySQL error 1136: Column count doesn't match value count at row 1
When executing:
INSERT INTO products (
products_image,
products_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
manufacturers_id)
VALUES (
'435864_MED.jpg','435864',
'2.99',
'',
'',
'1',
CURRENT_TIMESTAMP,
"2009-08-14 08:00:03",
NULL,
'1',
'',
'',
'500',
'133',
'486')

MySQL error 1136: Column count doesn't match value count at row 1
When executing:
INSERT INTO products (
products_image,
products_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
manufacturers_id)
VALUES (
'435864_MED.jpg','435864',
'2.99',
'',
'',
'1',
CURRENT_TIMESTAMP,
"2009-08-14 08:00:03",
NULL,
'1',
'',
'',
'500',
'133',
'486')

MySQL error 1136: Column count doesn't match value count at row 1
When executing:
INSERT INTO products (
products_image,
products_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
manufacturers_id)
VALUES (
'435864_MED.jpg','435864',
'2.99',
'',
'',
'1',
CURRENT_TIMESTAMP,
"2009-08-14 08:00:03",
NULL,
'1',
'',
'',
'500',
'133',
'486')

MySQL error 1136: Column count doesn't match value count at row 1
When executing:
INSERT INTO products (
products_image,
products_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
manufacturers_id)
VALUES (
'435864_MED.jpg','435864',
'2.99',
'',
'',
'1',
CURRENT_TIMESTAMP,
"2009-08-14 08:00:03",
NULL,
'1',
'',
'',
'500',
'133',
'486')

[lankeeyankee]

I think that you might have missed adding your extra fields in the code modification to easypopulate.php in one or more places. The error is telling you that the columns you are trying to import don't match up with the number of columns the script is expecting. Or possibly the order was added incorrectly in every place you modified. If you followed my tutorial in this forum there are 7 places to insert your extra fields in easypopulate.php and they all have to be in the same order and without any typos.

I suggest re-checking your modifications to make sure there are no errors.

[CRYSTALDOLL]

I checked the files which I had added msrp to, but this didn't change the outcome, Im still getting that sql error in my log, now another problem I am noticing when I upload is an error saying please check data input for tabs in fields and delete these, however, I am saving my files tab delimited in excel, so I do not understand why the warning is saying that on my administrative page, but in my error logs displaying something totally different. Any other suggestions?????

[lankeeyankee]

Then I would recommend saving the modified easypopulate.php file somewhere, uploading the unaltered easypopulate.php file, then download a new complete csv, make some changes/additions, upload back to your site and see if the error still occurs. This way we can eliminate/isolate your modifications as the problem or if it's something else.

Also, it would be helpful if you listed the zc version, php and mysql version, and any other mods you have added to make sure there are no conflicts elsewhere.

[CRYSTALDOLL]

Ok, I did as suggested and uploaded an unmodified file of easypopulate, downloaded a new full txt file, created some add ons, changed some prices and got this error:

File uploaded.
No model field in record. This line was not imported.

This error happened on the price changes and adding new products.

Now, I did include model numbers in my txt files, however, for some reason or another they were not detected.

I am running zen cart 1.38, apache 2.0 php 5.29, sql 5.133.

As far as mods, I have the msrp display installed.

I have spent all day trying to figure this one out. Any suggestions??

[lankeeyankee]

What version of EP are you using? Was there v_products_model in the first cell of column A in the file you uploaded?