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. 2005 - 2023
Версия от 08:40, 10 сентября 2019; Admin iph (обсуждение | вклад) (Новая страница: « === SQLSTATE[HY000]: General error: 1665 Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses …»)
(разн.) ← Предыдущая | Текущая версия (разн.) | Следующая → (разн.)
Перейти к:навигация, поиск

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 сервера.