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

Getting Session Errors

Post by Noonster » Tue Jun 14, 2005 8:15 pm

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

DEBUG MODE

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

DEBUG MODE

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.

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

phpmyadmin

Post by vcon13 » Tue Jun 14, 2005 8:44 pm

One of these posts may help.

http://www.webhostingtalk.com/archive/t ... 152-1.html
http://www.phpbb.com/phpBB/viewtopic.php?p=1176647

I had a similar problem and it worked.

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

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

Post by Jim_UK » Tue Jun 14, 2005 8:51 pm

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)


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

Locked

Return to “2.0.x Support Forum”