Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/Code)
 IPGate 2.4.3 beta and 2.3
 New Topic  Reply to Topic
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 11

AnonJr
Moderator

United States
5768 Posts

Posted - 17 April 2008 :  15:29:19  Show Profile  Visit AnonJr's Homepage  Reply with Quote
quote:
Originally posted by Desmomax

Hallo gpctexas!
hope you can help me as well...
i have installed your IPGate 2.4.3 Beta 2, i received an email from a user that every time he try to enter the result is this error:

Errore di run-time di Microsoft VBScript error '800a000d'

Tipo non corrispondente: '[string: "15, 192.168.200.15, "]'

/myforum/inc_ipgate.asp, line 377

the error line of inc_ipgate is:
num = Int(Mid(DottedIP, PrevPos + 1, pos - PrevPos - 1))


Looks like some problem with his Ip , i receive many other visit (around 200 each day) without any problem..

many thanx

Massimiliano


If memory serves, this stems from an issue with the string of routing addresses being reported. I know there was a bug report and a fix for the problems it was causing in the base code, but I don't know if it was addressed in this MOD. I seem to think it was, and that there was some code floating around for those that run into this problem.

If you can find the original bug report's thread, there's a detailed discussion on the whys and what-fors.

(Just figured I'd pull this issue up a little since it likely got lost when the next reply hit the next page...)<

Edited by - AnonJr on 17 April 2008 15:30:13
Go to Top of Page

gpctexas
Junior Member

320 Posts

Posted - 17 April 2008 :  19:09:43  Show Profile  Visit gpctexas's Homepage  Reply with Quote
That fix was implemented to the 2.4.4 mod<

ipgate 2.4.4 RC3
http://www.gpctexas.net/ipgate_v244.zip

Edited by - gpctexas on 17 April 2008 19:11:29
Go to Top of Page

palmdoc
Starting Member

23 Posts

Posted - 17 April 2008 :  21:21:27  Show Profile  Visit palmdoc's Homepage  Reply with Quote
Is IPGate hackable? I just had a Userban overcome and when I checked the End ban date it was changed to 70/51/2000 !!<
Go to Top of Page

gpctexas
Junior Member

320 Posts

Posted - 18 April 2008 :  22:34:10  Show Profile  Visit gpctexas's Homepage  Reply with Quote
There are no known vulnerabilities with the mod that I am aware of.<

ipgate 2.4.4 RC3
http://www.gpctexas.net/ipgate_v244.zip
Go to Top of Page

NiteOwl
Junior Member

Canada
403 Posts

Posted - 20 April 2008 :  16:05:22  Show Profile  Visit NiteOwl's Homepage  Reply with Quote
HI I am doing a completely new install, to SNiTZ 3.4.05 on a MySQL4 database, after running the dbs file I have these errors:


Net IPGate Mod v2.4 New Install

Dropping Table..

Table does not exist
Creating table(s)...
CREATE TABLE FORUM_IPLIST( IPLIST_ID INT (11) DEFAULT '' NOT NULL auto_increment , IPLIST_MEMBERID varchar(32) NULL DEFAULT 0, IPLIST_STARTIP varchar(32) NULL , IPLIST_STARTDATE varchar(32) NULL , IPLIST_ENDDATE varchar(32) NULL , IPLIST_COMMENT varchar(255) NULL , IPLIST_STATUS varchar(8) NULL , IPLIST_DBPAGEKEY varchar(32) NULL ,KEY FORUM_IPLIST_IPLIST_ID(IPLIST_ID))
CREATE TABLE FORUM_IPLIST( IPLIST_ID INT (11) DEFAULT '' NOT NULL auto_increment , IPLIST_MEMBERID varchar(32) NULL DEFAULT 0, IPLIST_STARTIP varchar(32) NULL , IPLIST_STARTDATE varchar(32) NULL , IPLIST_ENDDATE varchar(32) NULL , IPLIST_COMMENT varchar(255) NULL , IPLIST_STATUS varchar(8) NULL , IPLIST_DBPAGEKEY varchar(32) NULL ,KEY FORUM_IPLIST_IPLIST_ID(IPLIST_ID))
-2147217871 | Invalid default value for 'IPLIST_ID'

Dropping Table..

Table does not exist
Creating table(s)...
CREATE TABLE FORUM_PAGEKEYS( PAGEKEYS_ID INT (11) DEFAULT '' NOT NULL auto_increment , PAGEKEYS_PAGEKEY varchar(32) NULL ,KEY FORUM_PAGEKEYS_PAGEKEYS_ID(PAGEKEYS_ID))
CREATE TABLE FORUM_PAGEKEYS( PAGEKEYS_ID INT (11) DEFAULT '' NOT NULL auto_increment , PAGEKEYS_PAGEKEY varchar(32) NULL ,KEY FORUM_PAGEKEYS_PAGEKEYS_ID(PAGEKEYS_ID))
-2147217871 | Invalid default value for 'PAGEKEYS_ID'

Adding new records..
INSERT INTO FORUM_PAGEKEYS (PAGEKEYS_PAGEKEY) VALUES ('post.asp')
INSERT INTO FORUM_PAGEKEYS (PAGEKEYS_PAGEKEY) VALUES ('post.asp')
-2147217865 | Table 'cimare_prod.FORUM_PAGEKEYS' doesn't exist

Dropping Table..

Table does not exist
Creating table(s)...
CREATE TABLE FORUM_IPLOG( IPLOG_ID INT (11) DEFAULT '' NOT NULL auto_increment , IPLOG_MEMBERID varchar(32) NULL DEFAULT 0, IPLOG_IP varchar(32) NULL , IPLOG_PATHINFO varchar(255) NULL , IPLOG_DATE varchar(32) NULL ,KEY FORUM_IPLOG_IPLOG_ID(IPLOG_ID))
CREATE TABLE FORUM_IPLOG( IPLOG_ID INT (11) DEFAULT '' NOT NULL auto_increment , IPLOG_MEMBERID varchar(32) NULL DEFAULT 0, IPLOG_IP varchar(32) NULL , IPLOG_PATHINFO varchar(255) NULL , IPLOG_DATE varchar(32) NULL ,KEY FORUM_IPLOG_IPLOG_ID(IPLOG_ID))
-2147217871 | Invalid default value for 'IPLOG_ID'

Adding new records..
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATEBAN','1')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATELCK','0')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATECOK','0')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATEMET','0')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATEMSG','You are banned from these forums')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATELKMSG','Forums are currently locked')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATENOACMSG','You do not have access to the requested page')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATEWARNMSG','Your or another persons activity is being logged')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATEVER','Ver 2.4')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATELOG','1')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATETYP','0')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATEEXP','15')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATECSS','0')

Value(s) updated successfully


This is the dbs file provided:

Net IPGate Mod v2.4 New Install [DROP] IPLIST [END] [CREATE] IPLIST IPLIST_ID IPLIST_MEMBERID#varchar(32)#NULL#0 IPLIST_STARTIP#varchar(32)#NULL# IPLIST_STARTDATE#varchar(32)#NULL# IPLIST_ENDDATE#varchar(32)#NULL# IPLIST_COMMENT#varchar(255)#NULL# IPLIST_STATUS#varchar(8)#NULL# IPLIST_DBPAGEKEY#varchar(32)#NULL# [END] [DROP] PAGEKEYS [END] [CREATE] PAGEKEYS PAGEKEYS_ID PAGEKEYS_PAGEKEY#varchar(32)#NULL# [END] [INSERT] PAGEKEYS (PAGEKEYS_PAGEKEY)#('post.asp') [END] [DROP] IPLOG [END] [CREATE] IPLOG IPLOG_ID IPLOG_MEMBERID#varchar(32)#NULL#0 IPLOG_IP#varchar(32)#NULL# IPLOG_PATHINFO#varchar(255)#NULL# IPLOG_DATE#varchar(32)#NULL# [END] [INSERT] CONFIG_NEW (C_VARIABLE,C_VALUE)#('STRIPGATEBAN','1') (C_VARIABLE,C_VALUE)#('STRIPGATELCK','0') (C_VARIABLE,C_VALUE)#('STRIPGATECOK','0') (C_VARIABLE,C_VALUE)#('STRIPGATEMET','0') (C_VARIABLE,C_VALUE)#('STRIPGATEMSG','You are banned from these forums') (C_VARIABLE,C_VALUE)#('STRIPGATELKMSG','Forums are currently locked') (C_VARIABLE,C_VALUE)#('STRIPGATENOACMSG','You do not have access to the requested page') (C_VARIABLE,C_VALUE)#('STRIPGATEWARNMSG','Your or another persons activity is being logged') (C_VARIABLE,C_VALUE)#('STRIPGATEVER','Ver 2.4') (C_VARIABLE,C_VALUE)#('STRIPGATELOG','1') (C_VARIABLE,C_VALUE)#('STRIPGATETYP','0') (C_VARIABLE,C_VALUE)#('STRIPGATEEXP','15') (C_VARIABLE,C_VALUE)#('STRIPGATECSS','0') [END]

And I am getting this error aven after running setup.asp

Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
Table 'cimare_prod.FORUM_IPLIST' doesn't exist
/forum/inc_ipgate.asp, line 81


Any Ideas what I can do to fix this, should I manually add a column?


*** I see this fellow has the same problem:
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=65275&SearchTerms=Invalid,default,value,for,'IPLIST_ID'

-=NiteOwl=-
<

Edited by - NiteOwl on 20 April 2008 16:53:43
Go to Top of Page

NiteOwl
Junior Member

Canada
403 Posts

Posted - 21 April 2008 :  05:09:46  Show Profile  Visit NiteOwl's Homepage  Reply with Quote
ahhh, here is the fix, I kept reading the different posts and did not clue in that I need to change 2 of the base SNiTZ files, now all works.

As posted by Davio here
On line 275 in the admin_mod_dbsetup.asp file, remove the following code in red:
strSql = strSql & idFieldName &" INT (11) DEFAULT '' NOT NULL auto_increment "
And do the same thing for line 307 in the admin_mod_dbsetup2.asp file.
Then run the DBS files again.

-=NiteOwl=-<

Edited by - NiteOwl on 21 April 2008 05:10:44
Go to Top of Page

gpspassion
Junior Member

260 Posts

Posted - 21 October 2010 :  16:16:39  Show Profile  Visit gpspassion's Homepage  Reply with Quote
Any thoughts on using IPGate as an anti-scraping (someone downloading all the pages of the forums) tool? Thanks!
Go to Top of Page
Page: of 11 Previous Topic Topic Next Topic  
Previous Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000 Version 3.4.07