Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

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


egattocs

Recommended Posts

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

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

Link to comment
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

Link to comment
Share on other sites

  • 5 months later...

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

Archived

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

×
×
  • Create New...