Search Error

Morj · Very bored Joined: 29 Jul 2008 Posts: 211

Hm, so I think the search function does not like non-letter or number characters. A search for "Blood+" gets me the following error:

[quote]Warning: pg_query() [function.pg-query]: Query failed: ERROR: no operand in tsearch query: "blood&" in /usr/home/sites/www.fanart-central.net/www/search.php on line 307

Database Error: ERROR: no operand in tsearch query: "blood&"

#0 dbError() called at [/usr/home/sites/www.fanart-central.net/www/search.php:307]
[/quote]

>.< I broked it.
_________________
[i]Hint: everything moves.[/i]
[i]Believe me, If I started murdering people, there'd be none of you left...[/i] ~Charles Manson
[i][url=http://www.youtube.com/watch?v=G6D1YI-41ao]Моё судно на воздушной подушке полно угрей[/url][/i]
[i]"fish" could be spelled "ghoti" - that's "gh" as in "tough" "o" as in "women" and "ti" as in "nation"[/i]

cstdenis · Posted: Sun Aug 31, 2008 12:39 am Post subject:

The + symbol has special meaning in the search system. You can't search for it.

Same with &, |, and -
_________________
You will obey or molten silver will be poured into your ears.

Stratadrake · Posted: Sun Aug 31, 2008 4:10 am Post subject:

Is it possible to escape those characters?
_________________
Strata here: [url=http://www.nanowrimo.org/eng/user/242293]Nanowrimo[/url] - [url=www.fanart-central.net/user-Stratadrake.php]FAC[/url] - [url=http://stratadrake.deviantart.com]dA[/url] - [url=www.furaffinity.net/user/Stratadrake/]FA[/url]
[size=9]Disclaimer: Posts may contain URLs. Click [url=http://tvtropes.org/pmwiki/pmwiki.php/Main/TVTropesWillRuinYourLife]at your own risk.[/url][/size]

Sora121 · Posted: Sun Aug 31, 2008 9:31 am Post subject:

With the symbols use, we could do checking for a word or letter after the +/_ symbol. If there is nothing after the symbol then we should just escape it and allow it as part of the query.

Stratadrake · Posted: Sun Aug 31, 2008 4:55 pm Post subject:

But the search module doesn't work that way (strips special characters by default).

The only way to search for special characters would be with exact-phrase searching, which is not implemented yet.
_________________
Strata here: [url=http://www.nanowrimo.org/eng/user/242293]Nanowrimo[/url] - [url=www.fanart-central.net/user-Stratadrake.php]FAC[/url] - [url=http://stratadrake.deviantart.com]dA[/url] - [url=www.furaffinity.net/user/Stratadrake/]FA[/url]
[size=9]Disclaimer: Posts may contain URLs. Click [url=http://tvtropes.org/pmwiki/pmwiki.php/Main/TVTropesWillRuinYourLife]at your own risk.[/url][/size]