Jump to content



Photo
- - - - -

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


This topic has been archived. This means that you cannot reply to this topic.
4 replies to this topic

#1   egattocs

egattocs
  • Members
  • 74 posts

Posted 03 January 2008 - 17:13

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

#2   edschaum

edschaum
  • Members
  • 140 posts

Posted 03 January 2008 - 17:19

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

#3   egattocs

egattocs
  • Members
  • 74 posts

Posted 04 January 2008 - 10:15

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

#4   BAITDOMAIN

BAITDOMAIN
  • Members
  • 9 posts

Posted 25 June 2008 - 18:45

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

#5   BAITDOMAIN

BAITDOMAIN
  • Members
  • 9 posts

Posted 25 June 2008 - 19:03

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