phpBB Error creating new session

Rietbergen

Member
Nov 24, 2002
9
0
151
Can you tell me what to do?

My Forum does not work anymore
when I try to reach it I get the error message:

phpBB : Critical Error
Error creating new session
 

Website Rob

Well-Known Member
Mar 23, 2002
1,504
1
318
Alberta, Canada
cPanel Access Level
Root Administrator
More please. :)

Info that is.

What version was it?
Was this installed through Cpanel or Manually?

I use 2.0 (with an upgrade patch) and installed manually. Never had a problem, except for one-time when somebody took advantage of a bug -- hence the upgrade patch.
 

kosmo

Well-Known Member
Verifed Vendor
Aug 12, 2001
403
0
316
All over Europe
I have a similar problem for 3-4 days now: ALL my phpBBforums (several ones, including at cpanelthemes.com) will not accept login unless I check the &autologin next time&. This is true for MacIE. Other Mac browsers can not login at all. Windows users can login without any problems.

This happened suddenly, I don't know what the reason is.

kosmo
 

WebScHoLaR

Well-Known Member
Dec 14, 2005
510
3
168
Planet Earth
Rietbergen said:
Can you tell me what to do?

My Forum does not work anymore
when I try to reach it I get the error message:

phpBB : Critical Error
Error creating new session
If you have access to phpMyAdmin, try running the following query on the database:

Code:
TRUNCATE phpbb_sessions;
If you need help with running queries in phpMyAdmin, here is a great tutorial on it:
http://www.phpbb.com/kb/article.php?article_id=151
 
Last edited:

kieranmullen

Well-Known Member
Aug 25, 2005
165
0
166
Portland, OR USA
Thanks for the info. I exectured it in the mysql area and I still get the same result..
phpBB : Critical Error

Error creating new session

DEBUG MODE

SQL Error : 1054 Unknown column 'session_admin' in 'field list'

INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin) VALUES ('889669b7de2dc2dc7c5d883f61ce8f69', -1, 1135559070, 1135559070, '181673a9', 0, 0, 0)

Line : 189
File : sessions.php
 

AndyReed

Well-Known Member
PartnerNOC
May 29, 2004
2,221
4
193
Minneapolis, MN
kieranmullen said:
Thanks for the info. I exectured it in the mysql area and I still get the same result..
Backup your database before performing this fix.

This is a syntax error. Check the manual that corresponds to your MySQL server version for the right syntax to use near ession_admin and change it to session_admin.

You also need to run this code in phpMyAdmin:
Code:
ALTER TABLE `mos_session` ADD COLUMN `session_admin` tinyint(2) DEFAULT '0' NOT NULL