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

Can not install Piwik - table creation error #5654

Closed
anonymous-matomo-user opened this issue May 28, 2008 · 1 comment
Closed

Can not install Piwik - table creation error #5654

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

Comments

@anonymous-matomo-user
Copy link

When I try to install piwik i get this:

```
a{color:red;} Uncaught exception: ‘SQLSTATE42000: Syntax error or access violation: 1142 INDEX command denied to user ’web88’@’localhost’ for table ’piwik_pielstickerlog_link_visit_action’’ More information In /var/www/web88/html/piwik-pielsticker/libs/Zend/Db/Statement/Pdo.php on line 227 Backtrace: #0 /var/www/web88/html/piwik-pielsticker/libs/Zend/Db/Statement.php(298): Zend_Db_Statement_Pdo→execute(Array) #1 /var/www/web88/html/piwik-pielsticker/libs/Zend/Db/Adapter/Abstract.php(269): Zend_Db_Statement→execute(Array) #2 /var/www/web88/html/piwik-pielsticker/libs/Zend/Db/Adapter/Pdo/Abstract.php(206): Zend_Db_Adapter_Abstract→query(‘CREATE INDEX in…’, Array) #3 /var/www/web88/html/piwik-pielsticker/modules/Piwik.php(956): Zend_Db_Adapter_Pdo_Abstract→query(‘CREATE INDEX in…’) #4 /var/www/web88/html/piwik-pielsticker/plugins/Installation/Controller.php(193): Piwik::createTablesIndex() #5 /var/www/web88/html/piwik-pielsticker/plugins/Installation/Installation.php(66): Piwik_Installation_Controller→tablesCreation() #6 [internal function]: Piwik_Installation→startInstallation(Object(Event_Notification)) #7 /var/www/web88/html/piwik-pielsticker/libs/Event/Dispatcher.php(214): call_user_func_array(Array, Array) #8 /var/www/web88/html/piwik-pielsticker/modules/PluginsManager.php(400): Event_Dispatcher→addObserver(Array, ‘FrontController…’) #9 /var/www/web88/html/piwik-pielsticker/modules/PluginsManager.php(314): Piwik_PluginsManager→addPluginObservers(Object(Piwik_Installation)) #10 /var/www/web88/html/piwik-pielsticker/modules/PluginsManager.php(240): Piwik_PluginsManager→loadPlugins() #11 /var/www/web88/html/piwik-pielsticker/modules/Piwik.php(401): Piwik_PluginsManager→setPluginsToLoad(Array) #12 /var/www/web88/html/piwik-pielsticker/modules/FrontController.php(308): Piwik::loadPlugins() #13 /var/www/web88/html/piwik-pielsticker/index.php(51): Piwik_FrontController→init() #14 {main}document.getElementById(‘div2270252’).style.display=‘none’; 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 ’loggerexception’"
```

What can I do?

@mattab
Copy link
Member

mattab commented May 29, 2008

It is not a Piwik bug: your Mysql user should have permissions to create INDEX on your mysql tables.
If you don’t know what that means, you should request these permissions to your system adminitrator.

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