Issue upgrding 2.0.19 to 2.1.4

[rickmastfan67]

Just was trying to upgrade our forum from 2.0.19 to 2.1.4 tonight, and I keep running into an issue.  It seems to keep timing out on "Executing: "Messenger fields" (21 of 71)", and I'm not sure what the issue could be here.

If I remember correctly, we're on PHP 8.1.  Should try to downgrade the PHP (they auto updated us recently), if the server provider will let us?

I've tried restarting after 30m 3 times, and just can't get past Step 21.

Any ideas what the issue possibly could be?

Code Select Expand

Updating old values...done
Changing default values...done
Removing all karma data, if selected...done
Emptying error log, if selected...done
Adding login history...done
Copying the current package backup setting...done
Copying the current "allow users to disable word censor" setting...done
Converting collapsed categories...done
Parsing board descriptions and names...done
Dropping "collapsed_categories"...done
Adding new "topic_move_any" setting...done
Adding new "enable_ajax_alerts" setting...done
Adding new "alerts_auto_purge" setting...done
Adding new "minimize_files" setting...done
Collapse object...done
Adding new "DEFAULTMaxListItems" setting...done
Adding new "loginHistoryDays" setting...done
Enable some settings we ripped from Theme settings...done
Adding new "httponlyCookies" setting...done
Adding new "samesiteCookies" setting...done
Disable Moderation Center Security if it doesn't exist...done
Disable Moderation Center Security if it doesn't exist...done
Adding new profile data export settings...done
Adding settings for marking boards as read...done
Adding more space to the mime_type column...done
Converting legacy attachments...done
Note attachment conversion complete...done
Fixing invalid sizes on attachments...done
Fixing attachment directory setting...done
Adding new columns to log_group_requests...done
Adjusting the indexes for log_group_requests...done
Adding support for tag in package manager...done
Adding support for package hashes...done
Adding support for validation servers...done
Add Package Validation to Downloads Site...done
Ensure The Simple Machines Customize Site is https...done
Add validation to Simple Machines Customize Site...done
Altering the session_id columns...done
Adding new columns to topics ...done
Adding a new column "callable" to scheduled_tasks table...done
Adding new scheduled tasks...done
Adding a new task-related setting...done
Remove old tasks added by modifications...done
Adding the new table...done
Adding new columns to boards...done
Adding the boardindex_max_depth setting...done
Removing manage_boards permission...done
Adding new columns to categories...done
Adding the count to the members table...done
Adding the new table for alerts...done
Adding alert preferences...done
Upgrading post notification settings...done
Dropping old notification fields from the members table...done
Upgrading auto notify setting...done
Dropping old auto notify settings from the themes table...done
Creating alert prefs for watched topics...done
Creating alert prefs for watched boards...done
Updating obsolete alerts from before RC3...done
Adding new column to log_topics...done
Fixing column name change...done
Altering mil_queue table...done
Altering the membergroup stars to icons...done
Renaming default theme...done
Fader time update...done
Adding the enableThemes setting...done
Setting "default" as the default...done
Check the current saved names for icons and change them to the new name...done
Clean up settings for unused themes...done
Adding new field_order column...done
Adding new show_mlist column...done
Any help is appreciated.  Thanks.

EDIT: Hmmm, I just randomly decided to just log back into the updater, and found out that the %'s in the image below actually went up after about 60m.  So, maybe it's insanely slow for some odd reason.  Still not going to mark this as solved right now just in case.

[Oldiesmann]

How large is the forum you're trying to upgrade? There were several database changes in 2.1 - especially with everything being converted to UTF-8 (MySQL didn't have great support for that when 2.0 was released, but does now), and many of the profile fields were converted to custom profile fields instead to make things more flexible. If it's a large forum it could take a while to convert everything.

[Aleksi "Lex" Kilpinen]

Yeah, if it the percentage is rising, it is still actually working - Allowing it time may get it to run all the way through even if it's slow. I've had upgrades in the past that literally took all night to run while I slept. Shouldn't happen, but some bad luck and a suitably large database and it may.

[Doug Heffernan]

If you have a large forum and the upgrade is going very slowly you can also try to upgrade your forum using the Command Line Interface (CLI).

Have a look at the last section at the below wiki.

https://wiki.simplemachines.org/smf/Upgrading

[Deaks]

did you empty your logs first?

[rickmastfan67]

did you empty your logs first?

Yes.

Yeah, if it the percentage is rising, it is still actually working - Allowing it time may get it to run all the way through even if it's slow. I've had upgrades in the past that literally took all night to run while I slept. Shouldn't happen, but some bad luck and a suitably large database and it may.

It only progressed after I restarted at the point I left off.  Didn't progress any farther however sadly. Just stayed 'hanged' @ 29%(top)/30.7%(bottom), even after letting go for over 3h+.

How large is the forum you're trying to upgrade? There were several database changes in 2.1 - especially with everything being converted to UTF-8 (MySQL didn't have great support for that when 2.0 was released, but does now), and many of the profile fields were converted to custom profile fields instead to make things more flexible. If it's a large forum it could take a while to convert everything.

Huge sadly.  It's been running since 2012.

If the upgrade could be hanging on the 'Messenger Fields', what might that database ID be (beyond the base id of the database)?  Would it be safe to 'destroy' it to see if we can get past it?  If this is what I think it is, it's just stuff like the old AIM info, right?

[rickmastfan67]

If you have a large forum and the upgrade is going very slowly you can also try to upgrade your forum using the Command Line Interface (CLI).

Have a look at the last section at the below wiki.

https://wiki.simplemachines.org/smf/Upgrading

Just tried that.

However, every time I enter the 'php upgrade.php' command in Putty, I get the following response:
"Content-type: text/html"

No idea why that's happening.