Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error on Core Update #1266

Closed
anonymous-matomo-user opened this issue Apr 1, 2010 · 2 comments
Closed

Error on Core Update #1266

anonymous-matomo-user opened this issue Apr 1, 2010 · 2 comments
Labels
Bug For errors / faults / flaws / inconsistencies etc. Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical. wontfix If you can reproduce this issue, please reopen the issue or create a new one describing it.
Milestone

Comments

@anonymous-matomo-user
Copy link

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-matomo-user
Copy link
Author

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
Copy link
Contributor

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

@anonymous-matomo-user anonymous-matomo-user added this to the Piwik 0.6 milestone Jul 8, 2014
@mattab mattab added the wontfix label Aug 3, 2014
This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug For errors / faults / flaws / inconsistencies etc. Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical. wontfix If you can reproduce this issue, please reopen the issue or create a new one describing it.
Projects
None yet
Development

No branches or pull requests

3 participants