SQL PHPBB Upgrade error??

mrix · Client Joined: Dec 04, 2004 Posts: 524

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

kguske · Site Admin Joined: Jun 04, 2004 Posts: 4852

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

mrix · Client Joined: Dec 04, 2004 Posts: 524

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

kguske · Site Admin Joined: Jun 04, 2004 Posts: 4852

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?

mrix · Client Joined: Dec 04, 2004 Posts: 524

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

kguske · Site Admin Joined: Jun 04, 2004 Posts: 4852

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?

mrix · Client Joined: Dec 04, 2004 Posts: 524

Its phpbb stand alone
cheers
mrix

kguske · Site Admin Joined: Jun 04, 2004 Posts: 4852

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

mrix · Client Joined: Dec 04, 2004 Posts: 524

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

kguske · Site Admin Joined: Jun 04, 2004 Posts: 4852

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.

persona_non_grata · Joined: Posts: 0

maybe this helps..

Only registered users can see links on this board!
Get registered or login to the forums!