@anonymous-piwik-user opened this issue on May 28th 2008

When I try to install piwik i get this:

a{color:red;} Uncaught exception: 'SQLSTATE[42000]: 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 'logger_exception'"

What can I do?

@mattab commented on May 29th 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 on May 29th 2008
Powered by GitHub Issue Mirror