Update 2.1.4 LOOP ERROR

[rapalero]

Update 2.1.4 loop error.



To help, I tried to uninstall the only mod Simple Image Upload, but it also gives Loop Error.

Thanks.

[Doug Heffernan]

What version are you trying to upgrade from and how are you trying to do it? What is your php version?

[Kindred]

Per our lead developer,  it seems like this failure is indicative of a problem that literally prevents smf from completing the error report

Anything on the screen is a red herring, since you are seeing the error failure, not the triggering error itself

[rapalero]

What version are you trying to upgrade from and how are you trying to do it? What is your php version?

2.1.3

Package

PHP Version   7.4.33

[Sesquipedalian]

Could you please copy and paste the text of the error loop dump into your post (inside code BBC tags please) rather than as an image? That will make it a bit easier to read so that we can try to figure out where and why the error loop is being triggered.

[rapalero]

Could you please copy and paste the text of the error loop dump into your post (inside code BBC tags please) rather than as an image? That will make it a bit easier to read so that we can try to figure out where and why the error loop is being triggered.

Code Select Expand

array(14) {
[0]=> array(3) {
["file"]=> string(58) "/home/rapalean/public_html/foros/Sources/Subs-Db-mysql.php"
["line"]=> int(590)
["function"]=> string(9) "log_error"
}
[1]=> array(3) {
["file"]=> string(58) "/home/rapalean/public_html/foros/Sources/Subs-Db-mysql.php"
["line"]=> int(494)
["function"]=> string(12) "smf_db_error"
}
[2]=> array(3) {
["file"]=> string(51) "/home/rapalean/public_html/foros/Sources/Errors.php"
["line"]=> int(138)
["function"]=> string(12) "smf_db_query"
}
[3]=> array(3) {
["file"]=> string(51) "/home/rapalean/public_html/foros/Sources/Errors.php"
["line"]=> int(301)
["function"]=> string(9) "log_error"
}
[4]=> array(1) {
["function"]=> string(17) "smf_error_handler"
}
[5]=> array(3) {
["file"]=> string(58) "/home/rapalean/public_html/foros/Sources/Subs-Db-mysql.php"
["line"]=> int(1027)
["function"]=> string(22) "mysqli_stmt_bind_param"
}
[6]=> array(3) {
["file"]=> string(51) "/home/rapalean/public_html/foros/Sources/Errors.php"
["line"]=> int(129)
["function"]=> string(19) "smf_db_error_insert"
}
[7]=> array(3) {
["file"]=> string(58) "/home/rapalean/public_html/foros/Sources/Subs-Db-mysql.php"
["line"]=> int(590)
["function"]=> string(9) "log_error"
}
[8]=> array(3) {
["file"]=> string(58) "/home/rapalean/public_html/foros/Sources/Subs-Db-mysql.php"
["line"]=> int(494)
["function"]=> string(12) "smf_db_error"
}
[9]=> array(3) {
["file"]=> string(53) "/home/rapalean/public_html/foros/Sources/Packages.php"
["line"]=> int(928)
["function"]=> string(12) "smf_db_query"
}
[10]=> array(3) {
["file"]=> string(49) "/home/rapalean/public_html/foros/Sources/Subs.php"
["line"]=> int(6016)
["function"]=> string(14) "PackageInstall"
}
[11]=> array(3) {
["file"]=> string(53) "/home/rapalean/public_html/foros/Sources/Packages.php"
["line"]=> int(91)
["function"]=> string(11) "call_helper"
}
[12]=> array(3) {
["file"]=> string(50) "/home/rapalean/public_html/foros/Sources/Admin.php"
["line"]=> int(499)
["function"]=> string(8) "Packages"
}
[13]=> array(3) {
["file"]=> string(42) "/home/rapalean/public_html/foros/index.php"
["line"]=> int(191)
["function"]=> string(9) "AdminMain"
}
} Error loop.
array(5) {
[0]=> array(3) {
["file"]=> string(58) "/home/rapalean/public_html/foros/Sources/Subs-Db-mysql.php"
["line"]=> int(590)
["function"]=> string(9) "log_error"
}
[1]=> array(3) {
["file"]=> string(58) "/home/rapalean/public_html/foros/Sources/Subs-Db-mysql.php"
["line"]=> int(494)
["function"]=> string(12) "smf_db_error"
}
[2]=> array(3) {
["file"]=> string(58) "/home/rapalean/public_html/foros/Sources/Subs-Db-mysql.php"
["line"]=> int(802)
["function"]=> string(12) "smf_db_query"
}
[3]=> array(3) {
["file"]=> string(52) "/home/rapalean/public_html/foros/Sources/Session.php"
["line"]=> int(187)
["function"]=> string(13) "smf_db_insert"
}
[4]=> array(1) {
["function"]=> string(12) "sessionWrite"
}
} Error loop.


[Sesquipedalian]

Please post a copy of your Packages.php file. (You can find it at /home/rapalean/public_html/foros/Sources/Packages.php.) Never mind.

