Opened 6 years ago

Closed 6 years ago

#225 closed Bug (invalid)

Problems with Installation Piwik 0.1.9

Reported by: rainerschwartz Owned by:
Priority: major Milestone: RobotRock
Component: Core Keywords:
Cc: Sensitive:

Description

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:

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

Change History (2)

comment:1 Changed 6 years ago by maetrus

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.

comment:2 Changed 6 years ago by matt (mattab)

  • Milestone set to RobotRock
  • Resolution set to invalid
  • Status changed from new to closed

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

Note: See TracTickets for help on using tickets.