Update 2.1.4 LOOP ERROR

[shawnb61]

Yeah, that's not helpful, as the reason there is a null parameter is it couldn't connect, as mysql "went away"...

I believe these two issues are dupes, which is interesting.
https://www.simplemachines.org/community/index.php?topic=586522.0
https://www.simplemachines.org/community/index.php?topic=586471.0

How many rows are in your smf_log_packages table?
What mod were you trying to install?
What mods were already installed?
What theme were you using at the time?
If you use the default theme, does it still fail?

[rapalero]

Hello.

I attach the table you are talking about.

There are only packages: SMF 2.1.4 Update, SMF 2.1.3 Update, Simple Image Upload

The theme is: SMF Default Theme - Curve2

Thank you.

[shawnb61]

You were running this mod: https://custom.simplemachines.org/index.php?mod=1669

In SMF 2.1?

[rapalero]

You were running this mod: https://custom.simplemachines.org/index.php?mod=1669

In SMF 2.1?

Yes, it's the only mod I have since the forum is about fishing and if users don't have something like that they don't upload images.

[rapalero]

Up

[Oldiesmann]

That particular mod isn't even compatible with 2.1.

[shawnb61]

Looking at the installed mod list, they didn't install the mod from the cust site, but the one over on the imgbb site.  (Per this discussion: https://www.simplemachines.org/community/index.php?msg=4145106)

I've installed that one & it's quite minimal & simple and installs OK.  And it has the same name as the one installed here.

We've been looking at an almost identical problem over here: https://www.simplemachines.org/community/index.php?topic=586522.0

I'd say we do the same activities here.  Let's start by looking closely at the DB.  Please try the following steps:

...the next thing I would do is some routine maintenance:
- Run the Optimize all tables function under Forum Maintenance.  If there is a DB issue with one or more tables, this will error out.  This would be good to know...
- Run the Find & Repair Any Errors under Forum Maintenance.  Shouldn't hurt...

Another thing I would do if I were in your place is confirm the DB matches desired DB.  I have a utility that will help with this:
https://raw.githubusercontent.com/sbulen/sjrbTools/master/smf_db_compare.php

Right-click & download that utility.  Copy it to your forum root, then run it from your browser.

If there is anything missing from your DB, it will be highlighted in RED.  Let us know about those.

If there are columns/tables added (via mods or manually), they will be highlighted in GREEN.  You want to make sure these make sense & you know why they were added.

Ignore anything highlighted in yellow for now.

But raise any items in red here for us to look at.

Hope this helps,

If looking into the DB doesn't work, we will try loading a fresh set of files next.

[rapalero]

Looking at the installed mod list, they didn't install the mod from the cust site, but the one over on the imgbb site.  (Per this discussion: https://www.simplemachines.org/community/index.php?msg=4145106)

I've installed that one & it's quite minimal & simple and installs OK.  And it has the same name as the one installed here.

We've been looking at an almost identical problem over here: https://www.simplemachines.org/community/index.php?topic=586522.0

I'd say we do the same activities here.  Let's start by looking closely at the DB.  Please try the following steps:

...the next thing I would do is some routine maintenance:
- Run the Optimize all tables function under Forum Maintenance.  If there is a DB issue with one or more tables, this will error out.  This would be good to know...
- Run the Find & Repair Any Errors under Forum Maintenance.  Shouldn't hurt...

Another thing I would do if I were in your place is confirm the DB matches desired DB.  I have a utility that will help with this:
https://raw.githubusercontent.com/sbulen/sjrbTools/master/smf_db_compare.php

Right-click & download that utility.  Copy it to your forum root, then run it from your browser.

If there is anything missing from your DB, it will be highlighted in RED.  Let us know about those.

If there are columns/tables added (via mods or manually), they will be highlighted in GREEN.  You want to make sure these make sense & you know why they were added.

Ignore anything highlighted in yellow for now.

But raise any items in red here for us to look at.

Hope this helps,

If looking into the DB doesn't work, we will try loading a fresh set of files next.

Thanks. Red:

https://ibb.co/HHVnyZC

https://ibb.co/f9GBpSx

https://ibb.co/0qmVFNs

[shawnb61]

You are missing one index, but I don't think that is the real issue here.

To address the missing index, you can add it using this SQL in the SQL tab of phpmyadmin:

Code Select Expand

ALTER TABLE smf_members ADD INDEX idx_active_real_name (is_activated, real_name);

Something is causing your database to run away, and we still don't know the root cause.  There are two things I'd like to look at next:
(1) Do you have the mysql log entries?  Normally the only entries in the mysql log are startup/shutdown, but in the event of something deeper, errors may be logged here.
(2) Let's turn on SMF's mysql debug mode...  Place the following in your Settings.php file, near the other $db settings:

Code Select Expand

$db_show_debug = true;
After turning debug mode, attempt one of the actions that is failing.  Then, let's look at the queries that were executing.

[-Rock Lee-]

@shawnb61 Look https://www.simplemachines.org/community/index.php?msg=4121949 some mods produce that error, I don't know why... I think it doesn't manage to analyze it well.


Regards!

[shawnb61]

@shawnb61 Look https://www.simplemachines.org/community/index.php?msg=4121949 some mods produce that error, I don't know why... I think it doesn't manage to analyze it well.

Thanks @-Rock Lee- !

Based on Rock Lee's note above, the next thing I'd suggest is disabling *both* of the backup options under Package Manger | Options.

Then try installing the mod again.

[shawnb61]

I wanted to followup on this, to share what I have found, in case we see this again.

Based on @-Rock Lee- 's input above, I was able to reproduce the issue.  Steps:
 - Select both backup options under Package Manager | Options
 - Put a bunch of huge files under /Sources & /Themes - I put a few GB of backups there.  (Not too much or it will blow up on memory allocation...  Just enough to slow it down...)
 - Set the MySQL wait_timeout to a low value, e.g., 60 sec

Similar stack trace & errors.

So what I think is happening is that it takes so long to do the backup, MySQL goes away.  When the process resumes, it tries to make DB updates, which fail, since the DB is gone.  Then it tries to log the error, which also fails, since the DB is gone.  Rinse & repeat.

Note these issues will repeat until /Sources & /Themes are cleaned up, or, the backup option is disabled. 

I.e., you can refresh files, uninstall mods, revert package updates, etc., all you want, and the behavior won't change, as seen above...

If we see this again, I'd like to know:
 - Which backup options were selected?
 - Does disabling backups fix the issue?
 - How big are the latest backups under /Packages/backups?
 - Are there large files in /Sources & /Themes?  What & why?
 - What is the value of MySQL's wait_timeout?

[-Rock Lee-]

@shawnb61 The backup options at least in my case was 2.0.x by default from when I installed it. Only when going to 2.1 through the upgrade did it happen and when deactivating it I was able to install everything normal (only about 7/8 mods).

It wasn't very big, a few kb, although before passing on I had removed things I saw too much (a quick cleaning) and nothing apart from the normal files together with personalized images but at most 800kb. As for the time, it is the default unless my provider lowered it to 30 (tomorrow I confirmed it to you on my computer).