ACCORD5/TrellisDesk — Issue #54: Database error when "marking all tickets as read"
Author: darbin
Created: 2011-11-10 07:12:48+00:00
State: open

I have a usergroup with admin access to different departments. In few of them this usergroup have only viewer access, in others also a editor access (I don't think this matter, just giving information just in case). When user from this group clicking on "Mark all tickets as read" (/admin.php?section=manage&page=tickets&act=dotrackall) he getting error:

TD Fatal Error: MySQL - Unable to process query:
SELECT t.`id`, tt.`date` AS `track_date` FROM `td_tickets` t LEFT JOIN `td_tickets_track` tt ON ( tt.`tid` = t.`id` ) WHERE t.`did` IN ( '2', '3', '4', '5', '6', '7', '1' ) OR a.`uid` = '10'
The following error was returned:
1054: Unknown column 'a.uid' in 'where clause' in /includes/classes/class_mysql.php on line 79

Under admin I able to mark all tickets as read without database error.