Automatically upgraded to 2.14.0. No error reported during app and database upgrade.
New Dashboard shows SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘log_visit.location_browser_lang’ in ‘field list’" in Keywords, Visits Over Time, Search Engines, Referrer Websites, Operating System versions widgets, and “There is no data for this report” in Visitor Map widget. The browser and OS icons shows white squares next to a working flag under Visitors in Real-time widget. The SEO Rakings widget is the only one not showing any apparent error.
If set to 1 day, Visitors > Overview shows many lines of [i]“WARNING: /[path]/htdocs/piwik/plugins/UserLanguage/Visitor.php(29): Notice - Undefined index: location_browser_lang - Piwik 2.14.0…”[i], also “config_browser_version” and “config_os”.
All under one long red text error of [i]“ERROR: Failed to get data from API: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘log_visit.location_browser_lang’ in ‘field list’ #0 /[path]/piwik/libs/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array) #1 /[path]/piwik/libs/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array) #2 /[path]/piwik/libs/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(’\n\t\t\tSELECT\n\t\t\t\t…’, Array)…[snip]”
If set to longer periods, Visitors > Overview shows “Oops… there was a problem during the request. Maybe the server had a temporary issue, or maybe you requested a report with too much data. Please try again. If this error occurs repeatedly please contact your Piwik administrator for assistance.”
Visitors > Visitor Log shows working list other than blank OS and browser icons. Hovering over those shows unknown OS and browser but browser engines are still identified.
Virtually all other pages show "SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘log_visit.location_browser_lang’ in ‘field list’ " errors.
I don’t think Piwik is tracking any view visits.
Did not manually backup database prior to upgrade.
I have the same problem here, I’ve tried disabling/re-enabling UserLanguage plugin without success…
New version of piwik should really be much more tested, that’s not the first time an upgrade fail for me while I just use the stock version without any customization or using advanced features, that’s really annoying.
Update from 2.8 to 2.14 report some errors with the console core:archive.
First ‘log_visit.location_browser_lang’ was missing, have done an ALTER, and now…
Missing : 'log_visit.config_os’
And then : ‘log_visit.config_browser_name’
Where does those fields came from ?
I tried to reactive the plugin DeviceDetection but it does nothing on table update…
After disabling UserLanguage plugin, various widgets shows "SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘log_visit.config_os’ in ‘field list’ ".
After reactivating the plugin, various widgets returns to showing "SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘log_visit.location_browser_lang’ in ‘field list’ ".
Thank you. I note that the bug reports refers to the “location_browser_lang” problem specifically. As I mentioned in my original post other similar erros include at least “config_browser_version” and “config_os”. Should seperate bug reports be filed for each?
[ul]
[li]Applied workaround. 301 Moved Permanently
[/li][li]Deactivated/reactivated userLanguage plugin.
[/li][li]No more obvious database error.
[/li][li]Visitors > Visitor Log error remains. Log shows working list but blank OS and browser icons. Hovering over those shows unknown OS and browser but browser engines are still identified.
[/li][li]Still not tracking new visits. Last visitor entry just before upgrade. New test visits not showing.
[/li][/ul]
Apologies. It appears to have been tracking visitors since applying the workaround. Perhaps the host’s caching web servers cannot deliver results in real-time.
For entries before the update to 2.14, Visitors > Visitor Log shows blank OS and browser icons, which when hovered over show unknown OS and browser but browser engines are still identified.
New visitors entries since the applying the workaround show full set of icons.
in our case a phpmyadmin fix, where “stat” needs to be replaced by your DB table prefix
1 Go to your MySQL database (for example with phpmyadmin)
2. Click the SQL tab or SQL command button
3. Copy paste the code below in the text field
4. Click start/run/execute
ALTER TABLE stat_log_visit ADD COLUMN location_browser_lang VARCHAR(20) NOT NULL;
ALTER TABLE stat_log_visit ADD COLUMN config_os char(3) NOT NULL;
ALTER TABLE stat_log_visit ADD COLUMN config_browser_name varchar(10) NOT NULL;
ALTER TABLE stat_log_visit ADD COLUMN config_browser_version varchar(20) NOT NULL;
ALTER TABLE stat_log_visit ADD COLUMN config_resolution varchar(9) NOT NULL;
ALTER TABLE stat_log_visit ADD COLUMN config_pdf tinyint(1) NOT NULL;
ALTER TABLE stat_log_visit ADD COLUMN config_flash tinyint(1) NOT NULL;
ALTER TABLE stat_log_visit ADD COLUMN config_director tinyint(1) NOT NULL;
ALTER TABLE stat_log_visit ADD COLUMN config_quicktime tinyint(1) NOT NULL;
ALTER TABLE stat_log_visit ADD COLUMN config_realplayer tinyint(1) NOT NULL;
ALTER TABLE stat_log_visit ADD COLUMN config_windowsmedia tinyint(1) NOT NULL;
ALTER TABLE stat_log_visit ADD COLUMN config_gears tinyint(1) NOT NULL;
ALTER TABLE stat_log_visit ADD COLUMN config_silverlight tinyint(1) NOT NULL;
ALTER TABLE stat_log_visit ADD COLUMN config_java tinyint(1) NOT NULL;
ALTER TABLE stat_log_visit ADD COLUMN config_cookie tinyint(1) NOT NULL;