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

Problems with Installation Piwik 0.1.9 #5645

Closed
anonymous-matomo-user opened this issue May 17, 2008 · 2 comments
Closed

Problems with Installation Piwik 0.1.9 #5645

anonymous-matomo-user opened this issue May 17, 2008 · 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

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

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

mattab commented May 24, 2008

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

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

2 participants