MySQL - General error: 1665 Cannot execute statement: impossible to write to binary log since BINLOG FORMAT = STATEMENT


Материал из Wiki - Iphoster - 'the best ever hosting and support

Перейти к: навигация, поиск

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.

Ошибка вида

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.

при попытке залить файл через плагин Joomla -- слайдер Rockgalery решается изменением параметра в my.cnf:

binlog_format=row

и перезапуском mysql сервера.


Индекс цитирования