Error with Installs

Hangin' Around Joined: Mar 28, 2005 Posts: 42

I had version 7.7 running but completely deleted it after reading here and another site about security risks.

I downloaded the version 7.6 but kept getting access denied when I tried to access the admin pannel.

I decided to try the download from here and installed PHP-Nuke-7.6-patchedv3.0b. I can access the admin pannel just fine. However when I go into the forum section I receive the following error:

"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 ('11044ca3fedce123105ee84b8719b382', '2', '1122834821', '1122834821', '18fdd696', '0', '1', '0')

Line : 203
File : sessions.php "

I looked in mysql server and under nuke_bbsessions I do not have a entry that says session_admin. I have no clue how to add it.

I'm very dissapointed that I'm having all of these issues on an initial install. Even with the security risks in 7.7 the install was extremely clean.

Sells PC To Pay For Divorce Joined: Posts: 5661

no nothing wrong but you forgot to run the update..
look in the root folder...you missed that...

and to help you even more...
were talking about this..

Code:




alter table nuke_stories change informant informant varchar(25) not null default ''; 


alter table nuke_stories change aid aid varchar(25) not null default ''; 


alter table nuke_autonews change informant informant varchar(25) not null default ''; 


alter table nuke_autonews change aid aid varchar(25) not null default ''; 


alter table nuke_reviews change reviewer reviewer varchar(25) default NULL; 


alter table nuke_reviews_add change reviewer reviewer varchar(25) not null default ''; 


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


update nuke_bbconfig SET config_value='.0.15' where config_name='version';

Posted: Sun Jul 31, 2005 3:07 pm

I keep editing this post lol I found the file thanks for your help. It's working great!

Posted: Sun Jul 31, 2005 3:15 pm

Just upload all to your public_html folder..
Then install it with using the mysql file.
Then theres the upgrade.php you see in the root..
you only delete a INSTALL file...nothing else..
And reading some bit here and there howto do it all aint a waste of time.. Smile

Posted: Sun Jul 31, 2005 3:42 pm

I just took the file upgradesql I found under the html folder and added it to mysql - that seemed to do it. I just didn't realize I would have to upgrade something from a clean first time install.

Posted: Sun Jul 31, 2005 3:44 pm

normaly not...lolbut you are installing it after a patched release...
that comes with and upgrade as well...