@anonymous-piwik-user opened this Issue on December 18th 2008


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<a href='/0'>#0</a> piwik/core/Tracker/Visit.php(526): Piwik_Tracker_Db->query('INSERT INTO piw...', Array)\n<a href='/1'>#1</a> piwik/core/Tracker/Visit.php(343): Piwik_Tracker_Visit->handleNewVisit()\n
<a href='/2'>#2</a> piwik/core/Tracker.php(72): Piwik_Tracker_Visit->handle()\n
<a href='/3'>#3</a> piwik/piwik.php(46): Piwik_Tracker->main()\n
<a href='/4'>#4</a> {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.


@robocoder commented on December 28th 2008 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.)

This Issue was closed on August 20th 2010
Powered by GitHub Issue Mirror