eeldredge

Ah good call! There was indeed a cleanup task to convert the database to utf8mb4 which just ran successfully. Thanks for the help @Marc Stridgen!

Hey Marc, I just tried the "fix automatically" option and that worked - lucky break I guess! All set now. -Evan

Thanks @Marc Stridgen I have uploaded a new set of files and ran the upgrader from /admin/upgrade and I'm stuck on a different but similar error where I run the SQL commands manually and click "I have run..." but it's stuck on this screen: Running this as is gave me warnings about utf8 being depreciated and should use utf8mb4, so I tried changing the last statement to use uft8mb4 which then ran without warnings but still can't get past this screen. Here's the updated statement I ran without error: ALTER TABLE `ibf_forums_posts` CHANGE COLUMN `author_name` `author_name` VARCHAR (255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL , DROP INDEX `ip_address`, CHANGE COLUMN `ip_address` `ip_address` VARCHAR (46) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' , ADD KEY `ip_address` (`ip_address`), CHANGE COLUMN `post` `post` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL , CHANGE COLUMN `edit_name` `edit_name` VARCHAR (255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL , DROP INDEX `post_key`, CHANGE COLUMN `post_key` `post_key` VARCHAR (32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0' , ADD KEY `post_key` (`post_key`), CHANGE COLUMN `post_edit_reason` `post_edit_reason` VARCHAR (255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `post_field_t1` `post_field_t1` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL , CHANGE COLUMN `post_field_t2` `post_field_t2` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL ; Any other ideas? Thanks! -Evan

Hello @Marc Stridgen I'm currently running PHP 8.0, MySQL 8.0 and when attempting to upgrade my forum to 4.7.10, I get a similar error as described above, first hitting this message: When I click "Fix this" I get a giant list of SQL queries to run, which I did try to run in pieces manually in myPHP admin (the automatic fix didn't work). We tried upgrading the database tables from utf8 mb3 to mb4 which seemed to remove the warnings seen when trying to the run the scripts, but coming back to the upgrader we still hit this error. This is a self hosted forum. URL is https://forum.nhl94.com/ and the details should be stored in my client area info. Any ideas? Thanks, -Evan