Project

General

Profile

Actions

Bug #10706

closed

PostgreSQL error when searching

Added by Tom Morris over 7 years ago. Updated almost 7 years ago.

Status:
Duplicate
Priority:
Normal
Assigned To:
-
Category:
-
Target version:
-
Story points:
-

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>"


Related issues

Is duplicate of Arvados - Bug #11278: Trailing space on string pasted into search box should not cause "Oops request failed"ResolvedRadhika Chippada03/16/2017Actions
Actions #1

Updated by Tom Morris almost 7 years ago

  • Status changed from New to Duplicate
Actions

Also available in: Atom PDF