How to fix the issue: mobile smiles does not working issue

    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"

    Share
    100% users marked this FAQ as helpful. Is this FAQ helpful?

    Last update: 01/26/19 at 19:18 - Total 2 vote
    Yes No
Comments (3)
ketkew  
1. If you don't have a {PREFIX} you can remove {PREFIX}.

and

2. It is not app\Config.php but app/Config/config.php
Mark  
thanks for fixing the errors
A guide can be created on how to do it with snapshots
No login
Login or register to post your comment
Cookies on mooCommunity - Social Networking Script.
This site uses cookies to store your information on your computer.