osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now
I've been seeing this error pop up up every so often, but not too often, I'm running osTicket 1.10 stable and would like to know if I can get help figuring out what causes it. Here is the log for the error:
[SELECT A3.`address` AS `user__default_email__address`, null AS number, COUNT(DISTINCT A1.`ticket_id`) AS `tickets` FROM `ost_ticket` A1 JOIN `ost_user` A2 ON (A1.`user_id` = A2.`id`) LEFT JOIN `ost_user_email` A3 ON (A2.`default_email_id` = A3.`id`) WHERE (A1.`staff_id` = 11 OR A1.`team_id` IN (SELECT A1.`team_id` FROM `ost_team_member` A1 WHERE A1.`staff_id` = 11) OR A1.`dept_id` IN ('24', '21', '4', '22', '18', '11', '20', '19', '23', '26')) GROUP BY A3.`address` ORDER BY __relevance__ DESC LIMIT 25]
Unknown column '__relevance__' in 'order clause'