| Author |
 Topic  |
|
pahasapa
Starting Member
38 Posts |
 Posted - 18 December 2002 : 05:06:30
|
where I put <!--#INCLUDE FILE="inc_ipgate.asp"--> in inc_header.asp (v 3.4.0.03)
IPGate does not work when trying to ban a member!!  |
alex |
 |
|
|
Webbo
Average Member
United Kingdom
982 Posts |
Posted - 18 December 2002 : 06:30:29
|
When trying to install the database tables using the dbs files on a MySql db, I get this error:
Creating table(s)...
CREATE TABLE FORUM4_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 FORUM4_IPLIST _IPLIST_ID(IPLIST_ID))
CREATE TABLE FORUM4_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 FORUM4_IPLIST _IPLIST_ID(IPLIST_ID))
-2147217911 | [TCX][MyODBC]You have an error in your SQL syntax near '_IPLIST_ID(IPLIST_ID))' at line 1
Even using the alternative MOD setup:
[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]
Ay idea anyone what I need to do?
Thanks, Dave
|
Edited by - Webbo on 18 December 2002 06:41:40 |
|
|
|
alex042
Average Member
USA
631 Posts |
Posted - 18 December 2002 : 08:52:23
|
I'm glad some people took enough interest in this to keep this going. I'm taking a few days off starting this weekend to the end of the year so hopefully, I'll be able to make some of these revisions and post a new version soon.
|
|
|
|
pahasapa
Starting Member
38 Posts |
Posted - 18 December 2002 : 09:16:01
|
Ok, Alex Thank, but could you tell me where include <!--#INCLUDE FILE="inc_ipgate.asp"--> in inc_header.asp ?
Ale
quote:
Originally posted by alex042
I'm glad some people took enough interest in this to keep this going. I'm taking a few days off starting this weekend to the end of the year so hopefully, I'll be able to make some of these revisions and post a new version soon.
|
alex |
|
|
|
tomasalsbro
Average Member
Sweden
818 Posts |
Posted - 18 December 2002 : 09:38:06
|
quote:
Originally posted by pahasapa
Ok, Alex Thank, but could you tell me where include <!--#INCLUDE FILE="inc_ipgate.asp"--> in inc_header.asp ?
Ale
quote:
Originally posted by alex042
I'm glad some people took enough interest in this to keep this going. I'm taking a few days off starting this weekend to the end of the year so hopefully, I'll be able to make some of these revisions and post a new version soon.
Put it at line 236 in the original file (inc_header.asp)
Cheers
Tomas |
!-Keep distance in traffic-!
www.whiplashinfo.se |
|
|
|
pahasapa
Starting Member
38 Posts |
Posted - 18 December 2002 : 09:47:48
|
is it correct?
*************
end if
<!--#INCLUDE FILE="inc_ipgate.asp"-->
Response.Write "<html>" & vbNewline & vbNewline & _
"<head>" & vbNewline & _
"<title>" & GetNewTitle(strScriptName) & "</title>" & vbNewline
|
alex |
|
|
|
supergaillard
Starting Member
4 Posts |
Posted - 18 December 2002 : 12:18:44
|
quote:
Originally posted by Webbo
When trying to install the database tables using the dbs files on a MySql db, I get this error:
Creating table(s)...
CREATE TABLE FORUM4_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 FORUM4_IPLIST _IPLIST_ID(IPLIST_ID))
CREATE TABLE FORUM4_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 FORUM4_IPLIST _IPLIST_ID(IPLIST_ID))
-2147217911 | [TCX][MyODBC]You have an error in your SQL syntax near '_IPLIST_ID(IPLIST_ID))' at line 1
Even using the alternative MOD setup:
I ve got the same problem, you should create the DB manually.
 supergaillard |
