DISQUS

Jacob è un cylon.

No wait. I was wrong. It seems to work.

Well, not exactly like that, it returns a fatal error, but something similar. Have you got it, haven't you? :-)

I was meaning something slightly different. It is true we can't know if the user is searching for hello world precisely or hello AND world.
What I suggest is not hacking the search adding the minus between words, that would change the meaning of the search, but hacking the search tag results, removing the minus between the words.
I've made quite an unhappy example with hello world. But think about new york times. Let's say I've written a post without new york times in the body, maybe a one line one, but I want to explicit it in the tags. A search for new york times wouldn't return that post.
A php friend of mine have suggested an home solution for this and it seems quite simple indeed.
It should be something about changing
$where .= " OR ( tter.slug LIKE '%" . $wpdb->escape($wp_query->query_vars['s']) . "%') ";
in the search tag function with
$where .= " OR ( tter.slug LIKE '%" . str_replace(' ', '-',$wpdb->escape($wp_query->query_vars['s'])) . "%') ";
What about this?

Hi Dan,
got a question about the tag searching. There is a problem when searching a multiple words tag, let's say "hello world": if you search hello world straight you won't find that tag, because it's stored as "hello-world" in the db. Can you work around it in a future release?
Thanks. :-)

Too Good To Be True...

Some metadata, as UTW Tags, are stored in a peculiar way: while no problem with single words, "usa" is stored as "usa", phrases, eg. "united states of america", are stored as "united-states-of-america".

So if I search "united states of america" I don't get the result and really I can't hope my users to search "united-states-of-america" (by the way: if they even would do this they wouldn't get an eventual "united states of america" from post contents).

I don't think it's hard to work it around, it's a matter of converting spaces in minus signs in the query string in the single case of metadata search, but I'm a phpnewbie. Any ideas?

Hi everybody, I have succeded in correcting the error I had (Column ‘meta_value' in where clause is ambiguous). Maybe someone will find it useful: in the plugin's function SE2_search_metadata you simply should add wp_postmeta before .meta_value. So, at line 149:

$where .= " OR wp_postmeta.meta_value [...]

I have the same problem as Maria:

WordPress database error: [Column ‘meta_value' in where clause is ambiguous]
SELECT DISTINCT * FROM wp_posts LEFT JOIN wp_postmeta AS miniposts_meta ON (wp_posts.ID = miniposts_meta.post_id)LEFT JOIN wp_postmeta ON wp_posts.ID = wp_postmeta.post_id WHERE 1=1 AND (((post_title LIKE '%diario%') OR (post_content LIKE '%diario%')) OR (post_title LIKE '%diario%') OR (post_content LIKE '%diario%')) AND post_date_gmt