Laptop Overheated Now No site just error Msg. Help ME!

Permalink
I was working on my C5 site and my laptop overheated and shut down while i was in the middle of editing. Now when I try to go to my site this is the error I get for every page. Please Someone, Help me fix this so i can get back to building my site. I am working on XAMPP so I can't give you access unfortunatly. Here is the Error msg. i get:

Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1062: Duplicate entry '3657' for key 'PRIMARY'] in EXECUTE("insert into PageStatistics (cID, uID, date) values ('1', '1', NOW())") ' in C:\xampp\htdocs\concrete5.3.3.1\concrete\libraries\3rdparty\adodb\adodb-exceptions.inc.php:78 Stack trace: #0 C:\xampp\htdocs\concrete5.3.3.1\concrete\libraries\3rdparty\adodb\adodb.inc.php(1042): adodb_throw('mysql', 'EXECUTE', 1062, 'Duplicate entry...', 'insert into Pag...', false, Object(ADODB_mysql)) #1 C:\xampp\htdocs\concrete5.3.3.1\concrete\libraries\3rdparty\adodb\adodb.inc.php(998): ADOConnection->_Execute('insert into Pag...') #2 C:\xampp\htdocs\concrete5.3.3.1\concrete\libraries\3rdparty\adodb\adodb.inc.php(766): ADOConnection->Execute('insert into Pag...', Array) #3 C:\xampp\htdocs\concrete5.3.3.1\concrete\libraries\database.php(73): ADOConnection->Query('insert into Pag...', Array) #4 [internal function]: Database->__call(Array, Array) #5 C:\xampp\htdocs\concrete5.3.3.1\concrete\models\user.php(168 in C:\xampp\htdocs\concrete5.3.3.1\concrete\libraries\3rdparty\adodb\adodb-exceptions.inc.php on line 78

pakigreenl
View Replies: View Best Answer
thephilm replied on at Permalink Reply
thephilm
It looks something like an error with the page statistics trying to add an entry that already exists... may want to make sure your db and files are backed up, then see if there are any incomplete entries in that table of the db. Might be able to remove them and the site could continue from where you left off. It must have turned off in the middle of a SQL entry.
-Phil
pakigreenl replied on at Permalink Reply
pakigreenl
Thanks for the reply. I am more of a designer and not familiar with most of that. Would you mind putting that in terms I can understand. I really appreciate it. Thank You
pakigreenl replied on at Permalink Reply
pakigreenl
Sorry, I mean about the looking through the tables part. I've backed up my database just not sure how to sift through the tables and what i'd be looking for.
Mnkras replied on at Permalink Reply
Mnkras
go to the table
PageStatistics
then go to row
3657

delete the row, thats it
pakigreenl replied on at Permalink Reply
pakigreenl
I'm using phpmyadmin. It stops at 3656 there is no 3657. Now what?
Remo replied on at Permalink Reply
Remo
Just to be sure: He's not talking about the row number, he's talking about the colum where uID is equal to 3657, you can use the search tab for this..

If you don't care about the page statistics, you can also delete all entries. Not the first thing I recommend, but if nothing else helps.

Page statistics are used by the dicussion addon as far as I know but otherwise you're just going to have a flat graph when you log into the dashboard.
pakigreenl replied on at Permalink Reply
pakigreenl
Thanks. I do understand how to find it. But I appreciate the extra info to make sure. But, I don't have a 3657 just up to 3656 so do I delete that one instead?
pakigreenl replied on at Permalink Reply
pakigreenl
I deleted the entire table of page statistics and I still get the same error msg. ANy other Ideas?
thephilm replied on at Permalink Reply
thephilm
Have you cleared your cache?

Have you made sure there is nothing wrong with the MySQL server itself?
pakigreenl replied on at Permalink Reply
pakigreenl
I cleared the cache and nothing. I'm not sure how to figure out if anything is wrong with MYSQL but it seems ok as far as I can tell.
thephilm replied on at Permalink Reply
thephilm
Not sure if you backed up with the Concrete5 or with PHPMyAdmin...

If concrete5, that's fine, but in order to edit the table, you'll either need to do it manually(difficult for someone not familiar with command line), or use something like PHPMyAdmin(Graphic interface to MySQL).

Your host should give you access to that. If you need more info on that, let us know who your host is, and we can probably figure out where your PHPMyAdmin is, and then it's similar to editing in excel.
-Phil
thephilm replied on at Permalink Best Answer Reply
thephilm
TRY THIS:
add
define(‘STATISTICS_TRACK_PAGE_VIEWS’, false);
to your config/site.php

Should get you back up and running.
pakigreenl replied on at Permalink Reply
pakigreenl
I'll try that as soon as I get home from work thanks.
pakigreenl replied on at Permalink Reply
pakigreenl
Thanks to all that offered help. "thephilm" Thank you that worked. Will I be able to turn page statistics back on at some point? Again Thank You!
thephilm replied on at Permalink Reply
thephilm
Glad I could get that answered for you!

In PHPMyAdmin there’s the option to manually increase the auto_increment value. I would increased it by one to the error number you were getting and the site may work again with statistics (comment the line you just inserted in the config/site.php)
millennium replied on at Permalink Reply
REPAIR TABLE PageStatistics;

Worked for me today :)