XML-RPC Error (95042507): Error reading from database | ERRO

Hello,
I have the same problem (XML-RPC Error (95042507): Erreur de lecture de la base de données | ERRORCODE: dmlreadexception)
and impossible to enter moodle to unlock the debug. An idea ?
I said that it came since the update I made for joomla, moodle, joodle.
Everything is normally up to date !
thank you so much

I managed a debugg with the following codes in the config file:
$ CFG-> debug = 32767;
$ CFG-> debugdisplay = 1;

it gave me:
##XML-RPC Error (95042507): Error reading the database (COLLATION 'utf8_bin' is not valid for CHARACTER SET 'utf8mb4' SELECT * FROM mdl_user WHERE LOWER (username) COLLATE utf8_bin = LOWER (?) AND deleted <> 1 AND mnethostid [Array (0 => 'manager74', 1 => '1',)]) | DEBUG INFO: COLLATION 'utf8_bin' is not valid for CHARACTER SET 'utf8mb4' SELECT * FROM mdl_user WHERE LOWER (username) COLLATE utf8_bin = LOWER (?) AND deleted <> 1 AND mnethostid [array (0 => 'manager74', 1 => '1',)] | ERRORCODE: dmlreadexception

what is crazy is that the whole table is in 'utf8mb4' and some fields are in 'utf8_bin' and I can not change them.

Thanks for your help

Hi.

> and impossible to enter moodle to unlock the debug. An idea ?

Why can't you log in to Moodle? Don't you have a Moodle-only admin account? Or that does not work either?


I don't know where those errors are coming from,or if they are even related to Joomdle.
Do you get that error when you try to log in?