I was attempting to upgrade my piwik installation as usual via subversion as I have been quite successful with this method for almost a year. Great code quality control.
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:
Error trying to execute the query 'ALTER TABLE piwik_site ADD
timezone VARCHAR( 50 ) NOT NULL AFTER
The error was: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'timezone'
Piwik's svn trunk is for active development. "svn up" should not be used as an update source for a production site because at any given time, the trunk could be broken, unstable, or subject to change without notice.
Anthon, is it possible to use RC1, RC2 update package? I think I'll try that next time. It would allow anyone plugged in SVN to upgrade without hurdle.