The World of Avlis

Posted: **Fri Feb 18, 2005 12:00 am**

When I try to access one of my Forums, I get this error:

phpBB : Critical Error

Error creating new session

DEBUG MODE

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

INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in) VALUES ('f36662f40b8ef28106bd472dd54b689e', -1, 1108684110, 1108684110, 'c2f73399', 0, 0)

Line : 158
File : /homeb/s2/www/falcon4.uklinux.net/phpBB2/includes/sessions.php

I can FTP the site and as far as I can tell, the files all appear to be there and I am sure the URL I am using is correct. As I can still FTP the site, I assume my subscription has not expired.

Can anyone suggest what might be wrong please? Has the site been hacked, is the DB corrupt, or what?

Other Forums (Fora?) on the same Host are working, so the whole site is not down. The site is my Avlis UK site, so I would like to get it working again if possible.

Posted: **Fri Feb 18, 2005 4:35 am**

MySQL is trying to write to one of the data files on disk called phpbb_sessions.MYD. This data files directly correlates with the phpbb_sessions table of your database. For some reason, it can't open that file for writing.

What you can do is to repair your phpbb_sessions table (you will find the link in phpMyAdmin). If the table is too damaged, you will have to delete it and recreate it. This shouldn't messup the boards since it is only recording current session data.

Posted: **Fri Feb 18, 2005 5:21 pm**

Thanks Alex.

It wouldn't let me repair it, so I dropped it and ran an SQL script to recreate it. Now I can access the Website again.

It does not seem to have caused any problems with the loss of the Session history.

*Rushes off to backup the database now it is available again*

The World of Avlis

Technical Advice please

Technical Advice please