Comment 2 for bug 869005

Revision history for this message
Frederic Descamps (lefred) wrote :

For information this is the error returned when delete permissions is checked,

eval { $dbh->do($sql); };
   my $can_delete = $EVAL_ERROR ? 0 : 1;

this returns:

DBD::mysql::db do failed: 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. [for Statement "DELETE FROM `database_name`.`table_name` LIMIT 0"] at ./bin/pt-table-sync line 5577.