Board index   FAQ   Search  
Register  Login
Board index php forum :: Database MySQL Installation

Critical Error 145 for PHPBB

Installation and configuration iussues

Moderators: macek, egami, gesf

Critical Error 145 for PHPBB

Postby ylkien » Sat Apr 03, 2004 5:51 am

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.
ylkien
New php-forum User
New php-forum User
 
Posts: 28
Joined: Sat Dec 14, 2002 9:43 am

Postby swirlee » Sat Apr 03, 2004 11:20 am

I'd try dropping the table and creating it again.
User avatar
swirlee
Moderator
Moderator
 
Posts: 2272
Joined: Sat Jul 05, 2003 1:18 pm
Location: A bunk in the back

Postby ylkien » Sat Apr 03, 2004 2:51 pm

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)
);
ylkien
New php-forum User
New php-forum User
 
Posts: 28
Joined: Sat Dec 14, 2002 9:43 am

Postby swirlee » Sat Apr 03, 2004 4:00 pm

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.
User avatar
swirlee
Moderator
Moderator
 
Posts: 2272
Joined: Sat Jul 05, 2003 1:18 pm
Location: A bunk in the back

Postby gesf » Sat Apr 03, 2004 8:43 pm

Reason: This is corruption of a MySQL database table. The 'phpbb_sessions table is damaged.
See: Corrupted MyISAM Tables and How to Repair Tables
User avatar
gesf
Moderator
Moderator
 
Posts: 1718
Joined: Sun Dec 29, 2002 5:03 am
Location: Portugal / Sweden


Return to MySQL Installation

Who is online

Users browsing this forum: Yahoo [Bot] and 0 guests

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.