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 » Tue Jun 20, 2006 11:41 pm

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 » Tue Jun 20, 2006 11:44 pm

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 » Tue Jun 20, 2006 11:53 pm

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: 66907
Joined: Mon May 02, 2005 3:11 am
Contact:

Post by Lumpy Burgertushie » Wed Jun 21, 2006 12:35 am

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.2 Styles by PlanetStyles.net

If a tree falls in the forest and nobody is there, does it make a sound?

Stylee
Registered User
Posts: 54
Joined: Mon May 19, 2003 10:15 pm

Post by Stylee » Wed Jun 21, 2006 12:39 am

Could you please tell me how to do that

User avatar
Lumpy Burgertushie
Registered User
Posts: 66907
Joined: Mon May 02, 2005 3:11 am
Contact:

Post by Lumpy Burgertushie » Wed Jun 21, 2006 1:05 am

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.2 Styles by PlanetStyles.net

If a tree falls in the forest and nobody is there, does it make a sound?

Stylee
Registered User
Posts: 54
Joined: Mon May 19, 2003 10:15 pm

Post by Stylee » Wed Jun 21, 2006 1:21 am

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 » Wed Jun 21, 2006 1:23 am

Actually, this may be a different error all together, on a differnt file

User avatar
Lumpy Burgertushie
Registered User
Posts: 66907
Joined: Mon May 02, 2005 3:11 am
Contact:

Post by Lumpy Burgertushie » Wed Jun 21, 2006 2:09 am

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.2 Styles by PlanetStyles.net

If a tree falls in the forest and nobody is there, does it make a sound?

Stylee
Registered User
Posts: 54
Joined: Mon May 19, 2003 10:15 pm

Post by Stylee » Wed Jun 21, 2006 2:17 am

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: 66907
Joined: Mon May 02, 2005 3:11 am
Contact:

Post by Lumpy Burgertushie » Wed Jun 21, 2006 2:59 am

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.2 Styles by PlanetStyles.net

If a tree falls in the forest and nobody is there, does it make a sound?

Locked

Return to “2.0.x Support Forum”