Error on update from 2.0.19 to 2.1.4

[GhostRider2110]

First, thank you Kindred for getting me past V1 up to 2.0.19.  THANKS!!!!
AlmaLinux release 9.4
[stevenso@vps2 www]$ /usr/bin/php -v
PHP 8.0.30 (cli) (built: Aug  3 2023 17:13:08) ( NTS gcc x86_64 )
Copyright (c) The PHP Group
Zend Engine v4.0.30, Copyright (c) Zend Technologies
    with Zend OPcache v8.0.30, Copyright (c), by Zend Technologies
MariaDB 10.5.22

I started the move to 2.1.4, manual update.  After I got system up to 2.0.19, I was able to access, clean out out all the old Themes and mods. I backed things up at that point. Downloaded the 2.1.4 upgrade zip and started the upgrade.  It stopped at indicated below:

Code Select Expand

Converting table smf_moderator_groups to UTF-8... done.
Converting table smf_moderators to UTF-8... done.
Converting table smf_moonphase to UTF-8...PHP Fatal error:  Uncaught Error: Call to undefined function allowedTo() in /home/stevenso/public_html/Sources/Subs-Db-mysql.php:708
Stack trace:
#0 /home/stevenso/public_html/Sources/Subs-Db-mysql.php(494): smf_db_error()
#1 /home/stevenso/public_html/upgrade.php(3400): smf_db_query()
#2 /home/stevenso/public_html/upgrade.php(3790): ConvertUtf8()
#3 /home/stevenso/public_html/upgrade.php(357): serialize_to_json()
#4 {main}
  thrown in /home/stevenso/public_html/Sources/Subs-Db-mysql.php on line 708

The board does come up and I can log in with admin user, it's still in maintenance mode, but it is logging errors.  The DB does show 2.1.4 and shows 2.1.4.

Here are the errors being logged:

Code Select Expand

Type of error
Database
Error message
: Incorrect string value: '\xE0\xAE\x9A\xE0\xAE\xBF...' for column `stevenso_smf1`.`smf_settings`.`value` at row 1
File
/home/stevenso/public_html/Sources/Subs.php
Line
529
URL of page causing the error
http://www.stevensonclanonline.us/index.phphttp://www.stevensonclanonline.us/cron.php
Backtrace information
#0: smf_db_error()
Called from /home/stevenso/public_html/Sources/Subs-Db-mysql.php on line 494
#1: smf_db_query()
Called from /home/stevenso/public_html/Sources/Subs-Db-mysql.php on line 802
#2: smf_db_insert()
Called from /home/stevenso/public_html/Sources/Subs.php on line 529
#3: updateSettings()
Called from /home/stevenso/public_html/Sources/Subs.php on line 7484
#4: set_tld_regex()
Called from /home/stevenso/public_html/Sources/tasks/UpdateTldRegex.php on line 31
#5: execute()
Called from /home/stevenso/public_html/cron.php on line 249
#6: perform_task()
Called from /home/stevenso/public_html/cron.php on line 131
And

Code Select Expand

Type of error
Cron
Error message
2: Trying to access array offset on value of type null
File
/home/stevenso/public_html/Sources/Subs-Db-mysql.php
Line
590
URL of page causing the error
http://www.stevensonclanonline.us/index.phphttp://www.stevensonclanonline.us/cron.php
Backtrace information
#0: smf_error_handler_cron()
Called from /home/stevenso/public_html/Sources/Subs-Db-mysql.php on line 590
#1: smf_db_error()
Called from /home/stevenso/public_html/Sources/Subs-Db-mysql.php on line 494
#2: smf_db_query()
Called from /home/stevenso/public_html/Sources/Subs-Db-mysql.php on line 802
#3: smf_db_insert()
Called from /home/stevenso/public_html/Sources/Subs.php on line 529
#4: updateSettings()
Called from /home/stevenso/public_html/Sources/Subs.php on line 7484
#5: set_tld_regex()
Called from /home/stevenso/public_html/Sources/tasks/UpdateTldRegex.php on line 31
#6: execute()
Called from /home/stevenso/public_html/cron.php on line 249
#7: perform_task()
Called from /home/stevenso/public_html/cron.php on line 131
Since the upgrade didn't complete I am guessing these are related to that. 

Any help would be greatly appreciated.

I have tried this a couple times.  Starting from restoring things back to the 2.0.19 backup.

Thanks
Mitch

[GhostRider2110]

Well, after doing several searches... I made this post.. then did a few more and found a post that seemed to be like what I was experiencing. I made managed to change the collation set to utf8_general_ci and that seemed to quell the errors spamming the error log.  But the php.log is still giving an error:

Code Select Expand

[11-Jun-2024 22:04:56 UTC] PHP Warning:  Trying to access array offset on value of type null in /home/stevenso/public_html/Sources/Load.php on line 105
[11-Jun-2024 22:05:10 UTC] PHP Warning:  Trying to access array offset on value of type null in /home/stevenso/public_html/Sources/Load.php on line 105
[11-Jun-2024 22:05:10 UTC] PHP Warning:  Trying to access array offset on value of type null in /home/stevenso/public_html/Sources/Load.php on line 105
[11-Jun-2024 22:05:10 UTC] PHP Warning:  Trying to access array offset on value of type null in /home/stevenso/public_html/Sources/Load.php on line 105
I'm still kinda worried about the upgrade script not completing so not sure what might pop up on me.  Should I try to run it again since the collation set fix? 

Thanks
Mitch

[Kindred]

Please finish running the upgrade

[GhostRider2110]

Exited in the same place:

Code Select Expand

Converting table smf_moonphase to UTF-8...PHP Fatal error:  Uncaught Error: Call to undefined function allowedTo() in /home/stevenso/public_html/Sources/Subs-Db-mysql.php:708
Stack trace:
#0 /home/stevenso/public_html/Sources/Subs-Db-mysql.php(494): smf_db_error()
#1 /home/stevenso/public_html/upgrade.php(3400): smf_db_query()
#2 /home/stevenso/public_html/upgrade.php(3526): ConvertUtf8()
#3 /home/stevenso/public_html/upgrade.php(357): serialize_to_json()
#4 {main}
  thrown in /home/stevenso/public_html/Sources/Subs-Db-mysql.php on line 708

[Kindred]

That is a very odd error...

[Doug Heffernan]

Converting table smf_moonphase to UTF-8

That table is not part of the default smf a.f.a.i.k. It must have either been added by a third party mod or is part of the Smf 1.1.x branch. You can drop it from the database, but first back it up for just in case, and give the upgrade another ago.

[GhostRider2110]

Thanks Doug,

That did the trick.  From what I remember the only calendar mod I had was repeating-event mod. Maybe that was it..

Now I just have to find something to get my images back available.  Had use SMG for that. But I see that is no longer available. Anyone have a suggestion for something I can use? And hopefully be able to import/move my images into.  The mgal_data directory is there and the DB tables are also still there.

Thanks
Mitch

(And this is the easy one LOL)

[Steve]

Status?

[GhostRider2110]

Sorry, board is up and running but still no replacement for SMG.  Also still trying to work out email issues since hosting provider does not allow outbound port 25. 

Thanks
Mitch