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.
Bookmarks