EasyPopulate 4.0 Support Thread

Thank you for your advice.
I turned off the second language. The file is importing correctly now.

ma.r.a:

Thank you for your advice.
I turned off the second language. The file is importing correctly now.

Would you mind showing the first row of what the file looked like that was causing the issue? Generally speaking my intention was to allow Import to a multilingual database, though I wonder to what extent I limited such and furthermore to what extent that is expected or required. E.g., in language 1 a product is in cat1^cat1_1 in language 2 though in cat1^cat1_2 instead.

Reason I perceive the problem occurred is that in assignment or reassignment to another language is that if the category exists in both languages but is only referenced in the one then a search is not performed to push it to both languages. But, I await further information to try to resolve the issue identified.

dear mc12345678 ,
i can not find it on the search, but when can we safely use easy pop on version 2?
many greetings

kernheimer:

dear mc12345678 ,
i can not find it on the search, but when can we safely use easy pop on version 2?
many greetings

If you're OK with the files being installed like they have been until recently, the github latest version is reported to work with version 2.0. If you're hard set on installation via the zc_plugins directory, I've been advised that the installation process on version 2.0 needs some minor massaging to accommodate changes made in the zc_plugins process.

Beyond that, I don't have a specific time especially if I find issues with the latest of the v2 code now that it has been released.

thank you so much ( again!)

Morning,

Zen Cart 1.5.8
PHP 7.4
MySQL 8.0.36

[29-Apr-2024 05:31:30 UTC] Request URI: /index.php?cPath=330_331_377&main_page=product_info&products_id=3772, IP address: 111.111.111.111
#1  trigger_error() called at [/home/xxxxx/public_html/includes/classes/db/mysql/query_factory.php:667]
#2  queryFactory->show_error() called at [/home/xxxxx/public_html/includes/classes/db/mysql/query_factory.php:634]
#3  queryFactory->set_error() called at [/home/xxxxx/public_html/includes/classes/db/mysql/query_factory.php:275]
#4  queryFactory->Execute() called at [/home/xxxxx/public_html/includes/functions/functions_prices.php:1529]
#5  zen_update_products_price_sorter() called at [/home/xxxxx/public_html/includes/functions/functions_prices.php:1558]
#6  zen_update_salemaker_product_prices() called at [/home/xxxxx/public_html/includes/functions/salemaker.php:49]
#7  zen_expire_salemaker() called at [/home/xxxxx/public_html/includes/init_includes/init_special_funcs.php:65]
#8  require_once(/home/xxxxx/public_html/includes/init_includes/init_special_funcs.php) called at [/home/xxxxx/public_html/includes/autoload_func.php:40]
#9  require(/home/xxxxx/public_html/includes/autoload_func.php) called at [/home/xxxxx/public_html/includes/application_top.php:237]
#10 require(/home/xxxxx/public_html/includes/application_top.php) called at [/home/xxxxx/public_html/index.php:25]
--> PHP Fatal error: 1366:Incorrect decimal value: '' for column 'products_price_sorter' at row 1 :: UPDATE products
            SET products_price_sorter=''
            WHERE products_id=1530 ==> (as called by) /home/xxxxx/public_html/includes/functions/functions_prices.php on line 1529 <== in /home/xxxxx/public_html/includes/classes/db/mysql/query_factory.php on line 667.

mprough:

Morning,

Zen Cart 1.5.8
PHP 7.4
MySQL 8.0.36

