SQLSTATE[42000] Error


(Seventy9) #1

Morning all,

Just arrived in the office after the weekend to be greeted by the following error from Piwik. Anyone have any ideas what is causing the problem. We haven’t done and development / upgrades on Piwik so seems a bit random;

SQLSTATE[42000]: Syntax error or access violation: 1142 INSERT,UPDATE command denied to user ‘xxx’@‘xxx.net’ for table 'piwik_option

Backtrace:
#0 /websites/LinuxPackage02/sy/ne/rg/synergystatistics.co.uk/public_html/libs/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array)
#1 /websites/LinuxPackage02/sy/ne/rg/synergystatistics.co.uk/public_html/libs/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array)
#2 /websites/LinuxPackage02/sy/ne/rg/synergystatistics.co.uk/public_html/libs/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(‘INSERT INTO pi...', Array) #3 /websites/LinuxPackage02/sy/ne/rg/synergystatistics.co.uk/public_html/core/PluginsFunctions/Sql.php(37): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTOpi…’, Array)
#4 /websites/LinuxPackage02/sy/ne/rg/synergystatistics.co.uk/public_html/core/Option.php(80): Piwik_Query()
#5 /websites/LinuxPackage02/sy/ne/rg/synergystatistics.co.uk/public_html/core/Option.php(109): Piwik_Option->set(‘INSERT INTO `pi…’, Array)
#6 /websites/LinuxPackage02/sy/ne/rg/synergystatistics.co.uk/public_html/core/UpdateCheck.php(51): Piwik_SetOption()
#7 /websites/LinuxPackage02/sy/ne/rg/synergystatistics.co.uk/public_html/plugins/CoreUpdater/CoreUpdater.php(70): Piwik_UpdateCheck::check(‘UpdateCheck_Lat…’, ‘’, 0)
#8 /websites/LinuxPackage02/sy/ne/rg/synergystatistics.co.uk/public_html/libs/Event/Dispatcher.php(284): Piwik_CoreUpdater->updateCheck(‘UpdateCheck_Lat…’, ‘’)
#9 /websites/LinuxPackage02/sy/ne/rg/synergystatistics.co.uk/public_html/core/PluginsManager.php(504): Event_Dispatcher->postNotification()
#10 /websites/LinuxPackage02/sy/ne/rg/synergystatistics.co.uk/public_html/core/FrontController.php(251): Piwik_PostEvent(Object(Piwik_Event_Notification))
#11 /websites/LinuxPackage02/sy/ne/rg/synergystatistics.co.uk/public_html/index.php(102): Piwik_FrontController->init(Array, Array)

Many thanks in advance for your assistance!

Mike


(vipsoft) #2

Check the mysql privileges for the db user.