vb.org Archive
Page 6 of 7 « First 45 6 7
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   Anti-Spam Options - [GlowHost] Spam-O-Matic for vB 3.8 (StopForumSpam, Akismet, Auto-Moderation and more) (https://vborg.vbsupport.ru/showthread.php?t=248470)

mdawg 11-26-2013 03:37 PM
Will this version of Spam-o-Matic work on 3.8.7 PL3?

squidsk 11-27-2013 05:29 AM
Yes.

MaXimus 11-28-2013 04:29 PM
When I tried to import the plugin after copying the files to the root of my forum folder, this is the error I get, running VB 3.8.7

please help

Quote:
Database error in vBulletin 3.8.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
Request Date : Thursday, November 28th 2013 @ 11:28:26 AM
Error Date : Thursday, November 28th 2013 @ 11:28:26 AM
Script : http://forums.tweakarena.com/admincp...=productimport
Referrer : http://forums.tweakarena.com/admincp...?do=productadd
IP Address : 86.96.80.31
Username : Matrix Leader
Classname : vB_Database
MySQL Version : 5.5.33-31.1

squidsk 11-28-2013 05:03 PM
Change TYPE=MyISAM to ENGINE=MyISAM, either that or remove that bit of code and run it again.

MaXimus 11-28-2013 05:54 PM
Quote:
Originally Posted by squidsk (Post 2464375)
Change TYPE=MyISAM to ENGINE=MyISAM, either that or remove that bit of code and run it again.
sorry I'm a n00b, how do I do that?

squidsk 11-28-2013 09:24 PM
Quote:
Originally Posted by Matrix Leader (Post 2464384)
sorry I'm a n00b, how do I do that?
Edit the product's xml file and make the change.

MaXimus 11-29-2013 05:25 AM
Quote:
Originally Posted by squidsk (Post 2464418)
Edit the product's xml file and make the change.
that worked like a charm! thanks a lot chief! you rock

93Corvette 02-02-2014 03:40 AM
I am getting this error. I have changed the TYPE=MyISAM to ENGINE=MyISAM but it still doesn't work... Anyone know what this is?

squidsk 02-02-2014 07:15 PM
Except you changed it from Type=MyISAM to Type=Engine instead of Engine=MyISAM. Alternatively just remove that bit entirely and the table will be created with the default engine.

drsolomon1990 02-24-2014 08:39 PM
Quote:
Originally Posted by squidsk (Post 2478673)
Except you changed it from Type=MyISAM to Type=Engine instead of Engine=MyISAM. Alternatively just remove that bit entirely and the table will be created with the default engine.
Quote:
Database error in vBulletin 3.8.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=Engine;;

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=Engine' at line 10

Request Date : Monday, February 24th 2014 @ 03:36:53 PM
Error Date : Monday, February 24th 2014 @ 03:36:53 PM
tried that mate but still showing err

squidsk 02-27-2014 02:55 AM
Quote:
Originally Posted by drsolomon1990 (Post 2483513)
tried that mate but still showing err
You didn't change it correctly look at the code you've posted it is incorrect.

SirVault 05-20-2014 10:10 PM
Anyone, off the top of their heads, know how to allow registration but disallow posting abilities?

DaveHillDL 06-06-2014 01:26 PM
Just installed on 3.8.7PL4 - seems to be OK. I edited the XML file before I installed.

Is there any way to get VB to email the moderator(s) when there is a pending post? I can't see anything in the VB settings, nor any mod that will allow this (but I could be wrong!).

Dave

Tobin Frost 06-07-2014 10:40 AM
Thanks! :)

Katelynn 07-10-2014 05:45 PM
I've looked everywhere, and cannot find an answer. So I'll ask here.

My glowhostspamomatic_log table is HUGE! I have 1.5 million rows since initial install in 2012. I am running version 1.2.7

Was there no way to purge the table? Or is this something we have to do manually?

Does anybody have a cron job to purge the table to allow only "x" number of days to remain, and delete all other rows?

Hoping someone can help because my table is ridiculously large (250mb and 1.5 million rows).

Thank you

Katelynn 07-10-2014 08:40 PM
Hey Guys, Just wanted to let you know I figured it out. I ended up writing this for my dailycleanup.php cron job. Hope that helps someone with a huge log file!

If I should NOT be doing this, please let me know!!

