[01/12/06] Spam Words

All new MODs released in our MOD Database will be announced in here. All support for released MODs needs to take place in here. No new MODs will be accepted into the MOD Database for phpBB2
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.

Rating:

Excellent!
52
76%
Very Good
9
13%
Good
4
6%
Fair
0
No votes
Poor
3
4%
 
Total votes: 68

Billy2423
Registered User
Posts: 88
Joined: Sun Sep 28, 2003 2:23 pm
Location: USA
Name: Bill Withers
Contact:

Re: [01/12/06] Spam Words

Post by Billy2423 »

coulsontom wrote: i get this error message on the configuration page:
please help
U did not run db_update.php to install the table
coulsontom
Registered User
Posts: 2
Joined: Thu May 17, 2007 1:36 pm

Re: [01/12/06] Spam Words

Post by coulsontom »

Billy2423 wrote:
coulsontom wrote: i get this error message on the configuration page:
please help
U did not run db_update.php to install the table
i have run the update and this still appears:

Code: Select all

phpBB : Critical Error 

Could not query config information

DEBUG MODE

SQL Error : 1146 Table 'lukeclar_phpb1.SPAM_WORDS_CONFIG_TABLE' doesn't exist

SELECT * FROM SPAM_WORDS_CONFIG_TABLE

Line : 44
File : admin_spamwords_config.php 
however, the flag page seems to work
ben.suffolk
Registered User
Posts: 3
Joined: Sun Jan 23, 2005 10:29 pm

Re: [01/12/06] Spam Words

Post by ben.suffolk »

HI,

This looks like a great mod, but I can;t get it to work. All the admin part works. I have set up the words but it never blocks any spam.

Looking through the code I can't see any bits that call the check_spam function :-

