Radically improves the search in bbPress.
Adds Google-like search ability to your bbPress forum, with many advanced options to pinpoint results.
bbPress Plugin Browser »
Super Search (0.0.3)
Download
Version: 0.0.3
Last Updated: 2009-3-30
Requires bbPress Version: 0.9 or higher
Compatible up to: 0.9
Average Rating
Your Rating
Author: _ck_
-
0.0.2 is an early release
intended as a public "alpha test"Bug reports and feedback appreciated.
There are several ways you can already customize it and other options will be available in the future.
Do not use the early releases on a very active site as there is not a cache yet for search results and frequent queries could cause unexpected loads on your mysql.
Posted: 1 year ago # -
I gave it a try, but without success. I'm using bbpress 0.9.0.2.
Esthetically, it doesn't conform to the theme on my site. I have a sidebar, so it pushes all the options and results to the bottom of the page (although the search window itself is at the top).
Functionally, it returns an error. Below is what I saw, but it looks like it cuts off:
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 bb_topics.topic_id as topic_id,topic_title,topic_]
SELECT count(*) as count FROM (SELECT bb_topics.topic_id as topic_id,topic_title,topic_slug,topic_poster,topic_poster_name,topic_last_poster,topic_last_poster_name, topic_start_time,topic_time,bb_topics.forum_id as forum_id,topic_status,topic_open,topic_last_post_id,topic_sticky,topic_posts,tag_count, post_id,poster_id,post_text,post_time,poster_ip,post_status,post_position FROM bb_topics LEFT JOIN bb_posts ON bb_topics.topic_id = bb_posts.topic_id WHERE topic_status=0 AND bb_topics.forum_id NOT IN (2) AND post_status=0 AND ( (post_text LIKE '%test%' AND post_text REGEXP '[[:<:]]test[[:>:]][^\']') ) UNION SELECT bb_topics.topic_id as topic_id,topic_title,topic_slug,topic_poster,topic_poster_name,topic_last_poster,topic_last_poster_name, topic_start_time,topic_time,bb_topics.forum_id as forum_id,topic_status,topic_open,topic_last_post_id,topic_sticky,topic_posts,tag_count, NULL as post_id,NULL as poster_id,NULL as post_text,NULL as post_time,NULL as poster_ip,NULL as post_status,NULL as post_position FROM bb_topics WHERE topic_status=0 AND bb_topics.forum_id NOT IN (2) AND ( (topic_title LIKE '%test%' AND topic_title REGEXP '[[:<:]]test[[:>:]][^\']') ) ) as t3Posted: 1 year ago # -
That's extreme strange because the demo on my site is running on 0.9.0.2 also.
Are you completely integrated? Does your tables have unusual prefixes?
Strange though, that query you posted executes fine on my system.
OH! What version of mysql are you using, that might also matter.
Posted: 1 year ago # -
The forum isn't integrated with a Wordpress blog, if that's what you mean by completely integrated. It's running off a separate database, with the default "bb_" prefix on all the tables. I'm using MySQL 4.0 and PHP 5.2.6. I can upgrade to MySQL 5.0, but it's not worth the effort at the moment. I'm waiting to do that till a stable release of bbPress 1.0 is available, since I'll want to test it on a new database first anyway.
As far as the compatibility with the sidebar goes, I'm using a variation of the Misty Morning theme. I don't know how much good it will do you to take a look around my site, since access to the forums is restricted, but here's the url anyway: http://forum.demeo-web.com/
For now, I've just disabled the plug-in. I don't think anyone but me really uses the search anyway. I just wanted to give you some feedback. I don't mind experimenting some more if you want me to try anything.
Posted: 1 year ago # -
There's no need for mysql 5.0 as I am running mysql 4.1 and wanted to see if that was different with you, but I am still not certain what's going on with your configuration.
Thanks for trying it, I hope I can get more feedback from others, especially if it works elsewhere.
Posted: 1 year ago # -
Works great for me. Thanks _ck__!
Posted: 1 year ago # -
Thanks for the feedback citizenkeith, I was beginning to wonder if it only worked on my server!
Are you integrated with WordPress?
Posted: 1 year ago # -
Hey _ck_,
No, we're not integrated with WP. I'm running another site that is integrated, so I'll give it a shot and let you know how it goes...
Posted: 1 year ago # -
It works on my integrated site, but I can't search by user name. The only options I have are "Any" and "Admin."
Posted: 1 year ago # -
Hello :)
This plugin looks awesome (way much better than the default search) but unfortunately id DOES NOT WORK with Cyrillic letters! Do you have an idea why that might be and how to fix?
Posted: 1 year ago # -
When you say it doesn't work, do you mean it can't find results when you search in your language?
Please test results when trying EXACT case vs unexact and see if one works while the other doesn't. Unfortunately I have to use some mysql tricks and it's possible that messes up non utf8 searches.
Posted: 1 year ago # -
citizenkeith, sorry I missed your bug report.
There may be a problem with how it's pulling up the users, I will have to examine it.
Are you using Firefox or another browser?I am testing a radically improved way to specify users (ala google suggest) and will replace what's there in the next version.
Posted: 1 year ago # -
Please excuse me - I should have been more correct on the report.
It does not matter what type of search I perform - it messes up the characters and returns no results.
For example if I search for "здрасти" it changes the input to "здÑ�аÑ�Ñ�и"On the other hand it works flawlessly with latin characters.
Posted: 1 year ago # -
dragunoff that's much more helpful.
I will investigate that tomorrow as I think it might be related to an htmlentities bug.Posted: 1 year ago # -
_ck_,
I am using Firefox and Opera.
Posted: 1 year ago # -
citizenkeith, I should point out the drop down only works when logged in but I bet there is a character somewhere in the list that I am not encoding that I should.
I'm taking a bbPress break today and maybe tomorrow as I am getting burnt out on it all but I will look at this again later in the week.
Posted: 1 year ago # -
Thanks for the plugin, it's great. I've just found a bug in version 0.9.0.4 with your Plugin 0.0.2. When I go under admin and wanna filter for post's or topic's, he will show me the search window instead of running the query. Thx Stefan
Posted: 1 year ago # -
Work nice for me.
I just have the "non esthetic" problem because "I have a sidebar, so it pushes all the options and results to the bottom of the page (although the search window itself is at the top)."
But I guess it's more a problem coming from my not standard theme.Thanks a lot for this plugin.
I forgot to give some details :
I tried under 9.0.2 qnd 9.0.4, and it works the same.there is a small "functionality" problem : there are a lot of result with empty content. I mean : I see the title of the topic, the name of the poster and even details like the number of the post, but no post content.
I also try french characters like "à" ou "è" and the same bug than for cyrillic : the search is transformed into "Ã " and it does not find any matching word.
It is funny for set of word like "mise à jour" : the 2 'latin" words have matches, not the french special character.
I think this comes from an encoding translation : usually, when you type "à" in UTF8 and you read it in ISO-8859-1, you get this "Ã " characters. If I read directly inside the database, the post_text contains "Ã " and no "à".Posted: 1 year ago # -
Hi,
First of all, I wish to say my thanks to your great plugin.
I have also got an error while performing the search with selecting many features on the adavnced section. And it displays a long Query and the problem is fixed when I added a space in the line 471 just before the "GROUP BY"
super-search-init.php
Line 471
Old Code:
if (empty($SSrequest['posts'])) {$query.="GROUP BY t3.topic_id ";}
Used the following code:
if (empty($SSrequest['posts'])) {$query.=" GROUP BY t3.topic_id ";}
But the user search is not working fine. Can you help me to find the final SQL Query for getting the result? If so, I can fix this issue..
Thank You BBPress Team.
Posted: 1 year ago #
Add a Comment »
You must log in to post.