Public bug reported: Mahara Version: 20.10.0 Operating System: Ubuntu 18.04.5 LTS Database: MySQL 5.7
After upgrading from Mahara version 18.04 to 20.10 we ran into a small problem regarding Emojis. Emoji's in Messages, Blogposts and Forums turned into '?' Using the steps from https://bugs.launchpad.net/mahara/20.10/+bug/1895259 we went into the Mahara Database and did the following: For Blogs and Forum posts: ALTER TABLE interaction_forum_post CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ALTER TABLE artefact_blog_blogpost CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ALTER TABLE artefact default charset=utf8mb4 collate=utf8mb4_unicode_ci; ALTER TABLE artefact modify column description text character set utf8mb4 collate utf8mb4_unicode_ci null; For Messages: ALTER TABLE maharadb.notification_internal_activity DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; ALTER TABLE maharadb.notification_internal_activity MODIFY COLUMN message text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL; This solved our problem Regards, Philippe and Jochen ** Affects: mahara Importance: Undecided Status: New -- You received this bug notification because you are a member of Mahara Contributors, which is subscribed to Mahara. Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it! https://bugs.launchpad.net/bugs/1912492 Title: Unable to see Emojis in Blogposts, Forums and Messages Status in Mahara: New Bug description: Mahara Version: 20.10.0 Operating System: Ubuntu 18.04.5 LTS Database: MySQL 5.7 After upgrading from Mahara version 18.04 to 20.10 we ran into a small problem regarding Emojis. Emoji's in Messages, Blogposts and Forums turned into '?' Using the steps from https://bugs.launchpad.net/mahara/20.10/+bug/1895259 we went into the Mahara Database and did the following: For Blogs and Forum posts: ALTER TABLE interaction_forum_post CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ALTER TABLE artefact_blog_blogpost CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ALTER TABLE artefact default charset=utf8mb4 collate=utf8mb4_unicode_ci; ALTER TABLE artefact modify column description text character set utf8mb4 collate utf8mb4_unicode_ci null; For Messages: ALTER TABLE maharadb.notification_internal_activity DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; ALTER TABLE maharadb.notification_internal_activity MODIFY COLUMN message text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL; This solved our problem Regards, Philippe and Jochen To manage notifications about this bug go to: https://bugs.launchpad.net/mahara/+bug/1912492/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~mahara-contributors Post to : mahara-contributors@lists.launchpad.net Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp