SQL PHPBB Upgrade error??

Client Joined: Dec 04, 2004 Posts: 757

Hello all, after upgrading my phpbb forums I found on the upgrade details
it showed this error

Updating version and optimizing tables
Progress :: . . Done
Result :: Some queries failed, the statements and errors are listing below

Error :: Table 'mrix_phpb1.SESSIONS_KEYS_TABLE' doesn't exist
SQL :: DELETE FROM SESSIONS_KEYS_TABLE

If it needs adding how would I go about adding it?

thanks for any help

mrix

registered · Site Admin Joined: Jun 04, 2004 Posts: 6437

Do you mean, what is the syntax for CREATE TABLE?

Posted: Thu Jun 08, 2006 7:39 am

Just basically why have the error ? and how can I fix it?
I also notice which I think is the same problem when I go to delete a member I get this error

DEBUG MODE

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

DELETE FROM SESSIONS_KEYS_TABLE WHERE user_id = 35

Line : 191
File : admin_users.php

thanks for you help

cheers
mrix

Posted: Thu Jun 08, 2006 7:58 am

Since the table is missing, I'm wondering if there was a problem when you set up the database. Maybe this table was to be created with the upgrade?

Posted: Thu Jun 08, 2006 8:16 am

To be totally honest I have had this problem for some time, I am now wondering what do I need to add this piece of code to my database is it straight forward?
Cheers
mrix

Posted: Thu Jun 08, 2006 8:20 am

I think you might be OK as long as you create the table in your database. You should be able to find the SQL to create the table in your installation script or instructions. Just to clarify, is this a Nuke installation or phpBB standalone?

Posted: Thu Jun 08, 2006 8:21 am

Its phpbb stand alone
cheers
mrix

Posted: Thu Jun 08, 2006 9:01 am

Did you find the CREATE TABLE statement for the SESSIONS_KEYS_TABLE table in your installation sql?

Posted: Thu Jun 08, 2006 9:27 am

No I didnt what would be the code I need to add to my database not sure where I can get it from etc.
Thanks again
mrix

Posted: Thu Jun 08, 2006 9:44 am

One of the files that came with your download should have a .sql extension. Open that file with a text editor and search for SESSIONS_KEYS_TABLE. There should be an SQL statement there that looks something like

CREATE TABLE SESSIONS_KEYS_TABLE.....

Copy that entire statement.

Log into your web account, and open phpMyAdmin. Select your database, then click SQL. Paste the SQL statement you copied, then click Go (I think) to run the statement.

Sells PC To Pay For Divorce Joined: Posts: 5661

maybe this helps..
http://www.phpbb.com/phpBB/viewtopic.php?p=1957543&highlight=&sid=cf416e2322b225461dd7e121f8e8dd2f