Easy Populate SQL Error 1136 Help!!!!

[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?

[CRYSTALDOLL]

I am using Easy Populate standard version and yes the v_products_model was in the first column.

[lankeeyankee]

I meant are you using 1.2.5.4, 1.2.5.5, 1.2.5.6? If you are using the latest version then I would recommend trying 1.2.5.4(the version that I am using successfully) to see if it's the version that is causing the problem. I have seen elsewhere that there are a few bugs with the latest release.

I didn't see the 1.2.5.4 version in the downloads section so I am posting the link here. http://www.modhole.com/modhole/index...JAS_File_id=60

You might need to uninstall the fist one completely including the sql statements before installing this version since there might be more changes than just easypopulate.php.