Author |
Topic |
|
KMC
Starting Member
40 Posts |
Posted - 20 January 2003 : 02:22:22
|
I have IPGate installed and everything seems to be installed correctly. However the logging feature is not working. Nothing is being logged. I've seen that others have also had this problem and I've tried the fixes suggested but it's still a no go.
I've included <!--#INCLUDE FILE="inc_ipgate.asp"--> first at line 235 then at line 236 of inc_header.asp....
quote:
Response.Write "<html>" & vbNewline & vbNewline & _ "<head>" & vbNewline & _ "<title>" & GetNewTitle(strScriptName) & "</title>" & vbNewline <!--#INCLUDE FILE="inc_ipgate.asp"--> '## START - REMOVAL, MODIFICATION OR CIRCUMVENTING THIS CODE WILL VIOLATE THE SNITZ FORUMS 2000 LICENSE AGREEMENT
I can't figure out what the problem is.
Help!??? |
|
Heynow
Junior Member
374 Posts |
|
KMC
Starting Member
40 Posts |
Posted - 20 January 2003 : 12:49:49
|
Thanks. I just tried it and it's still not working. I'm about to give up. |
|
|
Chuck McB
Junior Member
WooYay
196 Posts |
Posted - 20 January 2003 : 19:50:32
|
try using
%>
<!--#INCLUDE FILE="inc_ipgate.asp"-->
<%
|
|
|
KMC
Starting Member
40 Posts |
Posted - 21 January 2003 : 00:30:36
|
That did it!!!! Oh, I could kiss you Chuck McB!! Thank you so much!!!! |
|
|
Chuck McB
Junior Member
WooYay
196 Posts |
Posted - 21 January 2003 : 12:05:07
|
\o/ |
|
|
KMC
Starting Member
40 Posts |
Posted - 21 January 2003 : 13:26:51
|
Ooooh Chuck, if you're still out there, I've run into a new problem. Since adding that code numerous people have been unable to access board when Banning is set to ON, even though no one's been banned. The error message they get is....
quote:
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters. /forum/inc_ipgate.asp, line 160
Any clue....anyone??
|
|
|
Chuck McB
Junior Member
WooYay
196 Posts |
Posted - 21 January 2003 : 17:06:37
|
these are the lines just before 160 do they match yours?
Set rs2 = Server.CreateObject("ADODB.Recordset")
StrSql = "SELECT IPLIST_STARTDATE, IPLIST_ENDDATE, IPLIST_STATUS, IPLIST_DBPAGEKEY "
StrSql = StrSql & "FROM " & strTablePrefix & "IPLIST"
StrSql = StrSql & " WHERE ('" & userip & "' = IPLIST_STARTIP" 'find matching ips
StrSql = StrSql & " OR '" & userhost & "' = IPLIST_STARTIP" 'find matching hosts
'StrSql = StrSql & " OR instr('" & userip & "', IPLIST_STARTIP) <> 0" 'find matching ranges
StrSql = StrSql & " OR '" & strDBNTUserName & "' = IPLIST_MEMBERID" 'find matching members
StrSql = StrSql & ") AND ('" & userdate & "' >= IPLIST_STARTDATE"
StrSql = StrSql & " AND '" & userdate & "' <= IPLIST_ENDDATE )"
rs2.Open StrSql, strConnString
|
|
|
KMC
Starting Member
40 Posts |
Posted - 21 January 2003 : 17:26:25
|
This is what I had....
quote: Set rs2 = Server.CreateObject("ADODB.Recordset")
StrSql = "SELECT IPLIST_STARTDATE, IPLIST_ENDDATE, IPLIST_STATUS, IPLIST_DBPAGEKEY " StrSql = StrSql & "FROM " & strTablePrefix & "IPLIST" StrSql = StrSql & " WHERE ('" & userip & "' = IPLIST_STARTIP" 'find matching ips StrSql = StrSql & " OR '" & userhost & "' = IPLIST_STARTIP" 'find matching hosts StrSql = StrSql & " OR instr('" & userip & "', IPLIST_STARTIP) <> 0" 'find matching ranges StrSql = StrSql & " OR '" & strDBNTUserName & "' = IPLIST_MEMBERID" 'find matching members StrSql = StrSql & ") AND ('" & userdate & "' >= IPLIST_BEGINDATE" StrSql = StrSql & " AND '" & userdate & "' <= IPLIST_ENDDATE )"
rs2.Open StrSql, strConnString
I replaced it with what you posted, logged out and got this....
quote: Microsoft VBScript runtime error '800a000d'
Type mismatch: '[string: ""]'
/forum/inc_ipgate.asp, line 167
|
|
|
KMC
Starting Member
40 Posts |
Posted - 21 January 2003 : 17:27:31
|
Forgot to add that I turned Banning On before logging out. |
|
|
Chuck McB
Junior Member
WooYay
196 Posts |
Posted - 21 January 2003 : 18:14:43
|
you running MySQL?
If so check out about 3/4 down this page |
|
|
KMC
Starting Member
40 Posts |
Posted - 21 January 2003 : 18:47:20
|
Nope. MS Access 2000 using virtual path |
|
|
|
Topic |
|