Critical Error 145 for PHPBB

[ylkien]

Hi,

This is the error i am getting. Previously, i got another error regarding php_users. I repaired that table already. Now, this error comes out. I tried to repair this table, but nothing happens. anyone know a solution?


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

thanks.

[swirlee]

I'd try dropping the table and creating it again.

[ylkien]

Don't know why it still doesn't work. I have dropped the table, and recreated it with this code, but the problem still presist... do i have to reinstall phpbb again?


CREATE TABLE phpbb_sessions (
session_id char(32) DEFAULT '' NOT NULL,
session_user_id mediumint(8) DEFAULT '0' NOT NULL,
session_start int(11) DEFAULT '0' NOT NULL,
session_time int(11) DEFAULT '0' NOT NULL,
session_ip char(8) DEFAULT '0' NOT NULL,
session_page int(11) DEFAULT '0' NOT NULL,
session_logged_in tinyint(1) DEFAULT '0' NOT NULL,
PRIMARY KEY (session_id),
KEY session_user_id (session_user_id),
KEY session_id_ip_user_id (session_id, session_ip, session_user_id)
);

[swirlee]

Don't know why it still doesn't work. I have dropped the table, and recreated it with this code, but the problem still presist... do i have to reinstall phpbb again?

Possibly. If I were you I'd ask this question over at the phpBB support forums in case someone else there has encountered it.

[gesf]

Reason: This is corruption of a MySQL database table. The 'phpbb_sessions table is damaged.
See: Corrupted MyISAM Tables and How to Repair Tables