phpBB : Critical Error - Error creating new session

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
sugarbear
Registered User
Posts: 5
Joined: Thu Sep 04, 2008 1:45 pm

phpBB : Critical Error - Error creating new session

Post by sugarbear » Tue Nov 25, 2008 5:03 pm

Hello,

I'm getting the following error:

phpBB : Critical Error

Error creating new session

DEBUG MODE

SQL Error : 1105 File './phpbb_6/phpbb_sessions.MYD' not found (Errcode: 13)

INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin) VALUES ('762fa5f35198aea238df4b17a8891396', 3, 1227632533, 1227632533, 'cf05cec6', 0, 1, 0)

Line : 189
File : sessions.php

Any ideas how I can fix this?

thank you!
sug

User avatar
JimA
Community Team Leader
Community Team Leader
Posts: 7620
Joined: Thu Jul 31, 2008 5:54 am
Location: The Netherlands
Name: Jim Mossing Holsteyn
Contact:

Re: phpBB : Critical Error - Error creating new session

Post by JimA » Tue Nov 25, 2008 6:13 pm

Error no. 13 is a permissions error, there are problems with the permissions of MySQL or the whole MYD file is missing. You need to contact your host to fix this.
Image Jim Mossing Holsteyn - Community Team Leader
Knowledge Base | Documentation | Board rules

If you're having any questions about the rules/customs of this website, feel free to drop me a PM.

sugarbear
Registered User
Posts: 5
Joined: Thu Sep 04, 2008 1:45 pm

Re: phpBB : Critical Error - Error creating new session

Post by sugarbear » Wed Nov 26, 2008 1:41 pm

thank you Jim,
I contacted them a few days ago, but they have not been able to fix it yet, do you think this is fixable?

I have a backup file I made the day before it went down called 23_Nov_2008-22_34_09.sql does this contain everything I need to restore my board, if it can't be fixed?

thank you for your help!!!!

espicom
Registered User
Posts: 17905
Joined: Wed Dec 22, 2004 1:14 am
Location: Woodstock, IL

Re: phpBB : Critical Error - Error creating new session

Post by espicom » Wed Nov 26, 2008 3:38 pm

The "problem" is that the file isn't available because the operating system has locked it. This means you probably can't even drop the table and replace it, because the file name is in use.

If it WILL let you drop the phpbb_sessions table, you can recreate it with this SQL statement:

Code: Select all

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,
   session_admin tinyint(2) 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)
);
Jeff
Fixing 1016/1030/1034 Errors | (obsolete link) | MySQL 4.1/5.x Client Error | phpBBv2 Logo in ACP
Support requests via PM are ignored!
"To be fully alive is to feel that everything is possible." - Eric Hoffer

Locked

Return to “2.0.x Support Forum”