When looking at data from the past piwik seems to work fine. When I set it to “today” I get these in various boxes:
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘visit.visit_server_date’ in ‘where clause’
Unexpected data type to render.
There is no data for this report.
I followed the instructions here:
http://forum.piwik.org/read.php?2,72767,page=1#msg-72790
Note that I did not experience a browser timeout nor did I “double click” the upgrade. The upgrade db script failed. Here is the manual run of the SQL scripts:
mysql> ALTER TABLE piwik_log_visit
DROP visit_server_date
, DROP INDEX index_idsite_date_config
, DROP INDEX index_idsite_datetime_config
, ADD visit_entry_idaction_name
INT UNSIGNED NOT NULL AFTER visit_entry_idaction_url
, ADD visit_exit_idaction_name
INT UNSIGNED NOT NULL AFTER visit_exit_idaction_url
, CHANGE visit_exit_idaction_url
visit_exit_idaction_url
INT UNSIGNED NOT NULL, CHANGE visit_entry_idaction_url
visit_entry_idaction_url
INT UNSIGNED NOT NULL, CHANGE referer_type
referer_type
TINYINT UNSIGNED NULL DEFAULT NULL, ADD idvisitor
BINARY(8) NOT NULL AFTER idsite
, ADD visitor_count_visits SMALLINT(5) UNSIGNED NOT NULL AFTER visitor_returning
, ADD visitor_days_since_last SMALLINT(5) UNSIGNED NOT NULL, ADD visitor_days_since_first SMALLINT(5) UNSIGNED NOT NULL, ADD config_id
BINARY(8) NOT NULL AFTER config_md5config
, ADD custom_var_k1 VARCHAR(50) DEFAULT NULL, ADD custom_var_v1 VARCHAR(50) DEFAULT NULL, ADD custom_var_k2 VARCHAR(50) DEFAULT NULL, ADD custom_var_v2 VARCHAR(50) DEFAULT NULL, ADD custom_var_k3 VARCHAR(50) DEFAULT NULL, ADD custom_var_v3 VARCHAR(50) DEFAULT NULL, ADD custom_var_k4 VARCHAR(50) DEFAULT NULL, ADD custom_var_v4 VARCHAR(50) DEFAULT NULL, ADD custom_var_k5 VARCHAR(50) DEFAULT NULL, ADD custom_var_v5 VARCHAR(50) DEFAULT NULL ;
ERROR 1054 (42S22): Unknown column ‘config_md5config’ in 'piwik_log_visit’
mysql> ALTER IGNORE TABLE piwik_log_visit
DROP visit_server_date
, DROP INDEX index_idsite_date_config
, DROP INDEX index_idsite_datetime_config
, ADD visit_entry_idaction_name
INT UNSIGNED NOT NULL AFTER visit_entry_idaction_url
, ADD visit_exit_idaction_name
INT UNSIGNED NOT NULL AFTER visit_exit_idaction_url
, CHANGE visit_exit_idaction_url
visit_exit_idaction_url
INT UNSIGNED NOT NULL, CHANGE visit_entry_idaction_url
visit_entry_idaction_url
INT UNSIGNED NOT NULL, CHANGE referer_type
referer_type
TINYINT UNSIGNED NULL DEFAULT NULL, ADD idvisitor
BINARY(8) NOT NULL AFTER idsite
, ADD visitor_count_visits SMALLINT(5) UNSIGNED NOT NULL AFTER visitor_returning
, ADD visitor_days_since_last SMALLINT(5) UNSIGNED NOT NULL, ADD visitor_days_since_first SMALLINT(5) UNSIGNED NOT NULL, ADD config_id
BINARY(8) NOT NULL AFTER config_md5config
, ADD custom_var_k1 VARCHAR(50) DEFAULT NULL, ADD custom_var_v1 VARCHAR(50) DEFAULT NULL, ADD custom_var_k2 VARCHAR(50) DEFAULT NULL, ADD custom_var_v2 VARCHAR(50) DEFAULT NULL, ADD custom_var_k3 VARCHAR(50) DEFAULT NULL, ADD custom_var_v3 VARCHAR(50) DEFAULT NULL, ADD custom_var_k4 VARCHAR(50) DEFAULT NULL, ADD custom_var_v4 VARCHAR(50) DEFAULT NULL, ADD custom_var_k5 VARCHAR(50) DEFAULT NULL, ADD custom_var_v5 VARCHAR(50) DEFAULT NULL ;
ERROR 1054 (42S22): Unknown column ‘config_md5config’ in 'piwik_log_visit’
mysql> ALTER TABLE piwik_log_link_visit_action
ADD idsite
INT( 10 ) UNSIGNED NOT NULL AFTER idlink_va
, ADD server_time
DATETIME NOT NULL AFTER idsite
, ADD idvisitor
BINARY(8) NOT NULL AFTER idsite
, ADD idaction_name_ref
INT UNSIGNED NOT NULL AFTER idaction_name
, ADD INDEX index_idsite_servertime
( idsite
, server_time
) ;
ERROR 1060 (42S21): Duplicate column name 'idsite’
mysql> ALTER IGNORE TABLE piwik_log_link_visit_action
ADD idsite
INT( 10 ) UNSIGNED NOT NULL AFTER idlink_va
, ADD server_time
DATETIME NOT NULL AFTER idsite
, ADD idvisitor
BINARY(8) NOT NULL AFTER idsite
, ADD idaction_name_ref
INT UNSIGNED NOT NULL AFTER idaction_name
, ADD INDEX index_idsite_servertime
( idsite
, server_time
) ;
ERROR 1060 (42S21): Duplicate column name 'idsite’
mysql> ALTER TABLE piwik_log_conversion
DROP referer_idvisit
, ADD idvisitor
BINARY(8) NOT NULL AFTER idsite
, ADD visitor_count_visits SMALLINT(5) UNSIGNED NOT NULL, ADD visitor_days_since_first SMALLINT(5) UNSIGNED NOT NULL, ADD custom_var_k1 VARCHAR(50) DEFAULT NULL, ADD custom_var_v1 VARCHAR(50) DEFAULT NULL, ADD custom_var_k2 VARCHAR(50) DEFAULT NULL, ADD custom_var_v2 VARCHAR(50) DEFAULT NULL, ADD custom_var_k3 VARCHAR(50) DEFAULT NULL, ADD custom_var_v3 VARCHAR(50) DEFAULT NULL, ADD custom_var_k4 VARCHAR(50) DEFAULT NULL, ADD custom_var_v4 VARCHAR(50) DEFAULT NULL, ADD custom_var_k5 VARCHAR(50) DEFAULT NULL, ADD custom_var_v5 VARCHAR(50) DEFAULT NULL ;
ERROR 1091 (42000): Can’t DROP ‘referer_idvisit’; check that column/key exists
mysql> UPDATE piwik_log_visit SET idvisitor = binary(unhex(substring(visitor_idcookie,1,16))), config_id = binary(unhex(substring(config_md5config,1,16))) ;
ERROR 1054 (42S22): Unknown column ‘visitor_idcookie’ in 'field list’
mysql> UPDATE piwik_log_conversion SET idvisitor = binary(unhex(substring(visitor_idcookie,1,16))) ;
ERROR 1054 (42S22): Unknown column ‘visitor_idcookie’ in 'field list’
mysql> ALTER TABLE piwik_log_visit
DROP visitor_idcookie, DROP config_md5config ;
ERROR 1091 (42000): Can’t DROP ‘visitor_idcookie’; check that column/key exists
mysql> ALTER TABLE piwik_log_conversion
DROP visitor_idcookie ;
ERROR 1091 (42000): Can’t DROP ‘visitor_idcookie’; check that column/key exists
mysql> ALTER TABLE piwik_log_visit
ADD INDEX index_idsite_datetime_config
(idsite, visit_last_action_time, config_id) ;
ERROR 1061 (42000): Duplicate key name 'index_idsite_datetime_config’
mysql> UPDATE piwik_log_link_visit_action as action, piwik_log_visit as visit SET action.idsite = visit.idsite, action.server_time = visit.visit_last_action_time, action.idvisitor = visit.idvisitor WHERE action.idvisit=visit.idvisit ;
Query OK, 2 rows affected (0.58 sec)
Rows matched: 235742 Changed: 2 Warnings: 0
mysql> ALTER TABLE piwik_option
ADD INDEX ( autoload
) ;
Query OK, 65 rows affected (0.01 sec)
Records: 65 Duplicates: 0 Warnings: 0
mysql> ALTER TABLE piwik_site
ADD group
VARCHAR( 250 ) NOT NULL;
ERROR 1060 (42S21): Duplicate column name 'group’
mysql> UPDATE piwik_option SET option_value = “1.2-rc2” WHERE option_name = “version_core”;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0