Piwik 1.3 Upgrade problem - DB State [42000] :(


(kwikone) #1

After upgrade to version 1.3 (OneClick upgrade) (clicked on continue to piwik) get the following error:

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

And this exception raised another exception “SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘requestKey’ in ‘field list’”

And, since all tables should have “piwik_” for a prefix where is table htm? and what do I need to do to fix this problem?


(Matthieu Aubry) #2

requestKey and htm are not Piwik tables or columns…?


(kwikone) #3

I did not think they were - at least I had not been able to find them. So… why am I getting this error from Piwik then?
And why after upgrading to 1.3? What can I do to further track this down?


(Matthieu Aubry) #4

are you using other non core plugins? try to disable them maybe?


(vipsoft) #5

Must be a really obscure plugin. I just grepped 40+ of them.