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