EasyPopulate 4.0 Support Thread

mc12345678:

Line 25 of admin/easypopulate_4_attrib.php change from:

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

> To:```
$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:

					$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/EasyPopulate-4.0/commit/dcac3ed63a1f0c0cd8f3c7b5e2d3495ef90b4c5c#diff-4c15e1a3fe90872f8a99d7d0671fc80b

mc12345678:

Ugh, apparently same issue on lines 97 and 98:

				$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/EasyPopulate-4.0/commit/dcac3ed63a1f0c0cd8f3c7b5e2d3495ef90b4c5c#diff-4c15e1a3fe90872f8a99d7d0671fc80b>

After modified, when importing the data I got a blank page.
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 ': 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'

su35:

After modified, when importing the data I got a blank page.
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 ': 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.

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

ntsllc:

I have downloaded this: easy_populate_csv_for_zencart_v1.5.x_v1.2.6.1
Similar program, different thread... think that the same issue has been "described" there for some time.

But, while you're here, maybe you'd like to try this version. Download is here.

Sorry, but if you use attributes in your import there's a minor patch a couple of posts back.

OK< I answered my own question!!! When I posted the version I used, I realized it wasn't EP4!!! What a moron!!! Removed th eold one, downloaded the REAL EP4 and all is working now!!! Sorry for wasting anyone's time today!!
Thank You!

ntsllc:

OK< I answered my own question!!! When I posted the version I used, I realized it wasn't EP4!!! What a moron!!! Removed th eold one, downloaded the REAL EP4 and all is working now!!! Sorry for wasting anyone's time today!!
Thank You!

No problem. Certainly threw me for a loop, but either without asking (or initially posting) might have gone chasing the wrong thing. :)

I know I've been meaning to make the plugin description more informative, but haven't submitted the requested text yet. The plugin finally reached a state of being submitted for approval and well... the plugin description didn't include more pertinent detail unlike the expectation for a store product description.

Anyways, glad you got through that hurdle.

Thank you!!! I probably would have kept beating my head against the wall!! Works great now!

Hi mc12345678
"Activate Blank Featured" miss the setting field at right.

su35:

Hi mc12345678
"Activate Blank Featured" miss the setting field at right.
Please explain. Right side of screen when looking at the configuration menu, right side of the a function that uses the constant? Is it enabled but not capturing one of the conditions? Etc.

I'm stumped. I uploaded the files but Easy Populate does not show up under Admin>Tools.

Here's what I've done.
I uploaded all the files in the admin directory to my site maintaining directory structure within admin from EasyPopulate-4.0-4.0.35.
I then logged in to my store's admin and looked under Tools. There is nothing there for Easy Populate.
I made note of the below comment from install.txt . . .

4. Login to your store's admin. Under Tools you will see a new entry "Easy Populate 4". 
   (If you do not see this entry, you did not upload your files correctly.)

I then checked and confirmed that each and every file was uploaded to the correct directory with the exception of the following that were not uploaded . . .

\admin\includes\languages\deutsche\ -- since I only need English
\examples\ -- since it was not in the admin directory and the instructions said to upload the files in the admin directory maintaining directory structure
\htaccess4AdminTempFolder\ -- since it was not in the admin directory
\examples\ -- since it was not in the admin directory
\zencart 1.3 extra files\ -- since I'm using Zen Cart 1.5.5a

Any ideas?

My vitals

1. Zen Cart v1.5.5a fresh clean install including demo data; files uploaded via FTP then run zc_install
2. Linux Apache
3. PHP Version: 5.6.17 (Zend: 2.6.0)
4. Database: MySQL 5.5.42-37.1-log
5. Database Backup MySQL Addon

More than likely the admin directory within the EP4 package has been copied to YOUR_SECRET_ADMIN folder rather than the contents of the admin directory within the EP4 package being copied there.

If you locate the file easypopulate_4.php on your server, what other file(s) are in the directory with it? If they are only other EP4 files, then loaded to the wrong location.

Installation of EP4 with regards to loading the contents of the admin directory to your server's admin directory is very similar to the installation of any other ZC plugin. It is an admin side application with no catalog side facing software (no basic includes folder).

mc12345678:

If you locate the file easypopulate_4.php on your server, what other file(s) are in the directory with it? If they are only other EP4 files, then loaded to the wrong location.

Good thought. However, there are many other files in my secret admin directory /zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/
Alphabetically the 1st file is admin_account.php and the last is zones.php
easypopulate_4.php and the four other easypopulate php files are also in there.

Also, as recommended in install.txt I successfully installed Back MYSQL Plugin. So backup_mysql.php is also in there indicating that I understood, at least in one case, how to upload files to MY_SECRET_ADMIN

What should I check out next?

Thanks so much for your assistance!

When you access your admin, does the path to your admin include zen-cart-v1.5.5a-05052016 when looking at the uri of your browser?

Does backup_mysql.php exist elsewhere in your file structure off of the catalog front end?

mc12345678:

When you access your admin, does the path to your admin include zen-cart-v1.5.5a-05052016 when looking at the uri of your browser?

Yes, when looking at the uri of my browser the path to my admin does include zen-cart-v1.5.5a-05052016. This is as expected since zen-cart-v1.5.5a-05052016 is the catalog front end of the Zen Cart.

mc12345678:

Does backup_mysql.php exist elsewhere in your file structure off of the catalog front end?

I don't know how to check for that short of manually looking into each of the hundreds of sub directories contained therein. However, just to confirm the admin tool console was in fact looking at that file, I deleted it and then tried accessing Tools> Database Backup - MySQL and, as expected, got a 404 Error File Not Found. I then restored /zen-cart-v1.5.5a-05052016/My_Secret_Admin/backup_mysql.php and then again accessed it via Tools> Database Backup - MySQL without error.

Additionally, I used the admin Console>Tools>Developers Tool Kit to Look up in all files and search the phrase easypopulate in All Files Catalog/Admin for every file type. Here are the files that were found.

/zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/easypopulate_4.php
/zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/easypopulate_4_attrib.php
/zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/easypopulate_4_export.php
zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/easypopulate_4_import.php
/zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/easypopulate_4_split.php
/zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/includes/functions/extra_functions/easypopulate_4_functions.php
/zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/includes/functions/extra_functions/reg_easypopulate_4.php
/zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/includes/languages/english/easypopulate_4.php
/zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/includes/languages/english/easypopulate_4_menus.php
/zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/includes/languages/english/extra_definitions/easypopulate_4.php
/zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/includes/modules/easypopulate_4_filelayout.php

How does that look? What should I do next? Thanks!!

Zean:

Additionally, I used the admin Console>Tools>Developers Tool Kit to Look up in all files and search the phrase easypopulate in All Files Catalog/Admin for every file type. Here are the files that were found.

/zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/easypopulate_4.php
/zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/easypopulate_4_attrib.php
/zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/easypopulate_4_export.php
zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/easypopulate_4_import.php
/zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/easypopulate_4_split.php
/zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/includes/functions/extra_functions/easypopulate_4_functions.php
/zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/includes/functions/extra_functions/reg_easypopulate_4.php
/zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/includes/languages/english/easypopulate_4.php
/zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/includes/languages/english/easypopulate_4_menus.php
/zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/includes/languages/english/extra_definitions/easypopulate_4.php
/zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/includes/modules/easypopulate_4_filelayout.php

How does that look? What should I do next? Thanks!!

I see you are missing admin/includes/extra_datafiles/easypopulate_4_filenames.php
Try to upload that file and let us know... :)