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
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
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
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.
go to the table
PageStatistics
then go to row
3657
delete the row, thats it
PageStatistics
then go to row
3657
delete the row, thats it
I'm using phpmyadmin. It stops at 3656 there is no 3657. Now what?
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.
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.
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?
I deleted the entire table of page statistics and I still get the same error msg. ANy other Ideas?
Have you cleared your cache?
Have you made sure there is nothing wrong with the MySQL server itself?
Have you made sure there is nothing wrong with the MySQL server itself?
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.
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
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
TRY THIS:
add
define(‘STATISTICS_TRACK_PAGE_VIEWS’, false);
to your config/site.php
Should get you back up and running.
add
define(‘STATISTICS_TRACK_PAGE_VIEWS’, false);
to your config/site.php
Should get you back up and running.
I'll try that as soon as I get home from work thanks.
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!
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)
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)
REPAIR TABLE PageStatistics;
Worked for me today :)
Worked for me today :)
-Phil