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)

Syxguns 03-23-2012 02:53 AM

Quote:

Originally Posted by ForceHSS (Post 2312348)
The version of mysql would not make a diffence

Why would that be? After I made the change it worked. However, I need to remove that post because looking back I see that his issue is different than what I originally thought!

ForceHSS 03-23-2012 02:56 AM

Quote:

Originally Posted by Syxguns (Post 2312350)
Why would that be? After I made the change it worked. However, I need to remove that post because looking back I see that his issue is different than what I originally thought!

to his problem I mean, your problem I know nothing off

shadowbreed 03-23-2012 04:14 PM

Quote:

Originally Posted by Syxguns (Post 2312347)
shadowbreed,
Are you still having the same issue? I was and after a little research I found that if you are running MySQL 5.5 it does not recognize the “Type=MyIsam:” . It was valid for for older versions. Let me show you how I corrected the problem.

Edit: Looking back I see that your problem is not the same as mine was. This will not help you.


Actually it was the same issue ;)

That worked thanks! :D

Syxguns 03-23-2012 06:58 PM

Quote:

Originally Posted by shadowbreed
Actually it was the same issue

That worked thanks!

Great I'm glad to hear that!

ForceHSS 03-24-2012 12:14 AM

So what mysql version did you have

scca 03-24-2012 07:12 PM

So I was running 1.2.7, on 4.1.2 I believe, I upgraded.to 4.1.11 and started getting error 500s on replying orc reating a new topic or post.
After troubleshooting for a couple of days, found out that disabling Spam-O-Matic made the error go away.

So I removed 1.2.7 and installed latest version from here, 2.0.2, and the same error 500s are showing up when replying or new topics.

again, disabling it, fixes the problem.

I have tried running just Spam-O-Matic with no other mods and still the same issue
Any ideas?
dont feel right running nakid right now

-bb

ForceHSS 03-24-2012 09:25 PM

bad upgrade maybe put in a support ticket let them have a look at it first

scca 03-25-2012 05:57 PM

support ticket with who?
vbulletin or SOM?

thanks
-

ForceHSS 03-25-2012 06:02 PM

show the error

Syxguns 03-25-2012 06:28 PM

GlowHost Forum: http://forums.glowhost.com/general-support/

Submit tickets to: https://glowhost.com/helpdesk/index.php?cmd=newticket

They should have all the information on a fix for it.

shadowbreed 03-25-2012 10:40 PM

Quote:

Originally Posted by ForceHSS (Post 2312682)
So what mysql version did you have

5.5.21-cll

ForceHSS 03-26-2012 12:37 AM

Quote:

Originally Posted by shadowbreed (Post 2313283)
5.5.21-cll

you should not have a problem with that version with this program
so this is what you had before so what do you have now

BryanLong 04-02-2012 09:52 PM

Question about Akismet:
Seems to be that Users which are found with too much URL-Count automatically gets posted to Akismet. Seems that I have to find a suitable URL-Count.

In this testing time: Will there be any possibility to report "false-positives", so that the User will not be blocked by Akismet again?

Best regards,
Bryan

hqlman 04-02-2012 11:54 PM

Quote:

Originally Posted by Syxguns (Post 2312347)
shadowbreed,
Are you still having the same issue? I was and after a little research I found that if you are running MySQL 5.5 it does not recognize the ?Type=MyIsam:? . It was valid for for older versions. Let me show you how I corrected the problem.

Edit: Looking back I see that your problem is not the same as mine was. This will not help you.



Edit: #2
For anyone that has a Database error that looks like the following example this is how I corrected it.

Code:

Error Code..

Database error in vBulletin 4.1.7:

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

Code:

$db->query_write('CREATE TABLE IF NOT EXISTS `'.TABLE_PREFIX.'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; ');

 
$db->query_write('CREATE TABLE IF NOT EXISTS `'.TABLE_PREFIX.'glowhostspamomatic_remotecache`(

                          `date` DATETIME NOT NULL,
                          `field` VARCHAR(20) NOT NULL,
                          `is_spambot` INT NOT NULL,
                          `data` VARCHAR(255) NOT NULL
                            ) TYPE=MyISAM; ');

 

