{"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"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-07-09T11:32:11Z","updated_at":"2015-07-09T11:44:05Z","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/119924204","html_url":"https://github.com/piwik/piwik/issues/8304#issuecomment-119924204","issue_url":"https://api.github.com/repos/piwik/piwik/issues/8304","id":119924204,"user":{"login":"chriscroome","id":1788560,"avatar_url":"https://avatars.githubusercontent.com/u/1788560?v=3","gravatar_id":"","url":"https://api.github.com/users/chriscroome","html_url":"https://github.com/chriscroome","followers_url":"https://api.github.com/users/chriscroome/followers","following_url":"https://api.github.com/users/chriscroome/following{/other_user}","gists_url":"https://api.github.com/users/chriscroome/gists{/gist_id}","starred_url":"https://api.github.com/users/chriscroome/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chriscroome/subscriptions","organizations_url":"https://api.github.com/users/chriscroome/orgs","repos_url":"https://api.github.com/users/chriscroome/repos","events_url":"https://api.github.com/users/chriscroome/events{/privacy}","received_events_url":"https://api.github.com/users/chriscroome/received_events","type":"User","site_admin":false},"created_at":"2015-07-09T11:44:05Z","updated_at":"2015-07-09T11:44:05Z","body":"I have also found [http://forum.piwik.org/read.php?8,127828,127828](this forum post), I tried posting a follow up there but got this error message:\r\n\r\n> Les informations que vous avez envoy�es ont �t� rejet�es, parce qu'elles semblent envoy�es par un robot d'envois automatiques. Si votre navigateur n'a pas de javascript, ou s'il est d�sactiv�, cela peut-�tre la raison de l'�chec. Le Javavascript doit �tre activ� pour que ce formulaire fonctionne.\r\n\r\nI have green ticks for everything in the System Check, the error message via cron, recieved soon after the upgrade to 2.14.0:\r\n\r\n    ERROR CoreConsole[2015-07-09 11:05:07] Got invalid response from API request: ?module=API&method=API.get&idSite=1&period=day&date=last52&format=php&trigger=archivephp. Response was 'a:2:{s:6:\"result\";s:5:\"error\";s:7:\"message\";s:104:\"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'log_visit.location_browser_lang' in 'field list'\";}'\r\n    ERROR CoreConsole[2015-07-09 11:05:07] Empty or invalid response '' for website id 1, Time elapsed: 2.943s, skipping\r\n    ERROR CoreConsole[2015-07-09 11:05:09] Got invalid response from API request: ?module=API&method=API.get&idSite=11&period=day&date=last52&format=php&trigger=archivephp. Response was 'a:2:{s:6:\"result\";s:5:\"error\";s:7:\"message\";s:104:\"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'log_visit.location_browser_lang' in 'field list'\";}'\r\n    ERROR CoreConsole[2015-07-09 11:05:09] Empty or invalid response '' for website id 11, Time elapsed: 2.274s, skipping\r\n    ERROR CoreConsole[2015-07-09 11:05:09] 4 total errors during this script execution, please investigate and try and fix these errors.\r\n    \r\n    \r\n    \r\n      [Exception]\r\n      4 total errors during this script execution, please investigate and try and fix these errors.\r\n    \r\n    \r\n    \r\n    core:archive [--url=\"...\"] [--force-all-websites] [--force-all-periods[=\"...\"]] [--force-timeout-for-periods[=\"...\"]] [--skip-idsites[=\"...\"]] [--skip-all-segments] [--force-idsites[=\"...\"]] [--force-periods[=\"...\"]] [--force-date-last-n=\"...\"] [--force-date-range[=\"...\"]] [--force-idsegments=\"...\"] [--concurrent-requests-per-website[=\"...\"]] [--disable-scheduled-tasks] [--accept-invalid-ssl-certificate]\r\n\r\nThe steps I followed doing the upgrade are [https://trac.transitionnetwork.org/trac/ticket/861#comment:1](documented here)."}}