Duplicate entry - Fatal Error

Permalink 2 users found helpful
Hi All,

My site was working fine until Friday. Now all I get is the blank white page and the following error in my server log.

[Mon Apr 02 10:19:13 2012] [error] [client 90.222.141.65] PHP Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1062: Duplicate entry '1184919' for key 1] in EXECUTE("insert into PageStatistics (cID, uID, date) values ('1', 0, NOW())")\n' in /var/www/vhosts/ecobuddhism.org/httpdocs/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78\nStack trace:\n#0 /var/www/vhosts/ecobuddhism.org/httpdocs/concrete/libraries/3rdparty/adodb/adodb.inc.php(1042): adodb_throw('mysql', 'EXECUTE', 1062, 'Duplicate entry...', 'insert into Pag...', false, Object(ADODB_mysql))\n#1 /var/www/vhosts/ecobuddhism.org/httpdocs/concrete/libraries/3rdparty/adodb/adodb.inc.php(998): ADOConnection->_Execute('insert into Pag...')\n#2 /var/www/vhosts/ecobuddhism.org/httpdocs/concrete/libraries/3rdparty/adodb/adodb.inc.php(766): ADOConnection->Execute('insert into Pag...', Array)\n#3 /var/www/vhosts/ecobuddhism.org/httpdocs/concrete/libraries/database.php(73): ADOConnection->Query('insert into Pag...', Array)\n#4 /var/www/vhosts/ecobuddhism.org/httpdocs/concrete/models/user.php(159): Datab in /var/www/vhosts/ecobuddhism.org/httpdocs/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78

Can anyone help me find out the cause or solve this ?

 
PineCreativeLabs replied on at Permalink Reply
PineCreativeLabs
I've seen this before. Are you on a shared hosting? If so, you may need to contact them to see if they're having issues. Sometimes, this is caused by the server itself. Kind of like a hiccup or whatever.

Or, if you can access your dashboard, go to 'System and settings'. You may want to try clearing your cache, and / or refresh your database.

For me, this has helped in the past.
figadmin replied on at Permalink Reply
Hi,

Despite this being an old threat, I wanted to let you know that for this was due to a corrupted Pagestatistics table. I repaired the table in phpadmin and the problem went away.
terano replied on at Permalink Reply
terano
Thanks figadmin that helped me: checking the table and then repairing it, fixed this error.

still curious how it could have occurred.