EasyPopulate 4.0 Support Thread

[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, or ask you host to check, modsecurity rules. They have have been updated. A 503 error will happen if modsecurity is blocking the action. There are, of course, many other reasons for a 503, but I have seen this happen.

Thank you, I'll check w/ godaddy.

[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

[dbltoe]

Thank you, I'll check w/ godaddy.

They are going to give you a bunch of gibberish BUT, ask them about the MySQL connection that is being used for your sites.

Not only did they drop PHP 5.4 and 5.6 (later to reinstated after customers complained) , they also changed the database connections from MySQL to MySQLi. All without telling the customer.

It is a better connection BUT, for some reason, you get a 503 error with any PHP below 7

[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.

[webmanstudios]

Thank you for this fix! :)

[shags38]

hello all - I am creating a Google Merchant Center data file for ads/free listings that requires amongst other things full Image URL - I've searched the thread and checked the Github - I can see that to do this will require a code change/addition so;
a) wondering if anyone has done this successfully and if so are you willing to share the changes made?
or b) can someone give me a hint as to how to do this please, what file etc.

many thanks, Mike