mahara-contributors team mailing list archive

Thread
Date

[Bug 2003190] Re: Not able to change Mahara collation from utf8_bin to utf8mb4_unicode_ci

To: mahara-contributors@xxxxxxxxxxxxxxxxxxx
From: Kristina Hoeppner <2003190@xxxxxxxxxxxxxxxxxx>
Date: Thu, 26 Jan 2023 07:25:57 -0000
Reply-to: Bug 2003190 <2003190@xxxxxxxxxxxxxxxxxx>
Sender: noreply@xxxxxxxxxxxxx

** Changed in: mahara
       Status: Incomplete => Invalid

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: mahara-contributors
https://bugs.launchpad.net/bugs/2003190

Title:
  Not able to change Mahara collation from utf8_bin to
  utf8mb4_unicode_ci

Status in Mahara:
  Invalid

Bug description:
  I am using Mahara version 22.04, Mahara recommending to change its DB collation.
  Mysql version - 5.7
  PHP version - 7.4

  Using PHPMyAdmin & manually, through the notepad editor(manually
  replacing) both methods are not working.

  Please suggest how can I change it from utf8_bin to
  utf8mb4_unicode_ci.

  - Using PHPMyAdmin
  It is not working to change the collation for MySQL table columns.

  - Using editor
  During DB import it shows multiple errors.
  like - Foreign Key constraint errors and more

  Please suggest

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/2003190/+subscriptions