>> Site Map >> Forums >> Installation 7x
Forum module - topics in forum:
Installation 7x - Discussions regarding PHP-Nuke Installation and Configuration. 7x
New Install Forum Problem?
Just installed 7.6 as recommeded by this site. Everything seems ok until i go to forum button. I get the following message;
| 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 ('64a85be4f9b64708b982cf1c9a0271b9', 2, 1159007257, 1159007257, '5680af21', 0, 1, 0) Line : 190 File : sessions.php |
Try the search function.
Search for what? I dont understand the error sry!?
SQL Error : 1054 Unknown column 'session_admin' in 'field list'
would be a good start.
Ok iv'e had a look at this problem there appears to be a few with similar problems? Unfortunately no concrete solution. I used the sql table given with the d/l version? And all points to admin_session being missing? How on earth do i get this back?
In PHPMyAdmin - drop the nuke_bbsessions table then run the follwing SQL query:
| Code: : |
| CREATE TABLE `nuke_bbsessions` ( `session_id` char(32) NOT NULL default '', `session_user_id` mediumint(8) NOT NULL default '0', `session_start` int(11) NOT NULL default '0', `session_time` int(11) NOT NULL default '0', `session_ip` char(8) NOT NULL default '0', `session_page` int(11) NOT NULL default '0', `session_logged_in` tinyint(1) NOT NULL default '0', `session_admin` tinyint(2) NOT NULL default '0', PRIMARY KEY (`session_id`), KEY `session_user_id` (`session_user_id`), KEY `session_id_ip_user_id` (`session_id`,`session_ip`,`session_user_id`) ) TYPE=MyISAM; |
Great help and much appreciated. I wouldnt have had a clue thanks again.
Take it it worked then?
Yes it worked, but now i'm getting a similar error relating to the users table??
Something to do with users, login etc... totally confusing.
It appears to me that the sql file enclosed with the 7.6 d/l is in someway incomplete? Would it be possible for someone to sort out the download? or just fix the sql data. Or even stick one in your d/l section to reduce the amount of spamming on these forums.
I'd like to know what version is considered to be the safest and most complete?
I had a look on the search re my problem with the login... but only found 43 pages ... but again similar problems but none the same?
SQL Error : 1054 Unknown column 'user_login_tries' in 'field list'
SELECT user_id, username, user_password, user_active, user_level, user_login_tries, user_last_login_try FROM nuke_users WHERE username = 'Butcher'
Line : 70
File : login.php
Where did you get your 7.6 from?
Are you using the Raven Package?
Looks like in your case the SQL hasnt been imported completely... try this:
http://ravenphpscripts.com/viewdownloaddetails-26-242.html
Complete with an installer....
BTW - if >THIS< is the site you mean - then that is NOT 7.6... but at least 7.7 as the source code mentions the awful TinyMCE editor - which is included with versions we don't support here....
I got it from the link here? I do however run as u have mentioned 7.9 on the same server on (obviously another database). The 7.6 is here http://www.armchair-assassins.co.uk/Ta-Web/html/index.php <--- this is the one with the probs... i'm downgrading as i'm gettin too many errors on the 7.9 install.
Looks like a standard Nuke install obtained from phpbuke.org
Give the Raven Package a try in my previous post.... Comes completed with Sentinel (Nuke Security addon)
| Quote: : |
Something to do with users, login etc... totally confusing. |
just registered and logged in fine there...
I too can do that. But logout and then try the log-in again?
I got the install from this link:
http://www.nukescripts.net/modules.php?name=Downloads&op=getit&lid=26 Nukescripts 7.6 with newest patch
Still waiting on confirmation email from the abvoe site!! I'll give raven a try.
