But if i select another website from right top area combobox, it gives error.
Error details :
SQLSTATE[42000]: Syntax error or access violation: 1044 Access denied for user ‘myusername’@’%’ to database ‘mydatabasename’
It said that, access denied but i can access to panel via my username and password. And i can see details of default selected website. Only when i changed website to see details, it gives error. Everything on same database.
Hi!
I upgraded from 1.7 to 1.8 and getting following error messages on Dashboard: ERROR MESSAGE 1:
Sat 2 Jun - 19:48:55 (
There is an error. Please report the message (Piwik 1.8) and full backtrace in the Piwik forums (please do a Search first as it might have been reported already!).
Notice: Undefined index: visitLengthPretty in /home/public_html/analytic/tmp/templates_c/%%12^122^12231148%%lastVisits.tpl.php on line 69
Backtrace --> #0 Piwik_ErrorHandler(…) called at [/home/public_html/analytic/tmp/templates_c/%%12^122^12231148%%lastVisits.tpl.php:69]#1 include(…) called at [/home/public_html/analytic/libs/Smarty/Smarty.class.php:1263]#2 Smarty->fetch(…) called at [/home/public_html/analytic/core/View.php:133]#3 Piwik_View->render(…) called at [/home/public_html/analytic/plugins/Live/Controller.php:44]#4 Piwik_Live_Controller->render(…) called at [/home/public_html/analytic/plugins/Live/Controller.php:99]#5 Piwik_Live_Controller->getLastVisitsStart(…) called at [:]#6 call_user_func_array(…) called at [/home/public_html/analytic/core/FrontController.php:138]#7 Piwik_FrontController->dispatch(…) called at [/home/public_html/analytic/index.php:53]
You wrote : "Solution: Please grant your database user the permission to LOCK tables, using phpMyAdmin or asking your webhost "
In my case and surely in many cases it is impossible to grant the permission to Lock Tables and asking to the webhost, what i did, would cost me too much as i would have to hire a separate database and it would cost me too much.
Unfortunately, i have to stay with 1.7 as i do not want to loose all my statistics.
@barnabe
I’d suggest you ask your host again, maybe someone else answers, and helps you.
You would already have your own database account, and they just have to give it the “lock tables” permission for your database.
You could point them too Piwik Requirements - Analytics Platform - Matomo
If they don’t want to do this, you’d probably be better off by changing hosts as soon as possible. It is not like you need some premium hosting for this functionality.
If they don’t want to do this, you’d probably be better off by changing hosts as soon as possible. It is not like you need some premium hosting for this functionality.[/quote]
Well, unfortunately i pay my host one year in advance and unfortunately it is absolutely impossible to change the permissions, i’ve asked many times.
I regret that Piwik did not think that many people cannot change the privileges of their DB.
it is absolutely impossible to change the permissions, i’ve asked many times.
I agree it’s frustrating for you. If we hear from MANY users with the problem maybe we will consider, but the LOCK table is really necessary to fix a bug with parallel archives…
But really please consider changing host next year as it’s not serious behavior from them