{"action":"created","issue":{"url":"https://api.github.com/repos/vitalidze/traccar-web/issues/728","repository_url":"https://api.github.com/repos/vitalidze/traccar-web","labels_url":"https://api.github.com/repos/vitalidze/traccar-web/issues/728/labels{/name}","comments_url":"https://api.github.com/repos/vitalidze/traccar-web/issues/728/comments","events_url":"https://api.github.com/repos/vitalidze/traccar-web/issues/728/events","html_url":"https://github.com/vitalidze/traccar-web/issues/728","id":159887117,"number":728,"title":"Parameter \"#1\" is not set; SQL statement:","user":{"login":"gitty8","id":19901796,"avatar_url":"https://avatars.githubusercontent.com/u/19901796?v=3","gravatar_id":"","url":"https://api.github.com/users/gitty8","html_url":"https://github.com/gitty8","followers_url":"https://api.github.com/users/gitty8/followers","following_url":"https://api.github.com/users/gitty8/following{/other_user}","gists_url":"https://api.github.com/users/gitty8/gists{/gist_id}","starred_url":"https://api.github.com/users/gitty8/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gitty8/subscriptions","organizations_url":"https://api.github.com/users/gitty8/orgs","repos_url":"https://api.github.com/users/gitty8/repos","events_url":"https://api.github.com/users/gitty8/events{/privacy}","received_events_url":"https://api.github.com/users/gitty8/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/vitalidze/traccar-web/labels/help%20wanted","name":"help wanted","color":"159818"}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":5,"created_at":"2016-06-13T07:20:37Z","updated_at":"2016-06-30T09:40:30Z","closed_at":null,"body":"How to fix:\r\n\r\n`WARN: Parameter \"#1\" is not set; SQL statement:\r\nINSERT INTO positions (device_id, protocol, serverTime, time, valid, latitude, longitude, altitude, speed, course, address, other)\r\n        VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?); [90012-191] - JdbcSQLException (... < QueryBuilder:431 < DataManager:440 < DefaultDataHandler:27 < ...)\r\n2016-06-13 03:17:57  INFO: [4D26274E] id: 1, time: 2016-06-13 03:17:13, lat: 99.21199, lon: 99.94865, speed: 0.0, course: 0.0\r\n`\r\n\r\n\r\nDevice not showing up."},"comment":{"url":"https://api.github.com/repos/vitalidze/traccar-web/issues/comments/229611642","html_url":"https://github.com/vitalidze/traccar-web/issues/728#issuecomment-229611642","issue_url":"https://api.github.com/repos/vitalidze/traccar-web/issues/728","id":229611642,"user":{"login":"gitty8","id":19901796,"avatar_url":"https://avatars.githubusercontent.com/u/19901796?v=3","gravatar_id":"","url":"https://api.github.com/users/gitty8","html_url":"https://github.com/gitty8","followers_url":"https://api.github.com/users/gitty8/followers","following_url":"https://api.github.com/users/gitty8/following{/other_user}","gists_url":"https://api.github.com/users/gitty8/gists{/gist_id}","starred_url":"https://api.github.com/users/gitty8/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gitty8/subscriptions","organizations_url":"https://api.github.com/users/gitty8/orgs","repos_url":"https://api.github.com/users/gitty8/repos","events_url":"https://api.github.com/users/gitty8/events{/privacy}","received_events_url":"https://api.github.com/users/gitty8/received_events","type":"User","site_admin":false},"created_at":"2016-06-30T09:40:30Z","updated_at":"2016-06-30T09:40:30Z","body":"Do you mean:\r\n\r\n`<entry key='database.selectDevicesAll'>\r\n        SELECT * FROM device;\r\n    </entry>`\r\n\r\nto\r\n\r\n`<entry key='database.selectDevicesAll'>\r\n        SELECT * FROM devices;\r\n    </entry>`"}}
{"actor":{"display_login":"gitty8"}}