{"action":"created","issue":{"url":"https://api.github.com/repos/Prospress/action-scheduler/issues/62","repository_url":"https://api.github.com/repos/Prospress/action-scheduler","labels_url":"https://api.github.com/repos/Prospress/action-scheduler/issues/62/labels{/name}","comments_url":"https://api.github.com/repos/Prospress/action-scheduler/issues/62/comments","events_url":"https://api.github.com/repos/Prospress/action-scheduler/issues/62/events","html_url":"https://github.com/Prospress/action-scheduler/issues/62","id":181157769,"number":62,"title":"MYSQL Unsafe Statement Warning.","user":{"login":"kymcarlsson","id":10130454,"avatar_url":"https://avatars.githubusercontent.com/u/10130454?v=3","gravatar_id":"","url":"https://api.github.com/users/kymcarlsson","html_url":"https://github.com/kymcarlsson","followers_url":"https://api.github.com/users/kymcarlsson/followers","following_url":"https://api.github.com/users/kymcarlsson/following{/other_user}","gists_url":"https://api.github.com/users/kymcarlsson/gists{/gist_id}","starred_url":"https://api.github.com/users/kymcarlsson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kymcarlsson/subscriptions","organizations_url":"https://api.github.com/users/kymcarlsson/orgs","repos_url":"https://api.github.com/users/kymcarlsson/repos","events_url":"https://api.github.com/users/kymcarlsson/events{/privacy}","received_events_url":"https://api.github.com/users/kymcarlsson/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-10-05T13:43:27Z","updated_at":"2016-10-07T23:44:57Z","closed_at":"2016-10-07T23:44:57Z","body":"Hi there,\r\n\r\nGetting the following warning msg from MYSQL when running wp-cron every 30 seconds.\r\nHere's the out output from /var/log/syslog:\r\n\r\n`Oct  5 13:27:01 mysite CRON[7843]: (root) CMD (curl https://mysite.example.com/wp-cron.php > /dev/null 2>&1)\r\nOct  5 13:27:01 mysite CRON[7844]: (root) CMD (( sleep 30; curl https://mysite.example.com/wp-cron.php > /dev/null 2>&1 ))\r\nOct  5 13:27:31 mysite mysqld: 2016-10-05 13:27:31 140383028554496 [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: UPDATE wp_posts SET post_password = '5b7d94922c5f856fe2a1', post_modified_gmt = '2016-10-05 13:27:31', post_modified = '2016-10-05 13:27:31' WHERE post_type = 'scheduled-action' AND post_status = 'pending' AND post_password = '' AND post_date <= '2016-10-05 13:27:31' ORDER BY menu_order ASC, post_date ASC LIMIT 25`"},"comment":{"url":"https://api.github.com/repos/Prospress/action-scheduler/issues/comments/252385736","html_url":"https://github.com/Prospress/action-scheduler/issues/62#issuecomment-252385736","issue_url":"https://api.github.com/repos/Prospress/action-scheduler/issues/62","id":252385736,"user":{"login":"thenbrent","id":235523,"avatar_url":"https://avatars.githubusercontent.com/u/235523?v=3","gravatar_id":"","url":"https://api.github.com/users/thenbrent","html_url":"https://github.com/thenbrent","followers_url":"https://api.github.com/users/thenbrent/followers","following_url":"https://api.github.com/users/thenbrent/following{/other_user}","gists_url":"https://api.github.com/users/thenbrent/gists{/gist_id}","starred_url":"https://api.github.com/users/thenbrent/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/thenbrent/subscriptions","organizations_url":"https://api.github.com/users/thenbrent/orgs","repos_url":"https://api.github.com/users/thenbrent/repos","events_url":"https://api.github.com/users/thenbrent/events{/privacy}","received_events_url":"https://api.github.com/users/thenbrent/received_events","type":"User","site_admin":false},"created_at":"2016-10-07T23:44:57Z","updated_at":"2016-10-07T23:44:57Z","body":"Hi @kymcarlsson that's caused by MySQL configuration.\r\n\r\nIf you're not using binary logs for anything, it's not really an issue. If you are using them for replication or recovery, you should change the `binlog_format` MySQL option on your serves to either `MIXED` or `ROW`.\r\n\r\nMore details:\r\n\r\n * https://www.psce.com/blog/2012/04/17/why-a-statement-can-be-unsafe-when-it-uses-limit-clause/\r\n* http://dev.mysql.com/doc/refman/5.7/en/binary-log-setting.html"}}
{"actor":{"display_login":"thenbrent"}}