Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Database whos_online Crashed


Guest

Recommended Posts

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]

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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!

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...