my sql error 145
#1
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.
#2
[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
#3
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.
#4
last time i repair mybb_sessions table i got this message :

Quote:Number of rows changed from 4904 to 4902
#5
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
#6
Your SQL query has been executed successfully (Query took 0.0604 sec)
SQL query:
TRUNCATE TABLE `mybb_sessions;
#7
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?
#8
Don't think so. Smile
[Image: destroyerjf8.jpg]

Give us your feedback about MyBB in this thread and become listed on the MyBB website.
#9
it is happened again

should i use this query again :

TRUNCATE TABLE `mybb_sessions;
#10
Use these:

TRUNCATE TABLE mybb_sessions;
REPAIR TABLE mybb_sessions;
[Image: destroyerjf8.jpg]

Give us your feedback about MyBB in this thread and become listed on the MyBB website.


Forum Jump:


Users browsing this thread: 1 Guest(s)