{"action":"created","issue":{"url":"https://api.github.com/repos/vitalidze/traccar-web/issues/579","repository_url":"https://api.github.com/repos/vitalidze/traccar-web","labels_url":"https://api.github.com/repos/vitalidze/traccar-web/issues/579/labels{/name}","comments_url":"https://api.github.com/repos/vitalidze/traccar-web/issues/579/comments","events_url":"https://api.github.com/repos/vitalidze/traccar-web/issues/579/events","html_url":"https://github.com/vitalidze/traccar-web/issues/579","id":143220202,"number":579,"title":"I dont get address with traccar 3.3","user":{"login":"fetteh","id":16548555,"avatar_url":"https://avatars.githubusercontent.com/u/16548555?v=3","gravatar_id":"","url":"https://api.github.com/users/fetteh","html_url":"https://github.com/fetteh","followers_url":"https://api.github.com/users/fetteh/followers","following_url":"https://api.github.com/users/fetteh/following{/other_user}","gists_url":"https://api.github.com/users/fetteh/gists{/gist_id}","starred_url":"https://api.github.com/users/fetteh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fetteh/subscriptions","organizations_url":"https://api.github.com/users/fetteh/orgs","repos_url":"https://api.github.com/users/fetteh/repos","events_url":"https://api.github.com/users/fetteh/events{/privacy}","received_events_url":"https://api.github.com/users/fetteh/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":9,"created_at":"2016-03-24T11:17:35Z","updated_at":"2016-03-28T04:43:48Z","closed_at":null,"body":"this is what I get in the log file :\r\n\r\n````\r\n2016-03-24 10:22:20  INFO: [0688EA86] id: 1, time: 2016-03-24 10:22:16, lat: 34.63690, lon: 10.64939, speed: 37.3, course: 43.0\r\n2016-03-24 10:22:26 DEBUG: [0688EA86: 5023 < 197.8.74.36] HEX: 78781f1210031809161ac803b75e8001248a2c53542c025d02008c00693e053e03950d0a\r\n2016-03-24 10:22:26 DEBUG: [0688EA86: 5023 > 197.8.74.36] HEX: 78780512053e04e10d0a\r\n2016-03-24 10:22:26  WARN: Unknown column 'status' in 'field list' - MySQLSyntaxErrorException (... < QueryBuilder:431 < DataManager:256 < ConnectionManager:110 < ...)\r\n2016-03-24 10:22:27  INFO: [0688EA86] id: 1, time: 2016-03-24 10:22:26, lat: 34.63829, lon: 10.65105, speed: 44.8, course: 44.0\r\n2016-03-24 10:22:36 DEBUG: [0688EA86: 5023 < 197.8.74.36] HEX: 78781f12100318091624c803b76964012496da56542b025d02008c00693e053fd8bf0d0a\r\n2016-03-24 10:22:36 DEBUG: [0688EA86: 5023 > 197.8.74.36] HEX: 78780512053f15680d0a\r\n2016-03-24 10:22:36  WARN: Unknown column 'status' in 'field list' - MySQLSyntaxErrorException (... < QueryBuilder:431 < DataManager:256 < ConnectionManager:110 < ...)\r\n2016-03-24 10:22:39  INFO: [0688EA86] id: 1, time: 2016-03-24 10:22:36, lat: 34.63984, lon: 10.65285, speed: 46.4, course: 43.0\r\n2016-03-24 10:22:47 DEBUG: [0688EA86: 5023 < 197.8.74.36] HEX: 78781f1210031809162ec903b774880124a3b0575429025d02008c00693e0540fdfe0d0a\r\n2016-03-24 10:22:47 DEBUG: [0688EA86: 5023 > 197.8.74.36] HEX: 7878051205409e180d0a\r\n2016-03-24 10:22:47  WARN: Unknown column 'status' in 'field list' - MySQLSyntaxErrorException (... < QueryBuilder:431 < DataManager:256 < ConnectionManager:110 < ...)\r\n2016-03-24 10:22:53  INFO: [0688EA86] id: 1, time: 2016-03-24 10:22:46, lat: 34.64143, lon: 10.65468, speed: 47.0, course: 41.0\r\n2016-03-24 10:22:56 DEBUG: [0688EA86: 5023 < 197.8.74.36] HEX: 78781f12100318091638c903b7805c0124aef0525422025d02008c00693e0541a5170d0a\r\n2016-03-24 10:22:56 DEBUG: [0688EA86: 5023 > 197.8.74.36] HEX: 7878051205418f910d0a\r\n2016-03-24 10:22:56  WARN: Unknown column 'status' in 'field list' - MySQLSyntaxErrorException (... < QueryBuilder:431 < DataManager:256 < ConnectionManager:110 < ...)\r\n2016-03-24 10:22:57  INFO: [0688EA86] id: 1, time: 2016-03-24 10:22:56, lat: 34.64311, lon: 10.65628, speed: 44.3, course: 34.0\r\n2016-03-24 10:23:06 DEBUG: [0688EA86: 5023 < 197.8.74.36] HEX: 78781f12100318091706c903b78cd40124b9c45a5424025d02008c00693e05427cdf0d0a\r\n2016-03-24 10:23:06 DEBUG: [0688EA86: 5023 > 197.8.74.36] HEX: 787805120542bd0a0d0a\r\n2016-03-24 10:23:06  WARN: Unknown column 'status' in 'field list' - MySQLSyntaxErrorException (... < QueryBuilder:431 < DataManager:256 < ConnectionManager:110 < ...)\r\n2016-03-24 10:23:10  INFO: [0688EA86] id: 1, time: 2016-03-24 10:23:06, lat: 34.64488, lon: 10.65782, speed: 48.6, course: 36.0\r\n2016-03-24 10:23:16 DEBUG: [0688EA86: 5023 < 197.8.74.36] HEX: 78781f12100318091710c903b799e40124c5985c5424025d02008c00693e0543a5c50d0a\r\n2016-03-24 10:23:16 DEBUG: [0688EA86: 5023 > 197.8.74.36] HEX: 787805120543ac830d0a\r\n2016-03-24 10:23:16  WARN: Unknown column 'status' in 'field list' - MySQLSyntaxErrorException (... < QueryBuilder:431 < DataManager:256 < ConnectionManager:110 < ...)\r\n````\r\n\r\nand in the data base the address field is NULL"},"comment":{"url":"https://api.github.com/repos/vitalidze/traccar-web/issues/comments/202227234","html_url":"https://github.com/vitalidze/traccar-web/issues/579#issuecomment-202227234","issue_url":"https://api.github.com/repos/vitalidze/traccar-web/issues/579","id":202227234,"user":{"login":"vitalidze","id":2294325,"avatar_url":"https://avatars.githubusercontent.com/u/2294325?v=3","gravatar_id":"","url":"https://api.github.com/users/vitalidze","html_url":"https://github.com/vitalidze","followers_url":"https://api.github.com/users/vitalidze/followers","following_url":"https://api.github.com/users/vitalidze/following{/other_user}","gists_url":"https://api.github.com/users/vitalidze/gists{/gist_id}","starred_url":"https://api.github.com/users/vitalidze/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vitalidze/subscriptions","organizations_url":"https://api.github.com/users/vitalidze/orgs","repos_url":"https://api.github.com/users/vitalidze/repos","events_url":"https://api.github.com/users/vitalidze/events{/privacy}","received_events_url":"https://api.github.com/users/vitalidze/received_events","type":"User","site_admin":false},"created_at":"2016-03-28T04:43:48Z","updated_at":"2016-03-28T04:43:48Z","body":"@waca98 first of all you will need to have a latest \"backend\" version built from sources because Google API key support was added only in code (I mean even 3.4 does not support it) (see https://github.com/tananaev/traccar/issues/1781). Then you will need to put the following entry to your `traccar.xml` configuration file (somewhere below the `geocoder.type` entry):\r\n\r\n````xml\r\n<entry key='geocoder.key'>YOUR API KEY</entry>\r\n````"}}