[wp-testers] 2.1-alpha3 search bug
oaso
oooaso at gmail.com
Mon Dec 11 08:42:22 GMT 2006
Yes, It is caused by the plugin named "Search Reloaded". Now my wordprss
search works well.
Thanks.
_________________________
Xiaofei GE
Http://if20.net
----- Original Message -----
From: "Ryan Boren" <ryan at boren.nu>
To: <wp-testers at lists.automattic.com>
Sent: Monday, December 11, 2006 4:05 PM
Subject: Re: [wp-testers] 2.1-alpha3 search bug
> oaso wrote:
>> I am now using WP 2.1 Alpha3 lastest SVN and I found it has some problems
>> when I did a search in my Chinese blog.
>>
>> I searched a chinese word and it returns as follow:
>>
>> WordPress database error: [Got error 'empty (sub)expression' from regexp]
>> SELECT DISTINCT posts.*, CASE WHEN posts.post_title REGEXP '' THEN 1 ELSE
>> 0 END AS keyword_in_title, MATCH ( posts.post_title, posts.post_content )
>> AGAINST ( '' ) AS mysql_score FROM wp_posts as posts LEFT JOIN
>> wp_postmeta as postmeta ON postmeta.post_id = posts.ID WHERE
>> posts.post_date_gmt <= '2006-12-11 02:47:00' AND ( posts.post_password =
>> '' ) AND ( ( post_status = 'publish' OR ( post_status = 'static' AND
>> postmeta.meta_value = 'article.php' ) ) ) AND ( posts.post_title REGEXP
>> '' OR posts.post_content REGEXP '' ) GROUP BY posts.ID ORDER BY
>> keyword_in_title DESC, mysql_score DESC, posts.post_date DESC LIMIT 0, 6
>
> WordPress doesn't do any queries that look like that. Perhaps that is
> from a plugin?
>
> Ryan
>
> _______________________________________________
> wp-testers mailing list
> wp-testers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-testers
More information about the wp-testers
mailing list