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


(angolanmade) #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!


(Matthieu Aubry) #2

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