Zen Cart Logo
Forums / General Questions / zen_whos_online is marked as crashed

zen_whos_online is marked as crashed

Locked

Views: 7,271

Results 21 to 24 of 24
This thread is locked. New replies are disabled.
8 Jan 2009, 3:28 PM
#21
mydanilo avatar

mydanilo

Totally Zenned

Join Date:
Dec 2004
Posts:
1,024
Plugin Contributions:
0

zen_whos_online is marked as crashed

Sorry did not read all posts. So the reason is db upgrades initiated by the hosting company? A little warning that this is possibly happening would be great. But is maybe too much asked for....

8 Jan 2009, 3:35 PM
#22
data_digger avatar

data_digger

Zen Follower

Join Date:
Jan 2009
Posts:
222
Plugin Contributions:
2

Re: zen_whos_online is marked as crashed

Use InnoDB tables instead, and I'm not saying that because of my recent post about it's performance. InnoDB is more reliable then MyISAM and will repair itself automatically upon mysql server restart.

MyISAM tables can be damaged but still work without reporting any errors, returning wrong data ( wrong record counts, wrong records etc).

29 Jan 2010, 12:01 PM
#23
saitomedia avatar

saitomedia

Zen Follower

Join Date:
Feb 2008
Location:
Southern California
Posts:
146
Plugin Contributions:
0

Re: zen_whos_online is marked as crashed

ALWAYS BACKUP YOUR DATABASE!!!!!!!!!!!!!!!!!!!!!!!!!!! If you don't have your original working backup, don't post and waste our time.

P.S. No excuses; and sorry for such thread digression.

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

I haven't experienced this disaster so far... my flagship Zencart URL still lives on. http://www.scienscope-products.com without any trouble at the moment. My ISP is he.net, cherry server. But I have used the code mentioned by Merlinpa1969" on my other accounts. It's definitely server-side issue.

29 Aug 2011, 6:35 AM
#24
printed_balloons avatar

printed_balloons

New Zenner

Join Date:
May 2011
Posts:
5
Plugin Contributions:
0

Re: zen_whos_online is marked as crashed

I went into my pphpadmin program, found the who's online entry, clicked on it and clicked the work empty. Website back online straight away.