EasyPopulate 4.0 Support Thread

[Russalpcs]

Maybe the error is that I used Softaculous to load the new site? After I have updated the stock on my old site to list new adverts on Bid or Buy for the next week I will load another v156 from a direct download and see if I get the same errors

[mc12345678]

Maybe the error is that I used Softaculous to load the new site? After I have updated the stock on my old site to list new adverts on Bid or Buy for the next week I will load another v156 from a direct download and see if I get the same errors

Well, that method doesn't exactly help things other than allowing those in the forum to possibly discover more quickly the errors with their installation package. One thing of note, whenever a screen goes blank there is likely an error message related to it in the logs folder. While total time to move an existing installation out of the way to discovery of a missing parentheses by execution of the code (would have likely been faster just to look at the patch itself) was about 20 minutes, I have pushed the revised patch to: https://github.com/mc12345678/EasyPo...n_import_patch

The issue is definitely a missing sql assignment when adding a new category. Again it was something that has existed in this software since before I started helping with it, but systems had generally been flexible enough to understand what to do and not cause a problem, but now are becoming stricter (which is good overall). Unfortunately users had not been making the issue known so changes could not be made for a problem not described... It has been addressed in an upcoming release and the above patch has been verified to work. Of course there are a number of things to be done with that code to tighten it up, but that's addressed in the next release.

[imacamper]

Well, that method doesn't exactly help things other than allowing those in the forum to possibly discover more quickly the errors with their installation package. One thing of note, whenever a screen goes blank there is likely an error message related to it in the logs folder. While total time to move an existing installation out of the way to discovery of a missing parentheses by execution of the code (would have likely been faster just to look at the patch itself) was about 20 minutes, I have pushed the revised patch to: https://github.com/mc12345678/EasyPo...n_import_patch

The issue is definitely a missing sql assignment when adding a new category. Again it was something that has existed in this software since before I started helping with it, but systems had generally been flexible enough to understand what to do and not cause a problem, but now are becoming stricter (which is good overall). Unfortunately users had not been making the issue known so changes could not be made for a problem not described... It has been addressed in an upcoming release and the above patch has been verified to work. Of course there are a number of things to be done with that code to tighten it up, but that's addressed in the next release.

I am having this issue with ZenCart 1.56a and EasyPopulate 4. If it matters, my PHP is version 7.1 and MySQL is 5.6.

In trying to address the issue, I came across this thread and have installed the v4.0.36.ZC Patch 1 12-29-2018 mc12345678. I didn't know exactly how to use the diff but I found the raw file on github and copy/pasted the entire thing so I think that would be OK?

However I still get an error when attempting an import. From ep_debug_log.txt:

MySQLi error 1366: Incorrect integer value: '' for column 'products_sort_order' at row 1
When executing:
INSERT INTO products SET
                                                        products_model                                  = 'BLUFFF_BLKDOV',
                                                        products_type                           = 1,
                                                        products_price                                  = '39.95', 
                                                        products_image                       = '62802-full.png',
                                                        products_weight                                 = 0.085,
                                                        products_discount_type          = 0,
                                                        products_discount_type_from     = 0,
                                                        product_is_call                 = 0,
                                                        products_sort_order             = '',
                                                        products_quantity_order_min     = 0,
                                                        products_quantity_order_units   = 0,
                                                        products_priced_by_attribute    = 0,
                                                        product_is_always_free_shipping = 0,
                                                        products_tax_class_id                   = 0,
                                                        products_date_available                 = NULL, 
                                                        products_date_added                             = '2018-08-09 11:10:00',
                                                        products_last_modified                  = CURRENT_TIMESTAMP,
                                                        products_quantity                               = 15,
                                                        master_categories_id                    = 139146,
                                                        manufacturers_id                                = 0,
                                                        products_status                                 = 1,
                                                        metatags_title_status                   = 0,
                                                        metatags_products_name_status   = 0,
                                                        metatags_model_status                   = 0,
                                                        metatags_price_status                   = 0,
                                                        metatags_title_tagline_status   = 0

Here are the columns in my CSV:

v_products_model,v_products_image,v_products_name_1,v_products_description_1,v_products_price,v_products_weight,v_products_quantity,v_date_added,v_categories_name_1,v_categories_name_2,v_status

Any ideas on how I can fix this?

Thanks for your time,

Drew

[mc12345678]

I am having this issue with ZenCart 1.56a and EasyPopulate 4. If it matters, my PHP is version 7.1 and MySQL is 5.6.

In trying to address the issue, I came across this thread and have installed the v4.0.36.ZC Patch 1 12-29-2018 mc12345678. I didn't know exactly how to use the diff but I found the raw file on github and copy/pasted the entire thing so I think that would be OK?

However I still get an error when attempting an import. From ep_debug_log.txt:

MySQLi error 1366: Incorrect integer value: '' for column 'products_sort_order' at row 1
When executing:
INSERT INTO products SET
                                                        products_model                                  = 'BLUFFF_BLKDOV',
                                                        products_type                           = 1,
                                                        products_price                                  = '39.95', 
                                                        products_image                       = '62802-full.png',
                                                        products_weight                                 = 0.085,
                                                        products_discount_type          = 0,
                                                        products_discount_type_from     = 0,
                                                        product_is_call                 = 0,
                                                        products_sort_order             = '',
                                                        products_quantity_order_min     = 0,
                                                        products_quantity_order_units   = 0,
                                                        products_priced_by_attribute    = 0,
                                                        product_is_always_free_shipping = 0,
                                                        products_tax_class_id                   = 0,
                                                        products_date_available                 = NULL, 
                                                        products_date_added                             = '2018-08-09 11:10:00',
                                                        products_last_modified                  = CURRENT_TIMESTAMP,
                                                        products_quantity                               = 15,
                                                        master_categories_id                    = 139146,
                                                        manufacturers_id                                = 0,
                                                        products_status                                 = 1,
                                                        metatags_title_status                   = 0,
                                                        metatags_products_name_status   = 0,
                                                        metatags_model_status                   = 0,
                                                        metatags_price_status                   = 0,
                                                        metatags_title_tagline_status   = 0

Here are the columns in my CSV:

v_products_model,v_products_image,v_products_name_1,v_products_description_1,v_products_price,v_products_weight,v_products_quantity,v_date_added,v_categories_name_1,v_categories_name_2,v_status

Any ideas on how I can fix this?

Thanks for your time,

Drew

This issue was fixed in a later push of code when more was done to ensure there was a "sanitizer" for every field being populated.

I'm nearly inclined to suggest installing the latest version on GitHub. I'm looking at a couple of additional tests to verify that it will be possible to import language related information using the two character language code. The existing method uses the numeric language id.

Change lines 1039 and 1190 of admin/easypopulate_4_import.php from:

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

to:

            $query = $db->bindVars($query, ':products_sort_order:', $v_products_sort_order, 'integer');

[imacamper]

This issue was fixed in a later push of code when more was done to ensure there was a "sanitizer" for every field being populated.

I'm nearly inclined to suggest installing the latest version on GitHub. I'm looking at a couple of additional tests to verify that it will be possible to import language related information using the two character language code. The existing method uses the numeric language id.

Change lines 1039 and 1190 of admin/easypopulate_4_import.php from:

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

to:

            $query = $db->bindVars($query, ':products_sort_order:', $v_products_sort_order, 'integer');

Thank you very much. That has solved my issue.

Cheers,

Drew