My b2evolution Version: 2.x
Hello,
Since last week, I get a MySQL error:
MySQL error!
Table './arnowalop_nl/evo_hitlog' is marked as crashed and should be repaired(Errno=145)
Your query: Hit: Check for reload
SELECT hit_ID
FROM evo_hitlog INNER JOIN evo_sessions ON hit_sess_ID = sess_ID
WHERE sess_user_ID = 1
AND hit_uri = '/'
LIMIT 1
Don't know how to remove this error. Maybe someone here can help me...[/quote]
Hi ArnoWalop,
That looks nasty. But the hit logs is the least important table.
I'd start with making a backup of your database, if the error allows that.
You could try to prune from within B2evo. Setup a scheduled job, execute at least once and then remove the job. See this image:
http://www.blog.hemminga.net/B2evoforum/NewJob.png
Next you could try from within PHPMyAdmin. There are some options to repair databases but I would start with emptying (not removing) the hitlog table. If you don't feel comfortable contact your host. It's an error after all.
Good luck