EasyPopulate 4.0 Support Thread

[stellarweb]

I am having the same issue on a client's website that is 1.5.3.

PHP Version: 5.4.30, used the latest files at https://github.com/chaddro/EasyPopulate-4.0

Mod worked the day I installed it and generated a file. Yesterday it stopped working and gave the error below.

I checked easypopulate_4 in developers tool kit - got 188 match lines in 10 files.

Any help would be appreciated! THANKS SO MUCH!

I have read through this entire thread looking for a different answer than the missing $ update, but even after uploading and installing the latest version, and even copying and pasting the code from GitHub, I am still getting EP4 FATAL ERROR: No default language set, even though just a few days ago, Easypopulate 4 was working perfectly on my site. Has anyone come up with any different reasons for this, and/or fixes?

[mc12345678]

I am having the same issue on a client's website that is 1.5.3.

PHP Version: 5.4.30, used the latest files at https://github.com/chaddro/EasyPopulate-4.0

Mod worked the day I installed it and generated a file. Yesterday it stopped working and gave the error below.

I checked easypopulate_4 in developers tool kit - got 188 match lines in 10 files.

Any help would be appreciated! THANKS SO MUCH!

In the file YOUR_ADMIN/easypopulate_4.php at line 177 that reads:

exit("EP4 FATAL ERROR: No default language set."); // this should never happen

Change to read:

exit("EP4 FATAL ERROR: No default language set. Table: ".TABLE_LANGUAGES." Code: ".DEFAULT_LANGUAGE." is set" ); // this should never happen

And please repost the resulting error message.

[stellarweb]

EP4 FATAL ERROR: No default language set. Table: languages Code: en is set

Above is the new error after making the change

In the file YOUR_ADMIN/easypopulate_4.php at line 177 that reads:

exit("EP4 FATAL ERROR: No default language set."); // this should never happen

Change to read:

exit("EP4 FATAL ERROR: No default language set. Table: ".TABLE_LANGUAGES." Code: ".DEFAULT_LANGUAGE." is set" ); // this should never happen

And please repost the resulting error message.

[mc12345678]

EP4 FATAL ERROR: No default language set. Table: languages Code: en is set

Above is the new error after making the change

Try this if you wouldn't mind after line 171, add the following:

$epdlanguage_query->store_result();

Ie:between these two lines:

