Error removing auto-login keys

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
buntyindia
Registered User
Posts: 69
Joined: Tue Mar 01, 2005 4:23 pm
Location: India
Contact:

Error removing auto-login keys

Post by buntyindia » Thu Jan 04, 2007 2:36 am

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
=====================
Knowledge Is Power Share It

cybrid23
Former Team Member
Posts: 9877
Joined: Wed Jun 29, 2005 5:55 am
Location: Somewhere in the Midwest...
Contact:

Post by cybrid23 » Thu Jan 04, 2007 2:54 am

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'); 
---Never leave home without a towel and your peril sensitive sunglasses.
---Do Not PM Me For Support. It will go unanswered.
Thanks.

buntyindia
Registered User
Posts: 69
Joined: Tue Mar 01, 2005 4:23 pm
Location: India
Contact:

Post by buntyindia » Thu Jan 04, 2007 1:36 pm

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
=====================
Knowledge Is Power Share It

cybrid23
Former Team Member
Posts: 9877
Joined: Wed Jun 29, 2005 5:55 am
Location: Somewhere in the Midwest...
Contact:

Post by cybrid23 » Thu Jan 04, 2007 3:12 pm

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.
---Never leave home without a towel and your peril sensitive sunglasses.
---Do Not PM Me For Support. It will go unanswered.
Thanks.

buntyindia
Registered User
Posts: 69
Joined: Tue Mar 01, 2005 4:23 pm
Location: India
Contact:

Post by buntyindia » Fri Jan 05, 2007 4:47 pm

Thanks Problem Solved
=====================
Knowledge Is Power Share It

Locked

Return to “2.0.x Support Forum”