Zen Cart Logo
Forums / Addon Admin Tools / EasyPopulate 4.0 Support Thread

EasyPopulate 4.0 Support Thread

Sticky

Views: 733,304

Results 3,481 to 3,500 of 3,671
8 Feb 2023, 11:01 PM
#3481
cindygordon avatar

cindygordon

New Zenner

Join Date:
Sep 2016
Location:
Dallas, TX USA
Posts:
71
Plugin Contributions:
0

EasyPopulate 4.0 Support Thread

jeking:

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.

8 Feb 2023, 11:02 PM
#3482
cindygordon avatar

cindygordon

New Zenner

Join Date:
Sep 2016
Location:
Dallas, TX USA
Posts:
71
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

mc12345678:

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!

8 Feb 2023, 11:49 PM
#3483
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: EasyPopulate 4.0 Support Thread

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:

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.php?do=newreply&p=1392327

cindygordon:

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.php?190417-EasyPopulate-4-0-Support-Thread&p=1392328#post1392328

8 Feb 2023, 11:56 PM
#3484
dbltoe avatar

dbltoe

Totally Zenned

Join Date:
Jan 2004
Location:
N of San Antonio TX
Posts:
9,763
Plugin Contributions:
9

Re: EasyPopulate 4.0 Support Thread

cindygordon:

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.:censored:

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

9 Feb 2023, 11:27 AM
#3485
allmart avatar

allmart

Zen Follower

Join Date:
Feb 2016
Location:
Canada
Posts:
192
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

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;
}

9 Feb 2023, 2:54 PM
#3486
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: EasyPopulate 4.0 Support Thread

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;
}

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.

16 Feb 2023, 12:46 PM
#3487
webmanstudios avatar

webmanstudios

New Zenner

Join Date:
Dec 2013
Location:
Adelaide, South Australia
Posts:
29
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

Thank you for this fix! :)

19 Feb 2023, 12:17 AM
#3488
shags38 avatar

shags38

Totally Zenned

Join Date:
Jan 2011
Location:
Adelaide, Australia
Posts:
1,684
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

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

21 Feb 2023, 4:46 PM
#3489
allmart avatar

allmart

Zen Follower

Join Date:
Feb 2016
Location:
Canada
Posts:
192
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

mc12345678:

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!!!

22 Feb 2023, 1:56 AM
#3490
jtlswan avatar

jtlswan

New Zenner

Join Date:
May 2006
Location:
Orangeburg, SC
Posts:
72
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

HTTP error 500 when going to admin page/tools/Easy Populate 4.

I hope this is the correct place to post...been out of the game for 7-9 years and slowly working my way back in again....I uploaded all the files as stated in the install file and now I get a HTTP error 500 and easy populate does not show up under the configuration tab.

Running zencart 1.5.8
MySQL 5.7.23-23
Linux 4.19.150
PHP 7.4.33

Please help....

22 Feb 2023, 4:01 AM
#3491
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: EasyPopulate 4.0 Support Thread

jtlswan:

HTTP error 500 when going to admin page/tools/Easy Populate 4.

I hope this is the correct place to post...been out of the game for 7-9 years and slowly working my way back in again....I uploaded all the files as stated in the install file and now I get a HTTP error 500 and easy populate does not show up under the configuration tab.

Running zencart 1.5.8
MySQL 5.7.23-23
Linux 4.19.150
PHP 7.4.33

Please help....

Please take a moment to read the very recent previous posts. Should not have to read many more than 10.

22 Feb 2023, 5:30 AM
#3492
jtlswan avatar

jtlswan

New Zenner

Join Date:
May 2006
Location:
Orangeburg, SC
Posts:
72
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

I'll look more closely again...most of the posts i looked at had to do with people being able to access EP, but then having errors...i can't even access EP after clicking on it under tools...Letcha know what I find. Thank you for the push in the right direction MC

22 Feb 2023, 9:37 AM
#3493
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: EasyPopulate 4.0 Support Thread

jtlswan:

I'll look more closely again...most of the posts i looked at had to do with people being able to access EP, but then having errors...i can't even access EP after clicking on it under tools...Letcha know what I find. Thank you for the push in the right direction MC

My how time flies. It is a few more than 10 posts back, but not by many as the same issue(s) seem to appear at least once per page of postings. The most summarized post of known issues which includes yours is: https://www.zen-cart.com/showthread.php?190417-EasyPopulate-4-0-Support-Thread&p=1392328#post1392328

