Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> NukeSentinel™ v2.4.x
Author Message
mael
New Member
New Member


Joined: Sep 02, 2005
Posts: 2

PostPosted: Fri Sep 02, 2005 6:09 pm Reply with quote

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?
 
View user's profile Send private message
mael
PostPosted: Fri Sep 02, 2005 6:28 pm Reply with quote

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.
 
Raven
Site Admin/Owner


Joined: Aug 27, 2002
Posts: 17086

PostPosted: Sun Sep 04, 2005 11:36 pm Reply with quote

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.
 
View user's profile Send private message
BobMarion
Former Admin in Good Standing


Joined: Oct 30, 2002
Posts: 1037
Location: RedNeck Land (known as Kentucky)

PostPosted: Tue Sep 06, 2005 10:38 pm Reply with quote

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` )
)

_________________
Bob Marion
Codito Ergo Sum
Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Send e-mail Visit poster's website
Raven
PostPosted: Tue Sep 06, 2005 10:43 pm Reply with quote

It didn't create the table in my case.
 
BobMarion
PostPosted: Tue Sep 06, 2005 10:54 pm Reply with quote

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.
 
Raven
PostPosted: Tue Sep 06, 2005 11:02 pm Reply with quote

Cheers
 
Display posts from previous:       
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> NukeSentinel™ v2.4.x

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©