本帖最后由 maid 于 2012-9-21 10:05 编辑
错误内容如下：[code]Debug info: Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.
INSERT INTO mdl_message_providers (name,component,capability) VALUES(?,?,?)
[array (
0 => ‘assign_notification’,
1 => ‘mod_assign’,
2 => NULL,
)]
Error code: dmlwriteexception
Stack trace:
line 410 of \lib\dml\moodle_database.php: dml_write_exception thrown
line 948 of \lib\dml\mysqli_native_moodle_database.php: call to moodle_database->query_end()
line 990 of \lib\dml\mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->insert_record_raw()
line 250 of \lib\messagelib.php: call to mysqli_native_moodle_database->insert_record()
line 614 of \lib\upgradelib.php: call to message_update_providers()
line 358 of \lib\upgradelib.php: call to upgrade_plugins_modules()
line 1524 of \lib\upgradelib.php: call to upgrade_plugins()
line 329 of \admin\index.php: call to upgrade_noncore()
Fatal error: Uncaught exception ‘dml_write_exception’ with message ‘Error writing to database’ in E:\works\htdocs\vhosts\demo.ossez.com\httpdocs\p\moodle\lib\dml\moodle_database.php:410 Stack trace: #0 E:\works\htdocs\vhosts\demo.ossez.com\httpdocs\p\moodle\lib\dml\mysqli_native_moodle_database.php(1151): moodle_database->query_end(false) #1 E:\works\htdocs\vhosts\demo.ossez.com\httpdocs\p\moodle\lib\dml\moodle_database.php(1651): mysqli_native_moodle_database->delete_records_select(‘config’, ‘name = ?’, Array) #2 E:\works\htdocs\vhosts\demo.ossez.com\httpdocs\p\moodle\lib\moodlelib.php(1397): moodle_database->delete_records(‘config’, Array) #3 E:\works\htdocs\vhosts\demo.ossez.com\httpdocs\p\moodle\lib\upgradelib.php(1259): unset_config(‘upgraderunning’) #4 E:\works\htdocs\vhosts\demo.ossez.com\httpdocs\p\moodle\lib\upgradelib.php(1244): upgrade_finished() #5 [internal function]: upgrade_finished_handler() #6 {main} thrown in E:\works\htdocs\vhosts\demo.ossez.com\httpdocs\p\moodle\lib\dml\moodle_database.php on line 410[/code]
在 Mysql 下面执行下面的命令：mysql> SET SESSION binlog_format = 'ROW';
mysql> SET GLOBAL binlog_format = 'ROW';就可以解决问题了。