EasyPopulate 4.0 Support Thread

A error occur when import the Attrib-Basic-EP.csv
log:

Code:

---

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 ':) LIMIT 1' at line 1
When executing:
SELECT * FROM products WHERE (products_model = xxx':) LIMIT 1

---

Zencart: v1.5.4
PHP: 7.0.6
MySQL: 5.0.12
EP: Easy Populate 4.0.35.ZC - 04-29-2016

There is no problem when use the old EP version Easy Populate 4.0.28 - Beta 01-03-2015

Quote:

---

Originally Posted by su35

A error occur when import the Attrib-Basic-EP.csv
log:

Code:

---

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 ':) LIMIT 1' at line 1
When executing:
SELECT * FROM products WHERE (products_model = xxx':) LIMIT 1

---

Zencart: v1.5.4
PHP: 7.0.6
MySQL: 5.0.12
EP: Easy Populate 4.0.35.ZC - 04-29-2016

There is no problem when use the old EP version Easy Populate 4.0.28 - Beta 01-03-2015

---

Line 25 of admin/easypopulate_4_attrib.php change from:

Code:

---

$query = $db->bindVars($query, ':v_products_model', $v_products_model, 'string');

---

To:

Code:

---

$query = $db->bindVars($query, ':v_products_model:', $v_products_model, 'string');

---

Adding a colon (:) after :v_products_model.

Quote:

---

Originally Posted by mc12345678

Line 25 of admin/easypopulate_4_attrib.php change from:

Code:

---

$query = $db->bindVars($query, ':v_products_model', $v_products_model, 'string');

---

To:

Code:

---

$query = $db->bindVars($query, ':v_products_model:', $v_products_model, 'string');

---

Adding a colon (:) after :v_products_model.

---

Ugh, apparently same issue on lines 97 and 98:

Code:

---

                                        $sql = $db->bindVars($sql, ':v_products_options_name:', $v_products_options_name[$l_id], 'string');
                                        $sql = $db->bindVars($sql, ':v_products_options_type:', $v_products_options_type, 'integer');

---

Change(s) shown: https://github.com/mc12345678/EasyPo...99d7d0671fc80b

Quote:

---

Originally Posted by mc12345678

Ugh, apparently same issue on lines 97 and 98:

Code:

---

                                        $sql = $db->bindVars($sql, ':v_products_options_name:', $v_products_options_name[$l_id], 'string');
                                        $sql = $db->bindVars($sql, ':v_products_options_type:', $v_products_options_type, 'integer');

---

Change(s) shown: https://github.com/mc12345678/EasyPo...99d7d0671fc80b

---

After modified, when importing the data I got a blank page.
log:

Code:

---

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 ': AND
                                                a.products_options_values_id = b.products_options_values_id AND
                                ' at line 8
When executing:
SELECT
                                                a.products_options_id,
                                                a.products_options_values_id,
                                                b.products_options_values_id,
                                                b.products_options_values_name
                                                FROM products_options_values_to_products_options as a, products_options_values as b
                                                WHERE
                                                a.products_options_id = 1: AND
                                                a.products_options_values_id = b.products_options_values_id AND
                                                b.products_options_values_name = 'xxx'

---

Quote:

---

Originally Posted by su35

After modified, when importing the data I got a blank page.
log:

Code:

---

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 ': AND
                                                a.products_options_values_id = b.products_options_values_id AND
                                ' at line 8
When executing:
SELECT
                                                a.products_options_id,
                                                a.products_options_values_id,
                                                b.products_options_values_id,
                                                b.products_options_values_name
                                                FROM products_options_values_to_products_options as a, products_options_values as b
                                                WHERE
                                                a.products_options_id = 1: AND
                                                a.products_options_values_id = b.products_options_values_id AND
                                                b.products_options_values_name = 'xxx'

---

---

More of the same issue. For some reason when I was searching the file yesterday only 6 occurrences of substitution were identified (included those correctly coded and the ones that were fixed as identified incorrect), when I returned to the same thing later, the total was more than the original 6. Will correct soon and repost the associated link(s).

As relates to EP4.0.35.ZC, this "patch" is provided for those that use the basic attribute import. This is/will be incorporated in 4.0.36. At this time, no interim version is being provided.

Hi guys, I am having problems with EP also....
I am running "Zen-Cart 1.5.5" and have "Easy Populate For ZenCart v1.5.x". I have followed all instructions but am getting stuck. I load all the files to my server and Easy Populate appears in my "TOOLS" dropdown. When I click it, I get the Easy Populate page with the error at the top of the page that reads "Easy Populate Configuration Missing. Please install your configuration by clicking here."
Clicking there gives me this error ""WARNING: An Error occurred, please refresh the page and try again."
Refreshing does nothing...

Also, on the Easy Populate page I see this note.."Import from Temp Dir (EASYPOPULATE_CONFIG_TEMP_DIR/)" and I do not see that Dir anywhere on my server? I have removed and re-installed EP 3 times with the same exact issues, I know I must be missing something?
Any help would be very much appreciated...

P.S. Easy Populate DOES NOT appear in my Configuration dropdown menu.

Don't necessarily expect this to be directly related, but what version of EP4 is being attempted to install?

Second, what is the error message seen by review of the latest logs directory entry (obscure your admin directory path when posting.) When posting please first press the # button in the message box toolbar and then paste the complete message with admin directory obscured.

Quote:

---

Originally Posted by mc12345678

As relates to EP4.0.35.ZC, this "patch" is provided for those that use the basic attribute import. This is/will be incorporated in 4.0.36. At this time, no interim version is being provided.

---

Thanks. It works!:smile:

I have downloaded this: easy_populate_csv_for_zencart_v1.5.x_v1.2.6.1