XF 2.2 Can't convert tables to utf8mb4 after upgrading to 2.2.17

I'm doing a test upgrade from 1.5 to 2.2.17. Everything seemed to go fine, but I noticed emojis aren't working even though I added $config['fullUnicode'] = true; to src/config.php during the upgrade.

When I run php cmd.php xf:convert-utf8mb4 it comes back with No convertable tables found. No action required. (Guessing it did this the first time as well and I just didn't notice.) In the admin panel it is not showing any errors about full unicode support.

I checked the database and none of the tables have been converted. Most of them are still utf8mb3, but some are latin1, which seems to be because the database defaults were set to latin1/latin_swedish_ci.

1763197005041.webp

This is a 15 year old DB that was running on a server that recently upgraded from MySQL 5.7 to 8.0. Currently running MySQL 8.0/PHP 8.2 on this test environment. (PHP 7.2 was used for the upgrade from 1.5.)

1763197906638.webp

I changed the DB defaults to utf8mb4/utf8mb4_general_ci in the mysql console, then restarted mysql and nginx, but the convert command still says no convertable tables found. Is there something I can do to fix this?
 
Back
Top Bottom