| Author |
 Topic  |
|
laser
Advanced Member
Australia
3859 Posts |
 Posted - 21 October 2004 : 17:58:57
|
Did you run the MOD Setup ?
The error means that the proper database tables don't exist.< |
 |
|
|
gpctexas
Junior Member
320 Posts |
|
|
pould
Starting Member
16 Posts |
Posted - 22 October 2004 : 05:11:27
|
quote:
Originally posted by gpctexas
You are missing the tables, did you upload the dbs file 'dbs_ipgate' and run the mod setup?
That's the puppy!! Once I put it in the forum directory and ran it it works fine. Thanks!!< |
|
|
|
ken derringer
Starting Member
40 Posts |
Posted - 13 January 2005 : 06:03:17
|
I have a problem. This is my new installation of ipgate.
Well.
I have run the dbs file. All ok.
I have changed my config and inc_header asp page. OK.
I have activated the wathing metod to 1 user and all activities are recorder. OK.
When i try to activate the cookies option to ON, i receive this error:
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'Response.Cookies(...).Expires'
/forumgdr/inc_ipgate.asp, line 192
I use access DB.< |
|
|
|
gpctexas
Junior Member
320 Posts |
Posted - 13 January 2005 : 09:02:38
|
Check this line at the top of inc_ipgate.asp
cookiename="IPGate" 'must change for each forum you host on the same domain!
make sure there are quotes around the name
< |
ipgate 2.4.4 RC3
http://www.gpctexas.net/ipgate_v244.zip |
|
|
|
ken derringer
Starting Member
40 Posts |
Posted - 13 January 2005 : 09:10:33
|
yes, the quotes appear:
cookiename="IPGate" 'must change for each forum you host on the same domain!< |
|
|
|
gpctexas
Junior Member
320 Posts |
Posted - 13 January 2005 : 14:18:27
|
check the table iplist and make sure IPLIST_ENDDATE is present.
are you sure all the tables were created without any errors?< |
ipgate 2.4.4 RC3
http://www.gpctexas.net/ipgate_v244.zip |
|
|
|
ken derringer
Starting Member
40 Posts |
Posted - 14 January 2005 : 03:50:54
|
Yes, I'm sure...
I have used the dbs file called dbs_ipgate.asp. This is the result:
Snitz Forum Modifications
Net IPGate Mod v2.3.0 New Install
Dropping Table..
Table dropped succesfully
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_IPLIST( IPLIST_ID int IDENTITY (1, 1) PRIMARY KEY NOT NULL , 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 )
Table created succesfully
--------------------------------------------------------------------------------
Dropping Table..
Table dropped succesfully
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_PAGEKEYS( PAGEKEYS_ID int IDENTITY (1, 1) PRIMARY KEY NOT NULL , PAGEKEYS_PAGEKEY varchar(32) NULL )
Table created succesfully
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_PAGEKEYS (PAGEKEYS_PAGEKEY) VALUES ('post.asp')
Value(s) updated succesfully
--------------------------------------------------------------------------------
Dropping Table..
Table dropped succesfully
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_IPLOG( IPLOG_ID int IDENTITY (1, 1) PRIMARY KEY NOT NULL , IPLOG_MEMBERID varchar(32) NULL DEFAULT 0, IPLOG_IP varchar(32) NULL , IPLOG_PATHINFO varchar(255) NULL , IPLOG_DATE varchar(32) NULL )
Table created succesfully
--------------------------------------------------------------------------------
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.3.0')
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 succesfully
--------------------------------------------------------------------------------
Database setup finished
< |
|
|
|
ken derringer
Starting Member
40 Posts |
Posted - 14 January 2005 : 04:02:32
|
| The error message appear only when this user access to the home page of the forum.< |
|
|
|
gpctexas
Junior Member
320 Posts |
Posted - 14 January 2005 : 15:23:10
|
| I'm researching this, there's a remote possibility your server doesn't like the procedure call I wrote to write the cookie and it isn't passing the db value to the procedure correctly. I'll work on a modified inc_ipgate.asp to see if it will work without the procedure.< |
ipgate 2.4.4 RC3
http://www.gpctexas.net/ipgate_v244.zip |
|
|
|
gpctexas
Junior Member
320 Posts |
Posted - 14 January 2005 : 15:35:00
|
Ken, backup inc_ipgate.asp and replace it with this. Don't forget to rename the txt to asp
http://www.gpctexas.net/inc_ipgate.txt
I removed the cookie procedure. Lemme know if this fixes the prob for you.
For other users, this file only tries to address ken's prob and shouldn't be applied to to you forums.< |
ipgate 2.4.4 RC3
http://www.gpctexas.net/ipgate_v244.zip |
|
|
|
stwilson
Junior Member
USA
385 Posts |
Posted - 15 January 2005 : 13:33:12
|
| I have a question about the edit blocked pages feature. What does this do? The ReadMe file says to add inc_ipgate.asp file to the pages you want to protect OR to add inc_ipgate.asp to the bottom of the header file to protect you entire site. This admin feature makes me think I can select the pages I want to protect. Do I have to do both, add the include file to the pages I want to protect and identify the pages to protect in the admin feature?< |
Shannon
RidingArizona.com |
|
|
|
gpctexas
Junior Member
320 Posts |
Posted - 15 January 2005 : 14:30:20
|
| the pagekey will block page name from a user. Example, it you dont want a user posting a message, you would add post.asp to the page key area. Adding the include protects the entire forum, adding the include to specific plages does not. Do one or the other but not both.< |
ipgate 2.4.4 RC3
http://www.gpctexas.net/ipgate_v244.zip |
|
|
|
stwilson
Junior Member
USA
385 Posts |
Posted - 15 January 2005 : 15:19:32
|
| Supposed I wanted to keep someone from registering again, do I need to add the include at all or will it be covered by adding registration.asp to the pagekey area?< |
Shannon
RidingArizona.com |
|
|
|
gpctexas
Junior Member
320 Posts |
Posted - 15 January 2005 : 17:50:52
|
adding it to the pagekey area will block it.
bah just realized typing errors above, grr @ colds and sinus infections.
above should have read; adding the include to inc_header.asp will protect the entire forum, adding the include to individual pages will only protect that page.< |
ipgate 2.4.4 RC3
http://www.gpctexas.net/ipgate_v244.zip |
|
|
|
Topic |
|
IPGate 2.4.3 beta and 2.3
