Hi, I am trying to install the latest OwnCloud 9.1.0 on my server. I attempted to configure the database for MySQL/MariaDB. (Username, database name, etc were all good.)
I received the following error from OwnCloud:
An exception occured whiel executing 'INSERT INTO' oc_users' ('uid', 'password') VALUES(?,?)' with params [something something]: SQLSTATE[HY000]: General Error: 1665 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.
My server administrator gave me the following replies:
After looking at the install instructions on this, it doesn't look like it's going to be supported here as the following is needed and cannot be changed due to other ecommerce software needs.
Database Requirements for MySQL / MariaDB¶
The following is currently required if you’re running ownCloud together with a MySQL / MariaDB database:
Disabled or BINLOG_FORMAT = MIXED configured Binary Logging
Maybe I'm reading their site wrong, and it's not required, but the error you presented showed from a quick search that they need a specific bin log format, which would break all sites using innodb, including your forums. That's not something that will be changed as it's needed for innodb configs, recovery, etc.
Can someone advise or provide a workaround solution?