NukeSentinel administration page is blank

New Member Joined: Sep 02, 2005 Posts: 2

I did a fresh install of NukeSentinel version 240b_71-78 on nuke version 7.6 patched with 3.1.

I followed the instructions uploaded the files, doubled checked my file edits and ran the install script. Initially the install script ran and produced the following error

error couldn't create nuke__nsnst_blocked_ips table.

All the rest of the tables were created. I had to manually create the nuke_nsnst_blocked_ips table from the code in the install.php scripts.

Everything appears to work, but when I try to access the NukeSentinel administration page from the main admin.php page, I get a blank page. I'm logged in under my GOD account. Just to be clear, I can access all other administrative functions, I'm just not able to get into the nukesentinel administration panel.

Any ideas?

Posted: Fri Sep 02, 2005 6:28 pm

DOH... Found the problem. The nuksentinel folder under admin/modules didn't get pushed out to my server. I had it copyed to my local site, but it didn't get syc'ed.

I am curious why I got the error trying to create the nuke_nsnst_blocked_ips table. Anyone else have this problem? I would expect to get that error if the table already existed, but it didn't.

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

Quote:

I am curious why I got the error trying to create the nuke_nsnst_blocked_ips table. Anyone else have this problem? I would expect to get that error if the table already existed, but it didn't.

We are looking into this. Thanks.

registered · Posted: Tue Sep 06, 2005 10:38 pm

Question, did it create the table but still render the error or did it render the error and not create the table?

The query in question is:

Code:

CREATE TABLE `nuke_nsnst_blocked_ips` (


`ip_addr` varchar( 15 ) NOT NULL default '',


`user_id` int( 11 ) NOT NULL default '1',


`username` varchar( 60 ) NOT NULL default '',


`user_agent` text NOT NULL ,


`date` int( 20 ) NOT NULL default '0',


`notes` text NOT NULL ,


`reason` tinyint( 1 ) NOT NULL default '0',


`query_string` text NOT NULL ,


`get_string` text NOT NULL ,


`post_string` text NOT NULL ,


`x_forward_for` varchar( 32 ) NOT NULL default '',


`client_ip` varchar( 32 ) NOT NULL default '',


`remote_addr` varchar( 32 ) NOT NULL default '',


`remote_port` varchar( 11 ) NOT NULL default '',


`request_method` varchar( 10 ) NOT NULL default '',


`expires` int( 20 ) NOT NULL default '0',


`c2c` char( 2 ) NOT NULL default '00',


PRIMARY KEY ( `ip_addr` ) ,


KEY `c2c` ( `c2c` ) ,


KEY `date` ( `date` ) ,


KEY `expires` ( `expires` ) ,


KEY `reason` ( `reason` )


)

Posted: Tue Sep 06, 2005 10:43 pm

It didn't create the table in my case.

Posted: Tue Sep 06, 2005 10:54 pm

line 28 of nsnst_installer/install.php has an error:

Code:

$result = $db->sql_query("CREATE TABLE `".$prefix."_nsnst_blocked_ips` (`ip_addr` varchar(15) NOT NULL default '', `user_id` int(11) NOT NULL default '1', `username` varchar(60) NOT NULL default '', `user_agent` text NOT NULL, `date` int(20) NOT NULL default '0', `notes` text NOT NULL, `reason` tinyint(1) NOT NULL default '0', `query_string` text NOT NULL, `get_string` text NOT NULL, `post_string` text NOT NULL, `x_forward_for` varchar(32) NOT NULL default '', `client_ip` varchar(32) NOT NULL default '', `remote_addr` varchar(32) NOT NULL default '', `remote_port` varchar(11) NOT NULL default '', `request_method` varchar(10) NOT NULL default '', `expires` int(20) NOT NULL default '0', `c2c` char(2) NOT NULL default '00', PRIMARY KEY (`ip_addr`), KEY `c2c` (`c2c`), KEY `date` (`date`), KEY `expires` (`expires`), KEY `reason` (`reason`))`");

Needs to be changed to:

Code:

$result = $db->sql_query("CREATE TABLE `".$prefix."_nsnst_blocked_ips` (`ip_addr` varchar(15) NOT NULL default '', `user_id` int(11) NOT NULL default '1', `username` varchar(60) NOT NULL default '', `user_agent` text NOT NULL, `date` int(20) NOT NULL default '0', `notes` text NOT NULL, `reason` tinyint(1) NOT NULL default '0', `query_string` text NOT NULL, `get_string` text NOT NULL, `post_string` text NOT NULL, `x_forward_for` varchar(32) NOT NULL default '', `client_ip` varchar(32) NOT NULL default '', `remote_addr` varchar(32) NOT NULL default '', `remote_port` varchar(11) NOT NULL default '', `request_method` varchar(10) NOT NULL default '', `expires` int(20) NOT NULL default '0', `c2c` char(2) NOT NULL default '00', PRIMARY KEY (`ip_addr`), KEY `c2c` (`c2c`), KEY `date` (`date`), KEY `expires` (`expires`), KEY `reason` (`reason`))");

It has a stray ` at the end of the query.

Posted: Tue Sep 06, 2005 11:02 pm