Advanced Contextual search for WordPress

Comments

1. Mark says:

   8/12/2004 at 11:41 am

   Did you run search_upgrade.php that is included in the zip file?
2. dodo (1 comments.) says:

   8/12/2004 at 2:02 am

   the script is great. but it doesn’t highlight the search keywords in the results?
3. Ryan says:

   8/12/2004 at 11:38 am

   Just installed the search engine. I get this error:

   Database error: [Can’t find FULLTEXT index matching the column list]
   SELECT ID,post_title,post_content,post_excerpt,post_date, MATCH(post_title,post_content) AGAINST (‘united forest’) AS score FROM wp_posts WHERE MATCH (post_title,post_content) AGAINST (‘united forest’) LIMIT 0,11

   No results.
4. Mark says:

   8/12/2004 at 10:04 am

   There is no search word highlighting because words are not searched for as a whole, there is some fuzzy matching going on.
5. Clay Heaton (1 comments.) says:

   7/12/2004 at 12:15 am

   Does this search hack search the text of the excerpt, or just the main contents of the post?
6. Mark says:

   7/13/2004 at 7:58 am

   Right now it only works with the post title and post content and not the excerpt.
7. BB (5 comments.) says:

   7/23/2004 at 7:06 am

   I wrapped my site design around the code and made a new search.php file. The search results don’t span from the left to the right within the div, as I would like them to. Complete newbie question:

   How do I get the search results to go completely across the center content div?

   FYI: You should change line 149 of search.php from “search-beta.php” to “search.php”.
8. Mark (34 comments.) says:

   7/23/2004 at 7:54 am

   I will make that change.
   As for the CSS, take a look at the source of my search page (or any single post page). The menu is suppressed.
9. BB (5 comments.) says:

   7/23/2004 at 8:37 pm

   Yes, I thought I had that, too. Take a look at this page on my site. You can see how the content isn’t filling up the center div. What did I do wrong? You can view the code I have in the search.php file here.
10. BB (5 comments.) says:

    7/23/2004 at 8:46 pm

    Apparently, the href’s got stripped out of that last comment. Here they are:
    
    
11. Kelso (2 comments.) says:

    8/4/2004 at 5:51 pm

    BTW – don’t hate me ’cause I use tables
    And, is there any reason why it wont show any results if I search “Nike”, but it will if I search “Air” keeping in mind that I have to posts with the words “Nike Air” in their titles… ?
12. Kelso (2 comments.) says:

    8/4/2004 at 5:44 pm

    This plugin is great

    However, I might be asking much, but is there ANY way to include PostMeta tags in the search page?
    I’ve sort of included them, but the values don’t “spit out”
    http://www.noranja.com/search.php?q=air
    (that page is still much under construction)
13. Jeffrey Morgenthaler (1 comments.) says:

    11/12/2004 at 7:34 pm

    I’ve used this before, and it worked great, but this time something’s wrong. I get no results for searches over three characters – four or more, it tells me I have no search results. COuld this be a result of using WordPress 1.2.1?

    Thanks
14. Mark says:

    11/14/2004 at 10:52 am

    I am not sure where it is breaking because your site seems to be searching just fine.
15. Mark says:

    12/4/2004 at 10:22 am

    Thisis a test