[Sesquipedalian]

To help with diagnosing the problem, please make the following temporary change in Subs-Db-mysql.php:

Code (Find) Select Expand

if ($ret === false && empty($db_values['db_error_skip']))
$ret = smf_db_error($db_string, $connection);


Code (Replace) Select Expand

if ($ret === false && empty($db_values['db_error_skip']))
{
var_dump($db_string);
die();
}

That won't fix anything, but it might give us a better clue about what is happening.

[rapalero]

To help with diagnosing the problem, please make the following temporary change in Subs-Db-mysql.php:

Code (Find) Select Expand

if ($ret === false && empty($db_values['db_error_skip']))
$ret = smf_db_error($db_string, $connection);


Code (Replace) Select Expand

if ($ret === false && empty($db_values['db_error_skip']))
{
var_dump($db_string);
die();
}

That won't fix anything, but it might give us a better clue about what is happening.

Thanks. Done

[rapalero]

New error

Code Select Expand

string(175) " SELECT version, themes_installed, db_changes FROM smf_log_packages WHERE package_id = 'smf:smf-2.1.4' AND install_state != 0 ORDER BY time_installed DESC LIMIT 1" string(1937) " REPLACE INTO smf_sessions(`session_id`, `data`, `last_update`) VALUES ('b71c985405ef8b3294234fd24fdb1a51', 'a:15:{s:13:\"session_value\";s:32:\"ca7b4910e4a9563919515572c5e394a3\";s:11:\"session_var\";s:8:\"e283aba9\";s:17:\"id_msg_last_visit\";s:6:\"269273\";s:2:\"mc\";a:7:{s:4:\"time\";i:1689508521;s:2:\"id\";i:2;s:2:\"gq\";s:3:\"1=1\";s:2:\"bq\";s:3:\"1=1\";s:2:\"ap\";a:1:{i:0;i:0;}s:2:\"mb\";a:0:{}s:2:\"mq\";s:3:\"0=1\";}s:2:\"rc\";a:4:{s:2:\"id\";i:2;s:4:\"time\";i:1689508521;s:7:\"reports\";s:1:\"0\";s:14:\"member_reports\";s:1:\"0\";}s:8:\"log_time\";i:1689525201;s:17:\"timeOnlineUpdated\";i:1689525201;s:15:\"unread_messages\";i:0;s:7:\"old_url\";s:111:\"https://www.rapaleando.com/foros/index.php?action=admin;area=packages;sa=install;package=smf_2-1-4_patch.tar.gz\";s:10:\"USER_AGENT\";s:101:\"Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36\";s:15:\"last_read_topic\";i:20761;s:5:\"forms\";a:1:{i:0;i:7035800;}s:5:\"token\";a:5:{s:16:\"post-admin-login\";a:4:{i:0;s:9:\"a9ac998dd\";i:1;s:32:\"ae7b3aa743c73ae88628c0dc9a374230\";i:2;i:1689521676;i:3;s:32:\"e917db74ff4aa14cf7d50ea5155498d9\";}s:15:\"post-admin-dbsc\";a:4:{i:0;s:11:\"ad3eca70cea\";i:1;s:32:\"5d908f695ca6d780d15fd1598342a8ac\";i:2;i:1689517710;i:3;s:32:\"303bbf2dab8a94ff8e4677ccac2efe0d\";}s:13:\"post-admin-mp\";a:4:{i:0;s:11:\"d29fbf461cd\";i:1;s:32:\"2007df7bf44e075a8e564b48034e142b\";i:2;i:1689509955;i:3;s:32:\"14f94d85f5d30e96577ed72143c69971\";}s:16:\"post-admin-maint\";a:4:{i:0;s:8:\"c029af05\";i:1;s:32:\"d003f604a3846546f95cc94327e39d19\";i:2;i:1689517674;i:3;s:32:\"9cd172e423bf171cbab4f7247b566809\";}s:14:\"post-admin-ssc\";a:4:{i:0;s:12:\"eb3ba2d603ad\";i:1;s:32:\"394a8c1cfbdf745b482a6126fc33fbf4\";i:2;i:1689517710;i:3;s:32:\"0053fd8b4d97801814f307cd9331394f\";}}s:10:\"admin_time\";i:1689521680;s:15:\"last_backup_for\";s:23:\"smf_2-1-4_patch.tar.gz$\";}', 1689525235)" string(44) " SELECT COUNT(*) FROM smf_log_errors"

[rapalero]

Up

[Kindred]

please note that this is not a "real time support" site.   We are all volunteers.

Please wait AT LEAST 24 hours before bumping a topic...

[rapalero]

please note that this is not a "real time support" site.   We are all volunteers.

Please wait AT LEAST 24 hours before bumping a topic...

My apologies.  I was unaware of that rule.  Thanks for the job.

[shawnb61]

Could we try this again? 

A little different...  Instead of:

Code Select Expand

if ($ret === false && empty($db_values['db_error_skip']))
{
var_dump($db_string);
die();
}
This time can we try:

