{"action":"created","issue":{"url":"https://api.github.com/repos/vitalidze/traccar-web/issues/718","repository_url":"https://api.github.com/repos/vitalidze/traccar-web","labels_url":"https://api.github.com/repos/vitalidze/traccar-web/issues/718/labels{/name}","comments_url":"https://api.github.com/repos/vitalidze/traccar-web/issues/718/comments","events_url":"https://api.github.com/repos/vitalidze/traccar-web/issues/718/events","html_url":"https://github.com/vitalidze/traccar-web/issues/718","id":159028448,"number":718,"title":"v3.5 with postgresql syntax error","user":{"login":"tzamagias","id":17560843,"avatar_url":"https://avatars.githubusercontent.com/u/17560843?v=3","gravatar_id":"","url":"https://api.github.com/users/tzamagias","html_url":"https://github.com/tzamagias","followers_url":"https://api.github.com/users/tzamagias/followers","following_url":"https://api.github.com/users/tzamagias/following{/other_user}","gists_url":"https://api.github.com/users/tzamagias/gists{/gist_id}","starred_url":"https://api.github.com/users/tzamagias/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tzamagias/subscriptions","organizations_url":"https://api.github.com/users/tzamagias/orgs","repos_url":"https://api.github.com/users/tzamagias/repos","events_url":"https://api.github.com/users/tzamagias/events{/privacy}","received_events_url":"https://api.github.com/users/tzamagias/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,"milestone":null,"comments":2,"created_at":"2016-06-07T21:25:54Z","updated_at":"2016-06-08T10:17:06Z","closed_at":null,"body":"I've had v3.5 running with postgres on a raspberry pi previously but have had to reinstall it.\r\nSince reinstalling, I've been getting the following error and no positions are being stored in the database or being displayed on the map. I've been over the xml file multiple times but it seems like I may have still missed something. Has anyone experienced this before?\r\n\r\n`2016-06-07 06:04:06  WARN: ERROR: syntax error at or near \"$5\"\r\n  Position: 163 - PSQLException (... < QueryBuilder:431 < DataManager:440 < DefaultDataHandler:27 < ...)`"},"comment":{"url":"https://api.github.com/repos/vitalidze/traccar-web/issues/comments/224548192","html_url":"https://github.com/vitalidze/traccar-web/issues/718#issuecomment-224548192","issue_url":"https://api.github.com/repos/vitalidze/traccar-web/issues/718","id":224548192,"user":{"login":"tzamagias","id":17560843,"avatar_url":"https://avatars.githubusercontent.com/u/17560843?v=3","gravatar_id":"","url":"https://api.github.com/users/tzamagias","html_url":"https://github.com/tzamagias","followers_url":"https://api.github.com/users/tzamagias/followers","following_url":"https://api.github.com/users/tzamagias/following{/other_user}","gists_url":"https://api.github.com/users/tzamagias/gists{/gist_id}","starred_url":"https://api.github.com/users/tzamagias/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tzamagias/subscriptions","organizations_url":"https://api.github.com/users/tzamagias/orgs","repos_url":"https://api.github.com/users/tzamagias/repos","events_url":"https://api.github.com/users/tzamagias/events{/privacy}","received_events_url":"https://api.github.com/users/tzamagias/received_events","type":"User","site_admin":false},"created_at":"2016-06-08T10:17:06Z","updated_at":"2016-06-08T10:17:06Z","body":"` <entry key='database.insertPosition'>\r\n        INSERT INTO positions (device_id, protocol, serverTime, time, valid, latitude, longitude, altitude, speed, course, address, other)\r\n        VALUES (:deviceId, :protocol, :now, :deviceTime :valid, :latitude, :longitude, :altitude, :speed, :course, :address, :attributes);\r\n    </entry>`\r\n`\r\n    <entry key='database.driver'>org.postgresql.Driver</entry>\r\n    <entry key='database.url'>jdbc:postgresql://127.0.0.1:xxxx/[db]</entry>\r\n    <entry key='database.user'>xxxx</entry>\r\n    <entry key='database.password'>xxxxx</entry>\r\n`\r\n\r\nWhat config is the bottom of that page referring to?\r\nI must have done that the first time, but I can't remember where/how to change that config."}}
{"actor":{"display_login":"tzamagias"}}