Jump to the post that solved this thread.
Solved: 1 Year, 3 Months, 1 Week ago Your database encoding is 'utf8', should be 'utf8mb4'. Please update your MyBB to use
#2
Solved: 1 Year, 3 Months, 1 Week ago
The only way is to access your database (console or phpMyAdmin) and run:
ALTER DATABASE databasename CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; (replace databasename with the name of your base)
And for each table in it: ALTER TABLE tablename CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

You can create a query to generate all the queries:
SELECT CONCAT('ALTER TABLE ', table_name, ' CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;') as qry FROM information_schema.tables WHERE table_schema = 'databasename';
[MyBB 1.8 mods] - Offer me a coffee
Do not ask me help through PM or Discord
Reply
Jump to the post that solved this thread.


Messages In This Thread
RE: Your database encoding is 'utf8', should be 'utf8mb4'. Please update your MyBB to use - by Crazycat - 2020-08-11, 06:24 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)