Ticket Search By Owner Breaks

413
Defect
Jack
3.5
3.4.3
-
Fixed
High
Major
3 years ago
3 years ago
0

Description

What did you do to cause this?

Tried to search for all tickets by Owner where the name provided does not match an existing username.

What page were you on?

Tickets page on Traq.io

What PHP and MariaDB versions do you run?

Traq.io main site

Describe the defect:

If you perform a search by Owner but the search does not match an existing user, rather than getting an empty list back, you get a SQL error:

Database Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY `traq_tickets`.`priority_id` ASC' at line 1
SELECT * FROM `traq_tickets` WHERE `project_id` = 1 AND `user_id` IN () ORDER BY `traq_tickets`.`priority_id` ASC
Powered by Avalon

Ticket History

3 years and 6 months ago by Jack

  • Changed Severity from Normal to Major
  • Changed Priority from Normal to High
  • Changed Status from New to Accepted
  • Assigned ticket to Jack

3 years and 6 months ago by Jack

  • Closed ticket as Fixed