@anonymous-piwik-user opened this Issue on April 1st 2010

vipsoft,

It's a bug in the updater.

Notice: Undefined variable: infos in /srv/www/xxxx/piwik/plugins/CoreUpdater/Controller.php on line 281

Backtrace -->
#0 Piwik_ErrorHandler(8, Undefined variable: infos, /srv/www/xxxx/piwik/plugins/CoreUpdater/Controller.php, 281, Array ([=> Piwik_View Object ( =>

I was attempting to upgrade my piwik as usual via subversion.

Anyways, this crept in today. It seems to be stuck trying to alter table. Certain columns exist, then don't exist or should exist don't. I even tried to manually alter the tables per the 0.6.php update file to no luck it still wants to Core Update.

Critical Error during the update process: /piwik/core/Updates/0.6.php: Error trying to execute the query 'ALTER TABLE piwik_site ADD timezone VARCHAR( 50 ) NOT NULL AFTER ts_created ;'. The error was: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'timezone'

@anonymous-piwik-user commented on April 1st 2010

I gave it a second try and these mysql commands fixed my dev

ALTER TABLE piwik_user CHANGE date_registered date_registered TIMESTAMP NULL;
ALTER TABLE piwik_site CHANGE ts_created ts_created TIMESTAMP NULL;
UPDATE piwik_option SET option_value = "0.6" WHERE option_name = "version_core";

Shame the undefined error had to be so ugly.

@robocoder commented on April 1st 2010 Contributor

I've re-opened #41 to fix a typo in the 0.6 update script.

This Issue was closed on April 1st 2010
Powered by GitHub Issue Mirror