I recently upgraded one of our Moodle environments from 2.9.6 to 3.3.3, and with that, wanted to convert our MariaDB database (v 10.2.10) from utf8 to utf8mb4, since I saw a warning on the Server > Environment page.
I looked at the Moodle Docs for more information about this, and found that there are two separate pages that appear to have duplicate procedures. They are:
I ran into trouble because of these separate procedures, since the 2nd procedure specifically says that you should add
to the my.cnf file, but the 1st procedure does not include that line. Once we added that line, everything worked fine.
We also experienced a separate error because of the 1st procedure, since it says you should add
to my.cnf, but these options are were apparently deprecated in MySQL 5.1 and removed in 5.5. For more information, read these bug reports and discussions. Once we removed those lines, the error went away.
I admit that I am a mere noob when it comes to these technical details about databases, collations, character sets, etc. (our fantastic IT department helps us manage these aspects), but still I wonder - are these Moodle Docs pages about the same thing? Could they be merged? Of course I could edit the wiki pages or write in the page comments, but given my lack of expertise, I fear I would do more harm than good, and wanted to share this with some expert eyes.