[29-Apr-2024 05:31:30 UTC] Request URI: /index.php?cPath=330_331_377&main_page=product_info&products_id=3772, IP address: 111.111.111.111
#1 trigger_error() called at [/home/xxxxx/public_html/includes/classes/db/mysql/query_factory.php:667]
#2 queryFactory->show_error() called at [/home/xxxxx/public_html/includes/classes/db/mysql/query_factory.php:634]
#3 queryFactory->set_error() called at [/home/xxxxx/public_html/includes/classes/db/mysql/query_factory.php:275]
#4 queryFactory->Execute() called at [/home/xxxxx/public_html/includes/functions/functions_prices.php:1529]
#5 zen_update_products_price_sorter() called at [/home/xxxxx/public_html/includes/functions/functions_prices.php:1558]
#6 zen_update_salemaker_product_prices() called at [/home/xxxxx/public_html/includes/functions/salemaker.php:49]
#7 zen_expire_salemaker() called at [/home/xxxxx/public_html/includes/init_includes/init_special_funcs.php:65]
#8 require_once(/home/xxxxx/public_html/includes/init_includes/init_special_funcs.php) called at [/home/xxxxx/public_html/includes/autoload_func.php:40]
#9 require(/home/xxxxx/public_html/includes/autoload_func.php) called at [/home/xxxxx/public_html/includes/application_top.php:237]
#10 require(/home/xxxxx/public_html/includes/application_top.php) called at [/home/xxxxx/public_html/index.php:25]
--> PHP Fatal error: 1366:Incorrect decimal value: '' for column 'products_price_sorter' at row 1 :: UPDATE products
SET products_price_sorter=''
WHERE products_id=1530 ==> (as called by) /home/xxxxx/public_html/includes/functions/functions_prices.php on line 1529 <== in /home/xxxxx/public_html/includes/classes/db/mysql/query_factory.php on line 667.

Didn't realize I missed the text =O

This error is logging for all products... I suspect it might be an issue from EP or DBIO

[30-Apr-2024 05:38:21 UTC] Request URI: /index.php?cPath=77_128&main_page=product_info&products_id=3168, IP address: 11.11.11.11
#1 trigger_error() called at [/home/xxxxx/public_html/includes/classes/db/mysql/query_factory.php:667]
#2 queryFactory->show_error() called at [/home/xxxxx/public_html/includes/classes/db/mysql/query_factory.php:634]
#3 queryFactory->set_error() called at [/home/xxxxx/public_html/includes/classes/db/mysql/query_factory.php:275]
#4 queryFactory->Execute() called at [/home/xxxxx/public_html/includes/functions/functions_prices.php:1529]
#5 zen_update_products_price_sorter() called at [/home/xxxxx/public_html/includes/functions/functions_prices.php:1558]
#6 zen_update_salemaker_product_prices() called at [/home/xxxxx/public_html/includes/functions/salemaker.php:49]
#7 zen_expire_salemaker() called at [/home/xxxxx/public_html/includes/init_includes/init_special_funcs.php:65]
#8 require_once(/home/xxxxx/public_html/includes/init_includes/init_special_funcs.php) called at [/home/xxxxx/public_html/includes/autoload_func.php:40]
#9 require(/home/xxxxx/public_html/includes/autoload_func.php) called at [/home/xxxxx/public_html/includes/application_top.php:237]
#10 require(/home/xxxxx/public_html/includes/application_top.php) called at [/home/xxxxx/public_html/index.php:25]
--> PHP Fatal error: 1366:Incorrect decimal value: '' for column 'products_price_sorter' at row 1 :: UPDATE products
SET products_price_sorter=''
WHERE products_id=4870 ==> (as called by) /home/xxxxx/public_html/includes/functions/functions_prices.php on line 1529 <== in /home/xxxxx/public_html/includes/classes/db/mysql/query_factory.php on line 667.

The decimal value stored in the DB is correct.

Easy Populate 4.0.39.ZC - 03-17-2023
Database I/O (DbIo) Manager v2.0.0-beta3 (2023-01-02)

~Melanie

mprough:

Didn't realize I missed the text =O

This error is logging for all products... I suspect it might be an issue from EP or DBIO

