Duplicate entry - Fatal Error2 users found helpful
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 22.214.171.124] 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 ?
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.
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.
still curious how it could have occurred.