Latest News: (loading..)

Archived

This topic is now archived and is closed to further replies.

egattocs

Table 'whos_online' is marked as crashed and should be repaired

5 posts in this topic

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

Share this post


Link to post
Share on other sites
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:

 

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites