zen_whos_online is marked as crashed

[NancyOK]

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.

[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

[NancyOK]

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.

[kobra]

I have cPanel but don't see cPanel Manager

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

mysql DB > select the DB > repair

[NancyOK]

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

mysql DB > select the DB > repair

Did the repair and didn't help.

[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,

[NancyOK]

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!!

[wishy]

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?

[jcinsc76]

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

[DrByte]

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