Skip to content

Known issues

Sara Monzón edited this page Mar 7, 2019 · 1 revision

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
Clone this wiki locally