Not a bug [Warning] Unsafe statement written to the binary log

[Alpha1]

My hosts reports a large number of MySQL errors for Unsafe Statements:

2017-03-02 17:20:38 1371 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT... ON DUPLICATE KEY UPDATE  on a table with more than one UNIQUE KEY is unsafe Statement: INSERT INTO xf_bb_code_parse_cache
                                                                        (content_type, content_id, parse_tree, cache_version, cache_date)
                                                                VALUES ('post', '1132816', 'a:1:{i:0;s:408:\"...
";}', '1488423489', '1488471636')
                                                                ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
                                                                        cache_version = VALUES(cache_version),
                                                                        cache_date = VALUES(cache_date)
2017-03-02 17:20:38 1371 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT... ON DUPLICATE KEY UPDATE  on a table with more than one UNIQUE KEY is unsafe Statement: INSERT INTO xf_bb_code_parse_cache
                                                                        (content_type, content_id, parse_tree, cache_version, cache_date)
                                                                VALUES ('post', '1133737', 'a:1:{i:0;s:707:\"
...
2017-03-02 17:20:38 1371 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT... ON DUPLICATE KEY UPDATE  on a table with more than one UNIQUE KEY is unsafe Statement: INSERT INTO xf_bb_code_parse_cache
                                                                        (content_type, content_id, parse_tree, cache_version, cache_date)
                                                                VALUES ('post', '1133800', 'a:1:{i:0;s:415:\"
...";}', '1488423489', '1488471636')
                                                                ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
                                                                        cache_version = VALUES(cache_version),
                                                                        cache_date = VALUES(cache_date)
2017-03-02 17:20:38 1371 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT... ON DUPLICATE KEY UPDATE  on a table with more than one UNIQUE KEY is unsafe Statement: INSERT INTO xf_bb_code_parse_cache
                                                                        (content_type, content_id, parse_tree, cache_version, cache_date)
                                                                VALUES ('post', '1133802', 'a:1:{i:0;s:264:\"
...";}', '1488423489', '1488471636')
                                                                ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
                                                                        cache_version = VALUES(cache_version),
                                                                        cache_date = VALUES(cache_date)

I checked the posts but can find no bbcode inside.

Is this something I need to fix somehow or is this a xenforo bug?

 

[Mike]

You need to change your bin log format in MySQL to either row or mixed mode.