16. Andrea says:

    1/14/2005 at 12:09 pm

    I just tried out this search on a local install of WP 1.2.2, but decided that it wasn’t what I want and went back to using the normal search (i.e., I changed the searchform action back to the default and deleted the files from my directory).

    I was able to create a new post after the change, but it wouldn’t let me edit it (changes wouldn’t be saved), and when I tried to edit another post, I got the following error messages on top of my header image:

    Database error: [Can't open file: 'wp_posts.MYD'. (errno: 145)]
SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND ID = 24 AND post_date_gmt < = '2005-01-14 15:54:59' AND (post_status = "publish") GROUP BY wp_posts.ID ORDER BY post_date DESC Database error: [Can't open file: 'wp_posts.MYD'. (errno: 145)] SELECT DISTINCT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHERE post_date < '2005-01-14 16:54:26' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC

    and a "Sorry, no posts matched your criteria." message in the content area. Everything worked fine before the search-upgrade, and I really hope you can help me with this.
17. Mark says:

    1/14/2005 at 1:24 pm

    Sounds like your system is caching some items. try rebooting the server or restarting.
18. Andrea says:

    1/14/2005 at 4:36 pm

    I tried both. Same error message. I *think* I didn’t do anything apart from running the upgrade_search.php, but I can’t rule out mistakes on my part. Any ideas? Don’t know if you need it, but here’s the full error message again, it got truncated in the previous post:

    Database error: [Can't open file: 'wp_posts.MYD'. (errno: 145)]
SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt < = '2005-01-14 20:25:59' AND (post_status = "publish") GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 1
19. Andrea says:

    1/14/2005 at 4:37 pm

    It got truncated again.
20. Andrea says:

    1/14/2005 at 9:18 pm

    Okay, I managed to fix the wp_posts table with the help of the MySQL REPAIR TABLE command and everything *seems* to work again now. But it’s doing the thing again where it doesn’t save changes to already-published posts, which has never happened before. I’ll try a restart tomorrow (after some sleep).

    Sorry for spamming your blog, I hope this counts as (welcome) bug-reporting.
21. essdsm says:

    1/17/2005 at 1:47 pm

    Nice mod but it’s a bit too rigorous since it displays private, drafts etc I would rather it didn’t. Can you provide and example of how to limit the search to published posts only?

    Many thanks
22. Mark says:

    1/19/2005 at 11:43 am

    Replace line 108 in search.php with the following line. Make sure there are no line breaks, all of this goes on one line.

    
$sql = "SELECT ID,post_title,post_content,post_excerpt,post_date, MATCH(post_title,post_content) AGAINST ('".$_GET['q']."') AS score FROM ".$table_prefix."posts WHERE MATCH (post_title,post_content) AGAINST ('".$_GET['q']."') WHERE post_status= 'publish' LIMIT ".$_GET['next_value'].",".(intval($_GET['next_value'])+$max_results+1);
23. Mark says:

    1/19/2005 at 11:47 am

    For the most part any input is really welcome, so no problem. I hope you got your issue fixed.
24. James (1 comments.) says:

    2/1/2005 at 7:04 am

    I wonder why no one knows about WHY THE TABLES CRACH AND WHY THIS ERRNO: 145 COMES UP. We all have been discussing the remedy for the identified problem… we we still don’t know WHAT ACTUALLY BREAKS THESE TABLES TO CAUSE THIS ERRNO 145!

    I’m facing this problem damn frequently…. and so I want to indentify the root cause of this problem…. please anyone let me know if you know….

    Thanks in Advance.
25. Mark says:

    2/1/2005 at 8:52 am

    James,
    this probably comes from a corrupted Mysql table and the only answer I have for you is to backup before you install any upgrade/plugin that modifies your tables. In the meantime, http://www.karakas-online.de/f......php?t=332 might help.
26. Eve says:

    2/6/2005 at 5:49 pm

    This is a great improvement over WP’s default search — thank you!

    One question. How do I get the results to sort by date as opposed to relevance?
27. Mark says:

    2/6/2005 at 6:25 pm

    It looks really strange on sort by date, but if thats what you want do the following:
    Line 103 in search.php, add the following:
    $sql .= ' ORDER BY post_date ASC ';

    Replace line 108 with the following:
    
$sql = "SELECT ID,post_title,post_content,post_excerpt,post_date, MATCH(post_title,post_content) AGAINST ('".$_GET['q']."') AS score FROM ".$table_prefix."posts WHERE MATCH (post_title,post_content) AGAINST ('".$_GET['q']."') ORDER BY post_date DESC LIMIT ".$_GET['next_value'].",".(intval($_GET['next_value'])+$max_results+1);


    Now this is considering you want the date sorted descending, if not replace DESC above with ASC.
28. Eve says:

    2/6/2005 at 10:49 pm

    Thank you very much. I am not sure why it “looks really strange” but it works well for our site (a political blog where we want the latest “news” on a given subject available first, or at least make it easier to find older posts).
29. David Merwin (2 comments.) says:

    2/23/2005 at 5:29 pm

    I have updated the search plugin to work with 1.5 of wordpress. Could I send it to you and have you announce it?

    you can email me at the above.
30. Randyd says:

    3/2/2005 at 1:17 pm

    Hi:

    I’ve just installed your search script using my own style sheet. Doesn’t see anything with my mod rewrite rules of %postname%. When I go back to the default permalink structure on a WP 1.2.2 it works just fine.
    Any ideas?

    Thanks
    RD
31. Sumit says:

    4/20/2005 at 3:50 pm

    Does anybody know how I can adjust the code so that it will also search through the category titles? Can’t seem to find any plugin that can do this…
32. Eniko says:

    4/26/2005 at 8:42 am

    I tryed to run the search_upgrade.php after copying bith scripts to the root of my blog an it gaves me the following error: No Database Selected. What should I do?

    Thanks!
33. Bhoffmann (1 comments.) says:

    9/1/2005 at 5:39 am

    I got the same error.
34. Joakim says:

    11/16/2008 at 5:38 pm

    Is it possible to change the URL structure?
    I prefer “http://www.example.com/search/?q=the+keyword” and have a search page under /search/ without any query to link to if I want someone to search.

    I would be very happy if it was possible to translate /search/ to /sok/ (Swedish) in the URL above.

    Thanks for a great “plugin”!

Trackbacks/Pingbacks

1. Mind of Mog » Found It says:

   6/7/2004 at 7:31 pm

   […] for providing the start to my skinning. Thanks to Mark fir the link.I was testing his new search function for WordPress naturally when I fou […]
2. Second Negative | And…We’re Back | Disinformation, Spread Liberally says:

   8/23/2004 at 8:58 pm

   […] lts in list format with title and blurb, based on a tutorial at noscope, and code from the Weblog Tools Collection. The search feature can b […]
3. Ajay - On the Road of Life! » 2004 » December » 25 says:

   12/25/2004 at 4:31 pm

   […] — Ajay @ 9:56 pm Been adding a few plugins to WordPress. Just installed the Advanced Contextual Search for WordPre […]
4. Blogging Pro - Blog News, Tools and Hacks says:

   6/7/2004 at 11:02 am

   WordPress Hack: Advanced Contextual Search
   Weblog Tools Collection has an advanced contextual search hack which provides an intelligent search engine for your WP weblog. This hack features text based “fuzzy” searches within WordPress, a nice Google like interface which is very customizable,…
5. Ajay - On the Road called Life! » Blog Archive » Pluggin’ WordPress says:

   3/12/2005 at 7:49 am

   […] 7; WordPress Been adding a few plugins to WordPress. Just installed the Advanced Contextual Search for Wor […]
6. noscope | Providing a separate page of Search Results with Wordpress says:

   4/20/2005 at 3:55 am

   […] ou wish to further improve your search page, you may want to look through the following. * Advanced Contextual search for WordPress * 404 Sea […]
7. Weblog Tools Collection » Advanced Contextual search for WordPress says:

   6/10/2007 at 5:34 pm

   […] http://weblogtoolscollection.c.....wordpress/ Tags: wordpress, plugin, blog, search(del.icio.us history) […]