Quote Originally Posted by Nightfly66 View Post
Zen Cart v1.5.4 (PHP Version: 5.6.17 - MySQL 5.6.29)
Localization -> Languages: Italian/English

Easy Populate 4.0.33a - Beta 02-29-2016
Model/Price/Qty (with Specials)

I export two "v_products_model" and two "v_products_name"
I correct the stocks ("v_products_quantity" and "v_status"

I import the file and i see: "An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer"

Debug Log: "MySQLi error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE products_id = *** AND language_id = 3' at line 1
When executing: UPDATE products_description SET WHERE products_id = *** AND language_id = 3"

*** They are different ID

Why ? Any suggestions ?

Regards
Request a little clarification and some additional information.

1) two v_products_model, does this mean two products that have a v_products_model or are there two fields along the top of the export file that have v_products_model as a field?
2) I understand two v_products_name to mean v_products_name_1 and v_products_name_2 are/might be fields though the second number could be other than 2. Please verify this is to what you were referring.

3) When exporting the product, what is/was the admin setting for the primary key, is it products_model, products_id or blank_new?
4) Same question for when importing.
5) What field(s) are in the user defined entry under admin/configuration/ep4?
6) The exported product, were there two or more rows that contained the same data in the v_products_model field? (Ie. either linked product or the same model applied to two different product?)
7) What fields are along the top of the export file?
8) What fields are along the top of the import file?