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.
Critical Error 145 for PHPBB
Moderators: egami, macek, gesf
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)
);
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
- Moderator
- Posts: 2257
- Joined: Sat Jul 05, 2003 1:18 pm
- Location: A bunk in the back
- Contact:
ylkien wrote: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.
Reason: This is corruption of a MySQL database table. The 'phpbb_sessions table is damaged.
See: Corrupted MyISAM Tables and How to Repair Tables
See: Corrupted MyISAM Tables and How to Repair Tables
Sincerely,
Gonçalo "gesf" Fontoura
gesf.org | sessionstart.com | urlms.com
Gonçalo "gesf" Fontoura
gesf.org | sessionstart.com | urlms.com