phpBB Error creating new session

[Rietbergen]

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

 

[mrprez]

Yep, we had the same problem last week. Had to reintall.

 

[Website Rob]

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]

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

 

[kieranmullen]

I upgraded PHP version on ours and also enabled phpsuex support. So I have clicked defaults and tried rebuilding it... See if it works now...

KM

 

[WebScHoLaR]

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:

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

 

[kieranmullen]

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]

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:

ALTER TABLE `mos_session` ADD COLUMN `session_admin` tinyint(2) DEFAULT '0' NOT NULL

 

[sunyl]

Hi Buddy

Probably you uploaded it incorrectly. This document should help you: http://www.phpbb.com/kb/article.php?article_id=13

Sunyl