my sql error 145

[free4free]

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

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.

[maatty]

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

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

[free4free]

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.

[free4free]

last time i repair mybb_sessions table i got this message :

Number of rows changed from 4904 to 4902

[maatty]

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

[free4free]

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

[maatty]

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?

[destroyer]

Don't think so.

[free4free]

it is happened again

should i use this query again :

TRUNCATE TABLE `mybb_sessions;

[destroyer]

Use these:

TRUNCATE TABLE mybb_sessions;
REPAIR TABLE mybb_sessions;