SQLSTATE[42000]: Syntax error or access violation: 1142

Support & Bugs
1

Hi,

I get the following error whenever i try to access my piwik installation. I Recently upgraded to the latest version and had it working fine for about 2-3 days.

SQLSTATE[42000]: Syntax error or access violation: 1142 INSERT command denied to user ‘dbo279435107’@‘74.208.16.203’ for table ‘piwik_option’

The only thing that I attempt to do was create a cron job to auto archive

#CRON JOB FOR PIWIK ANALYTICS
MAILTO="mail@mail.com"
5 * * * * wget -q -O - ‘mysite.com/apps/analytics/misc/cron/archive.sh’ >/dev/null

Thanks!

2

see http://piwik.org/faq/how-to-update/#faq_78 (similar to INDEX but in your case it’s INSERT that is denied)

3

If your database is hosted at OVH. In my case my database exceed the maximum quota in terms of size. It results that OVH put my database in read only access and as a result generate this error because they changed my user rights. So always good to check your web hosting platform if you are facing this issue.