$epdlanguage_query = ep_4_query("SELECT languages_id, name FROM ".TABLE_LANGUAGES." WHERE code = '".DEFAULT_LANGUAGE."'");
if (($ep_uses_mysqli ? mysqli_num_rows($epdlanguage_query) : mysql_num_rows($epdlanguage_query))) {

[stellarweb]

Done

Now get blank white page. Error log generated as follows

[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_query() expects parameter 1 to be mysqli, resource given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 990
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_errno() expects parameter 1 to be mysqli, resource given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 991
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 895
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_query() expects parameter 1 to be mysqli, resource given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 990
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_errno() expects parameter 1 to be mysqli, resource given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 991
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 895
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_query() expects parameter 1 to be mysqli, resource given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 990
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_errno() expects parameter 1 to be mysqli, resource given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 991
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 895
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_query() expects parameter 1 to be mysqli, resource given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 990
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_errno() expects parameter 1 to be mysqli, resource given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 991
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 895
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_query() expects parameter 1 to be mysqli, resource given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 990
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_errno() expects parameter 1 to be mysqli, resource given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 991
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 895
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_query() expects parameter 1 to be mysqli, resource given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 990
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_errno() expects parameter 1 to be mysqli, resource given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 991
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 895
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_query() expects parameter 1 to be mysqli, resource given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 990
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_errno() expects parameter 1 to be mysqli, resource given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 991
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 895
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_character_set_name() expects parameter 1 to be mysqli, resource given in /home3/beadins1/public_html/bI1544+/easypopulate_4.php on line 138
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_query() expects parameter 1 to be mysqli, resource given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 990
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_errno() expects parameter 1 to be mysqli, resource given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 991
[21-Aug-2014 12:06:11 America/Denver] PHP Fatal error: Call to a member function store_result() on a non-object in /home3/beadins1/public_html/bI1544+/easypopulate_4.php on line 172

Try this if you wouldn't mind after line 171, add the following:

$epdlanguage_query->store_result();

Ie:between these two lines:

$epdlanguage_query = ep_4_query("SELECT languages_id, name FROM ".TABLE_LANGUAGES." WHERE code = '".DEFAULT_LANGUAGE."'");
if (($ep_uses_mysqli ? mysqli_num_rows($epdlanguage_query) : mysql_num_rows($epdlanguage_query))) {

[mc12345678]

Ami correct that the three lines read:

$epdlanguage_query = ep_4_query("SELECT languages_id, name FROM ".TABLE_LANGUAGES." WHERE code = '".DEFAULT_LANGUAGE."'");
$epdlanguage_query->store_result();
if (($ep_uses_mysqli ? mysqli_num_rows($epdlanguage_query) : mysql_num_rows($epdlanguage_query))) {

In that sequence?

Here's what I have found regarding the way this has gone. Prior to the use of mysqli_, it seems that although possible, not as frequent that the returned data would be unbuffered and therefore when a function such as num_rows was called, the value returned would either be 0 (unbuffered) or the number of rows that actually exist(ed). It appears that the two reported occurrences of this have been more of the result of the return of zero rows even though the data could be enumerated. I have two alternative tests I'm working on for you to try which may need to happen in the functions file or in the main base file. The above error list is similar to what I observed when updating EP4 to work under ZC 1.5.3. Though I want to be sure that the above code is in the correct sequence before continuing down that alternative path. Also, wanted to verify that the test(s) that were requested in the original notification of this problem were also run with equivalent results. (Ie, verification that performing the sql query in myphpadmin had a successful result.)

Some of the next "solution" is to identify in how many places the additional "correction" would be needed. I thought that the num_rows function was only used the one time and all other actions were based on straight forward pull and check type routines, not necessarily a "hey how many" type call.

[stellarweb]

Lines 171 to 180

$epdlanguage_query = ep_4_query("SELECT languages_id, name FROM ".TABLE_LANGUAGES." WHERE code = '".DEFAULT_LANGUAGE."'");
$epdlanguage_query->store_result();
if (($ep_uses_mysqli ? mysqli_num_rows($epdlanguage_query) : mysql_num_rows($epdlanguage_query))) {
$epdlanguage = ($ep_uses_mysqli ? mysqli_fetch_array($epdlanguage_query) : mysql_fetch_array($epdlanguage_query));
$epdlanguage_id = $epdlanguage['languages_id'];
$epdlanguage_name = $epdlanguage['name'];
} else {
//exit("EP4 FATAL ERROR: No default language set."); // this should never happen
exit("EP4 FATAL ERROR: No default language set. Table: ".TABLE_LANGUAGES." Code: ".DEFAULT_LANGUAGE." is set" ); // this should never happen
}

Ami correct that the three lines read:

$epdlanguage_query = ep_4_query("SELECT languages_id, name FROM ".TABLE_LANGUAGES." WHERE code = '".DEFAULT_LANGUAGE."'");
$epdlanguage_query->store_result();
if (($ep_uses_mysqli ? mysqli_num_rows($epdlanguage_query) : mysql_num_rows($epdlanguage_query))) {

In that sequence?

Here's what I have found regarding the way this has gone. Prior to the use of mysqli_, it seems that although possible, not as frequent that the returned data would be unbuffered and therefore when a function such as num_rows was called, the value returned would either be 0 (unbuffered) or the number of rows that actually exist(ed). It appears that the two reported occurrences of this have been more of the result of the return of zero rows even though the data could be enumerated. I have two alternative tests I'm working on for you to try which may need to happen in the functions file or in the main base file. The above error list is similar to what I observed when updating EP4 to work under ZC 1.5.3. Though I want to be sure that the above code is in the correct sequence before continuing down that alternative path. Also, wanted to verify that the test(s) that were requested in the original notification of this problem were also run with equivalent results. (Ie, verification that performing the sql query in myphpadmin had a successful result.)

Some of the next "solution" is to identify in how many places the additional "correction" would be needed. I thought that the num_rows function was only used the one time and all other actions were based on straight forward pull and check type routines, not necessarily a "hey how many" type call.