if I enter "š" in search field, I get some strange warnings

Bug #398936 reported by Jurgis Pralgauskis
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
ideatorrent
New
Undecided
Unassigned

Bug Description

You can see the effect
http://ideatorrent.org/ideatorrent?keywords=%C5%A1&tags=

    * warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error in tsquery: "š" in /var/www/includes/database.pgsql.inc on line 139.
    * user warning: query: SELECT qapoll_choice.id, qapoll_choice.title, qapoll_choice.bugid, qapoll_choice.specid, qapoll_choice.forumid, qapoll_choice.userid as userid, qapoll_choice.date, qapoll_choice.status, qapoll_choice.description, qapoll_choice.duplicatenumber, qapoll_choice.totalapprovalvotes, qapoll_choice.whiteboard, qapoll_choice.release_target, qapoll_choice.categoryid, qapoll_choice.relation_id, qapoll_choice.relation_subcategory_id, qapoll_poll_category.name as catname, qapoll_poll_relation.name as relation_name, qapoll_poll_relation.url_name as relation_url_name, qapoll_poll_relation_subcategory.name as relationsubcatname, users.name as username, qapoll_choice.totalvotes as votes, qapoll_choice.ideavotes as ideavotes,qapoll_choice.relation_id as relation_id, qapoll_choice.commentscount, qapoll_choice.last_status_change, qapoll_choice.last_comment_date, qapoll_choice.last_edit_date FROM to_tsquery('š') as keywordsquery, qapoll_choice LEFT JOIN users ON users.uid = qapoll_choice.userid LEFT JOIN qapoll_poll_category ON qapoll_choice.categoryid = qapoll_poll_category.id LEFT JOIN qapoll_poll_relation ON qapoll_choice.relation_id = qapoll_poll_relation.id LEFT JOIN qapoll_poll_relation_subcategory ON qapoll_choice.relation_subcategory_id = qapoll_poll_relation_subcategory.id WHERE qapoll_choice.pollid='1' AND totalsearchable_index_col @@ keywordsquery AND qapoll_choice.status != '-2' AND qapoll_choice.status != 2 AND qapoll_choice.status != 3 AND qapoll_choice.status != 5 AND qapoll_choice.status != 4 AND qapoll_choice.status != 7 AND qapoll_choice.status != 8 AND qapoll_choice.choicetype != 0 AND ( ( qapoll_choice.bugid IS NOT NULL OR qapoll_choice.specid IS NOT NULL OR qapoll_choice.forumid IS NOT NULL ) OR (qapoll_choice.bugid IS NULL AND qapoll_choice.specid IS NULL AND qapoll_choice.forumid IS NULL ) ) AND qapoll_choice.duplicatenumber = '-1' ORDER BY votes DESC LIMIT 20 OFFSET 0 in /var/branches/release-0.9-drupal6/modules/ideatorrent/ideatorrent.function.php on line 38.
    * warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error in tsquery: "š" in /var/www/includes/database.pgsql.inc on line 139.
    * user warning: query: SELECT COUNT(*) FROM to_tsquery('š') as keywordsquery, qapoll_choice WHERE qapoll_choice.pollid='1' AND totalsearchable_index_col @@ keywordsquery AND qapoll_choice.status != '-2' AND qapoll_choice.status != 2 AND qapoll_choice.status != 3 AND qapoll_choice.status != 5 AND qapoll_choice.status != 4 AND qapoll_choice.status != 7 AND qapoll_choice.status != 8 AND qapoll_choice.choicetype != 0 AND ( ( qapoll_choice.bugid IS NOT NULL OR qapoll_choice.specid IS NOT NULL OR qapoll_choice.forumid IS NOT NULL ) OR (qapoll_choice.bugid IS NULL AND qapoll_choice.specid IS NULL AND qapoll_choice.forumid IS NULL ) ) AND qapoll_choice.duplicatenumber = '-1' in /var/branches/release-0.9-drupal6/modules/ideatorrent/ideatorrent.function.php on line 38.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.