Project

General

Profile

Actions
Copy link

Defect #14967

closed

Search Issues PGSqlError when select multiple ids

Added by Andrey Viktorov over 12 years ago. Updated about 12 years ago.

Status:
Closed
Priority:
High
Assignee:
-
Category:
Issues
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:
Affected version:
1.1.3

Description

Help me please:

Processing IssuesController#index () [POST]
Parameters: {"controller"=>"issues", "values"=>{"priority_id"=>["3"], "status_id"=>["1,9,10"], "due_date"=>[""], "created_on"=>[""], "tracker_id"=>["5"], "do
Query::StatementInvalid: PGError: ERROR: invalid input syntax for integer: "1,9,10"
LINE 1: ... "issues".project_id WHERE ((issues.status_id IN ('1,9,10'))...
^
: SELECT count(DISTINCT "issues".id) AS count_all FROM "issues" LEFT OUTER JOIN "issue_statuses" ON "issue_statuses".id = "issues".status_id LEFT OUTER JOIN

Actions
Copy link

Also available in: Atom PDF