[30-Apr-2024 05:38:21 UTC] Request URI: /index.php?cPath=77_128&main_page=product_info&products_id=3168, IP address: 11.11.11.11
#1 trigger_error() called at [/home/xxxxx/public_html/includes/classes/db/mysql/query_factory.php:667]
#2 queryFactory->show_error() called at [/home/xxxxx/public_html/includes/classes/db/mysql/query_factory.php:634]
#3 queryFactory->set_error() called at [/home/xxxxx/public_html/includes/classes/db/mysql/query_factory.php:275]
#4 queryFactory->Execute() called at [/home/xxxxx/public_html/includes/functions/functions_prices.php:1529]
#5 zen_update_products_price_sorter() called at [/home/xxxxx/public_html/includes/functions/functions_prices.php:1558]
#6 zen_update_salemaker_product_prices() called at [/home/xxxxx/public_html/includes/functions/salemaker.php:49]
#7 zen_expire_salemaker() called at [/home/xxxxx/public_html/includes/init_includes/init_special_funcs.php:65]
#8 require_once(/home/xxxxx/public_html/includes/init_includes/init_special_funcs.php) called at [/home/xxxxx/public_html/includes/autoload_func.php:40]
#9 require(/home/xxxxx/public_html/includes/autoload_func.php) called at [/home/xxxxx/public_html/includes/application_top.php:237]
#10 require(/home/xxxxx/public_html/includes/application_top.php) called at [/home/xxxxx/public_html/index.php:25]
--> PHP Fatal error: 1366:Incorrect decimal value: '' for column 'products_price_sorter' at row 1 :: UPDATE products
SET products_price_sorter=''
WHERE products_id=4870 ==> (as called by) /home/xxxxx/public_html/includes/functions/functions_prices.php on line 1529 <== in /home/xxxxx/public_html/includes/classes/db/mysql/query_factory.php on line 667.

> 
> The decimal value stored in the DB is correct.
> 
> Easy Populate 4.0.39.ZC - 03-17-2023
> Database I/O (DbIo) Manager v2.0.0-beta3 (2023-01-02)
> 
> ~Melanie

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/blob/v158/includes/functions/functions_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.

mc12345678:

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/blob/v158/includes/functions/functions_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

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.

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.

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.

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.

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.

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.

mc12345678:

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!

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.

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.

PHP 8.3.27 / ZC 2.0.1 / Easy Populate 4.0.39.ZC

After struggling through some errors and a lot of hunt and pecking while trying to patch those, I managed to get this mod to finally work with ZenCart 2.0.1.

Just a few questions:

1. is the EasyPopulate SBA modification supposed to create new combinations for inventorying? Is there a way to do so?
2. Is this the most recent version of Easy Populate to use? I couldn't keep track on the Git Hub repository.

retched:

PHP 8.3.27 / ZC 2.0.1 / Easy Populate 4.0.39.ZC

After struggling through some errors and a lot of hunt and pecking while trying to patch those, I managed to get this mod to finally work with ZenCart 2.0.1.

Just a few questions:

1. is the EasyPopulate SBA modification supposed to create new combinations for inventorying? Is there a way to do so?
2. Is this the most recent version of Easy Populate to use? I couldn't keep track on the Git Hub repository.

Could really be helpful to identify what errored and/or needed patching in association with EP4. Forgive me, but the above makes it seem (right or wrong) that all of the issues experienced in association with ZC 2.0.1 were only issues with EP4 v4.0.39.ZC. Would like to address any that exist.

In answer to the questions:

1. Effort has not been put forth to address the necessary complication of generating new SBA combinations through file upload based on what would be needed to import a new combination containing characteristics that do not yet exist and how easy an existing combination could get destroyed/improperly updated with that same set of considerations/concerns. If this is in relation to the previous query created to "import"/generate combinations for newly added product each with an attribute that do not yet have a combination, mind you, whatever problem was experienced (which I didn't see a proper explanation of why the particular issues existed) the query was still sound and could be executed outside of each of these applications.

2. Yes, 4.0.39.ZC is the most recent version to push for all to use. There were a LOT of changes made and while I attempt to test series of combinations and possibilities, I do not believe I can test every possibility, which brings me back to the above, if the issue(s) are EP4 related, let's fix them. If they are/were from something else, then please clear the air.