[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

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

Post by Joe Belmaati » Sun Mar 04, 2007 3:58 pm

That is a bug that was addressed a few pages back.

dishdiva,
there are many good articles on this site about how to install mods. I would encourage you to read them.


truepunk,
AFAIK the only diff. between CHAR and VARCHAR is that CHAR sets the character limit to a value where VARCHAR uses only the characters it needs. CHAR uses more db space but executes faster...

Billy2423,
that does not look like code from the general distribution. Looks like something from a small add on.
Image

alosito2
Registered User
Posts: 6
Joined: Tue Jan 09, 2007 6:17 pm

Post by alosito2 » Mon Mar 05, 2007 8:14 am

Joe Belmaati wrote: That is a bug that was addressed a few pages back.
alosito2 wrote:Why do I get the following error every time I delete flagged messages?
Could not get post ID

DEBUG MODE

SQL Error : 1064 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 '' at line 3

SELECT MAX(post_id) AS last_post, COUNT(post_id) AS total FROM phpbb_posts WHERE forum_id =

Line : 201
File : functions_admin.php

I went through all 36 pages, and I couldn't find the answer. Could you please give me the page number on which you addressed this issue or maybe the message number?

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

Post by Joe Belmaati » Mon Mar 05, 2007 10:33 am

Ooops this was something I addressed in a PM to someone.

OPEN admin/admin_spamwords_flagged.php

FIND

Code: Select all

   $flagged_forums = array_unique($flagged_forums);
REPLACE WITH

Code: Select all

//   $flagged_forums = array_unique($flagged_forums);
Image

mmantei
Registered User
Posts: 2
Joined: Mon Feb 27, 2006 12:46 am

Re: [01/12/06] Spam Words

Post by mmantei » Tue Mar 20, 2007 6:19 pm

This will seem like a dumb question, but where can I download this MOD? I've tried the link at the beginning of the thread, but it just brings up a page saying that it is an "ex-parrot" and to try using the search. I would love to try it out, but need to actually download it first.

Thanks,
M

Paul
Infrastructure Team Leader
Infrastructure Team Leader
Posts: 25497
Joined: Sat Dec 04, 2004 3:44 pm
Location: The netherlands.
Name: Paul Sohier
Contact:

Re: [01/12/06] Spam Words

Post by Paul » Tue Mar 20, 2007 6:50 pm

mmantei wrote: This will seem like a dumb question, but where can I download this MOD? I've tried the link at the beginning of the thread, but it just brings up a page saying that it is an "ex-parrot" and to try using the search. I would love to try it out, but need to actually download it first.

Thanks,
M

Please read the announcments in this forum ;)
Knock knock
Race condition
Who's there?

My BlogMy Photosmy phpBB Extensionscustom phpBB work & Development

karmica
Registered User
Posts: 13
Joined: Wed Mar 28, 2007 3:02 pm
Contact:

Re: [01/12/06] Spam Words

Post by karmica » Wed Mar 28, 2007 3:06 pm

this is my first mod and i'm having trouble with it. I'd really appreciate any help I can get.

1. I'm not sure if I did the first step correctly. I uploaded the db_update.php file into the mail folder of my forum and put that url in my browser.
When I did that, it went to my login page.
"...forum/login.php?redirect=db_update.php"

was that what it's supposed to do?
If you are going to run the SQL manually, then please
## remember to add your table prefix if other than phpbb_. For all intents and purposes it is probably easier to just run the root/db_update.php file. Upload it to your phpBB root directory and call it in your browser - then delete it.


2. Maybe this is a result of my first mistake. Here are the errors I have when I finished editing all the files.

at the main url:
SQL Error : 1054 Unknown column 'p.post_flagged' in 'field list'

SELECT f.*, p.post_time, p.post_username, p.post_flagged, u.username, u.user_id FROM (( phpbb_forums f LEFT JOIN phpbb_posts p ON p.post_id = f.forum_last_post_id ) LEFT JOIN phpbb_users u ON u.user_id = p.poster_id ) ORDER BY f.cat_id, f.forum_order

Line : 170
File : index.php



at the viewforum.php url:
SQL Error : 1054 Unknown column 'p.post_flagged' in 'where clause'

SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time FROM phpbb_topics t, phpbb_users u, phpbb_posts p, phpbb_posts p2, phpbb_users u2 WHERE t.forum_id = 1 AND t.topic_poster = u.user_id AND p.post_id = t.topic_first_post_id AND p2.post_id = t.topic_last_post_id AND u2.user_id = p2.poster_id AND t.topic_type <> 2 AND p.post_flagged <> 1 ORDER BY t.topic_type DESC, t.topic_last_post_id DESC LIMIT 0, 50

