2014-11-11, 08:11 PM
I moved my forum to a new server running centos 7 and mysql 5.5
I checked my /var/log/mariadb/mariadb.log for errors, and stunned to see thousand and thousand lines running the following content
There are some differences in letters in the second paragraph, thats the only difference.
Anybody please help me to sort out the issue with a fix for this
Thanks in advance.
I checked my /var/log/mariadb/mariadb.log for errors, and stunned to see thousand and thousand lines running the following content
Quote:[Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it usses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted. Statement: UPDATE mybb_sessions
SETnopermission='1',location1='0',location2='0' WHERE sid='595384a321d1337d184b7ebec0ef46e5' LIMIT 1
There are some differences in letters in the second paragraph, thats the only difference.
Anybody please help me to sort out the issue with a fix for this
Thanks in advance.