phpBB Just took a crap need some help

[Emancipator]

Ok so my admin is offline and my site is 50% not working as a result of some sort of phpBB error. Anyone seen this and or know a fix. When I look in phpadmin I can see the table it mentions is marked as "busy"


phpBB : Critical Error

Error doing DB query userdata row fetch

DEBUG MODE

SQL Error : 1016 Can't open file: 'phpbb_sessions.MYD'. (errno: 145)

SELECT u.*, s.* FROM phpbb_sessions s, phpbb_users u WHERE s.session_id = '0538ca57c914d06c5576c0257f2704c3' AND u.user_id = s.session_user_id

Line : 243
File : /home/httpd/vhosts/moviesonline.ca/httpdocs/phpBB2/includes/sessions.php

[Emancipator]

i rebuilt the table, problem solved. Now if only i knew WHY it did that.

[tomek]

The table 'phpbb_sessions' is stored in memory so that the access times are faster. While this is normaly a good idea it can give you trouble. I had a similar problem with this table.

My advice: If this problem keeps coming up then change the table type of phpbb_sessions to MyISAM. (that's how I solved my troubles)

good luck

[Emancipator]

yeah i already set it as myisam.. figured that would help, but thanks tomek! :)