Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP

Loading…

Problems with Installation Piwik 0.1.9 #5645

Closed
anonymous-piwik-user opened this Issue · 2 comments

2 participants

@anonymous-piwik-user

Hello,

we have Problems with the Installation of Piwik 0.1.9. We get this Error:

``` Uncaught exception: ‘SQLSTATE42000: Syntax error or access violation: 1142 INDEX command denied to user ’web0’@’localhost’ for table ’piwik_log_link_visit_action’’ More information

In /var/www/web0/html/cms/piwik/libs/Zend/Db/Statement/Pdo.php on line 227 Backtrace:

  1. /var/www/web0/html/cms/piwik/libs/Zend/Db/Statement.php(298): Zend_Db_Statement_Pdo→_execute(Array)
  2. /var/www/web0/html/cms/piwik/libs/Zend/Db/Adapter/Abstract.php(269): Zend_Db_Statement→execute(Array)
  3. /var/www/web0/html/cms/piwik/libs/Zend/Db/Adapter/Pdo/Abstract.php(206): Zend_Db_Adapter_Abstract→query(‘CREATE INDEX in…’, Array)
  4. /var/www/web0/html/cms/piwik/modules/Piwik.php(951): Zend_Db_Adapter_Pdo_Abstract→query(‘CREATE INDEX in…’)
  5. /var/www/web0/html/cms/piwik/plugins/Installation/Controller.php(193): Piwik::createTablesIndex()
  6. /var/www/web0/html/cms/piwik/plugins/Installation/Installation.php(66): Piwik_Installation_Controller→tablesCreation()
  7. /var/www/web0/html/cms/piwik/libs/Event/Dispatcher.php(214): Piwik_Installation→startInstallation(Object(Event_Notification))
  8. /var/www/web0/html/cms/piwik/modules/PluginsManager.php(400): Event_Dispatcher→addObserver(Array, Array)
  9. /var/www/web0/html/cms/piwik/modules/PluginsManager.php(314): Piwik_PluginsManager→addPluginObservers(Array, ‘FrontController…’)
  10. /var/www/web0/html/cms/piwik/modules/PluginsManager.php(240): Piwik_PluginsManager→loadPlugins(Object(Piwik_Installation))
  11. /var/www/web0/html/cms/piwik/modules/Piwik.php(396): Piwik_PluginsManager→setPluginsToLoad()
  12. /var/www/web0/html/cms/piwik/modules/FrontController.php(308): Piwik::loadPlugins(Array)
  13. /var/www/web0/html/cms/piwik/index.php(51): Piwik_FrontController→init()
  14. {main}

You can get help from http://piwik.org (give us the full error message + your PHP and Mysql version)

And this exception raised another exception “No entry is registered for key ‘logger_exception’” ```

PHP Version 5 and MySQL 5.0.32 on Debian

Do you have any ideas?

Thanks

@anonymous-piwik-user

Your error message:

Syntax error or access violation: 1142 INDEX command denied to user ’web0’@’localhost’ for table ’piwik_log_link_visit_action

The user have not enough rights.

@mattab
Owner

This is not a piwik bug. Your mysql user should have correct permissions to create tables, index, etc.

@anonymous-piwik-user anonymous-piwik-user added this to the RobotRock milestone
@mattab mattab added the wontfix label
This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.