安装moodle时出错

Question

我在本地服务器上安装moodle时遇到错误。错误显示

Debug info: Table 'performance_schema.session_variables' doesn't exist
SHOW VARIABLES LIKE 'innodb_file_per_table'
[array (
)]
Error code: dmlreadexception

堆栈跟踪：

line 474 of /lib/dml/moodle_database.php: dml_read_exception thrown
line 1088 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
line 1527 of /lib/dml/moodle_database.php: call to mysqli_native_moodle_database->get_records_sql()
line 332 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->get_record_sql()
line 308 of /lib/ddl/mysql_sql_generator.php: call to mysqli_native_moodle_database->is_compressed_row_format_supported()
line 542 of /lib/ddl/database_manager.php: call to mysql_sql_generator->getAddFieldSQL()
line 74 of /mod/data/db/upgrade.php: call to database_manager->add_field()
line 726 of /lib/upgradelib.php: call to xmldb_data_upgrade()
line 432 of /lib/upgradelib.php: call to upgrade_plugins_modules()
line 1742 of /lib/upgradelib.php: call to upgrade_plugins()
line 677 of /admin/index.php: call to upgrade_noncore()

我使用的是php 7.02、mysql 5.7.19和moodle 3.0.10

Answer 1

打开mysql安装文件夹，然后进入bin文件夹，然后打开my.ini和

添加下面这一行

show_compatibility_56=ON