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)

ForceHSS 01-04-2013 04:54 PM

Quote:

Originally Posted by dragonsflight (Post 2394693)
Hi All,

I imported and this is what I get:

Database error in vBulletin 4.2.0:

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 : Friday, January 4th 2013 @ 11:36:33 AM
Error Date : Friday, January 4th 2013 @ 11:36:34 AM
Script : http://www.domain.com/admincp/plugin...=productimport
Referrer : http://www.domain.com/admincp/plugin.php?do=productadd
IP Address :
Username : AdminMJ
Classname : vB_Database
MySQL Version : 5.5.23-55

Any idea how I can fix this?

Thank you

MJ

Here is the fix

dragonsflight 01-04-2013 05:19 PM

Thank you!! It worked!

Alibass 01-04-2013 05:24 PM

Quote:

Originally Posted by ForceHSS (Post 2394653)
was never but you can do this
admincp/Plugins & Products/Add New Plugin
Product = vBulletin
Hook Location = useradmin_edit_column1
Title = Submit to StopForumSpam.com
Execution Order = 5
Plugin PHP Code
PHP Code:

if (!is_member_of($user['usergroupid'], 6)) // we dont want to ban our admin account now do we
        

            
print_table_break(''$INNERTABLEWIDTH);
            
print_table_header("Submit to StopForumSpam");
            
                
print_label_row('Submit these details to www.stopforumspam.com ban list<BR><table><tr><td>Username:</td><td><input type="text" name="username"  size="30" value="'
$user['username'] . '"></td></tr>
<tr><td>Email:</td><td><input type="text" name="email"  size="30" value="' 
$user['email'] . '"></td></tr><tr><td>IP:&nbsp;</td>
<td><input type="text" name="ip_addr"  value="' 
.$user['ipaddress'] . '"></td></tr></table>
<input name="api_key" type="hidden" value="YOUR API KEY"><input onclick="this.form.action=\'http://www.stopforumspam.com/add.php\';this.form.submit()"  type="button" class="button" value="' 
$vbphrase['submit'] . '"/>');   
        } 

MAKE SURE YOU PUT IN YOUR API KEY You will see it on this line <input name="api_key" type="hidden" value="YOUR API KEY">
Plugin is Active = Yes

Thanks for this, you have been a big help with this mod :):up:

dragonsflight 01-04-2013 07:14 PM

Installed successfully. Now when I try to add a post I get this:

Warning: require_once(includes/functions_ghsom.php) [function.require-once]: failed to open stream: No such file or directory in [path]/includes/functions_newpost.php(532) : eval()'d code on line 5

Fatal error: require_once() [function.require]: Failed opening required 'includes/functions_ghsom.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/whatsyou/public_html/includes/functions_newpost.php(532) : eval()'d code on line 5

Is this related to Spam O Matic?

That is the last mod I made to my forum. Thanks for the help.

MJ

Big Engine 01-04-2013 07:21 PM

Quote:

Originally Posted by dragonsflight (Post 2394729)
Installed successfully. Now when I try to add a post I get this:

Warning: require_once(includes/functions_ghsom.php) [function.require-once]: failed to open stream: No such file or directory in [path]/includes/functions_newpost.php(532) : eval()'d code on line 5

Fatal error: require_once() [function.require]: Failed opening required 'includes/functions_ghsom.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/whatsyou/public_html/includes/functions_newpost.php(532) : eval()'d code on line 5

Is this related to Spam O Matic?

That is the last mod I made to my forum. Thanks for the help.

MJ

Are you sure you didn't miss this step ?

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

*

dragonsflight 01-04-2013 07:38 PM

Yep, I did upload the upload folder to my root. Intact.

MJ

dragonsflight 01-04-2013 07:40 PM

seems I was a bit too literal. It's working now.

Thanks!

MJ

hubbers72 01-06-2013 11:54 AM

Does this work on VB5?

spd2612 01-06-2013 01:29 PM

Is there a way I can give a user / moderator access to the Spam 0 Matic Logs ?

aspen0 01-06-2013 02:03 PM

Will this do anything with blocking and or with the easy-cleanup feature for removing blog spam?

vb has really poor built in tools for managing blog spam, its a problem in need of a solution.

camoit 01-07-2013 04:56 AM

I have this installed on V 4.1.11 and it does not move members from the new-be group to the registered group. They are to be moved at 8 posts but I have some with 50+ and there still in the new-be group. What can we do about this???

