Ticket #234 (closed Bug: invalid)

Opened 6 months ago

Last modified 6 months ago

Can not install Piwik - table creation error

Reported by: hank Assigned to:
Priority: major Milestone: RobotRock
Component: Core Version:
Keywords: Cc:

Description

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?

Change History

05/29/08 04:11:30 changed by matt

  • status changed from new to closed.
  • resolution set to invalid.
  • milestone set to RobotRock.

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.