Bug #10706
closedPostgreSQL error when searching
0%
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>"