>grep Version INSTALL.mod
## MOD Version: 1.1.3
>grep check_spam INSTALL.mod
>grep -R check_spam phpbb2_root/*
includes/spamwords.php:function check_spam($message, &$subject, &$signature)
includes/spamwords.php: check_spam($message, $subject, $signature);

I'm guessing there is something I have must have missed in some instructions somewhere along the lines, but having re read INSTALL.mod several times and looked through the code I'm not seeing it.

Regards

Ben
Skywalker3012
Registered User
Posts: 9
Joined: Sun May 20, 2007 6:48 am

Re: [01/12/06] Spam Words

Post by Skywalker3012 »

Hey big problem!

I installed the mod and then ran the db_update file for the forum I'm an admin for. Then for some reason there's a blank screen when I post. So I triple checked all the files and changed a couple of errors, and then ran the db_update again. Same error, I replaced all the files and it doesn't seem to be any different. I didn't replace the files that db_update modified because I'm unsure as to what it actually changed.

Finally, there is a seperate default theme on the board, but to be safe I copied the files to both SubSilver and the custom theme. I also edited both the files in each folder. Can anybody give tips ASAP? Thanks!
Billy2423
Registered User
Posts: 88
Joined: Sun Sep 28, 2003 2:23 pm
Location: USA
Name: Bill Withers
Contact:

Re: [01/12/06] Spam Words

Post by Billy2423 »

db_update only installed the needed tables and does not change any files. U should have gotten a error when you ran it again saying the tables are already there. Double check your edited files, mainly the ones for posting.php and includes/functions_post.php
Skywalker3012
Registered User
Posts: 9
Joined: Sun May 20, 2007 6:48 am

Re: [01/12/06] Spam Words

Post by Skywalker3012 »

Yea when I ran db_update a second time I got that error, but even after replacing all the files (Including the unmodified files) with the original, it still doesn't work. :(
plasmatic
Registered User
Posts: 14
Joined: Tue Dec 12, 2006 3:34 am

Re: [01/12/06] Spam Words

Post by plasmatic »

coulsontom wrote:
Billy2423 wrote:
coulsontom wrote: i get this error message on the configuration page:
please help
U did not run db_update.php to install the table
i have run the update and this still appears:

Code: Select all

phpBB : Critical Error 

Could not query config information

DEBUG MODE

SQL Error : 1146 Table 'lukeclar_phpb1.SPAM_WORDS_CONFIG_TABLE' doesn't exist

SELECT * FROM SPAM_WORDS_CONFIG_TABLE

Line : 44
File : admin_spamwords_config.php 
however, the flag page seems to work
I'm getting this same error.
I updated from phpbb 2.0.21 to 2.0.22 yesterday without a hitch. Then modded all the files the same way I did before, ran the db_update.php and saw the same error.

The tables are there, I even manually deleted them and reran db_update.php
Right now I'm looking into how the 2.0.22 update altered the tables.
Joe Belmaati
Registered User
Posts: 2110
Joined: Sun Sep 28, 2003 7:35 pm
Location: Denmark

Re: [01/12/06] Spam Words

Post by Joe Belmaati »

Make sure you edited constants.php properly.
Image
plasmatic
Registered User
Posts: 14
Joined: Tue Dec 12, 2006 3:34 am

Re: [01/12/06] Spam Words

Post by plasmatic »

Joe Belmaati wrote:Make sure you edited constants.php properly.
Good call.
I somehow loaded in backup files from an earlier date that weren't modded.
4am installs are not a great idea I guess.
estado3
Registered User
Posts: 5
Joined: Tue Apr 03, 2007 4:50 pm

Re: [01/12/06] Spam Words

Post by estado3 »

Is there an option to not have a spam words log, as the spam words log is having a substantial increase in the size of my database, I don't want any logs, how may I do this?
ben.suffolk
Registered User
Posts: 3
Joined: Sun Jan 23, 2005 10:29 pm

Re: [01/12/06] Spam Words

Post by ben.suffolk »

ben.suffolk wrote:Looking through the code I can't see any bits that call the check_spam function :-

>grep Version INSTALL.mod
## MOD Version: 1.1.3
>grep check_spam INSTALL.mod
>grep -R check_spam phpbb2_root/*
includes/spamwords.php:function check_spam($message, &$subject, &$signature)
includes/spamwords.php: check_spam($message, $subject, $signature);

I'm guessing there is something I have must have missed in some instructions somewhere along the lines, but having re read INSTALL.mod several times and looked through the code I'm not seeing it.
So can anybody tell me what I have missed?

Regards

ben
Joe Belmaati
Registered User
Posts: 2110
Joined: Sun Sep 28, 2003 7:35 pm
Location: Denmark

Re: [01/12/06] Spam Words

Post by Joe Belmaati »

Seriously?

Code: Select all

includes/spamwords.php: check_spam($message, $subject, $signature);
Image
jintxo
Registered User
Posts: 4
Joined: Fri May 27, 2005 3:09 pm

Re: [01/12/06] Spam Words

Post by jintxo »

Hello Joe and friends. I am using a slightly outdated version of the MOD (Installed it about a year ago) and it wasn't very effective up until now, I still had a bunch of spam even though I had the "typical" spam words list (you know cialis viagra porn etc etc.)

I found this thread and applied a couple changes to the MOD that are listed a few pages bach so that the filter would catch http and *http* in the body of the posts and I couldn't be happier with the results.

Everyone posting "legitimate" links is just posting urls without the http and the spambots all use the http in there somewhere, so the result is that I am VERY VERY VERY happy with the results of applying those small changes. Only 1 spam post since I have applied these changes (maybe about a month ago)

Many thanks to Joe and anyone else who has contributed to this MOD, maybe it could become a standard feature in phpbb software :-)

Cheers and Regards to all!!!

jintxo
Joe Belmaati
Registered User
Posts: 2110
Joined: Sun Sep 28, 2003 7:35 pm
Location: Denmark

Re: [01/12/06] Spam Words

Post by Joe Belmaati »

Thank you so much - I sincerely appreciate it. :)
Image
Matt Skillett
Registered User
Posts: 75
Joined: Fri Dec 03, 2004 9:41 am

Re: [01/12/06] Spam Words

Post by Matt Skillett »

At risk of sounding like an idiot... Where is the install.txt file for this mod? I didn't think there was one so I tried to guess! Apparently I have to edit constants.php...
Post Reply

Return to “[2.0.x] MOD Database Releases”