Page 1 of 1

Error: SESSIONS_KEYS_TABLE' doesn't exist - Help

Posted: Tue Jun 20, 2006 11:41 pm
by Stylee
After upgrade to 2.0.21 form .19I get this same error, on 2 different boards..
phpBB : Critical Error

Error doing DB query userdata row fetch

DEBUG MODE

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

SELECT u.* FROM phpbb_users u, SESSIONS_KEYS_TABLE k WHERE u.user_id = 14 AND u.user_active = 1 AND k.user_id = u.user_id AND k.key_id = 'b253a76263df963f25cb04c3e366cc24'

Line : 89
File : sessions.php

Posted: Tue Jun 20, 2006 11:44 pm
by Stylee
I can eventually get there, only afetr hitting F5
I even have to clear the cookies several times.

Posted: Tue Jun 20, 2006 11:53 pm
by Stylee
I followed this, but still get the same thing

http://www.phpbb.com/phpBB/viewtopic.ph ... able+exist

Posted: Wed Jun 21, 2006 12:35 am
by Lumpy Burgertushie
well, you must have made a mistake.

when you get that error with the table name in all uppercase letters, it means that that table has not been defined in your contstants.php file.

simple as that.

once you get that line of code inserted into that file, then you won't get that error .

robert

Posted: Wed Jun 21, 2006 12:39 am
by Stylee
Could you please tell me how to do that

Posted: Wed Jun 21, 2006 1:05 am
by Lumpy Burgertushie
Stylee wrote: Could you please tell me how to do that


using a text editor only, open your includes/constants.php file

find this section and make sure it looks exactly like this:

Code: Select all

define('SEARCH_MATCH_TABLE', $table_prefix.'search_wordmatch');
define('SESSIONS_TABLE', $table_prefix.'sessions');
define('SESSIONS_KEYS_TABLE', $table_prefix.'sessions_keys');
define('SMILIES_TABLE', $table_prefix.'smilies');
robert

Posted: Wed Jun 21, 2006 1:21 am
by Stylee
YES!!!!! Thats it buddy!
Thank you.

I have this error on the other board, looks the same, but a bit different, would I use the exact change?
phpBB : Critical Error

Error updating session key

DEBUG MODE

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

INSERT INTO SESSIONS_KEYS_TABLE(key_id, user_id, last_ip, last_login) VALUES ('8ec9a3f23314c38a1a37b865e25be2f8', 3, '1801ef8b', 1150852792)

Line : 229
File : sessions.php

Posted: Wed Jun 21, 2006 1:23 am
by Stylee
Actually, this may be a different error all together, on a differnt file

Posted: Wed Jun 21, 2006 2:09 am
by Lumpy Burgertushie
Stylee wrote: Actually, this may be a different error all together, on a differnt file


if you get an error that a table does not exist and the table name is in all caps, then it is the same thing. you are missing that table definition in the constants.php file.


robert

Posted: Wed Jun 21, 2006 2:17 am
by Stylee
I copied the fixed constants.php to the other site, and now it appears to functioning properly.

Once again,
From my game team, and my rock band, thank you very much! :D

Posted: Wed Jun 21, 2006 2:59 am
by Lumpy Burgertushie
Stylee wrote: I copied the fixed constants.php to the other site, and now it appears to functioning properly.

Once again,
From my game team, and my rock band, thank you very much! :D


very welcome, good luck,

robert