145 Table '.../whos_online' is marked as crashed

The front end of my site displays this message:

145 Table './shocking_catalog/whos_online' is marked as crashed and should be repaired
in:
[delete from whos_online where time_last_click < '1210125508']

I followed the instruction in the Zen-Cart Wiki to fix the table. I opened phpMyAdmin, clicked the SQL tab and entered the query "REPAIR TABLE whos_online" then click "Go". After I did that, nothing has changed, my site is still showing the same error message. What am I missing?

I am still able to log in at the backend though.

My URL: http://shockingprice.com

You should talk to your hosting company about that.

You may have to drop and recreate the table.

If I recreate the table, it would be empty. Will Zen-cart work with empty table?

If the table is busted, you'll have to start with an empty table anyway.
Zen Cart will rebuild the whos_online data automatically ... the data in the whos_online table is only ever valid for 20 minutes anyway.

You do keep regular backups, don't you?

I dropped the table, created a new one and it worked. Thanks.

what causes this to happen? I get this happening to both my whos_online and sessions tables on a regular basis. What can I do to resolve the issue?

fuzzball172:

what causes this to happen? I get this happening to both my whos_online and sessions tables on a regular basis. What can I do to resolve the issue?
Those are probably the two tables that get the most "write" traffic, and are thus the most vulnerable to corruption if the database server hiccups in the middle of a "write".

Who's your hosting company?
What version of PHP and MySQL is your server running?
What's your store URL?

That kind of repeat table corruption typically only happens on servers whose MySQL engine can't handle the volume of traffic coming to it. An overloaded server or poorly-tuned server could have that sort of problem regularly. If the server's database system is hiccuping regularly, you'll end up with table corruption regularly too.

the hosting is names.co.uk
PHP is version 4.4.8
mysql is version 5.0

https://www.redsnapperseafoods.co.uk

Thanks for the help

Lee

Your site appears to have reasonable speed and performance, even from across the pond. I suspect that the table corruption must be related to server problems that your hosting company is experiencing from time to time.
I'd suggest it's best to ask them for feedback about why the database appears to be crashing and thus corrupting the two tables that get the most read-and-write transactions.

Thanks for the advice, I'll contact them after the weekend and report any feedback / results I get

DrByte:

Those are probably the two tables that get the most "write" traffic, and are thus the most vulnerable to corruption if the database server hiccups in the middle of a "write".

Who's your hosting company?
What version of PHP and MySQL is your server running?
What's your store URL?

That kind of repeat table corruption typically only happens on servers whose MySQL engine can't handle the volume of traffic coming to it. An overloaded server or poorly-tuned server could have that sort of problem regularly. If the server's database system is hiccuping regularly, you'll end up with table corruption regularly too.

I am having the same problem, would the size of photographs etc have anything to do with it corrupting..I am getting conflicting info from the guy who runs my serveer ( who says its the size of my photos and amount of stock i have on it) and my guy who created the website and handles the MySQL who says its a server problem

Its happening far to often at the moment...:no:

I strongly doubt that it's related to photos. Nevertheless, it's always wise to optimize your photos/images for best performance.

Thats what I am led to belive but its hard to know which is true when one says one thing and someone says another

One way to find out is to go ahead and optimize your images :)