{"action":"created","issue":{"url":"https://api.github.com/repos/siddontang/go-mysql-elasticsearch/issues/15","labels_url":"https://api.github.com/repos/siddontang/go-mysql-elasticsearch/issues/15/labels{/name}","comments_url":"https://api.github.com/repos/siddontang/go-mysql-elasticsearch/issues/15/comments","events_url":"https://api.github.com/repos/siddontang/go-mysql-elasticsearch/issues/15/events","html_url":"https://github.com/siddontang/go-mysql-elasticsearch/issues/15","id":97340388,"number":15,"title":"mysql error 1064 when starting","user":{"login":"gogogen","id":6897445,"avatar_url":"https://avatars.githubusercontent.com/u/6897445?v=3","gravatar_id":"","url":"https://api.github.com/users/gogogen","html_url":"https://github.com/gogogen","followers_url":"https://api.github.com/users/gogogen/followers","following_url":"https://api.github.com/users/gogogen/following{/other_user}","gists_url":"https://api.github.com/users/gogogen/gists{/gist_id}","starred_url":"https://api.github.com/users/gogogen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gogogen/subscriptions","organizations_url":"https://api.github.com/users/gogogen/orgs","repos_url":"https://api.github.com/users/gogogen/repos","events_url":"https://api.github.com/users/gogogen/events{/privacy}","received_events_url":"https://api.github.com/users/gogogen/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-07-26T18:40:56Z","updated_at":"2015-07-27T02:25:48Z","closed_at":null,"body":"I encountered the following error when i tried to start:\r\nERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\"binlog_format\"' at line 1\r\n\r\nMy database is mysql 5.6.22. and the binlog_format is \"row\".\r\nSo could you help me figure this out. Thx"},"comment":{"url":"https://api.github.com/repos/siddontang/go-mysql-elasticsearch/issues/comments/125064840","html_url":"https://github.com/siddontang/go-mysql-elasticsearch/issues/15#issuecomment-125064840","issue_url":"https://api.github.com/repos/siddontang/go-mysql-elasticsearch/issues/15","id":125064840,"user":{"login":"gogogen","id":6897445,"avatar_url":"https://avatars.githubusercontent.com/u/6897445?v=3","gravatar_id":"","url":"https://api.github.com/users/gogogen","html_url":"https://github.com/gogogen","followers_url":"https://api.github.com/users/gogogen/followers","following_url":"https://api.github.com/users/gogogen/following{/other_user}","gists_url":"https://api.github.com/users/gogogen/gists{/gist_id}","starred_url":"https://api.github.com/users/gogogen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gogogen/subscriptions","organizations_url":"https://api.github.com/users/gogogen/orgs","repos_url":"https://api.github.com/users/gogogen/repos","events_url":"https://api.github.com/users/gogogen/events{/privacy}","received_events_url":"https://api.github.com/users/gogogen/received_events","type":"User","site_admin":false},"created_at":"2015-07-27T02:25:48Z","updated_at":"2015-07-27T02:25:48Z","body":"Thanks, I got it. \r\nBecause my database used the `sql_mode = \"Oracle\"` setting which contains `ANSI_QUOTES` mode. \r\nI will change my `sql_mode`, but I still recommend you to use single quotation instead of double quotation.\r\nThank you! This tool is really helpful."}}