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

Jump to bottom

Provider Core-Plugin SQLSTATE[42S22] #478

Closed
anonymous-matomo-user opened this issue Dec 18, 2008 · 1 comment
Closed

Provider Core-Plugin SQLSTATE[42S22] #478

anonymous-matomo-user opened this issue Dec 18, 2008 · 1 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.
Milestone
0.9.9

Comments

@anonymous-matomo-user
Copy link

Hey,

I just installed piwik and it didn’t work the whole day, so I browsed the logs and found this (it’s 0.2.26):

```
PHP Fatal error: Uncaught exception ‘Exception’ with message ‘Error query: SQLSTATE[42S22]:
Column not found: 1054 Unknown column ’location_provider’ in ‘field list’’ in piwik/core/Tracker/Db.php:204\n
Stack trace:\n#0 piwik/core/Tracker/Visit.php(526): Piwik_Tracker_Db→query(‘INSERT INTO piw…’, Array)\n#1 piwik/core/Tracker/Visit.php(343): Piwik_Tracker_Visit→handleNewVisit()\n

  1. piwik/core/Tracker.php(72): Piwik_Tracker_Visit→handle()\n
  2. piwik/piwik.php(46): Piwik_Tracker→main()\n
  3. {main}\n thrown in piwik/core/Tracker/Db.php on line 204

```

The installation went fine and I got no error messages. After disabling the Provider Plugin it works how it should.

maxstein
@robocoder
Copy link
Contributor

Your database user doesn’t have ALTER privileges. (During installation, the Provider plugin silently alters the log_visit table to add a location_provider column.)

@anonymous-matomo-user anonymous-matomo-user added this to the Piwik 0.9.9 - Stable release milestone Jul 8, 2014
Closed
@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
Assignees
No one assigned
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
Milestone
0.9.9
Development

No branches or pull requests
3 participants
@mattab @robocoder @anonymous-matomo-user