EasyPopulate 4.0 Support Thread

[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