SQL error on insert sessions.php file?

ossaracer

Getting the following error on start up I know I have fixed something similar about a year ago....cant recall solutuion?? anyone help please??

phpBB : Critical Error

Error creating new session

DEBUG MODE

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

INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin) VALUES ('527a3bb7d9113b4988cf8a94b33943af', -1, 1227304637, 1227304637, '43bfc864', 0, 0, 0)

Line : 187
File : sessions.php

sneakyimp

I had a similar problem when the googlebot came to crawl my phpBB forum. The problem was that the googlebot didn't handle sessions so each and every page it accessed resulted in a new session record being created -- this caused the session table to overflow. Try emptying your session table? You should also check the phpBB forums for a solution. They would probably be much more familiar with the circumstances that lead to this problem.

cahva

Table is broken. That happens from time to time with mysql. Just use repair table on that:

REPAIR TABLE phpbb_sessions;

Sxooter

Ya know phpBB runs on top of another database that doesn't do things like this, right?

cahva

Oh yeah? What is it? SQLite, MsSQL, Oracle? 😉

Sxooter

Gosh I can't remember right now. It's on the tip of my tongue. I know I've used it before, but it's just slipping my mind. Some kind of follow on to an earlier project from berkely.

Let's see, Berkely gave us acid, unix, and a couple of databases... It's gotta be one of those things. 🙂