Line : 328
File : viewforum.php
[/quote][/quote][/quote]

I know it says that i can enter the SQL table manually but i have no idea how to go about doing that. :(

Six Sigma Teacher
Registered User
Posts: 22
Joined: Thu May 26, 2005 6:48 pm
Contact:

Re: [01/12/06] Spam Words

Post by Six Sigma Teacher » Wed Mar 28, 2007 4:32 pm

karmica,

This MOD installs easily with something called EasyMod, information about which can be found here:

http://area51.phpbb.com/phpBB/viewforum.php?sid=&f=15

First, you will install EasyMOD by following those directions, then you will use EasyMOD to install Spamwords.

It will not require any editing of files or modifications of databases - it is very easy!

karmica
Registered User
Posts: 13
Joined: Wed Mar 28, 2007 3:02 pm
Contact:

Re: [01/12/06] Spam Words

Post by karmica » Wed Mar 28, 2007 10:26 pm

SST, thanks for that tip! I just used it now :D

User avatar
kwikone
Registered User
Posts: 6
Joined: Tue Nov 28, 2006 6:20 pm
Location: Virginia Beach, VA, USA
Contact:

Re: [01/12/06] Spam Words Unable to download

Post by kwikone » Thu Mar 29, 2007 2:40 pm

When I click on the link to download it all I get is a 404 Not found. :cry:

karmica
Registered User
Posts: 13
Joined: Wed Mar 28, 2007 3:02 pm
Contact:

Re: [01/12/06] Spam Words Unable to download

Post by karmica » Thu Mar 29, 2007 6:15 pm

go to the announcements at the top of this page and click on:
IMPORTANT: How to securely download MODs while the database is unavailable

I didn't realize this before either.
kwikone wrote: When I click on the link to download it all I get is a 404 Not found. :cry:

User avatar
Raimon
Former Team Member
Posts: 12088
Joined: Tue May 30, 2006 5:31 pm
Location: Netherlands
Name: Raimon Meuldijk
Contact:

Re: [01/12/06] Spam Words

Post by Raimon » Fri Mar 30, 2007 12:42 am

Here you have the direct url to the MOD: http://www.phpbb.com/files/mods/spamwords_1.1.3.zip
Need phpBB installation, extenstions, Styles or integrate phpBB with you website?
Contact me for fair prices and good service!

microchemicals
Registered User
Posts: 2
Joined: Wed Apr 04, 2007 6:45 am

Spam Words and Resync

Post by microchemicals » Wed Apr 04, 2007 7:01 am

Hello,

I implemented the Spam Words mod in our forum an now have a problem (since I also implemented some other mods, I cannot say if the problem started with Spam Words, but it seems to be connected with the Spam Words mod). All functions of the Spam Words mod work perfectly, but after deleting flagged posts in the admin panel:

1) The post counters in the forum (number of total posts as well as the number of posts in the forum the flagged post has been posted) keep to the values they got WITH the 'spam posts'.

2) The date of the last post in each forum from where a flagged post has been deleted goes to 'Thu 01 Jan, 1970 01:00'.

One solution is to click the 'resync' button in the admin panel for each forum from where a flagged post has been deleted. However, doing this every day costs some time ...

Is there any way out?

One more hint: Some time ago, I re-installed our forum onto a new domain. I started with a 'fresh' set of the 2.0.22 forum files, and very carefully added the mods. The problems started when I imported the old database, so I assume the problem being in the database, not in the forum files.

Thank you very much for your assistance!

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 » Wed Apr 04, 2007 7:24 pm

Hi,
there are solutions for all your questions a couple of pages back in this topic.
Image

microchemicals
Registered User
Posts: 2
Joined: Wed Apr 04, 2007 6:45 am

Re: [01/12/06] Spam Words

Post by microchemicals » Thu Apr 05, 2007 7:52 am

Hello,

do you mean the resync.php? After running it, everything ist fine (time, counters) - for the moment. Deleting the next flagged post in the admin panel appearing in the forum brings back the problems described (time-travel, wrong counter). So, is it neccessary to run the resync.php file continuously instead of fixing some trouble in the database once and for all?

As I understand, the install_extra.mod should have nothing to do with the problem, since it impacts on the counters before a flagged post is deleted, not after?

Maybe you give me a short hint where to find the solution in this topic - I aleady went through all 36 pages, maybe I don't exactly know what to search for ... Thank you for your assistance!

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 » Fri Apr 06, 2007 7:25 pm

I think one of the fixes show how to apply the resync when the flagged posts are purged.
Image

Post Reply

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