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.

Adding the following line to your MySQL configuration (my.cnf):

[mysqld]
binlog_format = 'MIXED'

should solve your problem (you may have to delete your database before trying 'openproject configure' again.