Added by James Brocklebank almost 7 years ago
Hi,
After setting up openproject I'm getting the following error when doing any updates, inserts to my database.
ActiveRecord::StatementInvalid (Mysql2::Error: 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.: UPDATE `users` SET `last_failed_login_on` = '2018-11-14 04:31:31', `failed_login_count` = 1, `updated_on` = '2018-11-14 04:31:31' WHERE `users`.`id` = 1)
Has anyone encountered this before and know how to fix it? I have several other Rails applications running using the same MySQL server all with InnoDB storage engine and not having any problems.
Replies (1)
Adding the following line to your MySQL configuration (my.cnf):
should solve your problem (you may have to delete your database before trying 'openproject configure' again.