English About Piwik translations አማርኛ Беларуская Български Català Česky Dansk Deutsch Ελληνικά English Español Eesti keel Euskara Suomi Français Galego Magyar Italiano 日本語 한국어 Lietuvių Norsk (bokmål) Nederlands Norsk Polski Português brasileiro Português Română Русский Slovensky Shqip Srpski Svenska ไทย Українська 简体中文 台灣語

Database Upgrade Required

Your Piwik database is out-of-date, and must be upgraded before you can continue.

Piwik database will be upgraded from version 0.2.9 to the new version 0.6.1.

Important note for large Piwik installations

• If you have a large Piwik database, updates might take too long to run in the browser. In this situation, you can execute the updates from your command line:
  php /homepages/22/d186548239/htdocs/piwik/index.php -- "module=CoreUpdater"
• If you are not able to use the command line updater and if Piwik fails to upgrade (due to a timeout of the database, a browser timeout, or any other issue), you could manually execute the SQL queries to update Piwik.
  › Click here to view and copy the list of SQL queries that will get executed
  
  # Note: if you manually execute these queries, it is expected that some of them fail. In this case, simply ignore the errors, and run the next ones in the list.

   CREATE TABLE `piwik_option` ( option_name VARCHAR( 64 ) NOT NULL, option_value LONGTEXT NOT NULL, autoload TINYINT NOT NULL DEFAULT '1', PRIMARY KEY ( option_name ) ) DEFAULT CHARSET=utf8 ;
   ALTER IGNORE TABLE `piwik_log_visit` CHANGE `location_provider` `location_provider` VARCHAR( 100 ) DEFAULT NULL;
   ALTER TABLE `piwik_logger_api_call` CHANGE `parameter_names_default_values` `parameter_names_default_values` TEXT, CHANGE `parameter_values` `parameter_values` TEXT, CHANGE `returned_value` `returned_value` TEXT;
   ALTER TABLE `piwik_logger_error` CHANGE `message` `message` TEXT;
   ALTER TABLE `piwik_logger_exception` CHANGE `message` `message` TEXT;
   ALTER TABLE `piwik_logger_message` CHANGE `message` `message` TEXT;
   ALTER IGNORE TABLE `piwik_site` CHANGE `feedburnerName` `feedburnerName` VARCHAR( 100 ) DEFAULT NULL;
   ALTER TABLE `piwik_site` CHANGE `ts_created` `ts_created` TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL;
   ALTER TABLE `piwik_log_visit` DROP `config_color_depth`;
   DROP INDEX index_idaction ON `piwik_log_action`;
   DROP TABLE IF EXISTS `piwik_option`;
   CREATE TABLE `piwik_option` ( option_name VARCHAR( 64 ) NOT NULL, option_value LONGTEXT NOT NULL, autoload TINYINT NOT NULL DEFAULT '1', PRIMARY KEY ( option_name ) ) DEFAULT CHARSET=utf8 ;
   CREATE INDEX index_type_name ON piwik_log_action (type, name(15));
   CREATE INDEX index_idsite_date ON piwik_log_visit (idsite, visit_server_date);
   DROP INDEX index_idsite ON piwik_log_visit;
   DROP INDEX index_visit_server_date ON piwik_log_visit;
   ALTER TABLE `piwik_log_visit` ADD `visit_goal_converted` VARCHAR( 1 ) NOT NULL AFTER `visit_total_time`;
   ALTER IGNORE TABLE `piwik_log_visit` CHANGE `visit_goal_converted` `visit_goal_converted` TINYINT(1) NOT NULL;
   CREATE TABLE `piwik_log_conversion` ( idvisit int(10) unsigned NOT NULL, idsite int(10) unsigned NOT NULL, visitor_idcookie char(32) NOT NULL, server_time datetime NOT NULL, idaction_url int(11) default NULL, idlink_va int(11) default NULL, referer_idvisit int(10) unsigned default NULL, referer_visit_server_date date default NULL, referer_type int(10) unsigned default NULL, referer_name varchar(70) default NULL, referer_keyword varchar(255) default NULL, visitor_returning tinyint(1) NOT NULL, location_country char(3) NOT NULL, location_continent char(3) NOT NULL, url text NOT NULL, idgoal int(10) unsigned NOT NULL, revenue float default NULL, PRIMARY KEY (idvisit, idgoal), INDEX index_idsite_datetime ( idsite, server_time ) ) DEFAULT CHARSET=utf8 ;
    CREATE TABLE `piwik_goal` ( `idsite` int(11) NOT NULL, `idgoal` int(11) NOT NULL, `name` varchar(50) NOT NULL, `match_attribute` varchar(20) NOT NULL, `pattern` varchar(255) NOT NULL, `pattern_type` varchar(10) NOT NULL, `case_sensitive` tinyint(4) NOT NULL, `revenue` float NOT NULL, `deleted` tinyint(4) NOT NULL default '0', PRIMARY KEY (`idsite`,`idgoal`) ) DEFAULT CHARSET=utf8 ;
   ALTER TABLE `piwik_access` CHANGE `login` `login` VARCHAR( 100 ) NOT NULL;
   ALTER TABLE `piwik_user` CHANGE `login` `login` VARCHAR( 100 ) NOT NULL;
   ALTER TABLE `piwik_user_dashboard` CHANGE `login` `login` VARCHAR( 100 ) NOT NULL;
   ALTER TABLE `piwik_user_language` CHANGE `login` `login` VARCHAR( 100 ) NOT NULL;
   ALTER TABLE `piwik_user_dashboard` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci ;
   ALTER TABLE `piwik_user_language` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci ;
   ALTER TABLE `piwik_user` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci ;
   ALTER TABLE `piwik_access` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci ;
   ALTER TABLE `piwik_site` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci ;
   ALTER TABLE `piwik_site_url` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci ;
   ALTER TABLE `piwik_goal` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci ;
   ALTER TABLE `piwik_logger_message` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci ;
   ALTER TABLE `piwik_logger_api_call` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci ;
   ALTER TABLE `piwik_logger_error` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci ;
   ALTER TABLE `piwik_logger_exception` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci ;
   ALTER TABLE `piwik_log_action` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci ;
   ALTER TABLE `piwik_log_visit` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci ;
   ALTER TABLE `piwik_log_conversion` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci ;
   ALTER TABLE `piwik_log_link_visit_action` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci ;
   ALTER TABLE `piwik_log_profiling` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci ;
   ALTER TABLE `piwik_option` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci ;
   ALTER TABLE `piwik_user_dashboard` CHANGE `layout` `layout` TEXT NOT NULL;
   DELETE FROM `piwik_user_dashboard` WHERE layout LIKE '%.getLastVisitsGraph%' OR layout LIKE '%.getLastVisitsReturningGraph%';
   UPDATE `piwik_log_visit` SET location_ip=location_ip+CAST(POW(2,32) AS UNSIGNED) WHERE location_ip < 0;
   ALTER TABLE `piwik_log_visit` CHANGE `location_ip` `location_ip` BIGINT UNSIGNED NOT NULL;
   UPDATE `piwik_logger_api_call` SET caller_ip=caller_ip+CAST(POW(2,32) AS UNSIGNED) WHERE caller_ip < 0;
   ALTER TABLE `piwik_logger_api_call` CHANGE `caller_ip` `caller_ip` BIGINT UNSIGNED;
   ALTER TABLE `piwik_log_conversion` CHANGE `idlink_va` `idlink_va` INT(11) DEFAULT NULL;
   ALTER TABLE `piwik_log_conversion` CHANGE `idaction` `idaction` INT(11) DEFAULT NULL;
   ALTER TABLE `piwik_log_visit` ADD `config_java` TINYINT(1) NOT NULL AFTER `config_flash`;
   ALTER TABLE `piwik_log_visit` ADD `config_quicktime` TINYINT(1) NOT NULL AFTER `config_director`;
   ALTER TABLE `piwik_log_visit` ADD `config_gears` TINYINT(1) NOT NULL AFTER `config_windowsmedia`, ADD `config_silverlight` TINYINT(1) NOT NULL AFTER `config_gears`;
   ALTER TABLE piwik_log_action ADD COLUMN `hash` INTEGER(10) UNSIGNED NOT NULL AFTER `name`;;
   ALTER TABLE piwik_log_visit CHANGE visit_exit_idaction visit_exit_idaction_url INTEGER(11) NOT NULL;;
   ALTER TABLE piwik_log_visit CHANGE visit_entry_idaction visit_entry_idaction_url INTEGER(11) NOT NULL;;
   ALTER TABLE piwik_log_link_visit_action CHANGE `idaction_ref` `idaction_url_ref` INTEGER(10) UNSIGNED NOT NULL;;
   ALTER TABLE piwik_log_link_visit_action CHANGE `idaction` `idaction_url` INTEGER(10) UNSIGNED NOT NULL;;
   ALTER TABLE piwik_log_link_visit_action ADD COLUMN `idaction_name` INTEGER(10) UNSIGNED AFTER `idaction_url_ref`;;
   ALTER TABLE piwik_log_conversion CHANGE `idaction` `idaction_url` INTEGER(11) UNSIGNED NOT NULL;;
   UPDATE piwik_log_action SET `hash` = CRC32(name);;
   CREATE INDEX index_type_hash ON piwik_log_action (type, hash);;
   DROP INDEX index_type_name ON piwik_log_action;;
   ALTER TABLE `piwik_log_action` CHANGE `name` `name` TEXT;
   DROP INDEX index_idsite_date ON piwik_log_visit;
   CREATE INDEX index_idsite_date_config ON piwik_log_visit (idsite, visit_server_date, config_md5config(8));
   ALTER TABLE piwik_user CHANGE date_registered date_registered TIMESTAMP NULL;
   ALTER TABLE piwik_site CHANGE ts_created ts_created TIMESTAMP NULL;
   ALTER TABLE piwik_site ADD `timezone` VARCHAR( 50 ) NOT NULL AFTER `ts_created` ;;
   UPDATE piwik_site SET `timezone` = "UTC";;
   ALTER TABLE piwik_site ADD currency CHAR( 3 ) NOT NULL AFTER `timezone` ;;
   UPDATE piwik_site SET `currency` = "USD";;
   ALTER TABLE piwik_site ADD `excluded_ips` TEXT NOT NULL AFTER `currency` ;;
   ALTER TABLE piwik_site ADD excluded_parameters VARCHAR( 255 ) NOT NULL AFTER `excluded_ips` ;;
   ALTER TABLE piwik_log_visit ADD INDEX `index_idsite_datetime_config` ( `idsite` , `visit_last_action_time` , `config_md5config` ( 8 ) ) ;;
   ALTER TABLE piwik_log_visit ADD INDEX index_idsite_idvisit (idsite, idvisit) ;;
   ALTER TABLE piwik_log_conversion DROP INDEX index_idsite_date;
   ALTER TABLE piwik_log_conversion DROP visit_server_date;;
   ALTER TABLE piwik_log_conversion ADD INDEX index_idsite_datetime ( `idsite` , `server_time` );
   UPDATE piwik_option SET option_value = "0.6-rc1" WHERE option_name = "version_core";

  
  
  

  Ready to go?

  The database upgrade process may take a while, so please be patient.