vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Anti-Spam Options - [GlowHost] Spam-O-Matic - Spam Firewall stops forum spam (https://vborg.vbsupport.ru/showthread.php?t=248042)

Pionex 05-31-2011 08:03 AM

installed, I dont know how well it works yet, but ill let you know tomorrow. Ive been getting, on average, 5 spam bots a day on my site before this was installed. installation went smoothly as well.

thank you.

Delphiprogrammi 05-31-2011 08:28 AM

Quote:

Originally Posted by shrimpca (Post 2201977)
I can't get APIkey from stopspam.

Can you help me ??

you have to register on there forum to get an apikey due to abuse (people submitting false reports etc)

for people who have there ip listed and are not a spammer you can request removal though keep this in mind

1) ask nicely
2) do not argue with them or your ip stays in there database

Glowhost you could update the first post so you don't have to answer the same question all the time :D

Delphiprogrammi 05-31-2011 08:30 AM

Quote:

Originally Posted by autostick (Post 2200975)
My apologies if this was covered, but I searched and found nothing. I am installing SpamOMatic for the first time, and when I click on Import Product, I get this error message. Any suggestions are most welcome. Thanks.
:confused:
Database error in vBulletin 4.1.3:

Invalid SQL:
CREATE TABLE IF NOT EXISTS `glowhostspamomatic_log`(
`date` DATETIME NOT NULL,
`ip` VARCHAR(15) NOT NULL,
`email` VARCHAR(255) NOT NULL,
`username` VARCHAR(255) NOT NULL,
`message` VARCHAR(255) NOT NULL,
`is_blocked` TINYINT NOT NULL DEFAULT "0",
`user_hash` VARCHAR(50) NOT NULL,
`user_id` INT NOT NULL
) TYPE=MyISAM;;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 10
Error Number : 1064
Request Date : Saturday, May 28th 2011 @ 09:01:53 PM
Error Date : Saturday, May 28th 2011 @ 09:01:53 PM
Script : http://164.107.52.52/vb3/admincp/plu...=productimport
Referrer : http://164.107.52.52/vb3/admincp/plu...?do=productadd
IP Address : 164.107.52.52
Username : xx xx
Classname : vB_Database
MySQL Version : 5.5.8

that looks like a duplicate ; at the end

Rabbit9149 05-31-2011 02:05 PM

Quote:

Originally Posted by autostick (Post 2200975)
My apologies if this was covered, but I searched and found nothing. I am installing SpamOMatic for the first time, and when I click on Import Product, I get this error message. Any suggestions are most welcome. Thanks.
:confused:
Database error in vBulletin 4.1.3:

Invalid SQL:
CREATE TABLE IF NOT EXISTS `glowhostspamomatic_log`(
`date` DATETIME NOT NULL,
`ip` VARCHAR(15) NOT NULL,
`email` VARCHAR(255) NOT NULL,
`username` VARCHAR(255) NOT NULL,
`message` VARCHAR(255) NOT NULL,
`is_blocked` TINYINT NOT NULL DEFAULT "0",
`user_hash` VARCHAR(50) NOT NULL,
`user_id` INT NOT NULL
) TYPE=MyISAM;;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 10
Error Number : 1064
Request Date : Saturday, May 28th 2011 @ 09:01:53 PM
Error Date : Saturday, May 28th 2011 @ 09:01:53 PM
Script : http://164.107.52.52/vb3/admincp/plu...=productimport
Referrer : http://164.107.52.52/vb3/admincp/plu...?do=productadd
IP Address : 164.107.52.52
Username : xx xx
Classname : vB_Database
MySQL Version : 5.5.8

I had this same error. It has to do with the newer versions of mysql you use. You can fix it by right clicking on product-glowhostspamomatic.xml and click edit and open your find window and search for TYPE=MyISAM I think there were 3 of them you need to change to ENGINE=MyISAM and that should fix you all up. ;)

Pionex 05-31-2011 02:37 PM

Spam-O-Matic Tagged ip - 213.163.97.20 Unable to connect to StopForumSpam.com. This is probably due to some temporary problems on their website: Unable to check. User passed to vBulletin registration system per your settings at 'StopForumSpam: Query Conne

Im not connecting to their website..... whats the issue?

CtrlAltDel 05-31-2011 04:02 PM

Has anyone written something to leverage this API to check existing registrations?

mrplowjr_ez_v 05-31-2011 06:18 PM

What a fantastic add-on! Thank you!!! Had 20 blocked spammers in the first 12 hours. This saves me an immense amount of time!

lurch_cr 06-01-2011 01:05 AM

On my forum, I have a bit of a problem with the 'Username' check when people try and register.
It seems to pick up some really common "real" names. A recently one being as something as simple as 'Leon' - the persons real name.
Now I realise that it goes and checks this against a central database and I'm assuming these names have been flagged.
What I would prefer is that rego's that have failed due to username be left for moderation instead of just blocked in its tracks.
Is this possible? I haven't been able to find such an option thus far :(

Mark Hewitt 06-02-2011 06:14 AM

Just trying to understand how this works.

I used to moderate all new members, but I switched that off when I installed this.

However, new members (all spammers) are still appearing in my moderation list. However they don't appear in the Spam-o-matic logs. Is this expected behaviour or have I got something strange going on here?

Mark Hewitt 06-02-2011 06:23 AM

I've also just been spammed by someone who doesn't appear in the logs.


All times are GMT. The time now is 12:31 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02611 seconds
  • Memory Usage 1,749KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (6)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete