Zen Cart Logo
Forums / General Questions / Tables keep on crashing

Tables keep on crashing

Locked

Views: 820

Results 1 to 5 of 5
This thread is locked. New replies are disabled.
7 Aug 2013, 2:38 PM
#1
pietpetoors avatar

pietpetoors

Zen Follower

Join Date:
Jun 2010
Location:
South Africa
Posts:
140
Plugin Contributions:
0

Tables keep on crashing

Is there a way I can turn off the function which shows how many people are online

On my shop the tables of the DB keeps on crashing and each time it is the who is online tables.

130807 14:51:17 [ERROR] /usr/libexec/mysqld: Table './pieter_direct/whos_online' is marked as crashed and should be repaired
130807 14:51:27 [ERROR] /usr/libexec/mysqld: Table './pieter_direct/whos_online' is marked as crashed and should be repaired
130807 14:51:30 [ERROR] /usr/libexec/mysqld: Table './pieter_direct/whos_online' is marked as crashed and should be repaired
7 Aug 2013, 3:44 PM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: Tables keep on crashing

It's odd that it's crashing so frequently, and worth figuring out "why".

But if your intention is to just disable it, you can make the following change to one file:
/includes/init_includes/init_special_funcs.php
Lines 18-19 can be commented-out by simply adding // to the beginning as shown here:```
/**

  • require the whos online functions and update
    */
    [B]//[/B]require(DIR_WS_FUNCTIONS . 'whos_online.php');
    [B]//[/B]zen_update_whos_online();

You should of course also turn off the whos-online sidebox via Admin->Tools->Layout Boxes Controller

Then repair the whos-online table again so that it's not in a bad state. Even truncating it would be wise too.
7 Aug 2013, 4:59 PM
#3
pietpetoors avatar

pietpetoors

Zen Follower

Join Date:
Jun 2010
Location:
South Africa
Posts:
140
Plugin Contributions:
0

Re: Tables keep on crashing

Thanx.
If I do want to investigate why this happens, where do I start?
What are common causes I have to look for?

7 Aug 2013, 6:50 PM
#4
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: Tables keep on crashing

Find out exactly what was happening when the table crashed.

ya, that's complicated.

5 May 2014, 12:48 PM
#5
heathenmagic avatar

heathenmagic

Totally Zenned

Join Date:
May 2005
Location:
England
Posts:
730
Plugin Contributions:
0

Re: Tables keep on crashing

Hello there,

Thanks for the fix. I just got this today, and I get it about once a year. Was on two separate hosts so far. But am glad I can turn it off in case it happens again