Error

Nuke Soldier Joined: Aug 02, 2006 Posts: 16

Fresh install of 7.6 with 3.0 security patches installed

When I click on forums I get this error

Quote:

phpBB : Critical Error

Error creating new session

DEBUG MODE

SQL Error : 1054 Unknown column 'session_admin' in 'field list'

INSERT INTO nuke_bbsessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin) VALUES ('25b5724ce57e9273d473f709352dd785', '1', '1155477290', '1155477290', '522f55aa', '0', '0', '0')

Line : 203
File : sessions.php

I have looked inside the forums folder and it looks like the phpNuke 7.6 came with the forum available so, If this is because I have not installed something please point this noob to the item to read, thanks

Lieutenant Joined: May 11, 2003 Posts: 167

CHECK IN YOUR VDATABASE IF THE FIELD SESSION_ADMIN EXISTS IN TABLE NUKE_BBSESSIONS

Sergeant Joined: Sep 11, 2003 Posts: 118

Ok, I was having the same problem and have looked and no, it's not there in the table. I don't know how to edit tables really, is there anyway to fix this?? Thanks

Corporal Joined: Oct 22, 2006 Posts: 59

Use your favourite method to execute this SQL query (phpmyadmin, a php script etc):

*edit* ok, damn... the hack-protection on this site is preventing me from posting the query you need. Put it together from this, paste each one after another to make the full query.

Code:

ALTER

Code:

TABLE `nuke_bbsessions`

Code:

ADD COLUMN

Code:

'session_admin' TINYINT( 2 )

Code:

NOT NULL;

Curiously I think there are some 7.6 packages out there that have been played with. I've had a couple of the "patched" ones that are missing db columns etc...