If we submit an idea that has "(" or ")" in it, the following warning is thrown (php 5.3.0)
Steps to simulate
Enter title containing "(" or ")" and click "Check for duplicates".
The warning below is thrown to the user. Can you suggest a solution/workaround for this?
warning: pg_query(): Query failed: ERROR: no operand in tsquery: "(" in D:\drupal-6.14\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_choice_approval_vote.value as myapprovalvote, (qapoll_choice_bookmark.date IS NOT NULL) as mybookmark, 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, ts_rank_cd(totalsearchable_index_col, keywordsquery, 32) as search_rank, 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_choice_approval_vote ON qapoll_choice_approval_vote.choiceid = qapoll_choice.id AND qapoll_choice_approval_vote.userid = 67 LEFT JOIN qapoll_choice_bookmark ON qapoll_choice_bookmark.choiceid = qapoll_choice.id AND qapoll_choice_bookmark.userid = 67 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.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 search_rank DESC LIMIT 10 OFFSET 0 in D:\drupal-6.14\modules\ideatorrent-0.9.1\ideatorrent\ideatorrent.function.php on line 38.
warning: pg_query(): Query failed: ERROR: no operand in tsquery: "(" in D:\drupal-6.14\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.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 D:\drupal-6.14\modules\ideatorrent-0.9.1\ideatorrent\ideatorrent.function.php on line 38.