Code:
// DELETE Spam--O-Matic Log Entries Older Than 7 Days
$vbulletin->db->query_write("
        DELETE FROM " . TABLE_PREFIX . "glowhostspamomatic_log
        WHERE date < DATE_SUB(NOW(), INTERVAL 7 DAY)
");

// OPTIMIZE Spam--O-Matic TABLE After Deletion Of Log Entries Older Than 7 Days
$vbulletin->db->query_write("
        OPTIMIZE TABLE " . TABLE_PREFIX . "glowhostspamomatic_log
");

OUTL4W 10-31-2014 08:51 AM
Anyone having issues on 3.8.8 patch level 4?...php 5.3.28

Fivestones 11-27-2014 05:50 AM
thanks

aseapeople 01-31-2015 01:43 AM
Anyone using this on 3.8.8 successfully still?

Zilvia 05-08-2015 02:17 PM
I know this is really old and unsupported, but Im trying to view the log in admincp, but I do not see anywhere that displays the log for Spam-O-Mattic and Ive looked through everything under AdminCP > Statistics & Logs. Im running 3.8.7Patch level 3. Does anyone know where I can review the log?

Thanks,

Jorrit787 06-18-2015 03:20 PM
Pruning of old log entries definitely should be added by default... My log table has grown to 160 MB :mad:

Jorrit787 06-18-2015 03:21 PM
Quote:
Originally Posted by 93Corvette (Post 2478534)
I am getting this error. I have changed the TYPE=MyISAM to ENGINE=MyISAM but it still doesn't work... Anyone know what this is?
WTH is with the feet?!

mykkal 06-18-2015 10:59 PM
Quote:
Originally Posted by Jorrit787 (Post 2548144)
WTH is with the feet?!
yup, i'm throwing errors just looking at this post.

skubaman 07-21-2015 10:23 PM
Hi,

As was wondering if anyone know if this should work on vB 3.8.8?

Thanks

squidsk 07-22-2015 07:10 PM
It says it works for 3.8.x so I'd say that's a yes. I know it worked for 3.8.7 and there's only been php compatibility updates in 3.8.8 anf 3.8.9 so it should work.

feldon23 12-16-2015 02:26 PM
The Edit User page of the AdminCP throws this when the Product is enabled:

Quote:
Warning: Illegal string offset 'userid' in [path]/includes/functions.php on line 509

Warning: Illegal string offset 'userid' in [path]/includes/functions.php on line 512

Warning: Illegal string offset 'membergroupids' in [path]/includes/functions.php on line 441

Warning: Illegal string offset 'membergroupids' in [path]/includes/functions.php on line 443

Warning: Illegal string offset 'usergroupid' in [path]/includes/functions.php on line 452

Warning: Illegal string offset 'usergroupid' in [path]/includes/functions.php on line 518

Warning: Illegal string offset 'userid' in [path]/includes/functions.php on line 518
The only thing I can think of is my admincp directory has been renamed, but I didn't find "admincp" hardcoded anywhere in the XML or PHP files. Uninstalling. :(

Dave 12-16-2015 02:32 PM
Quote:
Originally Posted by feldon23 (Post 2560589)
The Edit User page of the AdminCP throws this when the Product is enabled:



The only thing I can think of is my admincp directory has been renamed, but I didn't find "admincp" hardcoded anywhere in the XML or PHP files. Uninstalling. :(

That's not caused by this plugin. It's because of the PHP version you're using.
vBulletin 3 makes use of stuff like $userinfo[userid] instead of $userinfo['userid'], note the single quotes between the square brackets. Newer PHP version don't like that.

feldon23 12-16-2015 04:59 PM
Except that turning off the plugin makes those messages go away. Hmm.

Dave 12-16-2015 05:02 PM
It's possible that this plugin changes the error reporting level of PHP.
The errors itself are not related to the plugin in any way.

feldon23 12-16-2015 10:43 PM
Ah the 4th line in glowhostspamomatic.php which goes in admincp is "error_reporting(E_ALL & ~E_NOTICE);".

Dave 12-17-2015 06:23 AM
Yep, remove that line and it should work fine again.

oldengine 01-10-2016 01:02 AM
Just installed on 3.8.9 - Great!

Does anyone answer the phone here? I'd sure like to discuss operations of Spam-O-Matic.

Lots of bots trying to get in and still getting through. Still on manual approval. Did the renaming of register.php - not effective.

T.P. 03-08-2016 07:38 PM
Note for the Developer:

PHP 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; '); 
Please use instead only "ENGINE" not TYPE !!!

Quote:
The older TYPE option was synonymous with ENGINE. TYPE was deprecated in MySQL 4.0 and removed in MySQL 5.5. When upgrading to MySQL 5.5 or later, you must convert existing applications that rely on TYPE to use ENGINE instead.
http://stackoverflow.com/questions/1...le-type-myisam

John Diver 05-13-2016 09:23 PM
Hey,

I have done the above and I am still getting a blank forum - Running PHP 5.4.45

I haven't made any changes apart from this.

Anyone know what could be causing this?

Thanks

oldengine 09-02-2016 01:34 AM
Anyone notice that when www.stopforumspam.com is down, you then get duplicate account names in your user database?

oldengine 09-02-2016 02:55 PM
Also that spammers are able to get here without an email address:

2016-09-01 21:36:31 192.210.134.135 ShellaNzu cesartorrez@hidebox.org Spam-O-Matic Tagged email - cesartorrez@hidebox.org - Spammer Found and rejected.
2016-09-01 21:02:26 134.249.141.83 JCQcWwDm Passed StopForumSpam checks. Sent to vBulletin Registration System.
2016-09-01 21:02:25 134.249.141.83 JCQcWwDm Passed StopForumSpam checks. Sent to vBulletin Registration System.
2016-09-01 21:02:24 134.249.141.83 JCQcWwDm Passed StopForumSpam checks. Sent to vBulletin Registration System.
2016-09-01 21:02:23 134.249.141.83 JCQcWwDm Passed StopForumSpam checks. Sent to vBulletin Registration System.
2016-09-01 21:02:22 134.249.141.83 JCQcWwDm Passed StopForumSpam checks. Sent to vBulletin Registration System.
2016-09-01 21:02:21 134.249.141.83 JCQcWwDm Passed StopForumSpam checks. Sent to vBulletin Registration System.
2016-09-01 21:02:20 134.249.141.83 JCQcWwDm Passed StopForumSpam checks. Sent to vBulletin Registration System.
2016-09-01 21:02:19 134.249.141.83 JCQcWwDm Passed StopForumSpam checks. Sent to vBulletin Registration System.
2016-09-01 21:02:19 134.249.141.83 JCQcWwDm Passed StopForumSpam checks. Sent to vBulletin Registration System.
2016-09-01 21:02:17 134.249.141.83 JCQcWwDm Passed StopForumSpam checks. Sent to vBulletin Registration System.
2016-09-01 21:02:15 134.249.141.83 JCQcWwDm Passed StopForumSpam checks. Sent to vBulletin Registration System.
2016-09-01 21:02:15 134.249.141.83 JCQcWwDm Passed StopForumSpam checks. Sent to vBulletin Registration System.
2016-09-01 21:02:14 134.249.141.83 JCQcWwDm Passed StopForumSpam checks. Sent to vBulletin Registration System.
2016-09-01 21:01:59 134.249.141.83 JCQcWwDm Passed StopForumSpam checks. Sent to vBulletin Registration System.
2016-09-01 20:48:43 199.15.233.174 zffuui60 nulu9894@mail.com Spam-O-Matic Tagged ip - 199.15.233.174 - Spammer Found and rejected.

134.249.141.83 Email shows on stopforumspam as empty@unknown.com

There's no one here, so is this software a dead duck?

m7sen 09-12-2017 12:53 AM
any upgade ?

how can i stop spam emails sent it from my site

TAIFUN_T 02-13-2018 03:36 PM
Quote:
Originally Posted by hqlman (Post 2318087)
Tested working fine with VB3.8.7 patch level 2

Had to make a small change to the XML files sql syntax for it to import, so if you get SQL error whilst importing the XML file, make the changes mentioned below.

In product-glowhostspamomatic.xml

FIND:
Code:
) TYPE=MyISAM; ');
REPLACE WITH:
Code:
) TYPE=ENGINE; ');
SAVE AND RE IMPORT XML FILE, ENJOY :)
Are you sure?

Maybe)

Code:
ENGINE=MyISAM

Alice 06-24-2018 04:22 PM
I'm running vBulletin 3.8.11, and I tried installing this plugin today, and got this error:

Code:
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;;

BirdOPrey5 06-27-2018 11:12 AM
You have to chamge TYPE=MyISAM to ENGINE=MyISAM.


All times are GMT. The time now is 03:54 AM.
Page 6 of 7 « First 45 6 7
Show 40 post(s) from this thread on one page

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.01680 seconds
  • Memory Usage 1,848KB
  • 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
  • (5)bbcode_code_printable
  • (1)bbcode_php_printable
  • (13)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (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