trinv
commented
2 years ago https://stackoverflow.com/questions/33142095/impossible-to-write-to-binary-log-since-binlog-format-statement-and-at-least-o
add this line in the /etc/my.cnf
binlog_format=rowOpen trinv opened 2 years ago
trinv
commented
2 years ago https://stackoverflow.com/questions/33142095/impossible-to-write-to-binary-log-since-binlog-format-statement-and-at-least-o
add this line in the /etc/my.cnf
binlog_format=row
pdnsutil create-zone test1.com Creating empty zone 'test1.com' Error: Database error trying to insert new domain 'test1.com': Could not execute mysql statement: insert into domains (type,name,master,account,last_check,notified_serial) values(?,?,?,?,NULL,NULL): 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.