Displays a list of related topics based on tags and keywords. No template edits required.
View any topic on http://bbShowcase.org to see a demonstration.
bbPress Plugin Browser »
Related Topics (0.0.4)
Download
Version: 0.0.4
Last Updated: 2008-11-17
Requires bbPress Version: 0.9 or higher
Compatible up to: trunk
Average Rating
Your Rating
Author: _ck_
-
Excellent... again!!! =)
Posted: 7 months ago # -
Starting with version 0.0.3 this plugin can now also search titles for keywords, which is especially handy if it's a new topic or no tags yet - this feature is on by default.
Very large forums may want to turn the title keyword feature off as there is no fulltext index on titles and it may be too slow until caching is added in the near future.
I would like to hear some feedback from larger forums as far the performance and quality of results.
I also would like to hear from non-english forums, especially with non-latin characters (Chinese, Japanese, etc.) to make sure the mysql queries are working properly on title keywords.
Posted: 7 months ago # -
if "$related_topics['use_titles']" is true i get:
bbPress database error: [Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation 'like'] [...]its a german forum!
sorry for my bad english, im german :) nice work! great plugin!
Posted: 7 months ago # -
Ah I was afraid of that as they warn about it in the mysql documentation about LIKE. I am not certain how to fix and will have to ask some mysql experts.
Do you know how to inspect your bbpress mysql tables with phpmyadmin?
Posted: 7 months ago # -
Nice plugin. Any thoughts if you'll rework this plugin, so it pulls in related threads in WordPress (rather than bbPress), so when you write a post about Britney, it will bring up related threads about Britney on bbPress?
Posted: 7 months ago # -
That would be possible to do as a future feature.
Now that there is caching it would not cause as much overhead.I'll put it down on the "to do" list ;-)
Posted: 7 months ago # -
This plugin works great. I left the "title keyword scan" feature on, so was worried about load... but the cache seems to have taken care of that. I monitored my server's CPU usage carefully after installing this, and it barely moved. I'll check again on a high-traffic day, but so far I am impressed!
I like the "stop word" feature too. Words like "without" were driving Related Post matches, and I thought maybe the matching algorithm wasn't working. But of course it was working great; I just needed to add some basic stop words. Very handy :-).
One word of warning: I am now somewhat addicted to checking the Related Posts for every topic on my boards. I click in to see if they are good matches, and then add tags until the Related Posts improve. If you have an addictive personality, you too may get sucked into this twisted habit!
Posted: 6 months ago # -
Ah, I will add "without" as a default stopword.
There are several huge lists of stop words available however I wanted to keep the performance reasonable so I only used a smaller list by default.
When tags were "invented" (or at least brought to the mainstream) I didn't like them but seeing them match actual topic titles is far more useful.
On a big forum I always wondered what might be a good incentive to get members to add quality tags, but it's hard to find a way. I wonder if the Amazon Mechanical Turk could be put to use by having several strangers look at the title and first post and seeing what keywords they come up with - those that come up with the same, there's your tags. Would costs a few pennies a topic though, that might add up fast.
Posted: 6 months ago # -
Ah neat! Maybe user-volunteers could do something similar... a plugin like that could also let user-volunteers vote on whether or not a topic/post is spam or not.
Posted: 6 months ago # -
Hi, that is a nice plugin...! but i get on first page load an error:
bbPress database 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 'SELECT 'normalized' AS wd UNION SELECT 'material' UNION SELEC]
SELECT topic_id, COUNT(*) as count FROM bbpressforumtopics AS s1 JOIN (SELECT 'normalized' AS wd UNION SELECT 'material' UNION SELECT 'functions' ) AS v1 ON s1.topic_slug LIKE CONCAT('%',v1.wd,'%') GROUP BY s1.topic_id HAVING count>=1 ORDER BY count DESC LIMIT 100i guess that it is a problem of related topics plugin? Thanks for any help or people with same problems!
Posted: 6 months ago # -
Interesting. You get that on every page load?
Do related topics actually come up?
bbpress 0.9 or 1.0?
Any chance you know if you are using mysql 4 or 5?Posted: 6 months ago # -
i use it on [a]www.partyxtutti.com[/a]
Posted: 5 months ago # -
sorry party x tutti
Posted: 5 months ago # -
I also get:
bbPress database 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 'SELECT 'crema' AS wd UNION SELECT 'catalana' ) AS v1 ON s1.top] SELECT topic_id, COUNT(*) as count FROM bb_topics AS s1 JOIN (SELECT 'crema' AS wd UNION SELECT 'catalana' ) AS v1 ON s1.topic_slug LIKE CONCAT('%',v1.wd,'%') GROUP BY s1.topic_id HAVING count>=1 ORDER BY count DESC LIMIT 100> You get that on every page load?
No. Just on the initial load. As I reload the page no error is shown.
> Do related topics actually come up?
Never.
> bbpress 0.9 or 1.0?
0.9.0.4
> mysql 4 or 5?
Mysql 5 on Linux/Apache
What do you think, please?
Posted: 5 months ago # -
It's really strange as that query works fine for me on mysql 4 and mysql 5.
Maybe it's the results of those search terms specifically not meshing somehow.Do you have phpmyadmin? Maybe try that query directly and see if it also gives an error, or vary the terms ('crema' and 'catalana' ) and see what happens
Posted: 5 months ago # -
> vary the terms ('crema' and 'catalana' ) and see what happens
Actually, by further testing it, one can
a) get no error and have a nice list of related topics;
b) get the error and also a related topics list;
c) get just the error.It all seems to be dependent fron the "keywords" used.
I do not know *why* the error is generated, but as one obviously cannot control the keywords, I'm afraid I have to deactivate this pugin.
Pity, for it is really nice!Posted: 4 months ago #
Add a Comment
You must log in to post.