我们已经将moodle网站从inmotion主机迁移到EC2上安装的新cPanel/WHM。我们的数据库版本是Mariadb 10.2，PHP 7.2(和以前一样(。但在创建新用户时，无法写入数据库，出现dmlwriteexception错误：
Debug info: FUNCTION db.CAP_FIRST does not exist
INSERT INTO mdl_user (username,auth,suspended,firstname,lastname,email,maildisplay,city,country,timezone,theme,imagealt,firstnamephonetic,lastnamephonetic,middlename,alternatename,url,icq,skype,aim,yahoo,msn,idnumber,institution,department,phone1,phone2,address,timemodified,description,descriptionformat,mnethostid,confirmed,timecreated,password,calendartype,mailformat,maildigest,autosubscribe,trackforums,lang) VALUES(
)
Error code: dmlwriteexception
Stack trace:
line 489 of /lib/dml/moodle_database.php: dml_write_exception thrown
line 1300 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
line 1346 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->insert_record_raw()
line 107 of /user/lib.php: call to mysqli_native_moodle_database->insert_record()
line 188 of /user/editadvanced.php: call to user_create_user()
以前有人有这个问题吗？
这是升级moodle站点时的常见问题，请将dbcollocation更改为'utf8_general_ci'