错误的信息如下:[code]Error:
SQLSTATE[42000]: Syntax error or access violation: 1044 Access denied for user ‘statistics’@‘—’ to database ‘statistics’
Backtrace:
#0 /home/siti/www.—.com/—.com/htdocs/statistics/core/PluginsFunctions/Sql.php(51): Zend_Db_Adapter_Pdo_Abstract->exec(‘LOCK TABLES piw…’)
#1 /home/siti/www.—.com/—.com/htdocs/statistics/core/PluginsFunctions/Sql.php(205): Piwik_Sql::exec(‘LOCK TABLES piw…’)
#2 /home/siti/www.—.com/—.com/htdocs/statistics/core/PluginsFunctions/Sql.php(359): Piwik_Sql::lockTables(‘piwik_archive_n…’, ‘piwik_archive_n…’)
#3 /home/siti/www.—.com/—.com/htdocs/statistics/core/ArchiveProcessing.php(688): Piwik_LockTables(‘piwik_archive_n…’, ‘piwik_archive_n…’)
#4 /home/siti/www.—.com/—.com/htdocs/statistics/core/ArchiveProcessing.php(533): Piwik_ArchiveProcessing->loadNextIdarchive()
#5 /home/siti/www.—.com/—.com/htdocs/statistics/core/ArchiveProcessing/Period.php(230): Piwik_ArchiveProcessing->initCompute()
#6 /home/siti/www.—.com/—.com/htdocs/statistics/core/ArchiveProcessing.php(472): Piwik_ArchiveProcessing_Period->initCompute()
#7 /home/siti/www.—.com/—.com/htdocs/statistics/core/Archive/Single.php(226): Piwik_ArchiveProcessing->launchArchiving()
#8 /home/siti/www.—.com/—.com/htdocs/statistics/core/Archive/Single.php(256): Piwik_Archive_Single->prepareArchive()
#9 /home/siti/www.—.com/—.com/htdocs/statistics/core/Archive/Single.php(446): Piwik_Archive_Single->get(‘UserCountry_dis…’, ‘numeric’)
#10 /home/siti/www.—.com/—.com/htdocs/statistics/core/Archive/Single.php(489): Piwik_Archive_Single->getNumeric(‘UserCountry_dis…’)
#11 /home/siti/www.—.com/—.com/htdocs/statistics/plugins/UserCountry/API.php(68): Piwik_Archive_Single->getDataTableFromNumeric(‘UserCountry_dis…’)
#12 [internal function]: Piwik_UserCountry_API->getNumberOfDistinctCountries(‘1’, ‘range’, ‘2012-01-22,2012…’, false)
#13 /home/siti/www.—.com/—.com/htdocs/statistics/core/API/Proxy.php(190): call_user_func_array(Array, Array)
#14 /home/siti/www.—.com/—.com/htdocs/statistics/core/API/Request.php(128): Piwik_API_Proxy->call(‘Piwik_UserCount…’, ‘getNumberOfDist…’, Array)
#15 /home/siti/www.—.com/—.com/htdocs/statistics/core/Controller.php(347): Piwik_API_Request->process()
#16 /home/siti/www.—.com/—.com/htdocs/statistics/plugins/UserCountry/Controller.php(67): Piwik_Controller->getNumericValue(‘UserCountry.get…’)
#17 /home/siti/www.—.com/—.com/htdocs/statistics/plugins/UserCountry/Controller.php(24): Piwik_UserCountry_Controller->getNumberOfDistinctCountries(true)
#18 [internal function]: Piwik_UserCountry_Controller->index()
#19 /home/siti/www.—.com/—.com/htdocs/statistics/core/FrontController.php(138): call_user_func_array(Array, Array)
#20 /home/siti/www.—.com/—.com/htdocs/statistics/index.php(53): Piwik_FrontController->dispatch()
#21 {main} [/code]错误的原因是 Piwik 1.8 版本需要用户具有 LOCK TABLES 的权限(锁表权限)。
通过后台管理,把用户赋予这个权限就可以了。