EasyPopulate 4.0 Support Thread

[mprough]

Might want to confirm the version of your includes/functions/functions_prices.php file against a new or original 1.5.8 version. Line numbers are not aligning at least with: https://github.com/zencart/zencart/b...ons_prices.php

Further I'm not yet seeing in that version of the file where an empty string would make its way back. I didn't do a comparison though between the v158 branch and the v1.5.8 breaks with also knowing that there was a sub version issued.

While I've found some other Zen Cart functions that don't handle a missing record sufficiently, this area may be one of them, but I don't really see how either tool could cause the described issue of the database field contains information on the correct format.

File version is * @version $Id: Scott C Wilson 2022 May 26 Modified in v1.5.8-alpha $ and it's the original installed file, untouched for over a year. File comparison with stock fresh file from 1.5.8 is identical. The one you posted that didn't line up is 1.5.8a.

The 1.5.8a file has a few code differences from 1.5.8.

Noting also that the what caught my attention originally is how slow the admin is. Front end is fast and fine.

I switched to the 1.5.8a file which seems to stop the logged error... However, the admin remains slow.

~Melanie

[g2ktcf]

I am doing a clean install of 2.0.0 and my old 1.5.7c (thought it was d but that is wrong lol). I have the following KEYS listed in the database. Do I need to remove these before upgrading? I would rather get this all working right and just installing a new EP after.

[g2ktcf]

ZC 2.0.0
Easy Populate 4.0.37.13 - 05-03-2021

Getting the following debug log file. Also, while the date on the code above says 5/3/2021, it was downloaded only 3 days ago.

[31-May-2024 10:44:32 UTC] Request URI: /fLash-SUC-snaCk/index.php?cmd=easypopulate_4, IP address: ::1, Language id 1
#0 [internal function]: zen_debug_error_handler()
#1 C:\wamp64\www\WLC_Artistry_158a\fLash-SUC-snaCk\includes\header.php(71): trigger_error()
#2 C:\wamp64\www\WLC_Artistry_158a\fLash-SUC-snaCk\easypopulate_4.php(646): require('C:\\wamp64\\www\\W...')
#3 C:\wamp64\www\WLC_Artistry_158a\fLash-SUC-snaCk\index.php(11): require('C:\\wamp64\\www\\W...')
--> PHP Deprecated: This page requires updates for the next Zen Cart version. Please refer your site developer or plugin author to <a href="https://docs.zen-cart.com/dev/plugins/admin_head_content/" rel="noopener noreferrer" target="_blank">this</a> documentation. in C:\wamp64\www\WLC_Artistry_158a\fLash-SUC-snaCk\includes\header.php on line 71.

[mc12345678]

ZC 2.0.0
Easy Populate 4.0.37.13 - 05-03-2021

Getting the following debug log file. Also, while the date on the code above says 5/3/2021, it was downloaded only 3 days ago.

[31-May-2024 10:44:32 UTC] Request URI: /fLash-SUC-snaCk/index.php?cmd=easypopulate_4, IP address: ::1, Language id 1
#0 [internal function]: zen_debug_error_handler()
#1 C:\wamp64\www\WLC_Artistry_158a\fLash-SUC-snaCk\includes\header.php(71): trigger_error()
#2 C:\wamp64\www\WLC_Artistry_158a\fLash-SUC-snaCk\easypopulate_4.php(646): require('C:\\wamp64\\www\\W...')
#3 C:\wamp64\www\WLC_Artistry_158a\fLash-SUC-snaCk\index.php(11): require('C:\\wamp64\\www\\W...')
--> PHP Deprecated: This page requires updates for the next Zen Cart version. Please refer your site developer or plugin author to <a href="https://docs.zen-cart.com/dev/plugins/admin_head_content/" rel="noopener noreferrer" target="_blank">this</a> documentation. in C:\wamp64\www\WLC_Artistry_158a\fLash-SUC-snaCk\includes\header.php on line 71.

Thanks for the report, will seek updating the page's header to incorporate that direction. Note that the log is expected to be generated once per session until resolved.

[mc12345678]

I am doing a clean install of 2.0.0 and my old 1.5.7c (thought it was d but that is wrong lol). I have the following KEYS listed in the database. Do I need to remove these before upgrading? I would rather get this all working right and just installing a new EP after.

Thought I had responded to this, but it is obvious I did not. Not sure how just throw two keys remained in the database. I would have expected that an uninstall at the version that added them or beyond would have also removed them. Further without reviewing the installation steps, I'm not sure if or what issues might occur (e.g., other settings get loaded but to a different configuration menu, log generated because of attempted duplicate).

I do see though that you've reported performing a clean install, so this serves more of an acknowledgement to the question. I would have removed those two additional remnants before attempting a (re)install and investigated why they remained or were present.

Oh, and your database may have been 1.5.7d because issue of that version didn't actually update the version designation. File comparison would have been best to validate.

[g2ktcf]

Thought I had responded to this, but it is obvious I did not. Not sure how just throw two keys remained in the database. I would have expected that an uninstall at the version that added them or beyond would have also removed them. Further without reviewing the installation steps, I'm not sure if or what issues might occur (e.g., other settings get loaded but to a different configuration menu, log generated because of attempted duplicate).

