Bug #10706
closedPostgreSQL error when searching
Description
Typing "now is the time for all good men to come to the aid of their party in the search box resulted in this ActiveRecord/PG error:
"#<ActiveRecord::StatementInvalid: PG::SyntaxError: ERROR: syntax error in tsquery: "now & is & the & time & for & all & good & men & to & come & to & the & :*"↵: SELECT "groups".* FROM "groups" WHERE "groups"."group_class" = 'project' AND ((to_tsvector('english', ' ' || coalesce(uuid,'') || ' ' || coalesce(owner_uuid,'') || ' ' || coalesce(modified_by_client_uuid,'') || ' ' || coalesce(modified_by_user_uuid,'') || ' ' || coalesce(name,'') || ' ' || coalesce(description,'') || ' ' || coalesce(group_class,'')) @@ to_tsquery('now & is & the & time & for & all & good & men & to & come & to & the & :*'))) ORDER BY groups.modified_at desc LIMIT 200 OFFSET 0>"