Forum Problem

Posted: Mon Dec 05, 2005 8:28 pm

Hi All,
I have just installed Raven Nuke 76. Installation went good except for:
When I login to the Forum I am getting the folloing Message:
*******************************************************
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 ('3f783468d0f3f387ab0570a9ad46d8eb', '1', '1133834690', '1133834690', '3d448206', '0', '0', '0')

Line : 220
File : sessions.php
****************************************************
Can anyone help please
Problem can be seen on my site at [ Only registered users can see links on this board! Get registered or login! ]
Thanking you
Ray

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

I have not experienced that problem. Very strange indeed. I would do this.

- DROP the entire database.
- Create the new database and update your config.php with the MySQL settings.
- Run [ Only registered users can see links on this board! Get registered or login! ]
- Load raven_base.sql
- raven_ip2country.sql files 1 to 6
- Rename or delete the INSTALLATION folder
- Run [ Only registered users can see links on this board! Get registered or login! ] - You should now see your site.
- Create nuke god admin id/pass
- Log into ACP
- Select Preferences. Correct the site name and email addresses
- Select NukeSentinel(tm). Update email address. Type .htaccess in .htaccess path box and save. Scan for new Admins. Edit admin auth list. Add password and save. Select NS administration. Activate HTTP Auth and save.
- Select Forums from nuke ACP

You should not see an error.

Posted: Mon Dec 05, 2005 11:48 pm

Just make sure you have the 'session_admin' field in the nuke_bbsessions table

Or in phpMyAdmin

Code:




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

Posted: Mon Dec 05, 2005 11:51 pm

It was actually more than that. He needed to reinstall.

Posted: Mon Dec 05, 2005 11:58 pm

Ah bad installation?
Just giving him the solution that would be apparent from his error message, no harm Smile

Posted: Tue Dec 06, 2005 12:02 am

Sorry. Didn't mean to be so blunt Laughing

Yes, we had been PM'ing each other. I knew if he was getting an error like that that something else was really wrong Wink