$db->query_write('CREATE TABLE IF NOT EXISTS `'.TABLE_PREFIX.'glowhostspamomatic_stats`(

                          `denied` INT NOT NULL DEFAULT "0",
                          `banned` INT NOT NULL DEFAULT "0",
                          `moderated` INT NOT NULL DEFAULT "0",
                          `s_sfs` INT NOT NULL DEFAULT "0",
                          `s_akismet` INT NOT NULL DEFAULT "0",
                          `removed` INT NOT NULL DEFAULT "0"
                          ) TYPE=MyISAM; ');

Each item marked in red needs to be removed from the XML file. Leave the rest of the statement including the semi-colons. It is located 3 times so be sure to remove the test in red. The line should look like this:

Code:

) ; ');
That may get it working for you. It worked for me when I made the change. Good Luck!


Works perfectly, thanks a lot :)

Dave234 04-03-2012 02:26 AM

Can someone please help me to install this on my vbulletin 4 site?

I am stuck on steps 2.2 and 2.3

These are the instructions:

/************************** 2. INSTALLATION ****************************/

2.1 IF UPGRADING FROM SPAM-O-MATIC VERSION 1:
Make sure to remove the following file before installing version 2
/forum/includes/xml/bitfield_glowhostspamomatic.xml

2.2. Upload content of the upload folder into you forum root folder

*

2.3. Import product-glowhostspamomatic.xml into products (Located
at
AdminCP -> Plugin System -> Manage Products -> Add/Import Product)

/************************** 3. SETTINGS ********************************/

3.1. You can edit plug-in options at: AdminCP -> Settings -> Options ->

GlowHost - Spam-O-Matic

3.2. You can edit plug-in messages at: AdminCP -> Languages & Phrases ->

Phrase Manager -> Search Variable Name for 'glowhostspamomatic'

/************************** 4. ACTIONS *********************************/

4.1.
A) Located @ Edit user profile
B) If you have you API keys (set in settings) -
you will be able
to submit user details to StopForumSpam.com and Akismet databases simply
Delete a post as spam and ban the user to submit them if you have these
options enabled.

4.2. Get API key for Akismet
and enter it in settings. After this edit
your usergroups and you will
see the option to "Filter posts with Akismet".
Only check groups with
untrusted users (i.e. Unregistered / Not Logged In,
Registered Users).

Syxguns 04-03-2012 02:47 AM

@Dave234,
You have already removed the previous XML file? The next step requires FTP access to your server. Just change the name of your upload folder to the name of your forums folder. Drop the upload folder after the name is changed into the primary folder that holds your forums folder.

Primary Directory - drop it here
Forum folder

Someone else should not be granted access to your server!

Dave234 04-03-2012 03:00 AM

I never downloaded the first Spam-O-Matic, so I doubt it's in there. Unless it came with vbulletin?

I have FTP access.

What is the name of my forums folder? I have so many folders. Is it the "Includes" folder? That has a folder in it called "XML" which has other items in it.

However my "install" folder also has a folder called "includes". But that one does not have an "XML" folder in it.

This stuff is so confusing.

And I'm worried about trying anything because I don't want to ruin my vbulletin.

I know I should back it up, but vbulletin apparently got rid of the "Backup Database" button in the admincp. I have no idea how to back up the vbulletin. Can you explain it to me, as if you were explaining it to a 2-year-old? Because that's really my level of understanding with this.

Stryker412 04-03-2012 03:11 AM

Can someone offer advice on how to handle this? I have spammers registering and posting blogs but not on the forums. How can I ban them and have their blogs deleted?

Syxguns 04-03-2012 03:50 AM

1 Attachment(s)
@Dave234,

The folders you are naming are withing the primary forum directory. Your structure should look similar to this one that I kind of made up!! I figured a picture might help. Notice the following:

1) The top folder is the primary folder that holds the forums and or other items that you may have like shopping carts and so forth.

2) The second folder is the vB folder for your forums. It may not be called forum, mine is not, but that folder is where all of vB resides.

