Upgrade to 2.14.0 and then 2.14.1 does not track visitors

Support & Bugs
1

Hi all:

Piwik is broken.

After the last two upgrades nothing is being tracked. No errors logged that I can find, the ALTER TABLE work around was tried but does not work:


mysql> ALTER TABLE piwik_log_visit ADD COLUMN location_browser_lang VARCHAR(20) NOT NULL; 
ERROR 1060 (42S21): Duplicate column name 'location_browser_lang'
mysql> ALTER TABLE piwik_log_visit ADD COLUMN config_os char(3) NOT NULL; 
ERROR 1060 (42S21): Duplicate column name 'config_os'
mysql> ALTER TABLE piwik_log_visit ADD COLUMN config_browser_name varchar(10) NOT NULL; 
ERROR 1060 (42S21): Duplicate column name 'config_browser_name'
mysql> ALTER TABLE piwik_log_visit ADD COLUMN config_browser_version varchar(20) NOT NULL; 
ERROR 1060 (42S21): Duplicate column name 'config_browser_version'
mysql> ALTER TABLE piwik_log_visit ADD COLUMN config_resolution varchar(9) NOT NULL; 
ERROR 1060 (42S21): Duplicate column name 'config_resolution'
mysql> ALTER TABLE piwik_log_visit ADD COLUMN config_pdf tinyint(1) NOT NULL; 
ERROR 1060 (42S21): Duplicate column name 'config_pdf'
mysql> ALTER TABLE piwik_log_visit ADD COLUMN config_flash tinyint(1) NOT NULL; 
ERROR 1060 (42S21): Duplicate column name 'config_flash'
mysql> ALTER TABLE piwik_log_visit ADD COLUMN config_director tinyint(1) NOT NULL; 
ERROR 1060 (42S21): Duplicate column name 'config_director'
mysql> ALTER TABLE piwik_log_visit ADD COLUMN config_quicktime tinyint(1) NOT NULL; 
ERROR 1060 (42S21): Duplicate column name 'config_quicktime'
mysql> ALTER TABLE piwik_log_visit ADD COLUMN config_realplayer tinyint(1) NOT NULL; 
ERROR 1060 (42S21): Duplicate column name 'config_realplayer'
mysql> ALTER TABLE piwik_log_visit ADD COLUMN config_windowsmedia tinyint(1) NOT NULL; 
ERROR 1060 (42S21): Duplicate column name 'config_windowsmedia'
mysql> ALTER TABLE piwik_log_visit ADD COLUMN config_gears tinyint(1) NOT NULL; 
ERROR 1060 (42S21): Duplicate column name 'config_gears'
mysql> ALTER TABLE piwik_log_visit ADD COLUMN config_silverlight tinyint(1) NOT NULL; 
ERROR 1060 (42S21): Duplicate column name 'config_silverlight'
mysql> ALTER TABLE piwik_log_visit ADD COLUMN config_java tinyint(1) NOT NULL; 
ERROR 1060 (42S21): Duplicate column name 'config_java'
mysql> ALTER TABLE piwik_log_visit ADD COLUMN location_browser_lang VARCHAR(20) NOT NULL;
ERROR 1060 (42S21): Duplicate column name 'location_browser_lang'

What is the fix? Any ideas/news?

Bruce

2

Interestingly, after clearing the Global list of Excluded IPs SOME, but not all visits are tracked.

e.g. iPhone browsing on AT&T cellular registered but a Windows laptop from a Fortune 100 company network didn’t.

Bruce