Forums

Help request - mySQL error

Permalink
Hi All,

We are having some problems withhttp://www.861sqn.org - all of a sudden it has started showing the following error when you try to access the page.

mysql error: [145: Table './sqno_concrete/PageStatistics' is marked as crashed and should be repaired] in EXECUTE("insert into PageStatistics (cID, uID, date) values ('1', 0, NOW())")


You can access the login screen but when you do login, it just takes you back to the above page/error.

Can anyone offer an advice on how to repair this?

Cheers

James
oc861
 
goutnet replied on at Permalink Best Answer Reply
Your database got corrupted, This is where you contact your admin to ask him to fix your database :/ The only good news is it seems to only affect PageStatistics table (which is not really a vital one), let's just hope that it will be the only one.

This link might help you :

http://www.mysqlperformanceblog.com/2008/07/04/recovering-innodb-ta...
oc861 replied on at Permalink Reply
oc861
Many thanks mate - I managed to fix the issue through the php MyAdmin...just selected the table and clicked repair - job done :)