mahara-contributors team mailing list archive

[Kristina Hoeppner <1912492@xxxxxxxxxxxxxxxxxx>]

** Changed in: mahara
       Status: New => Confirmed

** Changed in: mahara
   Importance: Undecided => Low

** Tags added: bite-sized

** Changed in: mahara
     Assignee: (unassigned) => Gold (gold.catalyst)

-- 
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:
  Confirmed

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