Forums

[Help] Fatal Error ADODB pagestatistics

Permalink
please help,
i've got this error when i open my site:



Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [145: Table './k9933008_concrete/PageStatistics' is marked as crashed and should be repaired] in EXECUTE("insert into PageStatistics (cID, uID, date) values ('1', '1', NOW())") ' in /home/sloki/user/k9933008/sites/sigitjayaherlambang.com/www/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /home/sloki/user/k9933008/sites/sigitjayaherlambang.com/www/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 145, 'Table './k99330...', 'insert into Pag...', false, Object(ADODB_mysql)) #1 /home/sloki/user/k9933008/sites/sigitjayaherlambang.com/www/concrete/libraries/3rdparty/adodb/adodb.inc.php(993): ADOConnection->_Execute('insert into Pag...') #2 /home/sloki/user/k9933008/sites/sigitjayaherlambang.com/www/concrete/libraries/3rdparty/adodb/adodb.inc.php(761): ADOConnection->Execute('insert into Pag...', Array) #3 /home/sloki/user/k9933008/sites/sigitjayaherlambang.com/www/concrete/libraries/da in /home/sloki/user/k9933008/sites/sigitjayaherlambang.com/www/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78

my site still works 2 days ago, and i didnt touch it after that, and then this error show when i open my site...
i've tried solution in this forum:
http://www.concrete5.org/community/forums/usage/laptop-overheated-n...
but it didnt give me any result...
even i cant go to my dashboard...
please help...
mkharisecario
 
JohntheFish replied on at Permalink Reply
JohntheFish
The page statistics table just grows and grows, so if your site has been running for a while it is the one that is subject to most updates, and consequently most at risk from any glitch spoiling its integrity.

It is used by some addons, but other than that is not needed.

Just in case, use phpMyAdmin to make a database backup before doing anything.

You could use phpMyAdmin to repair the table, to remove old entries, to slim it down or delete it and your site should work again. Once back in the dashboard there is an option to switch it off which will lead to a small speed improvement.

One of the solutions on the referenced thread is to add a constant to the config file, which you can do by ftp/edit, so will switch off statistics without needing C5 to do so.
mkharisecario replied on at Permalink Reply
mkharisecario
what table to delete?

i already try to browse my page statistics table, but it doesnt show...
mdzoidberg replied on at Permalink Reply
mdzoidberg
You need to repair the table, check out this link with step by step instructions with images on how to repair tables via phpMyAdmin.

http://paulstamatiou.com/how-to-quickie-repair-mysql-tables-in-phpm...


Cheers.
mkharisecario replied on at Permalink Reply
mkharisecario
page is missing... :(
JohntheFish replied on at Permalink Best Answer Reply
JohntheFish
There should be a table pagestatistics or PageStatistics. As Mdzolberg suggests, maybe the table doesn't show fully in phpMyAdmin if it is broken.

Another link:

http://php.about.com/od/mysqladministration/qt/repair_mysql.htm...

And the original link, found via google

http://paulstamatiou.com/how-to-quickie-repair-mysql-tables-in-phpm...

http://www.google.co.uk/search?hl=en&q=repair+tables+in+pnpMyAd...
mkharisecario replied on at Permalink Reply
mkharisecario
after a few try, now i can repair my table.
one of JohntheFish link work for me.

thanks...