HTTP 500 Internal Server Error message when trying to view site

Permalink 1 user found helpful
Hi All

I'm in desperate need of assistance. We've got an event in Australia on 23 October and the site is down. I've contacted our hosting provider and left a ticket for resolution but the turn around is 24/48 hrs. They have told me that it is a Php error. This is the error log message:

PHP error_log:
--------------------------------------------------------------------------------

/home2/canberra/public_html/error_log:
#3 /home2/canberra/public_html/concrete/libraries/database.php(73): ADOConnection->Query('insert into Pag...', Array)
#4 /home2/canberra/public_html/concrete/models/user.php(177): Database->__call(Array, Array)
#5 /home2/canberra/public_html/concrete/models/user.ph in /home2/canberra/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
[19-Oct-2010 23:02:42] PHP Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1062: Duplicate entry '0' for key 'uID'] in EXECUTE("insert into PageStatistics (cID, uID, date) values ('1', 0, NOW())")
' in /home2/canberra/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78
Stack trace:
#0 /home2/canberra/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 1062, 'Duplicate entry...', 'insert into Pag...', false, Object(ADODB_mysql))
#1 /home2/canberra/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(993): ADOConnection->_Execute('insert into Pag...')
#2 /home2/canberra/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(761): ADOConnection->Execute('insert into Pag...', Array)
#3 /home2/canberra/public_html/concrete/libraries/database.php(73): ADOConnection->Query('insert into Pag...', Array)
#4 /home2/canberra/public_html/concrete/models/user.php(177): Database->__call(Array, Array)
#5 /home2/canberra/public_html/concrete/models/user.ph in /home2/canberra/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
[19-Oct-2010 23:14:52] PHP Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1062: Duplicate entry '0' for key 'uID'] in EXECUTE("insert into PageStatistics (cID, uID, date) values ('61', 0, NOW())")
' in /home2/canberra/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78
Stack trace:
#0 /home2/canberra/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 1062, 'Duplicate entry...', 'insert into Pag...', false, Object(ADODB_mysql))
#1 /home2/canberra/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(993): ADOConnection->_Execute('insert into Pag...')
#2 /home2/canberra/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(761): ADOConnection->Execute('insert into Pag...', Array)
#3 /home2/canberra/public_html/concrete/libraries/database.php(73): ADOConnection->Query('insert into Pag...', Array)
#4 /home2/canberra/public_html/concrete/models/user.php(177): Database->__call(Array, Array)
#5 /home2/canberra/public_html/concrete/models/user.p in /home2/canberra/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
[19-Oct-2010 23:16:36] PHP Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1062: Duplicate entry '0' for key 'uID'] in EXECUTE("insert into PageStatistics (cID, uID, date) values ('61', 0, NOW())")
' in /home2/canberra/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78
Stack trace:
#0 /home2/canberra/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 1062, 'Duplicate entry...', 'insert into Pag...', false, Object(ADODB_mysql))
#1 /home2/canberra/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(993): ADOConnection->_Execute('insert into Pag...')
#2 /home2/canberra/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(761): ADOConnection->Execute('insert into Pag...', Array)
#3 /home2/canberra/public_html/concrete/libraries/database.php(73): ADOConnection->Query('insert into Pag...', Array)
#4 /home2/canberra/public_html/concrete/models/user.php(177): Database->__call(Array, Array)
#5 /home2/canberra/public_html/concrete/models/user.p in /home2

I can't access the website via thehttp://www.canberramedievaltournamentandfair.com/index.php/login....
Need step by step instructions as not a techo.
Very grateful for anyones time and experience.

Thanks
KHTM

 
jbx replied on at Permalink Reply
jbx
Hey - I think I see the problem. Can you access MySQL at all? Do you have commandline access or phpMyAdmin?

If you like, send me a private message with your serve login details and I'll fix it this morning for you...

Jon
jbx replied on at Permalink Best Answer Reply
jbx
Or if you wanna do it yourself, I found a great set of instructions:
http://blog.ideaday.de/max/2010/06/concrete-5-site-is-suddenly-down...

(summarized)
Add define(‘STATISTICS_TRACK_PAGE_VIEWS’, false); to your site.php file.

That will switch off statistics and get your site back online.

Then use phpMyAdmin to manually increase the auto_increment value by 1 on the pageStatistics table.

Comment out the line you just added to get your statistics working again.

Personally, I always switch off page tracking at install. That table can get huge and I can't make any sense out of the figures it displays, even when comparing it to the data in the db. I just use Google Analytics instead :)

Hope that helps!

Jon
KHTM replied on at Permalink Reply
Thanks Jon for your effort and for the instructions, much appreciated!

Cheers
KHTM