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 ?
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 ?
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.
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.
Thanks figadmin that helped me: checking the table and then repairing it, fixed this error.
still curious how it could have occurred.
still curious how it could have occurred.
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.