我在本地服务器上安装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
打开您的MySQL安装文件夹，然后转到bin文件夹，然后打开my.ini和
添加以下行
show_compatibility_56=ON