Page 1 of 1

Error removing auto-login keys

Posted: Thu Jan 04, 2007 2:36 am
by buntyindia
i am getting the following error while changing the password....

i m using phpbb 2.0.20

Code: Select all

phpBB : Critical Error

Error removing auto-login keys

DEBUG MODE

SQL Error : 1146 Table 'swes_rohinidata.SESSIONS_KEYS_TABLE' doesn't exist

DELETE FROM SESSIONS_KEYS_TABLE WHERE user_id = 3

Line : 535
File : sessions.php

Posted: Thu Jan 04, 2007 2:54 am
by cybrid23
You missed an update to the /includes/constants.php file. You may have other out of date files.

Edit your includes/constant.php

FIND:

Code: Select all

define('SESSIONS_TABLE', $table_prefix.'sessions');
AFTER ADD:

Code: Select all

define('SESSIONS_KEYS_TABLE', $table_prefix.'sessions_keys'); 

Posted: Thu Jan 04, 2007 1:36 pm
by buntyindia
I am still getting this error....i am also hitting error while i deleting a user

user is deleted but i am getting this error


Could not delete auto-login keys for this user

Code: Select all

DEBUG MODE

SQL Error : 1146 Table 'swes_rohinidata.SESSIONS_KEYS_TABLE' doesn't exist

DELETE FROM SESSIONS_KEYS_TABLE WHERE user_id = 4457

Line : 213
File : admin_users.php

Posted: Thu Jan 04, 2007 3:12 pm
by cybrid23
Upload a new /includes/constant.php file.

That error in all CAPS means that it is not defined in that file. The fix I posted is the solution.

If a new constant.php file does not take care of it, we will have to look deeper.

Posted: Fri Jan 05, 2007 4:47 pm
by buntyindia
Thanks Problem Solved