Page 1 of 1

Getting Session Errors

Posted: Tue Jun 14, 2005 8:15 pm
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

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.

phpmyadmin

Posted: Tue Jun 14, 2005 8:44 pm
by vcon13
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

Posted: Tue Jun 14, 2005 8:51 pm
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)


Jim