#413 - Ticket Search By Owner Breaks
Type Defect
Status Fixed
Milestone 3.5
Version 3.4.3
Component -
Priority High
Severity Major
Assigned to Jack
Reported 8 years ago
Updated 8 years ago
Votes 0
Related tickets
Proposed time
Worked time

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

8 years and 5 months ago by Jack

  • Severity Normal Major
  • Priority Normal High
  • Status New Accepted
  • Assigned to Jack
Jack closed as Fixed 8 years and 4 months ago