Forums

Page Statistics MySQL Crash

Permalink
Howdy,

A client's site has gone down, with the following error code:

mysql error: [1062: Duplicate entry '80419' for key 'PRIMARY'] in EXECUTE("insert into PageStatistics (cID, uID, date) values ('1', 0, NOW())")


I HAVE NOT done anything manually to this table, so I figure it's a C5 bug or perhaps something with too many entries?

If anyone has an immediate solution, that'd be awesome. Long term can be resolved when I/we can get to it!

Thanks guys!
Landson
 
Landson replied on at Permalink Reply
Landson
Hey all!

So I've implemented a temporary fix, having manually turned off page statistics (that is, without using the dashboard), following these instructions:

http://www.concrete5.org/documentation/how-tos/developers/disable-t...

Not sure why this error arose, but glad the site is working now!

-Landson