[quote=matt]
Alain, you have missed some queries, in particular you should have seen the query:
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[/quote]
Piwik-upgrade only write what you report over there on April 18, 2011 06:26AM :
[quote=matt]
ignore the very first DROP index_idsite_date_config and leave the rest, so as follows
ALTER DATABASE `askfrank_piwik` DEFAULT CHARACTER SET utf8;
ALTER TABLE `piwik_log_visit` DROP INDEX index_idsite_idvisit, ADD INDEX index_idsite_config_datetime (idsite, config_id, visit_last_action_time), ADD INDEX index_idsite_datetime (idsite, visit_last_action_time);
ALTER TABLE `piwik_goal` ADD `allow_multiple` tinyint(4) NOT NULL AFTER case_sensitive;
ALTER TABLE `piwik_log_conversion` ADD buster int unsigned NOT NULL AFTER revenue, DROP PRIMARY KEY, ADD PRIMARY KEY (idvisit, idgoal, buster);
ALTER TABLE `piwik_log_visit` ADD INDEX index_idsite_idvisitor (idsite, idvisitor);
UPDATE `piwik_option` SET option_value = "1.2.5-rc7" WHERE option_name = "version_core";
if you get an error for the next bit, then do it again (remove just this bit) and try again, until all bits have been executed and you can be sure that the update was done cleanly.
Next time, consider running the update in the Console shell or make sure you don’t click twice on the button Update.[/quote]
So I only try this with tie error that I mentionned. But if you say so, I will try.