22 Feb 2023, 11:44 AM
#3494
jtlswan avatar

jtlswan

New Zenner

Join Date:
May 2006
Location:
Orangeburg, SC
Posts:
72
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

mc12345678:

My how time flies. It is a few more than 10 posts back, but not by many as the same issue(s) seem to appear at least once per page of postings. The most summarized post of known issues which includes yours is: https://www.zen-cart.com/showthread.php?190417-EasyPopulate-4-0-Support-Thread&p=1392328#post1392328

I don’t know how you deal with idiots like me and keep your composure/patience. It worked. Thank you very very much! All in a days work for Superman MC

22 Feb 2023, 2:26 PM
#3495
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: EasyPopulate 4.0 Support Thread

jtlswan:

I don’t know how you deal with idiots like me and keep your composure/patience. It worked. Thank you very very much! All in a days work for Superman MC

I appreciate the credit, though have not 100% remained so composed. I'm human and have my moments. Thank you though.

For you and others, I have a change in the works, but am trying to test it thoroughly so as not to cause a further show of issues to address. These two are enough. :)

26 Feb 2023, 4:01 AM
#3496
jtlswan avatar

jtlswan

New Zenner

Join Date:
May 2006
Location:
Orangeburg, SC
Posts:
72
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

Good news MC...it still working...thank you Sir...now, bad news...I'm sure I'm being a dumbass again and getting an upload error: SKIPPED! - v_products_model: gwpuldvd1361 - No category provided for this new product...

Obviously I have a category (categories) in the csv file:

v_products_model v_products_image v_products_name_1 v_categories_name_1
gwdvd103428 gwdvd103428.jpg DVD - Back to the Future Miscellaneous^Discontinued Items

ideas?

26 Feb 2023, 7:37 AM
#3497
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: EasyPopulate 4.0 Support Thread

jtlswan:

Good news MC...it still working...thank you Sir...now, bad news...I'm sure I'm being a dumbass again and getting an upload error: SKIPPED! - v_products_model: gwpuldvd1361 - No category provided for this new product...

Obviously I have a category (categories) in the csv file:

v_products_model v_products_image v_products_name_1 v_categories_name_1
gwdvd103428 gwdvd103428.jpg DVD - Back to the Future Miscellaneous^Discontinued Items

ideas?

Well as this is the last post of this page, for those listing 10 posts per page, groundhog day begins on the next post. The issue described above is the "second" issue with the current version of EP4. Please follow the guidance from the above link about ensuring the import of language dependent fields matches the filename fields. It is discussed in the thread previously shared where the statement was that there are two known issues. It looks like you've resolved the 1.5.8 issue, now the other one.

17 Mar 2023, 4:29 AM
#3498
diptimoy avatar

diptimoy

Zen Follower

Join Date:
Apr 2012
Location:
Bardhaman , Bharat
Posts:
214
Plugin Contributions:
1

Re: EasyPopulate 4.0 Support Thread

Getting this errors after installation , kindly help

"PHP Fatal error: Uncaught Error: Cannot access private property queryFactory::$link
includes/functions/extra_functions/easypopulate_4_functions.php(447): ep_4_query('SHOW COLUMNS FR...')

the error shows in line 447 and 609 on the file easypopulate_4_functions.php

17 Mar 2023, 10:53 AM
#3499
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: EasyPopulate 4.0 Support Thread

diptimoy:

Getting this errors after installation , kindly help

"PHP Fatal error: Uncaught Error: Cannot access private property queryFactory::$link
includes/functions/extra_functions/easypopulate_4_functions.php(447): ep_4_query('SHOW COLUMNS FR...')

the error shows in line 447 and 609 on the file easypopulate_4_functions.php

Please see post #3495 which refers to: https://www.zen-cart.com/showthread.php?190417-EasyPopulate-4-0-Support-Thread&p=1392328#post1392328. From there please identify what issues there are with applying the sun total of two changes (one in the software the other in the admin configuration settings) to support operation in 1.5.8 and in general, respectively.

25 Apr 2023, 9:03 PM
#3500
speak394 avatar

speak394

New Zenner

Join Date:
Mar 2018
Location:
Alabama
Posts:
61
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

v1.5.8
PHP Version: 7.4.33

I am getting this error:

SQLi error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '
categories_id = 3,
language_id = 1' at line 1

Have latest version from github.

Please help.