Forums / General Questions / 145 Table 'whos_online' is marked as crashed and should be repaired

145 Table 'whos_online' is marked as crashed and should be repaired

Views: 2,028

Results 1 to 6 of 6
30 Jul 2011, 3:38 PM
#1
trevally avatar

trevally

New Zenner

Join Date:
Jun 2009
Posts:
29
Plugin Contributions:
0

145 Table 'whos_online' is marked as crashed and should be repaired

Hello. The following message pops up when you click on my site http://castersonlineflyshop.com

145 Table './casterso_zc1/zen_whos_online' is marked as crashed and should be repaired
in:
[delete from zen_whos_online where time_last_click < '1312039367']

Any ideas?

thank you in advance,
Dave

30 Jul 2011, 3:41 PM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: 145 Table 'whos_online' is marked as crashed and should be repaired

Try going to your phpMyAdmin and click on the checkbox for the table and click on REPAIR at the bottom in the of the screen in the dropdown to see if this fixes it ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

30 Jul 2011, 3:59 PM
#3
trevally avatar

trevally

New Zenner

Join Date:
Jun 2009
Posts:
29
Plugin Contributions:
0

Re: 145 Table 'whos_online' is marked as crashed and should be repaired

is that in my ftp server?

30 Jul 2011, 4:00 PM
#4
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: 145 Table 'whos_online' is marked as crashed and should be repaired

No, that should be available via the Control Panel for your domain ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

11 Feb 2014, 4:43 AM
#5
jorger avatar

jorger

New Zenner

Join Date:
Aug 2010
Posts:
53
Plugin Contributions:
0

Re: 145 Table 'whos_online' is marked as crashed and should be repaired

Hi I Ajeh,
My whos_online table is gone and this patch did not work. I got an error when I submit the patch. Please advice

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;

11 Feb 2014, 2:00 PM
#6
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: 145 Table 'whos_online' is marked as crashed and should be repaired

You appear to have prefixes on your tables:

145 Table './casterso_zc1/zen_whos_online' is marked as crashed and should be repaired
in:

But you do not appear to be using that in the fix:

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;

What happens if on the two table lines you add the prefix zen_ ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!