[wp-testers] 2.1-alpha3 search bug
Ryan Boren
ryan at boren.nu
Mon Dec 11 08:05:29 GMT 2006
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
More information about the wp-testers
mailing list