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

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 IP Gate
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

JBaldwin
Junior Member

USA
137 Posts

Posted - 30 December 2005 :  11:33:45  Show Profile
Everything works fine with the exception of when I try to view Page Logs. I have seen the other posts about a missing variable (strIPgateshowrecs), but that variable is there in config.asp.

This is the error I am getting:
ADODB.Recordset error '800a0bb9' 

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. 

/forum/forum2/admin_ipgate.asp, line 1401


The abbreviated section of code is here (lines 1390-1401):

numofobs=0
Set rs = Server.CreateObject("ADODB.Recordset")
strSql = "SELECT * from " & strTablePrefix & "IPLOG order by IPLOG_ID DESC"

rs.cursorlocation=aduseclient

rs.cachesize=5
rs.Open StrSql, strConnString
if not rs.BOF then
   rs.movefirst

rs.pagesize=int(strIPGateshowrecs)


Any ideas?

AbsolutelyFreerolls.com - Poker Freeroll Listings, Poker Forum and Poker News


gpctexas
Junior Member

320 Posts

Posted - 30 December 2005 :  14:01:39  Show Profile  Visit gpctexas's Homepage
a quick way to set the variable is to open the ipgate config and set the number of records and save the config.


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

clatters
Starting Member

United Kingdom
11 Posts

Posted - 08 January 2006 :  03:31:20  Show Profile  Visit clatters's Homepage
I am also suffering the same problem, but at line 1333(?). It only effects the 'paginated logs' option.

My code is identical to that posted above by JBaldwin. Viewing the complete log works OK. (Using ipgate_v24)
Go to Top of Page

gpctexas
Junior Member

320 Posts

Posted - 08 January 2006 :  16:18:59  Show Profile  Visit gpctexas's Homepage
open ipgate settings and set the number of pages to display. Look at the upgrade instructions in the zip called upgrade from update from 2.3 to 2.4.3 instructions.txt

also this is missing from instructions and should be first step in the alternate mod setup
[INSERT]
CONFIG_NEW
(C_VARIABLE,C_VALUE)#('STRIPGATEAUTOCLEAN','0')
[END]

ipgate 2.4.4 RC3
http://www.gpctexas.net/ipgate_v244.zip
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.21 seconds. Powered By: Snitz Forums 2000 Version 3.4.07