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
 Anti-Spam Installation Error		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

ai429
Starting Member

USA
7 Posts
Posted - 30 June 2008 :  17:35:48  Show Profile  Visit ai429's Homepage
Installation problem on antispam_registratio-3406-11

ERROR:
-2147217865 | Could not find output table 'FORUM_FORUM_BANNED'.

Using Access Database
IPGATE v2.44 is the only other mod that was added previously.

Any ideas?

Thanks in advance.
<
--MKrumm--

Carefree
Advanced Member

Philippines
4207 Posts
Posted - 30 June 2008 :  17:43:59  Show Profile
Yes. Save the following as dbs_antispam2.asp, then in Admin Home, run the config file titled "Antispam Remaining". All done.


AntiSpam Remaining

[INSERT]
BANNED
(BADSITES)#("versatel.de")
(BADSITES)#("verytec.org")
(BADSITES)#("wanadoo.fr")
(BADSITES)#("yahoo.co.jp")
(BADSITES)#("yahoo.com.au")
[END]
<
Go to Top of Page

bwunited
Starting Member

United Kingdom
25 Posts
Posted - 24 November 2008 :  19:06:42  Show Profile  Visit bwunited's Homepage
I'm getting the following errors when installing the dbs file:

INSERT INTO FORUM_BANNED (BADSITES) VALUES ("tzeng.com")
INSERT INTO FORUM_BANNED (BADSITES) VALUES ("uswa1155.org")
INSERT INTO FORUM_BANNED (BADSITES) VALUES ("u-yep.com")
INSERT INTO FORUM_BANNED (BADSITES) VALUES ("u-yep.com")
-2147217900 | The name 'u-yep.com' is not permitted in this context.
Only constants, expressions, or variables allowed here.
Column names are not permitted.

-------------------------------------

Adding new records..
INSERT INTO FORUM_BANNED (BADSITES) VALUES ("versatel.de")
INSERT INTO FORUM_BANNED (BADSITES) VALUES ("verytec.org")
INSERT INTO FORUM_BANNED (BADSITES) VALUES ("wanadoo.fr")
INSERT INTO FORUM_BANNED (BADSITES) VALUES ("yahoo.co.jp")
INSERT INTO FORUM_BANNED (BADSITES) VALUES ("yahoo.com.au")
INSERT INTO FORUM_BANNED (BADSITES) VALUES ("yahoo.com.au")
-2147217900 | The name 'yahoo.com.au' is not permitted in this context.
Only constants, expressions, or variables allowed here.
Column names are not permitted.



I tried the dbs_antispam2.asp but it gave the same problem with the yahoo.com.au

It seems to work ok though when I add the admin_badsites.asp but it just loads a blank page.


I'm starting to get a ton of unwanted (suspect) spam signups and it's becoming a problem so is there a better Mod to go with or anyone any suggestions on tweaking this one slightly?<
regards
Brian ]:-)
Edited by - bwunited on 25 November 2008 20:25:51
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts
Posted - 25 November 2008 :  04:46:30  Show Profile
Get the fix at SnitzBitz.<
Go to Top of Page

bwunited
Starting Member

United Kingdom
25 Posts
Posted - 25 November 2008 :  20:23:38  Show Profile  Visit bwunited's Homepage
Unfortunately thats the version I was using :(


If I remove "yahoo.com.au" then I get the following error instead:

Adding new records..
INSERT INTO FORUM_BANNED (BADSITES) VALUES ("versatel.de")
INSERT INTO FORUM_BANNED (BADSITES) VALUES ("verytec.org")
INSERT INTO FORUM_BANNED (BADSITES) VALUES ("wanadoo.fr")
INSERT INTO FORUM_BANNED (BADSITES) VALUES ("yahoo.co.jp")
INSERT INTO FORUM_BANNED (BADSITES) VALUES ("yahoo.co.jp")
-2147217900 | The name 'yahoo.co.jp' is not permitted in this context.
Only constants, expressions, or variables allowed here.
Column names are not permitted.



Got me well stuffed :(<
regards
Brian ]:-)
Edited by - bwunited on 25 November 2008 20:29:53
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts
Posted - 25 November 2008 :  23:01:43  Show Profile
I doubt it. I made that release last night.<
Go to Top of Page

bwunited
Starting Member

United Kingdom
25 Posts
Posted - 26 November 2008 :  19:34:34  Show Profile  Visit bwunited's Homepage
Soz, everything looked identical when I viewed the contents of the files. Blame tired eyes and frustration at it not working.

When I run this one I get the exact same error when running the dbs file although the admin_badsites.asp does display a box with "Add a Server" and "Current Servers" "No Sites Found"

When you try to add a server it generates the following error:

Microsoft OLE DB Provider for SQL Server error '80040e14'
Invalid column name 'Testing'.

/forum/admin_badsites.asp, line 209

<
regards
Brian ]:-)
Edited by - bwunited on 26 November 2008 19:49:27
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts
Posted - 27 November 2008 :  13:06:36  Show Profile
I just installed it on a new server, had 0 errors. Admin_badsites.asp resulted in 0 errors. Make sure you replaced both files. The dbs file should delete your existing table before recreating and populating it.<
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.35 seconds. Powered By: Snitz Forums 2000 Version 3.4.07