Known issues - BU-ISCIII/iskylims GitHub Wiki

Summary

1. Error in manage.py migrate: Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT an django ...

FAQ1

I get the error django.db.utils.OperationalError: (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.') when I try to make manage.py migrate.

This can happen with certain MySQL versions. One of the solutions is to add in /etc/mysql/my.conf the next lines after [mysqld]

binlog_format=mixed