Thanks in advance.

spd2612 01-07-2013 03:41 PM

Their has to be a way to do this I just have one Super Moderator that I want to be able to view the Logs to see who and why they were banned, however I dont want them to have full Admin CP access. I tried adding there user id to config.php that did nothing anyone have any ideas ??


Quote:

Is there a way I can give a user / moderator access to the Spam 0 Matic Logs ?
Well what I did was make the Moderator a Admin then took away all the permissions that he didn't need that seems to work, Shouldn't have anything in there he can hurt

ForceHSS 01-07-2013 03:58 PM

Quote:

Originally Posted by spd2612 (Post 2395300)
Their has to be a way to do this I just have one Super Moderator that I want to be able to view the Logs to see who and why they were banned, however I dont want them to have full Admin CP access. I tried adding there user id to config.php that did nothing anyone have any ideas ??

Post here and get someone to code it for you

wayno007 01-08-2013 03:38 AM

I've installed the plugin for the first time, but when I enable it and attempt to post to the forum, I get an "HTTP Error 500 " and everything freezes. Any ideas on what I could be doing wrong, or what I should check for?

n00b here, so take 'er easy...

ForceHSS 01-08-2013 04:21 AM

Quote:

Originally Posted by wayno007 (Post 2395456)
I've installed the plugin for the first time, but when I enable it and attempt to post to the forum, I get an "HTTP Error 500 " and everything freezes. Any ideas on what I could be doing wrong, or what I should check for?

n00b here, so take 'er easy...

did you first upload the files to your ftp before you installed the xml

camoit 01-08-2013 07:23 AM

I have this installed on V 4.1.11 and it does not move members from the new-be group to the registered group. They are to be moved at 8 posts but I have some with 50+ and there still in the new-be group. What can we do about this???

TheInsaneManiac 01-08-2013 10:52 AM

need to have blog anti spam

Dutch_Boy 01-08-2013 11:21 AM

Database error in vBulletin 4.1.2:

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 : Tuesday, January 8th 2013 @ 01:17:04 PM
Error Date : Tuesday, January 8th 2013 @ 01:17:05 PM
Script : http://www.mccrafty.nl/admincp/plugi...=productimport
Referrer : http://www.mccrafty.nl/admincp/plugin.php?do=productadd
IP Address : ******
Username : Dutch_Boy
Classname : vB_Database
MySQL Version : 5.5.14

Can anyone tell me how i can fix this problem?

Gemeos 01-08-2013 12:06 PM

Quote:

Originally Posted by ForceHSS (Post 2391558)
in product-glowhostspamomatic.xml change all instances of

Code:

) TYPE=MyISAM; ');
to

Code:

) ENGINE=MyISAM; ');
then install again

Hi there!

I was having the same problem when installing. I did what you suggested, but then my forum was totally dis-configured...

I had to uninstall the plugin. Any help?

Thanks

ForceHSS 01-08-2013 03:13 PM

Quote:

Originally Posted by Gemeos (Post 2395531)
Hi there!

I was having the same problem when installing. I did what you suggested, but then my forum was totally dis-configured...

I had to uninstall the plugin. Any help?

Thanks

dis-configured? you need to give more info on the problem/error

Dutch_Boy 01-08-2013 08:59 PM

Quote:

Originally Posted by Dutch_Boy (Post 2395524)
Database error in vBulletin 4.1.2:

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 : Tuesday, January 8th 2013 @ 01:17:04 PM
Error Date : Tuesday, January 8th 2013 @ 01:17:05 PM
Script : http://www.mccrafty.nl/admincp/plugi...=productimport
Referrer : http://www.mccrafty.nl/admincp/plugin.php?do=productadd
IP Address : ******
Username : Dutch_Boy
Classname : vB_Database
MySQL Version : 5.5.14

Can anyone tell me how i can fix this problem?

Can someone help me with this problem?

I get this error when i try to install the plugin.

Im getting spammed with bots...

ForceHSS 01-08-2013 09:02 PM

Quote:

Originally Posted by Dutch_Boy (Post 2395637)
Can someone help me with this problem?

I get this error when i try to install the plugin.

Im getting spammed with bots...

the fix is two posts above you try harder

Gemeos 01-08-2013 10:35 PM

Quote:

Originally Posted by ForceHSS (Post 2395561)
dis-configured? you need to give more info on the problem/error

Everything was out of place. It was impossible to "navigate" on the forum.