I do see though that you've reported performing a clean install, so this serves more of an acknowledgement to the question. I would have removed those two additional remnants before attempting a (re)install and investigated why they remained or were present.

Oh, and your database may have been 1.5.7d because issue of that version didn't actually update the version designation. File comparison would have been best to validate.

I did a database only upgrade on a test site at my host this morning. So, I have a native 2.0.1 install without all the old files. After installing Mod List I worked to find all the outdated configuration keys and pages. I found WAY more than those 2 for some odd reason this time. Mod List now shows only what is installed so I am making progress.

Thanks!

[Pingfah]

Zen Cart 1.5.6
Easy Populate 4.0.36.ZC
PHP versions tried 5.6, 7.1, 7.3
MySQL 8.0.37

Having a very strange problem, when I upload my products file, EP says it has been imported successfully, it spits out all the products in green in the list at the bottom and says they have all been created correctly, but in reality I only have one product visible on the website, it contains the Product Model, Image, Price & Min Order Quantity, from the product in the first row of the CSV, and the rest of the details (Name & Description) are populated from the product in the final row of the CSV file. The product has been added to every category that is listed in the Category column, so if I have 100 products across 20 categories, I am ending up with one product visible in 20 categories.

If I actually look in the MySQL database at the Products table, all the products are there. If I look at the Product Description table, the products are absent with the exception of the one product from the final row that it puilled the description from. The product ID is the product ID from the product that was in the first row of the CSV file.

Importantly, if I export the existing products on the site using EP, delete them all using EP, and then reupload the file I exported, it works properly and imports all the products correctly.

I have tried every version of UTF I can think of, using Notepad++ to convert to UTF8, nothing has worked so far. I have also tried uploading the file with double quotes around every value (matching how the EP export files look), but this does not work either.

I have not touched the site or EP version in a few years, this has started happening recently seemingly spontaneously. I know the host has upgraded the MySQL to version 8 recently. The PHP version changes sometimes, but I have tried reverting to multiple older versions with no luck. I have also tried uploading last year's data file, which worked last year, but this presents with the same problems.

[g2ktcf]

So I started a new clean install of ZC 2.0.1

I have removed all the legacy configurations from the database and installed EP 4.0

I am getting the warning about opening the log file. However, the configuration EAYPOPULATE_4_CONFIG_TEMP_DIR does not exist. AND, there is no Easy Populate in the configuration menu. I have verified that all the files from Github did copy over.

If I try and load the Easy Populate Tools, I get a 500 error. Thoughts?

[g2ktcf]

So I started a new clean install of ZC 2.0.1

I have removed all the legacy configurations from the database and installed EP 4.0

I am getting the warning about opening the log file. However, the configuration EAYPOPULATE_4_CONFIG_TEMP_DIR does not exist. AND, there is no Easy Populate in the configuration menu. I have verified that all the files from Github did copy over.

If I try and load the Easy Populate Tools, I get a 500 error. Thoughts?

I have found zero logs for this. I have looked through ZC's logs and the only thing there is the debug log related to not finding the temp directory. The server error logs show ZERO errors.

ZC 2.0.1 Database only upgrade
Mod List
Image Handler
Bootstrap
Clone a Template
OPC

this is hosted on a sandbox server where the site address is site.host.com if that makes any difference. This is my last full test before going live.

[Pingfah]

Zen Cart 1.5.6
Easy Populate 4.0.36.ZC
PHP versions tried 5.6, 7.1, 7.3
MySQL 8.0.37

Having a very strange problem, when I upload my products file, EP says it has been imported successfully, it spits out all the products in green in the list at the bottom and says they have all been created correctly, but in reality I only have one product visible on the website, it contains the Product Model, Image, Price & Min Order Quantity, from the product in the first row of the CSV, and the rest of the details (Name & Description) are populated from the product in the final row of the CSV file. The product has been added to every category that is listed in the Category column, so if I have 100 products across 20 categories, I am ending up with one product visible in 20 categories.

If I actually look in the MySQL database at the Products table, all the products are there. If I look at the Product Description table, the products are absent with the exception of the one product from the final row that it puilled the description from. The product ID is the product ID from the product that was in the first row of the CSV file.

Importantly, if I export the existing products on the site using EP, delete them all using EP, and then reupload the file I exported, it works properly and imports all the products correctly.

I have tried every version of UTF I can think of, using Notepad++ to convert to UTF8, nothing has worked so far. I have also tried uploading the file with double quotes around every value (matching how the EP export files look), but this does not work either.

I have not touched the site or EP version in a few years, this has started happening recently seemingly spontaneously. I know the host has upgraded the MySQL to version 8 recently. The PHP version changes sometimes, but I have tried reverting to multiple older versions with no luck. I have also tried uploading last year's data file, which worked last year, but this presents with the same problems.

I am unable to edit the post now, but I should add that if I switch to Product ID as the primary key, all these problems go away.

All CSV files have been created in Open Office with recommended settings.