mysql warning unsafe statement

  • Resolved Muhammad Saqib Sarwar

    (@saqibsarwar)


    5 years, 6 months ago

    Hi,

    I am getting this in my server log.

    mysqld[1824]: 2018-09-29 12:25:00 140636419537664 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted. Statement: DELETE FROM 'wp_options' WHERE 'option_name' LIKE 'jetpack\\_nonce\\_%' AND CAST('option_value' AS UNSIGNED ) < 1538220300 ORDER BY 'option_id' LIMIT 100

    Please look into it and fix it in next update.

    Regards

Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘mysql warning unsafe statement’ is closed to new replies.