Getting Session Errors

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
Registered User
Posts: 37
Joined: Thu Jan 20, 2005 9:45 pm
Location: East Yorkshire, UK

Getting Session Errors

Post by Noonster »

Members of my forums seem to be getting session errors on my site. I am stuck and don't seem to see what it causing. These are the errors we're getting.
phpBB : Critical Error
Error updating sessions table


SQL Error : 1034 Incorrect key file for table: 'phpbb_users'. Try to repair it

UPDATE phpbb_users SET user_session_time = 1118779418, user_session_page = -1, user_session_topic='0' WHERE user_id = 225

Line : 297

File : sessions.php

phpBB : Critical Error

Error creating new session


SQL Error : 1062 Duplicate entry '-1' for key 2

INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in) VALUES ('d05c85291e3909b7c67999a0fcbd6d23', -1, 1118778067, 1118778067, '51b3ebbc', 0, 0)

Line : 166

File : sessions.php

Any ideas?? Can't seem to think whats happening.

Registered User
Posts: 34
Joined: Sun May 15, 2005 11:34 pm


Post by vcon13 »

One of these posts may help. ... 152-1.html

I had a similar problem and it worked.

"Great people will always figure out why they can do it, fools will always figure out why others cant' do it."

User avatar
Former Team Member
Posts: 18478
Joined: Tue Oct 12, 2004 5:36 pm
Location: Darwen N.West UK

Post by Jim_UK »

You should update your board as well. (session_admin)
Version 2.0.15 introduced an extra field into that table.
INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in,session_admin)

The truth is out there.
Unfortunately they will not let you anywhere near it!


Return to “2.0.x Support Forum”