Re: [Wikitech-l] Search problem - Polish Wikipedia

On Mon, Mar 10, 2003 at 09:40:10PM +0100, Krzysztof P. Jasiutowicz wrote:

Hello all,

I have come across this error during this complex search "Historia not informatyki"

Wyst?pi? b??d sk?adni w zapytaniu do bazy danych. Mog?o to by? spowodowane przez z?e sformu?owanie zapytania (zobacz Przeszukiwanie Wikipedii) albo przez b??d w oprogramowaniu. Ostatnie, nieudane zapytanie to:

 SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchindex
 WHERE cur_id=si_page AND ( (MATCH (si_title) AGAINST ('historia'))
 NOT (MATCH (si_title) AGAINST ('informatyki')) ) AND
 (cur_namespace=0) LIMIT 0, 20

wys?ane przez funkcj? "SearchEngine::showResults". MySQL zg?osi? b??d "1064: You have an error in your SQL syntax near '(MATCH (si_title) AGAINST ('informatyki')) ) AND (cur_namespace=0) LIMIT 0, 20' at line 1". "Historia and Polski" seems to work OK.

Can you fix it ?

Is this really a bug?

"Historia and not informatyki" should work.

Regards,

jeluf