zen_whos_online is marked as crashed

When I go to my website this is what it says.

1194 Table 'zen_whos_online' is marked as crashed and should be repaired
in:
[delete from zen_whos_online where time_last_click < '1211653118']

I have not added any new products or have done any changes to my website. My website is http://discount-cell-accessories.com.

Have no idea what is wrong and was hoping somebody might know how I can fix this.

If you have a host that provides cPanel manager - go there and first backup the DB - Then go to the mysql screen and select "repair" and the DB name

Se if this corrects it

kobra:

If you have a host that provides cPanel manager - go there and first backup the DB - Then go to the mysql screen and select "repair" and the DB name

Se if this corrects it

I have cPanel but don't see cPanel Manager.

I have cPanel but don't see cPanel Manager
cPanel is your manager.....backup > DB

mysql DB > select the DB > repair

kobra:

cPanel is your manager.....backup > DB

mysql DB > select the DB > repair

Did the repair and didn't help.

run this in your Zen Cart -> admin -> tools -> sql patch updater

DROP TABLE IF EXISTS whos_online;
CREATE TABLE whos_online (
  customer_id int(11) default NULL,
  full_name varchar(64) NOT NULL default '',
  session_id varchar(128) NOT NULL default '',
  ip_address varchar(15) NOT NULL default '',
  time_entry varchar(14) NOT NULL default '',
  time_last_click varchar(14) NOT NULL default '',
  last_page_url varchar(255) NOT NULL default '',
  host_address text NOT NULL,
  user_agent varchar(255) NOT NULL default '',
  KEY idx_ip_address_zen (ip_address),
  KEY idx_session_id_zen (session_id),
  KEY idx_customer_id_zen (customer_id),
  KEY idx_time_entry_zen (time_entry),
  KEY idx_time_last_click_zen (time_last_click),
  KEY idx_last_page_url_zen (last_page_url)
) TYPE=MyISAM;

This will literaly drop it and re insert it,
all will be OK,

you can do this with this table since its not a mission critical table,

Merlinpa1969:

run this in your Zen Cart -> admin -> tools -> sql patch updater

DROP TABLE IF EXISTS whos_online;
CREATE TABLE whos_online (
customer_id int(11) default NULL,
full_name varchar(64) NOT NULL default '',
session_id varchar(128) NOT NULL default '',
ip_address varchar(15) NOT NULL default '',
time_entry varchar(14) NOT NULL default '',
time_last_click varchar(14) NOT NULL default '',
last_page_url varchar(255) NOT NULL default '',
host_address text NOT NULL,
user_agent varchar(255) NOT NULL default '',
KEY idx_ip_address_zen (ip_address),
KEY idx_session_id_zen (session_id),
KEY idx_customer_id_zen (customer_id),
KEY idx_time_entry_zen (time_entry),
KEY idx_time_last_click_zen (time_last_click),
KEY idx_last_page_url_zen (last_page_url)
) TYPE=MyISAM;

> This will literaly drop it and re insert it, 
> all will be OK, 
> 
> you can do this with this table since its not a mission critical table,


Thank you Thank you Thank you Thank you Thank you Thank you!!!!!! It worked!! :clap:

Many thanks for the fix, merlinpa.

No idea what caused the problem but I had the exact same thing happen and this fixed it up in a trice.

Any ideas why the who's online should crash?

Merlinpa1969:

run this in your Zen Cart -> admin -> tools -> sql patch updater

DROP TABLE IF EXISTS whos_online;
CREATE TABLE whos_online (
customer_id int(11) default NULL,
full_name varchar(64) NOT NULL default '',
session_id varchar(128) NOT NULL default '',
ip_address varchar(15) NOT NULL default '',
time_entry varchar(14) NOT NULL default '',
time_last_click varchar(14) NOT NULL default '',
last_page_url varchar(255) NOT NULL default '',
host_address text NOT NULL,
user_agent varchar(255) NOT NULL default '',
KEY idx_ip_address_zen (ip_address),
KEY idx_session_id_zen (session_id),
KEY idx_customer_id_zen (customer_id),
KEY idx_time_entry_zen (time_entry),
KEY idx_time_last_click_zen (time_last_click),
KEY idx_last_page_url_zen (last_page_url)
) TYPE=MyISAM;

> This will literaly drop it and re insert it, 
> all will be OK, 
> 
> you can do this with this table since its not a mission critical table,
Thank you so much! Your suggestion fixed the site!!!!!!!!!!!!!!!!!!! You rock!

Jason

Remember, THAT particular fix is ONLY suitable for v1.3.x.
Newer versions will require a different structure on that table ... A better fix would be just to do a **REPAIR TABLE whos_online **instead

I am curious now. Since the 21st/Nov I have seen this table corruption on 5 sites on different servers and hosting companies. Could this possibly be some trick/hack that is causing this?

You can also run an SQL statement such as **repair table zen_whos_online **

Anyone know why this is occurring? I start noticing it a couple weeks ago on my BlueHost site. I have another site on GoDaddy but haven't experience it there so far. Yeah, Yeah I tried the Bluehost help desk(there usual response is that they don't support Zencart and will not provide any more assistance!)

I had the same issue about 2 weeks ago and fixed it via a cPanel repair. Just adding my name to the statistics.

Yet another Zenner who's had to deal with this problem. No wonder I had no hits on my site yesterday. How embarrassing! :blush:

DrByte... What's the path for REPAIR TABLE Who's Online? I'm guessing it's on the admin section of the website (sarassoapsnsuch.com/admin, in this case).

I also tried using the cPanel path, and part of my path is MIA. So, after backing up the DB, I went to my Admin -> Tools -> Install SQL Patches, then copy/pasted the coding into the box. I got a message that I needed to download/install zc_install (??? think it was), but when I tested the patch, it worked fine without that download.

~Sara

kiddo:

I am curious now. Since the 21st/Nov I have seen this table corruption on 5 sites on different servers and hosting companies. Could this possibly be some trick/hack that is causing this?

This can be caused by a variety of things such as having a blip in the backup procedure or export, simple corruption and migration MySQL mismatches. This is one of a couple sensitive tables in the database.

Sara's Soaps:

Yet another Zenner who's had to deal with this problem. No wonder I had no hits on my site yesterday. How embarrassing! :blush:

DrByte... What's the path for REPAIR TABLE Who's Online? I'm guessing it's on the admin section of the website (sarassoapsnsuch.com/admin, in this case).

I also tried using the cPanel path, and part of my path is MIA. So, after backing up the DB, I went to my Admin -> Tools -> Install SQL Patches, then copy/pasted the coding into the box. I got a message that I needed to download/install zc_install (??? think it was), but when I tested the patch, it worked fine without that download.

~Sara

The references for the fixes are recommended to be run in PhpMyAdmin

I have this happen again on three more sites in last day. Different sites, different hosts, a few hours apart. I can say that this is happen to my one 1.3.7 site as well as the 1.3.8 sites.

It seems very strange that this should now be happening on so many machines. On don't have opportunities to investigate as at this season I just repair and back on line.

I am starting to wonder if maybe there is some type of injection try going on in the user agent string. This is much too often and spread to be a local issue on one bad boxen or host. Is the user agent sanitized clean before writing?

There has been an on-slaught of upgrades happening to MySql in the past few months.

Most likely it is your host just upgrading and not repairing all databases after they upgrade.

Thank you very much. It worked for me.

Worked for me as well. Why is this happening? Is this an attack? One of my other sites had a db problem at the same time but Store Manager and then Optimize Database did the trick.