EasyPopulate 4.0 Support Thread

[mc12345678]

Friends, I'm using version v1.5.5e. (yeah, I know...) but I have like 50 sites and upgrading is going to be a massive undertaking, so I'm still there. Until a few days ago, this mod worked perfectly, has worked perfectly for years. Now I'm getting this error each time I choose "easy populate 4" from my tools menu:



Any ideas what may have changed on my hosting server perhaps? This behavior is consistent across ALL of my sites, and has been this way for several days. Everything else is working fine on the site.

Check your logs directory to see what if any debug logs were generated while attempting access. If posting the content here, remember that the admin directory will be present and should be obscured.

Also, if the housing company for all sites is the same, they may be having a particular issue besides s what was previously suggested.

[allmart]

Hello my Zen Cart version is 1.5.5e and using EasyPopulate 4.0.37.13 and have used EP for years without issue. For reasons unknown to me I can no longer import new products getting the error SKIPPED! - v_products_model: ??? - No category provided for this new product the categories heading in my csv file is v_categories_name_1 and is in the 27th column of my csv file or AA if using Excel. If I export Complete Products (with Metatags) the columns are identical. I do have categories entered in the column ... they are not blank and named correctly. What am I doing wrong.
Thanks in advance.

[mc12345678]

Hello my Zen Cart version is 1.5.5e and using EasyPopulate 4.0.37.13 and have used EP for years without issue. For reasons unknown to me I can no longer import new products getting the error SKIPPED! - v_products_model: ??? - No category provided for this new product the categories heading in my csv file is v_categories_name_1 and is in the 27th column of my csv file or AA if using Excel. If I export Complete Products (with Metatags) the columns are identical. I do have categories entered in the column ... they are not blank and named correctly. What am I doing wrong.
Thanks in advance.

Haven't read the post just 7 posts before on the same page of this original post when listed a default way: https://www.zen-cart.com/newreply.ph...eply&p=1392327

[cindygordon]

trying to delete this, sorry

[cindygordon]

Check your logs directory to see what if any debug logs were generated while attempting access. If posting the content here, remember that the admin directory will be present and should be obscured.

Also, if the housing company for all sites is the same, they may be having a particular issue besides s what was previously suggested.

I am not exactly sure how to check logs. I will call the hosting company tho, yes, it's the same host for all of the sites. Thank you!

[mc12345678]

Hello my Zen Cart version is 1.5.5e and using EasyPopulate 4.0.37.13 and have used EP for years without issue. For reasons unknown to me I can no longer import new products getting the error SKIPPED! - v_products_model: ??? - No category provided for this new product the categories heading in my csv file is v_categories_name_1 and is in the 27th column of my csv file or AA if using Excel. If I export Complete Products (with Metatags) the columns are identical. I do have categories entered in the column ... they are not blank and named correctly. What am I doing wrong.
Thanks in advance.

Haven't read the post just 7 posts before on the same page of this original post when listed a default way: https://www.zen-cart.com/newreply.ph...eply&p=1392327

I am not exactly sure how to check logs. I will call the hosting company tho, yes, it's the same host for all of the sites. Thank you!

I have no idea why the link I pasted had been captured instead of this one: https://www.zen-cart.com/showthread....28#post1392328

[allmart]

My query_factory.php file has no such code as posted in the fix

private $link; // mysqli object

see below

/**
* Queryfactory - A simple database abstraction layer
*
*/
class queryFactory extends base {
var $link, $count_queries, $total_query_time, $dieOnErrors;
var $error_number = 0;
var $error_text = '';

function __construct() {
$this->count_queries = 0;
$this->total_query_time = 0;
}

[mc12345678]

My query_factory.php file has no such code as posted in the fix

private $link; // mysqli object

see below

/**
* Queryfactory - A simple database abstraction layer
*
*/
class queryFactory extends base {
var $link, $count_queries, $total_query_time, $dieOnErrors;
var $error_number = 0;
var $error_text = '';

function __construct() {
$this->count_queries = 0;
$this->total_query_time = 0;
}

The issue, based on your description is with the second problem identified in the previous discussion. It comes down to alignment of import language identifiers as compared to what the file contains. Your file has the language id (1), but the default install/upgrade for import incorrectly sets to language_code_only. This means that if a file had for example: categories_name_1 and categories_name_en columns, then only the data in categories_name_en would be imported. Not having that column in a default install causes no category names being found.

So, change the setting to literally anything else (recommendation is language_id_only) and that problem will be resolved. The issue quoted above about that file is in reference to the original distribution of Zen Cart 1.5.8.

[allmart]

The issue, based on your description is with the second problem identified in the previous discussion. It comes down to alignment of import language identifiers as compared to what the file contains. Your file has the language id (1), but the default install/upgrade for import incorrectly sets to language_code_only. This means that if a file had for example: categories_name_1 and categories_name_en columns, then only the data in categories_name_en would be imported. Not having that column in a default install causes no category names being found.

So, change the setting to literally anything else (recommendation is language_id_only) and that problem will be resolved. The issue quoted above about that file is in reference to the original distribution of Zen Cart 1.5.8.

Sorry for the late response, your fixed worked ... many thanks!!!

[webmanstudios]

Thank you for this fix! :)