Moodle Install Failed

[glennda]

trying to installing moodle 2.1 (and also 2.2) but neither seem to be able to complete properly.

 

Error writing to database

 

More information about this error

 

It is usually not possible to recover from errors triggered during installation, you may need to create a new database or use a different database prefix if you want to retry the installation.

 

Debug info: Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'

INSERT INTO mdl_message_providers (name,component,capability) VALUES(?,?,?)

[array (

0 => 'notices',

1 => 'moodle',

2 => 'moodle/site:config',

)]

Stack trace:

line 397 of /lib/dml/moodle_database.php: dml_write_exception thrown

line 893 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()

line 935 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->insert_record_raw()

line 248 of /lib/messagelib.php: call to mysqli_native_moodle_database->insert_record()

line 1375 of /lib/upgradelib.php: call to message_update_providers()

line 182 of /admin/index.php: call to install_core()

 

[glennda]

This is the fix

 

Using Moodle: 2.0 Upgrade Database Error