SQLSTATE Error


(jazzi) #1

Hi guys!

Firstly, let me say “thanks” for such an awesome product! I’ve had enough of Google Analytics and it’s inaccurate stats. Piwik is like a little breath of fresh air into my otherwise mundane site management role!

I do however have some weird problems with my Piwik dashboard… style_emoticons/<#EMO_DIR#>/wink.gif

Half the time I load the dashboard page, I get error messages like this:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '166-done' for key 'PRIMARY'

The 166-done bit varies, but it’s always the same error. It shows randomly inside the modules themselves.

If I refresh the page then the error is replaced by a message that says “no data for this table” or “no data for this graph”. If I refresh again then the modules load…

I’m running 0.4.3 by the way - here’s some server info:

Server: CentOS 5 on a dedi x64
MySQL: 5.1.36
Database collation: utf8_general_ci
PHP: 5.2.6
Web Server: Apache 2

Any thoughts on what I can try? style_emoticons/<#EMO_DIR#>/smile.gif

Thanks!

Jazzi


(vipsoft) #2

are you using cron or browser triggered archiving?

if cron, how frequently?
if the latter, how many simultaneous dashboard users?