{"action":"created","issue":{"url":"https://api.github.com/repos/LogBlock/LogBlock/issues/662","repository_url":"https://api.github.com/repos/LogBlock/LogBlock","labels_url":"https://api.github.com/repos/LogBlock/LogBlock/issues/662/labels{/name}","comments_url":"https://api.github.com/repos/LogBlock/LogBlock/issues/662/comments","events_url":"https://api.github.com/repos/LogBlock/LogBlock/issues/662/events","html_url":"https://github.com/LogBlock/LogBlock/issues/662","id":143850239,"number":662,"title":"MySQL 5.7 incompatible SQL","user":{"login":"mb243","id":9483554,"avatar_url":"https://avatars.githubusercontent.com/u/9483554?v=3","gravatar_id":"","url":"https://api.github.com/users/mb243","html_url":"https://github.com/mb243","followers_url":"https://api.github.com/users/mb243/followers","following_url":"https://api.github.com/users/mb243/following{/other_user}","gists_url":"https://api.github.com/users/mb243/gists{/gist_id}","starred_url":"https://api.github.com/users/mb243/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mb243/subscriptions","organizations_url":"https://api.github.com/users/mb243/orgs","repos_url":"https://api.github.com/users/mb243/repos","events_url":"https://api.github.com/users/mb243/events{/privacy}","received_events_url":"https://api.github.com/users/mb243/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":6,"created_at":"2016-03-27T21:36:53Z","updated_at":"2016-03-27T22:46:19Z","closed_at":null,"body":"The SQL statement for log dumping generates an error under MySQL 5.7."},"comment":{"url":"https://api.github.com/repos/LogBlock/LogBlock/issues/comments/202164488","html_url":"https://github.com/LogBlock/LogBlock/issues/662#issuecomment-202164488","issue_url":"https://api.github.com/repos/LogBlock/LogBlock/issues/662","id":202164488,"user":{"login":"mb243","id":9483554,"avatar_url":"https://avatars.githubusercontent.com/u/9483554?v=3","gravatar_id":"","url":"https://api.github.com/users/mb243","html_url":"https://github.com/mb243","followers_url":"https://api.github.com/users/mb243/followers","following_url":"https://api.github.com/users/mb243/following{/other_user}","gists_url":"https://api.github.com/users/mb243/gists{/gist_id}","starred_url":"https://api.github.com/users/mb243/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mb243/subscriptions","organizations_url":"https://api.github.com/users/mb243/orgs","repos_url":"https://api.github.com/users/mb243/repos","events_url":"https://api.github.com/users/mb243/events{/privacy}","received_events_url":"https://api.github.com/users/mb243/received_events","type":"User","site_admin":false},"created_at":"2016-03-27T22:46:18Z","updated_at":"2016-03-27T22:46:18Z","body":"This may not be an issue with MySQL 5.7 after all. The command I used was:\r\n\r\n/lb clearlog chat search save\r\n\r\nwhich I expected to search the chat log for the word \"save\" and clear all matches. This failed with the above. I then tried:\r\n\r\n/lb clearlog chat search meow\r\n\r\nwhich also generated the error. I then did \r\n\r\n/lb clearlog chat player <player>\r\n\r\nwhich triggered a dump of \"Block changes from player <player> in world.csv\"\r\n\r\nEither my understanding of the parameters of clearlog is incorrect, or it is not handling parameters correctly.\r\n\r\nI "}}