Bug #302
closedIssuelogger dropdown issues
Description
Started GET "/wktime/get_issue_loggers?autocomplete=true&q=15" for 127.0.0.1 at 2021-03-24 18:15:38 +0530
Processing by WktimeController#get_issue_loggers as /
Parameters: {"autocomplete"=>"true", "q"=>"15"}
Current user: dhanasingh (id=5)
Completed 500 Internal Server Error in 8ms (ActiveRecord: 4.4ms)
ActiveRecord::StatementInvalid (PG::SyntaxError: ERROR: syntax error at or near "OR"
LINE 1: ...es.closed_on >= NULL) and (issues.assigned_to_id= OR issues....
^
: SELECT "issues"."id" AS t0_r0, "issues"."tracker_id" AS t0_r1, "issues"."project_id" AS t0_r2, "issues"."subject" AS t0_r3, "issues"."description" AS t0_r4, "issues"."due_date" AS t0_r5, "issues"."category_id" AS t0_r6, "issues"."status_id" AS t0_r7, "issues"."assigned_to_id" AS t0_r8, "issues"."priority_id" AS t0_r9, "issues"."fixed_version_id" AS t0_r10, "issues"."author_id" AS t0_r11, "issues"."lock_version" AS t0_r12, "issues"."created_on" AS t0_r13, "issues"."updated_on" AS t0_r14, "issues"."start_date" AS t0_r15, "issues"."done_ratio" AS t0_r16, "issues"."estimated_hours" AS t0_r17, "issues"."parent_id" AS t0_r18, "issues"."root_id" AS t0_r19, "issues"."lft" AS t0_r20, "issues"."rgt" AS t0_r21, "issues"."is_private" AS t0_r22, "issues"."closed_on" AS t0_r23, "issue_statuses"."id" AS t1_r0, "issue_statuses"."name" AS t1_r1, "issue_statuses"."is_closed" AS t1_r2, "issue_statuses"."position" AS t1_r3, "issue_statuses"."default_done_ratio" AS t1_r4 FROM "issues" LEFT OUTER JOIN "issue_statuses" ON "issue_statuses"."id" = "issues"."status_id" WHERE (((issue_statuses.is_closed = FALSE OR issues.closed_on >= NULL) and (issues.assigned_to_id= OR issues.author_id=) ) ) AND (subject like '%15%' OR issues.id = 15) ORDER BY project_id):
plugins/redmine_wktime/app/controllers/wktime_controller.rb:547:in `getissues'
plugins/redmine_wktime/app/controllers/wktime_controller.rb:574:in `get_issue_loggers'
lib/redmine/sudo_mode.rb:65:in `sudo_mode'
Updated by Arun T over 3 years ago
- Status changed from New to Closed
- % Done changed from 0 to 100
Completed