Database whos_online Crashed

[Guest]

My site has worked for 9 months with no problems till this today.

 

Cannot get site up or do any back ups.

 

:'(

 

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

 

delete from whos_online where time_last_click < '1207341927'

 

[TEP STOP]

[Guest]

Just remove all the rows from your whos online table and it will work again.

[minuteman1970]

Just remove all the rows from your whos online table and it will work again.

 

Hello,

By some strange coincidence, I am having the exact same issue today. I logged into my PHPMyadmin, and found the whos_online table. In the 'Structure' tab, it shows the following fields:

 

 Field 

 customer_id 

 full_name 

 session_id 

 ip_address 

 time_entry 

 time_last_click 

 last_page_url 

 http_referer 

 user_agent 

 

When you say 'remove all the rows from the table' do you mean I need to 'check all' and then click 'drop'?

Would you please be so kind as to elaborate? FYI, while in that screen just now, I accidentally clicked 'fulltext' for the 'last_time_click' Field. Hopefully, I did not make matters worse.

 

I am hoping someone here is able to step us through resolving this; it sounds like an easy fix once you know what you're doing.

Thanks in advance,

Ray

[Guest]

Click on the Browse tab at the top and then delete the rows. Don't delete the table, it won't work afterwards. SQL is hard to explain without a visual aid.

[minuteman1970]

Click on the Browse tab at the top and then delete the rows. Don't delete the table, it won't work afterwards. SQL is hard to explain without a visual aid.

Thanks for the reply. I went into 'Browse', and deleted all 19 rows. However, that did not seem to do the trick. Do I need to give it some time to do its thing?

The 'Browse' menu cannot be accessed now. Also, should I un-do the 'fulltext' action I accidentally clicked onto in my earlier post?

Thanks.

[Guest]

You can try that or try this, do a full DB backup first.

 

 

Also see if there is a repair function for the table. Your table seems to be different from mine.

[currye]

I also have a this problem.

 

 

when I try to open my site this is the error I get.

 

1016 - Can't open file: 'whos_online.MYI' (errno: 145)

 

delete from whos_online where time_last_click < '1207663797'

 

[TEP STOP]

 

 

How do I fix this problem. Can someone please help. my site has been running since 2005.

 

 

currysgiftshop.com

[Kyrsten]

I have had these same who's online errors in the past. In my case, I went into my Cpanel, went into the MySql within Cpanel and clicked "repair" next to the Oscommerce database and this has fixed the same problems when I have had them everytime before. Hope this helps!

[currye]

I have had these same who's online errors in the past. In my case, I went into my Cpanel, went into the MySql within Cpanel and clicked "repair" next to the Oscommerce database and this has fixed the same problems when I have had them everytime before. Hope this helps!

I have DirectAdmin. I went into phpMyAdmin and this is what I get.

 

Error

SQL query:

 

SHOW FIELDS FROM `whos_online` ;

 

 

 

MySQL said:

 

#1016 - Can't open file: 'whos_online.MYI' (errno: 145)

 

I dont know what to do.

[Kyrsten]

I am sorry I have never dealt with DirectAdmin, only CPanel which gives me an option of viewing what SQL Databases I have installed, and to check repair or delete them without every going to phpMyAdmin. Hopefully someone with DirectAdmin will come accross your post and be able to help.

[currye]

Thanks Kyrsten,

 

I hope someone out there can help me with this problem so I can get me site back up.