MyBB Community Forums

i got this message many times a day and my forum be down :

Quote:MySQL error: 145
Table './mydb1/mybb_sessions' is marked as crashed and should be repaired
Query: SELECT * FROM mybb_sessions WHERE sid='0' AND ip='11.240.77.564'

i know that i have to repair my database and i do but it is happened many times a day.

what can i do to stop it.

please help.

Thanks.

[quote=free4free]
i got this message many times a day and my forum be down :

Quote:MySQL error: 145
Table './mydb1/mybb_sessions' is marked as crashed and should be repaired
Query: SELECT * FROM mybb_sessions WHERE sid='0' AND ip='11.240.77.564'

Please try this: http://community.mybboard.net/showthread...#pid150784

thanks maatty.
i know how to repair my database tables but im i asking for stopping this error because it is happened many times a day and im being offline and my forum stopped many hours until i repair database tables.

last time i repair mybb_sessions table i got this message :

Quote:Number of rows changed from 4904 to 4902

free4free Wrote:thanks maatty.
i know how to repair my database tables but im i asking for stopping this error because it is happened many times a day and im being offline and my forum stopped many hours until i repair database tables.

Have you considered this:
- backup your mybb_sessions first
- run this query:

TRUNCATE TABLE `mybb_sessions;

In your PhpMyAdmin and see it works without that error.

Regards

Your SQL query has been executed successfully (Query took 0.0604 sec)
SQL query:
TRUNCATE TABLE `mybb_sessions;

free4free Wrote:Your SQL query has been executed successfully (Query took 0.0604 sec)
SQL query:
TRUNCATE TABLE `mybb_sessions;

So do you still get error messages?

Don't think so.

it is happened again

should i use this query again :

TRUNCATE TABLE `mybb_sessions;

Use these:

TRUNCATE TABLE mybb_sessions;
REPAIR TABLE mybb_sessions;