mysql_full_unicode_support warning despite converted character set

Re: mysql_full_unicode_support warning despite converted character set

by Ken Task -
Number of replies: 2
Picture of Particularly helpful Moodlers

Congrats!   Yep ... editing wrong config.php file wouldn't do a thing for your issue.   But ... now I have to ask was the config.php file you were editing in moodle code else where?   And ... more importantly did you change back to it's orginal state?

In a 3.8.highest, there are the following config.php files:

[root@server moodle38]# find ./ -name config.php
./lib/editor/tinymce/plugins/spellchecker/config.php
./config.php
./mod/chat/gui_ajax/theme/bubble/config.php
./mod/chat/gui_ajax/theme/compact/config.php
./mod/chat/gui_ajax/theme/course_theme/config.php
./cache/classes/config.php
./theme/boost/config.php
./theme/classic/config.php

You might want to run same command in your code directory to re-call which config.php file you were editing! smile

'SoS', Ken


In reply to Ken Task

Re: mysql_full_unicode_support warning despite converted character set

by Paulo Renan Melo -

Thanks again. I was editing the ./moodledata/muc/config.php, which I already restored to its original state. All good there.

I'm kinda liking the cli tools. I knew a bit already of bash/batch in desktop, pretty handy to use now!

Just for the record, in case some newcomers like me have the same issues
After that win, I was able to login, but yet couldn't make a new user account.

So I activated debugging in the moodle admin, got the details which showed some error with collation, and then I solved it by opening ssh command-line on my server, and running the lines

cd public_html/mymoodlesitename/admin/cli

php mysql_collation.php --collation=utf8mb4_unicode_ci

as suggested in https://moodle.org/mod/forum/discuss.php?d=390351

in my case when I ran

php mysql_collation.php -l

I saw various different collations, and I set my config to use utf8mb4_unicode_ci, so applied that to the files too.

And now everything seems to work fine here.

Average of ratings: Useful (1)
In reply to Paulo Renan Melo

Re: mysql_full_unicode_support warning despite converted character set

by Ken Task -
Picture of Particularly helpful Moodlers

Great!  Problem solved!   Congrats!

'SoS', Ken