|
|
|
Webbo
Average Member
United Kingdom
982 Posts |
Posted - 19 December 2002 : 06:52:07
|
Still having problems when trying to implement with MySql db, I've Created the table manually and set ID as the PRIMARY KEY
Inserting the following into inc_header.asp (line 237)
'######IPGate Mod
%> <!--#INCLUDE FILE="inc_ipgate.asp"--> <%
'#####IPGate Mod
and applying the fixes by supergaillard to admin_ipgate.asp and inc_ipgate.asp, I get the following errors in the forum's default page:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[TCX][MyODBC]Unknown column 'IPLIST_STARTDATE' in 'field list'
/testforum/inc_ipgate.asp, line 116
Removing the include in inc_header and from the forum's Admin page I get the following errors when trying to access IP Administration in admin_ipgate.asp :
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[TCX][MyODBC]Unknown column 'IPLIST_ID' in 'order clause'
/testforum/admin_ipgate.asp, line 104
and the following when trying to access LOG Administration:
Microsoft OLE DB Provider for ODBC Drivers error '80040e09'
[TCX][MyODBC]You have an error in your SQL syntax near '500 * from FORUM4_IPLOG order by IPLOG_ID desc' at line 1
/testforum/admin_ipgate.asp, line 161
Any help would be appreciated 
Dave
|
Edited by - Webbo on 19 December 2002 06:54:57 |
|
|
|
tomasalsbro
Average Member
Sweden
818 Posts |
Posted - 19 December 2002 : 06:55:46
|
quote:
Originally posted by pahasapa
is it correct?
*************
end if
<!--#INCLUDE FILE="inc_ipgate.asp"-->
Response.Write "<html>" & vbNewline & vbNewline & _
"<head>" & vbNewline & _
"<title>" & GetNewTitle(strScriptName) & "</title>" & vbNewline
Nop,
-----------------
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
Response.Write "<meta name=""copyright"" content=""This Forum code is Copyright (C) 2000-02 Michael Anderson, Pierre Gorissen, Huw Reddick and Richard Kinser, Non-Forum Related code is Copyright (C) " & strCopyright & """>" & vbNewline
'## END - REMOVAL, MODIFICATION OR CIRCUMVENTING THIS CODE WILL VIOLATE THE SNITZ FORUMS 2000 LICENSE AGREEMENT
-----------------
Tomas |
!-Keep distance in traffic-!
www.whiplashinfo.se |
|
|
|
CodeName
Junior Member
296 Posts |
Posted - 19 December 2002 : 07:54:55
|
| At inc_header.asp tomasalsbro? |
|
|
|
tomasalsbro
Average Member
Sweden
818 Posts |
Posted - 19 December 2002 : 16:52:50
|
quote:
Originally posted by CodeName
At inc_header.asp tomasalsbro?
Yeap,
if you need the IP Gate to control the entire forum, you should put the include in inc_heather.asp where I suggested before.
I - for myself - just puted it in admin_home.asp
Tomas |
!-Keep distance in traffic-!
www.whiplashinfo.se |
|
|
|
CodeName
Junior Member
296 Posts |
Posted - 19 December 2002 : 17:58:08
|
Well I put there but same problem..
I can see the member name 2-3 times after Member Names dissepears..
|
|
|
|
pahasapa
Starting Member
38 Posts |
Posted - 20 December 2002 : 04:31:38
|
quote:
Originally posted by tomasalsbro
quote:
Originally posted by pahasapa
is it correct?
*************
end if
<!--#INCLUDE FILE="inc_ipgate.asp"-->
Response.Write "<html>" & vbNewline & vbNewline & _
"<head>" & vbNewline & _
"<title>" & GetNewTitle(strScriptName) & "</title>" & vbNewline
Nop,
-----------------
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
Response.Write "<meta name=""copyright"" content=""This Forum code is Copyright (C) 2000-02 Michael Anderson, Pierre Gorissen, Huw Reddick and Richard Kinser, Non-Forum Related code is Copyright (C) " & strCopyright & """>" & vbNewline
'## END - REMOVAL, MODIFICATION OR CIRCUMVENTING THIS CODE WILL VIOLATE THE SNITZ FORUMS 2000 LICENSE AGREEMENT
-----------------
Tomas
Nothing to do: no ban!! sigh  |
alex |
|
|
|
JLocke
Starting Member
USA
23 Posts |
Posted - 23 December 2002 : 12:42:34
|
I am having a major major problem.... I cant view my Admin Options... Or any page I put the <--#INCLUDE FILE="inc_ipgate"--> or any of the Ip Gate Files... I might be putting the wrong files, but here are the errors ive got:
when I put the INCLUDE ipgate i got "Page Not Found"
when I put the
" <LI><span class=""spnMessageText""><a href=""ipgate.asp"">Ip Gate</a></span></LI>" & vbNewLine & _ I got Page Not Found...
When I took that line out to make it like it was, I got:
Microsoft VBScript compilation error '800a0400'
Expected statement
/ashaden/admin_home.asp, line 133
" <LI><span class=""spnMessageText""><a href=""admin_config_members.asp"">Member Details Configuration</a></span></LI>" & vbNewLine & _
^
Please help me, cuz right now my Admin options are down, and im using this forum for a company, and things are pickingup... :(
|
Hello... |
|
|
|
JLocke
Starting Member
USA
23 Posts |
Posted - 23 December 2002 : 12:58:08
|
| oh by the way, im using Microsoft Access 2000 on Brinksters and I run version 3.4.03 and I have newest beta for Ip Gate... (I think) Correction, I have 8.0 |
Hello... |
Edited by - JLocke on 23 December 2002 13:01:43 |
|
|
|
Topic |
|
Topic Locked