Code Select Expand

if ($ret === false && empty($db_values['db_error_skip']))
{
var_dump($connection);
die();
}
I'm trying to get a clue as to the real underlying db error...

[rapalero]

Could we try this again? 

A little different...  Instead of:

Code Select Expand

if ($ret === false && empty($db_values['db_error_skip']))
{
var_dump($db_string);
die();
}
This time can we try:

Code Select Expand

if ($ret === false && empty($db_values['db_error_skip']))
{
var_dump($connection);
die();
}
I'm trying to get a clue as to the real underlying db error...

Thanks! Done.

Code Select Expand

object(mysqli)#1 (18) { ["affected_rows"]=> int(-1) ["client_info"]=> string(15) "10.6.11-MariaDB" ["client_version"]=> int(100611) ["connect_errno"]=> int(0) ["connect_error"]=> NULL ["errno"]=> int(2006) ["error"]=> string(20) "Server has gone away" ["error_list"]=> array(1) { [0]=> array(3) { ["errno"]=> int(2006) ["sqlstate"]=> string(5) "HY000" ["error"]=> string(20) "Server has gone away" } } ["field_count"]=> int(0) ["host_info"]=> string(25) "Localhost via UNIX socket" ["info"]=> NULL ["insert_id"]=> int(0) ["server_info"]=> string(23) "10.6.14-MariaDB-cll-lve" ["server_version"]=> int(100614) ["sqlstate"]=> string(5) "HY000" ["protocol_version"]=> int(10) ["thread_id"]=> int(4368163) ["warning_count"]=> int(0) } object(mysqli)#1 (18) { ["affected_rows"]=> int(-1) ["client_info"]=> string(15) "10.6.11-MariaDB" ["client_version"]=> int(100611) ["connect_errno"]=> int(0) ["connect_error"]=> NULL ["errno"]=> int(2006) ["error"]=> string(20) "Server has gone away" ["error_list"]=> array(1) { [0]=> array(3) { ["errno"]=> int(2006) ["sqlstate"]=> string(5) "HY000" ["error"]=> string(20) "Server has gone away" } } ["field_count"]=> int(0) ["host_info"]=> string(25) "Localhost via UNIX socket" ["info"]=> NULL ["insert_id"]=> int(0) ["server_info"]=> string(23) "10.6.14-MariaDB-cll-lve" ["server_version"]=> int(100614) ["sqlstate"]=> string(5) "HY000" ["protocol_version"]=> int(10) ["thread_id"]=> int(4368163) ["warning_count"]=> int(0) } object(mysqli)#1 (18) { ["affected_rows"]=> int(-1) ["client_info"]=> string(15) "10.6.11-MariaDB" ["client_version"]=> int(100611) ["connect_errno"]=> int(0) ["connect_error"]=> NULL ["errno"]=> int(2006) ["error"]=> string(20) "Server has gone away" ["error_list"]=> array(1) { [0]=> array(3) { ["errno"]=> int(2006) ["sqlstate"]=> string(5) "HY000" ["error"]=> string(20) "Server has gone away" } } ["field_count"]=> int(0) ["host_info"]=> string(25) "Localhost via UNIX socket" ["info"]=> NULL ["insert_id"]=> int(0) ["server_info"]=> string(23) "10.6.14-MariaDB-cll-lve" ["server_version"]=> int(100614) ["sqlstate"]=> string(5) "HY000" ["protocol_version"]=> int(10) ["thread_id"]=> int(4368163) ["warning_count"]=> int(0) }

[shawnb61]

So the DB error is "Server has gone away"...

That usually indicates a timeout.

It's doing a very simple query against smf_log_packages.

Can you browse the smf_log_packages table in phpmyadmin?

I would next try to repair the table.

[Aleksi "Lex" Kilpinen]

My experience would say that around 99% of the time, that error indicates a host issue of some sort.

[rapalero]

Thank you for your response.

I touched repair the board but the update does not work.

What should I complain to the hosting?

Regards.

[Aleksi "Lex" Kilpinen]

I can't really be completely sure if that's the case here, but the most common reason for the server has gone away errors is that the server timed out and closed the connection. It shouldn't really do that with simple queries like that if everything is working right. So what you can tell your host is that you seem to have connection issues with the database, and ask them if they can find an explanation to this.

[rapalero]

The hosting tells me:

after analyzing your case, we do not see any anomalies at the server level that could be affecting the reported behavior. Therefore, everything points to a web related issue.

We have detected that the following warnings are registered when performing the process, in case they could be useful for you:


PHP Warning:  mysqli_stmt_bind_param() expects parameter 1 to be mysqli_stmt, bool given in /home/rapalean/public_html/foros/Sources/Subs-Db-mysql.php on line 1030\n

PHP Warning:  mysqli_stmt_execute() expects parameter 1 to be mysqli_stmt, bool given in /home/rapalean/public_html/foros/Sources/Subs-Db-mysql.php on line 1031\n