Old Time RockenRoll
Member
I have been having lots of issues with the following
2018-08-16 13:42:58 25818 [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_thread_read
(user_id, thread_id, thread_read_date)
VALUES
('228405', '385167', '1534444938')
ON DUPLICATE KEY UPDATE thread_read_date = VALUES(thread_read_date)
any help would be appreciated
2018-08-16 13:42:58 25818 [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_thread_read
(user_id, thread_id, thread_read_date)
VALUES
('228405', '385167', '1534444938')
ON DUPLICATE KEY UPDATE thread_read_date = VALUES(thread_read_date)
any help would be appreciated