The Elearning Community

Hello everyone !

Once I installed formaLMS 3.3.17 with php, I started by registering a course, but, I can't register courses, I get the following error.

"Error while processing the requested operation"



in php_errors.log I have:

================================
thrown in /home/paco/www/formalms/db/drivers/docebodb.mysqli.php on line 127
[29-Mar-2024 08:35:17 America/Mexico_City] PHP Fatal error: Uncaught mysqli_sql_exception: Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER' in /home/paco/www/formalms/db/drivers/docebodb.mysqli.php:127
Stack trace:
#0 /home/paco/www/formalms/db/drivers/docebodb.mysqli.php(127): mysqli_query()
#1 /home/paco/www/formalms/db/drivers/docebodb.mysqli.php(83): mysqli_DbConn->query()
#2 /home/paco/www/formalms/db/drivers/docebodb.mysqli.php(62): mysqli_DbConn->select_db()
#3 /home/paco/www/formalms/db/lib.docebodb.php(83): mysqli_DbConn->connect()
#4 /home/paco/www/formalms/lib/lib.utils.php(280): DbConn::getInstance()
#5 /home/paco/www/formalms/lib/lib.bootstrap.php(352): Util::load_setting()
#6 /home/paco/www/formalms/lib/lib.bootstrap.php(93): Boot::loadSetting()
#7 /home/paco/www/formalms/index.php(35): Boot::init()
=============================



Thanks for the answers.

Search the forum. You will find tons if topics regarding sql_mode directive

The error is due to the fact that in the instance I have mysql version 8.1, and:

NO_AUTO_CREATE_USER has been deprecated and removed from MySQL 8 and is no longer available. It was considered an unsafe setting.

So you can solve, can't you?