Hi,

A client website of ours has crashed and shows the following error message:

A Database Error Occurred

Error Number: 145

Table ‘./dhc_db/exp_online_users’ is marked as crashed and should be repaired

SELECT * FROM (`exp_online_users`) WHERE `site_id` = ‘1’ AND `date` > 1341475211 ORDER BY `name`

Filename: libraries/Stats.php

Line Number: 79

We are also running the Store module.

Any ideas on how to rectify the error at all?

Hey Scott,

I would try repairing the table. (BACK UP FIRST)

In the Control Panel go to Tools ‣ Data ‣ SQL Manager ‣ Manage Database Tables and then select that table and hit repair.

That should do it.

Cheers,

Ah thanks man, that did the trick - any idea what caused it, happened to two of our sites today?

Thanks again

Hiya Scott,

Cause .... that’s a good question. Maybe a ton of visitors recently? Just a guess, I have never seen that happen, but who knows.

What version are you on, I can check to see if there is maybe a bug around this doozy.

Thanks,