Categories

    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)

No login