[wp-testers] 2.1-alpha3 search bug

oaso oooaso at gmail.com
Mon Dec 11 03:17:07 GMT 2006

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

During my further test I found if I add an English letter before the Chinese 
word it would not give this warning but the search result is for the english 
letter/word, which has nothing to do with my Chinese keyword.

You may take a look at my site if you can take Chinese :)



More information about the wp-testers mailing list