| Author |
 Topic  |
|
Davio
Development Team Member
Jamaica
12217 Posts |
|
|
MisterVB
Junior Member
274 Posts |
 Posted - 24 March 2001 : 18:20:56
|
the link is dead
... I just changed the asp ending to zip... Might want to fix that.
Edited by - MisterVB on 24 March 2001 18:23:51 |
 |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 24 March 2001 : 18:35:14
|
| Davio, I fixed the link in your post above. |
|
|
|
MisterVB
Junior Member
274 Posts |
Posted - 24 March 2001 : 18:57:07
|
i installed it and got this error... New so i don't know what it is telling me....
Adding Column...
ALTER TABLE FORUM_CONFIG ADD COLUMN C_BAN_IP text(255) NULL DEFAULT 000.000.000.000|
-2147467259 | Syntax error in number in table-level validation expression.
|
|
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 24 March 2001 : 19:14:05
|
I got the same error
quote:
i installed it and got this error... New so i don't know what it is telling me....
Adding Column...
ALTER TABLE FORUM_CONFIG ADD COLUMN C_BAN_IP text(255) NULL DEFAULT 000.000.000.000|
-2147467259 | Syntax error in number in table-level validation expression.
Test Site
www.eastpasco.com
Running on HuwR's SR4 release. Colors and Graphic scheme done by Richard Kinser. |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 24 March 2001 : 19:33:02
|
Ok, now I'm puzzled. I installed the database field without any default value for the C_BAN_IP field. But when I have an array access the empty field, it throws an error. What i did was just enter in "000.000.000.000|" manually into the database and everything was ok. So I figured that the field needs a default field so the array won't throw an error. Even though the field has the NULL option.
Guys, did it install the other tables? I will put up a link for a setup script to only create that field, without any default value. But then you would have to manually enter it in your database using a database editor. Because you are gonna get an error accessing the Ban Users administration for the first time if there is nothing in the field.
Unless you can wait until I find away around it.
You both are using Access right?
|
|
|
|
MisterVB
Junior Member
274 Posts |
Posted - 24 March 2001 : 19:44:56
|
yes i'm using access and as far as editing the dbase where would i enter the new field?
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 24 March 2001 : 19:48:06
|
Davio,
try changing this line:
ADD#C_BAN_IP#varchar(255)#NULL#000.000.000.000|
to this:
ADD#C_BAN_IP#varchar(255)#NULL#'000.000.000.000|'
|
|
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 24 March 2001 : 19:53:06
|
Richard that worked, but I get this now
Microsoft VBScript runtime error '800a005e'
Invalid use of Null: 'Split'
/forums/admin_ban_ip.asp, line 148
Test Site
www.eastpasco.com
Running on HuwR's SR4 release. Colors and Graphic scheme done by Richard Kinser. |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 24 March 2001 : 20:01:32
|
Ok, thanks Richard.
rick, you would have to do the same for"ADD#C_BAN_IPRANGE#varchar(255)#NULL#" to thisADD#C_BAN_IPRANGE#varchar(255)#NULL#'000.000.000|' And that should fix it.
|
|
|
|
MisterVB
Junior Member
274 Posts |
Posted - 24 March 2001 : 20:05:42
|
could you tell me where i would change that please.
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 24 March 2001 : 20:11:15
|
MisterVB, download this file, extract it to your forum folder, and run the mod_dbsetup.asp file from your browser. Select the "Ban IP Fix" from the dropdown box and click update. It will delete the 2 fields and re-create them with the proper values.
<link removed>
|
|
|
|
MisterVB
Junior Member
274 Posts |
Posted - 24 March 2001 : 20:13:06
|
Thank and sorry for the newbie questions..I'll learn sometime int he next 600 years. lol
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 24 March 2001 : 20:16:57
|
I just tried it and it installed them ok for me.
Rick, download the file I posted for MisterVB and follow the instructions. It will delete the tables and re-create them.
|
|
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 24 March 2001 : 21:37:48
|
Davio... Got it to work..
Thanks for the Mod
Rick
Test Site
www.eastpasco.com
Running on HuwR's SR4 release. Colors and Graphic scheme done by Richard Kinser. |
|
|
|
Giapai
New Member
92 Posts |
Posted - 27 March 2001 : 13:43:31
|
quote:
SETUP
Extract all files into your forum folder. If you have made any changes to your other files you will need to copy and paste the code into your files. All code that has been added is clearly commented. Just do a search for "Ban IP Mod" or look for this:
' ####################### Ban IP Mod #######################
hi owk i admit am blonde lol now i start copy the code there but untill what point?
and.. about those two lines that needed to be changed is that fixed or do i still need to do that?
greetings ladylee
|
|
|
|
Topic |
|
Topic Locked
