MySQL error 1231 'sql_mode' 'NO_AUTO_CREATE_USER'

Question

Dear OCS Team,

I upgraded my OCS Server from Ubuntu 18.04 to 20.04 during the last week and got the following error while trying to update the OCS server and report installed on that server : "ERROR: MySql connection problem 1231 Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'".

It looks and MySQL issue, but no issue with other software using the same server's DB.

The computer's client software doesn't seems to have issues to access the server's DB too ...

Any ideas regarding that issue ?

Many thanks in advance,

Best regards,

Jean

Answer 1

¿Are you using MariaDB or MySQL (Oracle's)? Please also add the version.

According to  MySQL Documentation this mode was added on version 5.7.7. You should also check the Create Users you might have

Answer 2

Hi Jean,

I had this same error and I found that variable sql_mode being set to "NO_AUTO_CREATE_USER" in 5 different .php files within the OCS software.
It was set in all the following;

./install.php
./backend/require/connexion.php
./plugins/main_sections/ms_server_infos/ms_server_infos.php
./require/function_commun.php
./require/html_header.php

I removed it from all of those and the webpage starting working and connected to MySql as expected.

Duncan