3) All the folders under the second folder are vB folders for the forum. You may have some mods on your forum and they will show up as well.

So by telling you to rename the Upload folder to the name of your forum folder you would be looking at the second one in the picture. However, you will drop the folder onto the 1st folder. The first folder is the ROOT of the forum.

Hope that helps.

Backups of the Database are generally done through PHPMyAdmin: https://www.vbulletin.com/docs/html/...myadmin_backup

Syxguns 04-03-2012 03:59 AM

Quote:

Originally Posted by Stryker412 (Post 2316255)
Can someone offer advice on how to handle this? I have spammers registering and posting blogs but not on the forums. How can I ban them and have their blogs deleted?

Styker412,
This is handled through permissions. Do not allow guest to post, and do not allow new members to post on blogs until they reach a desired number of posts on the forum. Or you can set it so that all new members posts are moderated before they are displayed.

Now Spam-O-Matic will remove a lot of stuff for you, but you have to make other preventative measures against problems like that. I don't allow guest to post, leave guest messages, leave messages on blogs, and new members I have set to have a minimum of 5 moderated posts before they become a registered user. Then they have a lot more freedom.

Dave234 04-03-2012 04:18 AM

I really, really appreciate you laying it all out simply like that. This stuff is very complicated for me.

In my FTP program, however, I can only see the Forum folder (actually mine is labled "/") and then the folders beneath that (admincp, etc). I cannot see the primary folder (the one you labeled "My Primary Directory")

By the way, I can put a shopping cart in that folder, too? Like if I want to have an online store? I guess I can get back to that question later.

Do I really need to backup my files and everything? My webhost says they do that every 24 hours. Is there any reason to also do it through vbulletin?

To backup my vbulletin, do I need to download phpMyAdmin? http://www.phpmyadmin.net/home_page/index.php

My God, this stuff is confusing.

Syxguns 04-03-2012 04:37 AM

I may be able to offer you a little more assistance. I suggest having PHPMyAdmin because it gives you a direct link to the database. However, that is another totally different tool to learn how to use, and without a full understanding of database and the structure of a database, I would not mess with it for now.

So you did not point your forum to a primary folder? That is okay there is another way to do everything, just ignore what I told you in the threads above. It takes a little longer to transfer, because you transfer items individually.

As far as shopping carts, yes you can add them however, most of them are not great. I'm speaking with a designer and trying to get a nice cart integrated into vB4. That's another topic. I tell you what send me a PM. The rest of this I can help you with away from the thread.

ForceHSS 04-03-2012 12:20 PM

Quote:

Originally Posted by Stryker412 (Post 2316255)
Can someone offer advice on how to handle this? I have spammers registering and posting blogs but not on the forums. How can I ban them and have their blogs deleted?

change permissions of the normal reg user group so they cant post at all in the blog then make a new user group and set it to transfer them to the new group after so many posts

DannyITR 04-03-2012 12:43 PM

There are always some posts that cannot be approved. It's soooooo annoying. 1 every few days.

tony 04-06-2012 04:47 PM

Is anyone else finding that spam-o-matic isn't stopping a spammer based on their email address?

I check the settings for StopForumSpam: Email Check is enable. But the description for this option says "Test the email address against the ban list" Does this mean it's only checking the ban list and not on stop forum spam?

ForceHSS 04-06-2012 06:14 PM

make sure check settings

tony 04-06-2012 07:01 PM

Quote:

Originally Posted by ForceHSS (Post 2317465)
make sure check settings

Well, there is only one setting for the mail and it's enable.

Syxguns 04-06-2012 09:09 PM

@tony
I just tried to register with an email address posted on stopforumspam and it did not allow me to register. I don't see the error you are talking about.

ForceHSS 04-06-2012 09:41 PM

Quote:

Originally Posted by tony (Post 2317481)
Well, there is only one setting for the mail and it's enable.

do u have both API Keys filled in

monday3 04-07-2012 11:17 PM

I'm on step 2.3 of the install - trying to import the product and I'm getting a database error.

Would you please let me know how I can get this script installed.


