{"action":"created","issue":{"url":"https://api.github.com/repos/piwik/piwik/issues/8304","labels_url":"https://api.github.com/repos/piwik/piwik/issues/8304/labels{/name}","comments_url":"https://api.github.com/repos/piwik/piwik/issues/8304/comments","events_url":"https://api.github.com/repos/piwik/piwik/issues/8304/events","html_url":"https://github.com/piwik/piwik/issues/8304","id":94023907,"number":8304,"title":"Column not found: 1054 Unknown column 'log_visit.location_browser_lang' in 'field list'\"","user":{"login":"mattab","id":466765,"avatar_url":"https://avatars.githubusercontent.com/u/466765?v=3","gravatar_id":"","url":"https://api.github.com/users/mattab","html_url":"https://github.com/mattab","followers_url":"https://api.github.com/users/mattab/followers","following_url":"https://api.github.com/users/mattab/following{/other_user}","gists_url":"https://api.github.com/users/mattab/gists{/gist_id}","starred_url":"https://api.github.com/users/mattab/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mattab/subscriptions","organizations_url":"https://api.github.com/users/mattab/orgs","repos_url":"https://api.github.com/users/mattab/repos","events_url":"https://api.github.com/users/mattab/events{/privacy}","received_events_url":"https://api.github.com/users/mattab/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/piwik/piwik/labels/Bug","name":"Bug","color":"fc2929"},{"url":"https://api.github.com/repos/piwik/piwik/labels/Critical","name":"Critical","color":"e11d21"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/piwik/piwik/milestones/85","html_url":"https://github.com/piwik/piwik/milestones/2.14.2","labels_url":"https://api.github.com/repos/piwik/piwik/milestones/85/labels","id":1211939,"number":85,"title":"2.14.2","description":"","creator":{"login":"mattab","id":466765,"avatar_url":"https://avatars.githubusercontent.com/u/466765?v=3","gravatar_id":"","url":"https://api.github.com/users/mattab","html_url":"https://github.com/mattab","followers_url":"https://api.github.com/users/mattab/followers","following_url":"https://api.github.com/users/mattab/following{/other_user}","gists_url":"https://api.github.com/users/mattab/gists{/gist_id}","starred_url":"https://api.github.com/users/mattab/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mattab/subscriptions","organizations_url":"https://api.github.com/users/mattab/orgs","repos_url":"https://api.github.com/users/mattab/repos","events_url":"https://api.github.com/users/mattab/events{/privacy}","received_events_url":"https://api.github.com/users/mattab/received_events","type":"User","site_admin":false},"open_issues":4,"closed_issues":5,"state":"open","created_at":"2015-07-16T21:22:07Z","updated_at":"2015-07-21T10:48:04Z","due_on":"2015-07-29T22:00:00Z","closed_at":null},"comments":47,"created_at":"2015-07-09T11:32:11Z","updated_at":"2015-07-21T10:49:56Z","closed_at":null,"body":"Few users reported having this error after upgrading to 2.14.0: `Column not found: 1054 Unknown column 'log_visit.location_browser_lang' in 'field list'\"`\r\n\r\nin [this forum post](http://forum.piwik.org/read.php?2,127841) and [this one](http://forum.piwik.org/read.php?2,127838) and few other ones.\r\n\r\n\r\nThe workaround is to manually run the SQL query: `ALTER TABLE piwik_log_visit ADD COLUMN location_browser_lang VARCHAR(20) NOT NULL; `\r\n\r\nIn general, I'm wondering why some users have this problem? currently I don't understand how this could occur."},"comment":{"url":"https://api.github.com/repos/piwik/piwik/issues/comments/123260860","html_url":"https://github.com/piwik/piwik/issues/8304#issuecomment-123260860","issue_url":"https://api.github.com/repos/piwik/piwik/issues/8304","id":123260860,"user":{"login":"tsteur","id":273120,"avatar_url":"https://avatars.githubusercontent.com/u/273120?v=3","gravatar_id":"","url":"https://api.github.com/users/tsteur","html_url":"https://github.com/tsteur","followers_url":"https://api.github.com/users/tsteur/followers","following_url":"https://api.github.com/users/tsteur/following{/other_user}","gists_url":"https://api.github.com/users/tsteur/gists{/gist_id}","starred_url":"https://api.github.com/users/tsteur/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tsteur/subscriptions","organizations_url":"https://api.github.com/users/tsteur/orgs","repos_url":"https://api.github.com/users/tsteur/repos","events_url":"https://api.github.com/users/tsteur/events{/privacy}","received_events_url":"https://api.github.com/users/tsteur/received_events","type":"User","site_admin":false},"created_at":"2015-07-21T10:49:56Z","updated_at":"2015-07-21T10:49:56Z","body":"Sure thing. I issued a PR for both already"}}