I'll take the risk of installing it again and make a printscreen of the result.

Dutch_Boy 01-09-2013 12:31 AM

Quote:

Originally Posted by ForceHSS (Post 2395639)
the fix is two posts above you try harder

Thanks i didnt see any database errors here so i didint know that someone els had the same problem.

And i worked fine for me!

Many thanks!

ForceHSS 01-09-2013 12:35 AM

Quote:

Originally Posted by Dutch_Boy (Post 2395661)
Thanks i didnt see any database errors here so i didint know that someone els had the same problem.

And i worked fine for me!

Many thanks!

if you looked you would of seen the same error as yours above the post of mine with the fix

Thangvip9x 01-10-2013 03:17 AM

Currently Active Users Viewing This Thread:
107 (3 members and 104 guests)
Thangvip9x, sapomega, RaidenDAWG2

reboot_me 01-10-2013 04:01 AM

I was going to post the same error on line ten, but I did catch the answer, now going to try it.

Thanks!

Gemeos 01-10-2013 10:21 PM

Quote:

Originally Posted by ForceHSS (Post 2395561)
dis-configured? you need to give more info on the problem/error

I re-installed, and again this is what I got

https://vborg.vbsupport.ru/external/2013/01/39.png

Mark4865 01-11-2013 09:42 AM

to upgrade from 2.01 to 2.1 I assume I just import xml file and overwrite, is that correct

Alex@bulletin 01-11-2013 12:58 PM

Quote:

Originally Posted by Mark4865 (Post 2396188)
to upgrade from 2.01 to 2.1 I assume I just import xml file and overwrite, is that correct

I suppose that you got to reupload the folders to your webspace as there is a new function available in the AdminCP, I can't imagine that this will work with only adding code to the product.xml^^ Do so and you are on the safe side. (lol this idiom is the same in English as in German xD)

Alibass 01-11-2013 01:20 PM

Install just like you did 2.01 but allow overwrite to the files in folders and the xml file.

Ted Clore 01-11-2013 06:36 PM

This is an excellent add-on. Thmbs up. Stopped the bots dead in their tracks. Thanks, MOM.

ForceHSS 01-13-2013 01:44 PM

Quote:

Originally Posted by Gemeos (Post 2396101)
I re-installed, and again this is what I got

https://vborg.vbsupport.ru/external/2013/01/39.png

link to site

aquabid 01-13-2013 07:14 PM

Quote:

Originally Posted by ForceHSS (Post 2396608)
link to site

I have the same problem after upgrading

http://www.aquaboards.com

Plugin has been uninstalled and I have the same problem.

ForceHSS 01-13-2013 08:12 PM

Quote:

Originally Posted by aquabid (Post 2396655)
I have the same problem after upgrading

http://www.aquaboards.com

Plugin has been uninstalled and I have the same problem.

check url settings
and disable all plugins from config

aquabid 01-13-2013 08:22 PM

Quote:

Originally Posted by ForceHSS (Post 2396667)
check url settings
and disable all plugins from config

Everything was working prior to upgrading the plugin

I installed the 4.2 upgrade and everything is back to normal.

ForceHSS 01-14-2013 12:04 AM

Quote:

Originally Posted by aquabid (Post 2396670)
Everything was working prior to upgrading the plugin

try reinstalling all again all files to ftp then xml then remove xml then all files from the ftp see if that help also check error logs

Gemeos 01-14-2013 03:02 PM

Quote:

Originally Posted by ForceHSS (Post 2396608)
link to site

I have installed the updated version and it's now working.

Thanks! :up:

WorldCraft 01-15-2013 06:10 AM

Two feature requests:

More flexible "Override" permissions. ie: I'd like to deny my moderators from permanently deleting, but still let them choose what criteria to delete.

And, allow Admins to have full control over the moderator tool regardless of override settings.

spd2612 01-15-2013 01:07 PM

I have been running this a couple weeks now and it works very well
The question I have is it normal to be viewing whos online and see that there is 6 or 7 people trying to register quite often
It seems like my board is attracting alot of spammers is there a way to cut it down for instance adding no bots like i would on a web page
If so what can I do ?

Spam-O-Matic Statistics
117 Spammers Denied Registration
1 Spammy Post Automatically Moderated


All times are GMT. The time now is 02:29 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.03491 seconds
  • Memory Usage 1,854KB
  • 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
  • (2)bbcode_code_printable
  • (1)bbcode_php_printable
  • (21)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)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