@anonymous-piwik-user opened this Issue on May 17th 2008

Hello,

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

Uncaught exception: 'SQLSTATE[42000]: 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:

<a href='/0'>#0</a> /var/www/web0/html/cms/piwik/libs/Zend/Db/Statement.php(298): Zend_Db_Statement_Pdo->_execute(Array)
<a href='/1'>#1</a> /var/www/web0/html/cms/piwik/libs/Zend/Db/Adapter/Abstract.php(269): Zend_Db_Statement->execute(Array)
<a href='/2'>#2</a> /var/www/web0/html/cms/piwik/libs/Zend/Db/Adapter/Pdo/Abstract.php(206): Zend_Db_Adapter_Abstract->query('CREATE INDEX in...', Array)
<a href='/3'>#3</a> /var/www/web0/html/cms/piwik/modules/Piwik.php(951): Zend_Db_Adapter_Pdo_Abstract->query('CREATE INDEX in...')
<a href='/4'>#4</a> /var/www/web0/html/cms/piwik/plugins/Installation/Controller.php(193): Piwik::createTablesIndex()
<a href='/5'>#5</a> /var/www/web0/html/cms/piwik/plugins/Installation/Installation.php(66): Piwik_Installation_Controller->tablesCreation()
<a href='/6'>#6</a> /var/www/web0/html/cms/piwik/libs/Event/Dispatcher.php(214): Piwik_Installation->startInstallation(Object(Event_Notification))
<a href='/7'>#7</a> /var/www/web0/html/cms/piwik/modules/PluginsManager.php(400): Event_Dispatcher->addObserver(Array, Array)
<a href='/8'>#8</a> /var/www/web0/html/cms/piwik/modules/PluginsManager.php(314): Piwik_PluginsManager->addPluginObservers(Array, 'FrontController...')
<a href='/9'>#9</a> /var/www/web0/html/cms/piwik/modules/PluginsManager.php(240): Piwik_PluginsManager->loadPlugins(Object(Piwik_Installation))
<a href='/10'>#10</a> /var/www/web0/html/cms/piwik/modules/Piwik.php(396): Piwik_PluginsManager->setPluginsToLoad()
<a href='/11'>#11</a> /var/www/web0/html/cms/piwik/modules/FrontController.php(308): Piwik::loadPlugins(Array)
<a href='/12'>#12</a> /var/www/web0/html/cms/piwik/index.php(51): Piwik_FrontController->init()
<a href='/13'>#13</a> {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 commented on May 17th 2008

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 commented on May 24th 2008 Owner

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

This Issue was closed on May 24th 2008
Powered by GitHub Issue Mirror