Error: SESSIONS_KEYS_TABLE' doesn't exist - Help

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
Stylee
Registered User
Posts: 54
Joined: Mon May 19, 2003 10:15 pm

Error: SESSIONS_KEYS_TABLE' doesn't exist - Help

Post 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
Stylee
Registered User
Posts: 54
Joined: Mon May 19, 2003 10:15 pm

Post by Stylee »

I can eventually get there, only afetr hitting F5
I even have to clear the cookies several times.
Stylee
Registered User
Posts: 54
Joined: Mon May 19, 2003 10:15 pm

Post by Stylee »

I followed this, but still get the same thing

http://www.phpbb.com/phpBB/viewtopic.ph ... able+exist
User avatar
Lumpy Burgertushie
Registered User
Posts: 68476
Joined: Mon May 02, 2005 3:11 am
Contact:

Post 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
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.3 Styles by PlanetStyles.net

If nobody is in the forest, does a tree really fall?
Stylee
Registered User
Posts: 54
Joined: Mon May 19, 2003 10:15 pm

Post by Stylee »

Could you please tell me how to do that
User avatar
Lumpy Burgertushie
Registered User
Posts: 68476
Joined: Mon May 02, 2005 3:11 am
Contact:

Post 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
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.3 Styles by PlanetStyles.net

If nobody is in the forest, does a tree really fall?
Stylee
Registered User
Posts: 54
Joined: Mon May 19, 2003 10:15 pm

Post 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
Stylee
Registered User
Posts: 54
Joined: Mon May 19, 2003 10:15 pm

Post by Stylee »

Actually, this may be a different error all together, on a differnt file
User avatar
Lumpy Burgertushie
Registered User
Posts: 68476
Joined: Mon May 02, 2005 3:11 am
Contact:

Post 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
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.3 Styles by PlanetStyles.net

If nobody is in the forest, does a tree really fall?
Stylee
Registered User
Posts: 54
Joined: Mon May 19, 2003 10:15 pm

Post 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
User avatar
Lumpy Burgertushie
Registered User
Posts: 68476
Joined: Mon May 02, 2005 3:11 am
Contact:

Post 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
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.3 Styles by PlanetStyles.net

If nobody is in the forest, does a tree really fall?
Locked

Return to “2.0.x Support Forum”