Database error in vBulletin 4.1.11:

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, April 7th 2012 @ 07:15:16 PM
Error Date : Saturday, April 7th 2012 @ 07:15:17 PM
Script : http://iskcon.me/admincp/plugin.php?do=productimport
Referrer : http://iskcon.me/admincp/plugin.php?do=productadd
IP Address : 70.113.90.117
Username : admin
Classname : vB_Database
MySQL Version : 5.5.19-55

monday3 04-07-2012 11:33 PM

I found the answer in this thread. Removed TYPE=MyISAM from script.

djbaxter 04-07-2012 11:50 PM

Is there an easy way to restrict the Easy Cleanup Functions to Admins only, rather than including moderators?

Lover1 04-08-2012 05:30 AM

Strange things goin' on with vB 4.1.11 Patch Level 1

Menu entry:
https://vborg.vbsupport.ru/]


Menu with empty entries:
https://vborg.vbsupport.ru/

ForceHSS 04-08-2012 12:17 PM

Quote:

Originally Posted by Lover1 (Post 2317916)
Strange things goin' on with vB 4.1.11 Patch Level 1

Menu entry:
https://vborg.vbsupport.ru/]


Menu with empty entries:
https://vborg.vbsupport.ru/

screenshots way to small to see

tony 04-08-2012 01:00 PM

I have both api keys setup.

One of my moderators pointed out a couple that got by spam-o-matic.

Quote:

Check this one out, invesiple stoonswimmilt@gmail.com 212.94.104.4 signed on April1. SFS list stoonswimmilt@gmail.com 788 times starting back February 19. However none of those entries list IP 212.94.104.4. While a spammers IP may change they have to confirm with the e-mail addresses.

Another one; feariammaby j.u.l.o.ngj.u.long@gmail.com 121.11.64.13 joined April 1. Listed 1000 times on SFS starting March 14. Again I do not see the IP in the list.

FannBlade 04-08-2012 02:55 PM

Quote:

Originally Posted by Lover1 (Post 2317916)
Strange things goin' on with vB 4.1.11 Patch Level 1

I'm sure 4.1.12 will fix it or maybe 4.1.13 when it's released 2 weeks later or maybe 4.1.....
is it just me or does each version upgrade just seem to make things worse. I spend more time fixing and updating than working on content. Now I understand why alot of big boards are still running 3.8.
Sorry for the rant but I can see why developers stop updating these mods we've all grown to love and depend on.

Maybe 4.5 CMS will be a viable product.

Syxguns 04-08-2012 05:52 PM

Quote:

Originally Posted by ForceHSS (Post 2317974)
screenshots way to small to see

ForceHSS,
Right click the pic and select open in new tab. The photo's are hosted, and not uploaded here.

Syxguns 04-08-2012 06:01 PM

Quote:

Originally Posted by tony (Post 2317985)
I have both api keys setup.

One of my moderators pointed out a couple that got by spam-o-matic.

tony,
This may be in how you have the system configured. Do you allow registration if there is a hang up in the system? You have to go through the settings and pay close attention to small things like that. You also have to let your moderators be aware of the fact that not everyone will be caught, if you allow registration anyway.

My suggestion is to allow registration, but still moderate at least the first two posts. Make sure the new members do not write access to blogs, or comments, etc. etc.

ForceHSS 04-08-2012 06:36 PM

Quote:

Originally Posted by Lover1 (Post 2317916)
Strange things goin' on with vB 4.1.11 Patch Level 1

Menu entry:
http://imup.me/uploads/2012/04/thumb/i16b5ziys.png]


Menu with empty entries:
http://imup.me/uploads/2012/04/thumb/i17bjwtpj.png

you have not uploaded all files this is why you are getting that

xtragic 04-09-2012 02:44 AM

I've encountered a few members being moderated automatically because they posted a few links in one thread/post. Why is this? How do I stop it?

Quote:

Post put under moderation based on Auto-Moderation URL count
I'm running 4.1.10


All times are GMT. The time now is 06:14 PM.

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.03877 seconds
  • Memory Usage 1,863KB
  • 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_code_printable
  • (18)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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