[wp-testers] 2.1-alpha3 search bug

[Rob Doar]

Rajan,  I think you responded to the wrong person.

Thanks!



On 12/14/06, Rajan Packiyathurai <rajanpack at gmail.com> wrote:
Where did you download this 2.1 beta?
>
> http://comox.textdrive.com/pipermail/wp-testers/
>
> /Rajan
>
> On 12/11/06, oaso <oooaso at gmail.com> 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
> >
> >
> > 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 :)
> >
> > Http://if20.net
> >
> > Feir
> >
> >
> > _______________________________________________
> > wp-testers mailing list
> > wp-testers at lists.automattic.com
> > http://lists.automattic.com/mailman/listinfo/wp-testers
> >
> _______________________________________________
> wp-testers mailing list
> wp-testers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-testers
>