Snitz Forums 2000 - MOD : Ban IP : Installation Problems

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Help Groups for Snitz Forums 2000 Users

Help: MOD Implementation

MOD : Ban IP : Installation Problems

New Topic

Topic Locked

Printer Friendly

Author

Topic

swatijain
Starting Member

48 Posts

Posted - 25 April 2001 : 18:07:30

Got this error...

Adding Column...
ALTER TABLE FORUM_CONFIG ADD C_STRBANIP byte NULL DEFAULT 0
-2147217900 | Column or parameter #118: Cannot find data type byte.
Adding Column...
ALTER TABLE FORUM_CONFIG ADD C_STRBANIPRANGE byte NULL DEFAULT 0
-2147217900 | Column or parameter #118: Cannot find data type byte.
Adding Column...
ALTER TABLE FORUM_CONFIG ADD C_BAN_IP nvarchar(255) NULL DEFAULT '000.000.000.000|'
Column added successfully
Populating Current Records with new Default value
UPDATE FORUM_CONFIG SET C_BAN_IP='000.000.000.000|'
Adding Column...
ALTER TABLE FORUM_CONFIG ADD C_BAN_IPRANGE nvarchar(255) NULL DEFAULT '000.000.000|'
Column added successfully
Populating Current Records with new Default value
UPDATE FORUM_CONFIG SET C_BAN_IPRANGE='000.000.000|'
Table(s) updated

When trying to install the MOD. Used the mod_dbsetup.asp file in the zip.

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 25 April 2001 : 18:33:22

Would need to ask HuwR about that problem. Haven't seen that error with the mod_dbsetup.asp file before. I presume you are using SQL Server.

swatijain
Starting Member

48 Posts

Posted - 25 April 2001 : 19:06:50

Yes, I am using SQL Server 7.0.

Have installed several mods before...

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 26 April 2001 : 11:46:34

I updated the zip file with the fix.
http://www.dsilvera.com/forum/mods/ban_ip.zip

Extract the ban_ip.dbs file from the zip and into your forum folder. Go thru the same routine to installing the mod. You would get somme errors for some of the database fields because they already exist in your database. But the first two fields C_STRBANIP and C_STRBANIPRANGE should install ok. I changed it from the "BYTE" type to the "INT" type. Let me know if it works ok.

swatijain
Starting Member

48 Posts

Posted - 26 April 2001 : 15:02:37

Got this error...

ALTER TABLE FORUM_CONFIG ADD C_STRBANIP byte NULL DEFAULT 0
-2147217900 | Column or parameter #120: Cannot find data type byte.
Adding Column...
ALTER TABLE FORUM_CONFIG ADD C_STRBANIPRANGE byte NULL DEFAULT 0
-2147217900 | Column or parameter #120: Cannot find data type byte.
Adding Column...
ALTER TABLE FORUM_CONFIG ADD C_BAN_IP nvarchar(255) NULL DEFAULT '000.000.000.000|'
-2147217900 | Column names in each table must be unique. Column name 'C_BAN_IP' in table 'FORUM_CONFIG' is specified more than once.
Adding Column...
ALTER TABLE FORUM_CONFIG ADD C_BAN_IPRANGE nvarchar(255) NULL DEFAULT '000.000.000|'
-2147217900 | Column names in each table must be unique. Column name 'C_BAN_IPRANGE' in table 'FORUM_CONFIG' is specified more than once.
Table(s) updated

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 26 April 2001 : 18:12:26

You're still using the old ban_ip.dbs file.
Ok do this. Open ban_ip.dbs in a text editor.
Change the code in red:

Ban IP Mod
[ALTER]
CONFIG
ADD#C_STRBANIP#byte#NULL#0
ADD#C_STRBANIPRANGE#byte#NULL#0
ADD#C_BAN_IP#varchar(255)#NULL#'000.000.000.000|'
ADD#C_BAN_IPRANGE#varchar(255)#NULL#'000.000.000|'
[END]

to this:

Ban IP Mod
[ALTER]
CONFIG
ADD#C_STRBANIP#int#NULL#0
ADD#C_STRBANIPRANGE#int#NULL#0
ADD#C_BAN_IP#varchar(255)#NULL#'000.000.000.000|'
ADD#C_BAN_IPRANGE#varchar(255)#NULL#'000.000.000|'
[END]

Then save it and try again.

swatijain
Starting Member

48 Posts

Posted - 26 April 2001 : 20:27:04

Alright!

That worked.

Thank You! for taking your time to help me.

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.41 seconds.