Error writing to database - Moodle installation

Asked

Viewed 725 times

1

I’m trying to install the moodle on my server Digital Ocean I am following all the steps according to what is asked, until there comes a time that asks to install the plugins, but during the installation I get the following error:

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: 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_config_log (userid,timemodified,name,oldvalue,value,plugin) VALUES(?,?,?,?,?) [array ( 0 => 0, 1 => 1457352248, 2 => 'filter_active', 3 => ', 4 => 1, 5 => 'activitynames', )] Error code: dmlwriteexception

Stack trace: line 446 of /lib/dml/moodle_database.php: dml_write_exception thrown line 1164 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end() line 1210 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->insert_record_raw() line 1613 of /lib/datalib.php: call to mysqli_native_moodle_database->insert_record() line 598 of /lib/filterlib.php: call to add_to_config_log() line 29 of /filter/activitynames/db/install.php: call to filter_set_global_state() line 519 of /lib/upgradelib.php: call to xmldb_filter_activitynames_install() line 1647 of /lib/upgradelib.php: call to upgrade_plugins() line 677 of /admin/index.php: call to upgrade_noncore()

As the error appears I give a refresh on the page and appears the following Site is being upgraded, please retry later. ai passing a few minutes I give refresh again and appears the error above but with another plugin every hour is a plugin, are 361 in total as or I am doing this refresh procedure the number of plugin to be intalado will decrease, the impression is that they are being installed but I even reset this number but then after that began to give error of pagina nao encontrada ... Wow this Moodle is giving me a lot of work to install on the server, I’m only getting to run it local.

  • Drop the database and install the moddle again.

  • @rray would simplify this DROPA the database hehe did not understand =D obg

  • Enter by phpmyadmin and delete this created base

  • @rray So I have deleted and created the bank a few times, but always the same error, but now I will do a test take the bank I have in place export and import on the server, you think it can work?

  • I don’t know, try

  • Might help http://stackoverflow.com/a/18427799/1342547

  • @rray forgive my ignorance regarding database and/or anything else related, but when he asks the guy to execute that command, where do I execute it? in phpmyadmin in SQL does not go because of syntax ...

Show 2 more comments
No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.