MAKE CHANGE FOLLOW THE BELOW STEPS MAY CRASH DATABASE, PLEASE BACKUP YOUR DATABASE FIRST. IF YOU'RE NOT SURE HOW TO DO, PLEASE CONTACT US.
1. Full backup database first. IT'S VERY IMPORTANCE
2. Please run the following queries to update database structure:
ALTER TABLE `activities` CHANGE `content` `content` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
ALTER TABLE `{PREFIX}activity_comments` CHANGE `comment` `comment` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
ALTER TABLE `{PREFIX}comments` CHANGE `message` `message` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
ALTER TABLE `{PREFIX}conversations` CHANGE `message` `message` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
ALTER TABLE `{PREFIX}comment_histories` CHANGE `content` `content` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
Importance: if you you have database prefix, please replace {PREFIX} with your own prefix. If you don't have a {PREFIX} you can remove {PREFIX}.
Ex: your database Prefix is: "Travel_" -> please replace the {PREFIX} with Travel_. The query after replaced the Prefix will look like this:
ALTER TABLE `Travel_comment_histories` CHANGE `content` `content` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
3. Go to ...app/Config/config.php and make the following change
change "encoding" => "utf8" to "encoding" => "utf8mb4"
and
2. It is not app\Config.php but app/Config/config.php