EasyPopulate 4.0 Support Thread

[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