[Resolved] 'Whosonline' Error.

Plastic - 7-23-2012 at 11:12 PM

Full Board URL: http://www.heybritneyforums.com
XMB Version: 1.9.11

I got this error for the past few days:

Quote:

MySQL encountered the following error: Table './heyforum_heybritneyforums/xmb_whosonline' is marked as crashed and should be repaired(errno = 145)

In the following query: DELETE FROM xmb_whosonline WHERE ((ip='XXX.XX.XXX.XXX' && username='xguest123') OR (username='Plastic')

It's fixed repairing the whosonline table in the database but i don't know why this happen every 3-4-5 hours and nobody can't access to the page.

vamsee - 7-24-2012 at 02:14 AM

there's must be a problem in your profile settings.
dont login for 24 hrs and observe if the forum goes down every 3-4 hrs.

What values do you have "topics per page" and "posts per page" set as in your profile?
there should be some value set, it shouldnt be empty

lottos - 7-24-2012 at 02:38 AM

If the table requires a constant repair, one common cause of this is the disk hitting 100%. You need to contact your web host.

Mouser - 7-24-2012 at 03:41 PM

As lottos said.
This has absolutely nothing to do with your profile settings. But this is a problem with your host.
It's not normal that a table crashes so often. It should actually, never (or very rarely) crash.

Plastic - 7-24-2012 at 09:13 PM

I just send a email to the host, today this error happened twice.

Plastic - 8-1-2012 at 02:21 AM

Everything works fine now, thanks guys.

Mouser - 8-1-2012 at 04:05 PM

Glad to hear