Members List Error

digitalpimp · Client Joined: Aug 11, 2005 Posts: 32

I hope I posted this in the right forum, if not I appologize. I cannot use the Members List option, I get the following error:

Code:

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 ('bbf46d6351af0a8cde1674e52e69c18e', '2', '1124790849', '1124790849', '4770c14a', '0', '1', '0')

Line : 203
File : sessions.php

I use a stand alone version of phpbb and not the phpnuke version. I am currently running phpnuke 7.6 3.1 patch. What do I need to do to be able to use the Members List feature? Any help is much appreciated and I will make another donation to Raven if I can get this problem fixed.

hitwalker · Sells PC To Pay For Divorce Joined: Posts: 5661

well to me it looks like the same error that you get that the forum has to be updated...

technocrat · Posted: Tue Aug 23, 2005 9:30 am

Code:

ALTER TABLE nuke_bbsessions ADD COLUMN session_admin tinyint(2) DEFAULT '0' NOT NULL;

Though you must have missed a step in your upgrade, so you should really complete it.

Xiode · Regular Joined: Jun 15, 2005 Posts: 78 Location: AR

Well that is included in upgrade.php that comes with the patch. It also updates a couple other tables so it maybe of you best interest to track that file down.

digitalpimp · Client Joined: Aug 11, 2005 Posts: 32

Please excuse my ignorance but I am not understanding?

Quote:

Though you must have missed a step in your upgrade, so you should really complete it.

I am lost. I installed a fresh copy of 7.6 with the patch already included. I am unsure what step or upgrade you are referring to?

Quote:

Well that is included in upgrade.php that comes with the patch. It also updates a couple other tables so it maybe of you best interest to track that file down.

I didn't have to upgrade your use the patch since it was already included with the phpnuke 7.6 files?

Thanks for the fast replies. I am still lost =( Xiode can you please help me find a link to that file?

Xiode · Regular Joined: Jun 15, 2005 Posts: 78 Location: AR

Yes you still need to run the upgrade.php file.

It should be in the root folder...

Where did you get this package?

if anything drop by nukeresources.com and grab the 3.1 patch, upload it, overwrite all thefiles just like you were alppying the patch and then run the upgrade.php file

all you should have to do to run it is log into admin and go to

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

digitalpimp · Client Joined: Aug 11, 2005 Posts: 32

I got the phpnuke 7.6 files with 3.1 patch from nuke resources I think?

Xiode · Regular Joined: Jun 15, 2005 Posts: 78 Location: AR

ok make sure that upgrade.php is in the root folder and run it via http.

digitalpimp · Client Joined: Aug 11, 2005 Posts: 32

Ok in the original install files there is a folder upgrades. I ftp'ed the file upgrade75-76.php to my root, called it via browser and said it completed ok but I still get the same error when I click on the members list...

digitalpimp · Client Joined: Aug 11, 2005 Posts: 32

I got it! I am an idiot!! LoL The upgrade.php file was still there in my root from the original install and I overlooked it. I executed it and all is well. Thank you so much all! I will head over to the donations block soon! Thanks!!!