egattocs Posted January 3, 2008 Share Posted January 3, 2008 Hi Firstly, Happy new year to all. Secondly, I'm having some trouble when going to our website. I'm getting the following error message: 1194 - Table 'whos_online' is marked as crashed and should be repaired delete from whos_online where time_last_click < '1199379187' [TEP STOP] I've been into mySQL and it says 1194 - Table 'whos_online' is marked as crashed and should be repaired when I hover over 'whos_online'. How exactly do I go about repairing the table. It is a case of restoring the latest backup, or is there something else I should be doing? I hope somebody is able to help? Many thanks in advance Scott Link to comment Share on other sites More sharing options...
edschaum Posted January 3, 2008 Share Posted January 3, 2008 HiFirstly, Happy new year to all. Secondly, I'm having some trouble when going to our website. I'm getting the following error message: I've been into mySQL and it says when I hover over 'whos_online'. How exactly do I go about repairing the table. It is a case of restoring the latest backup, or is there something else I should be doing? I hope somebody is able to help? Many thanks in advance Scott Try going into phpmyadmin and selecting to repair that table. Maybe run a database backup first to be sure you don't create any additional problems. Ed Link to comment Share on other sites More sharing options...
egattocs Posted January 4, 2008 Author Share Posted January 4, 2008 Thanks for your help Ed. If I had perhaps looked a bit harder within MySQL to start with then I would've found how to repair the table! I've repaired it now and the site is back up and running. Thanks again for your help. Scott Link to comment Share on other sites More sharing options...
BAITDOMAIN Posted June 25, 2008 Share Posted June 25, 2008 Hello Ed, This is a old thread, I have the same problem. Not sure how to repair it? Please assist, Thanks, Paul Error SQL query: Documentation SELECT COUNT( * ) AS `Rows` , `time_last_click` FROM `whos_online` GROUP BY `time_last_click` ORDER BY `time_last_click` LIMIT 0 , 30 MySQL said: Documentation #1194 - Table 'whos_online' is marked as crashed and should be repaired Link to comment Share on other sites More sharing options...
BAITDOMAIN Posted June 25, 2008 Share Posted June 25, 2008 Wow, just like the Scott, I went in and looked around and found it, deleted it and the site was back up. Thanks a million. Paul Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.