Looks like ost_ticket_priority is also using ispublic, hence the error.
we just want it to be used for department:
The following parts use ispublic:
$qselect = 'SELECT ticket.users_name,ticket.ticket_id,ticket.ticketID,ticket.dept_id,isanswered,ost_department.ispublic,subject,name,email '.
',dept_name,status, users_name,source,priority_id, priority_desc ,ticket.created ';
$qfrom=' FROM '.TICKET_TABLE.' ticket LEFT JOIN '.DEPT_TABLE.' dept ON ticket.dept_id=dept.dept_id ';
//Pagenation stuff....wish MYSQL could auto pagenate (something better than limit)
and here
<?
$class = "row1";
$total=0;
if($tickets_res && ($num=db_num_rows($tickets_res))):
$defaultDept=Dept:();
while ($row = db_fetch_array($tickets_res)) {
$dept=$row?$row:$defaultDept; //Don't show hidden/non-public depts.
$subject=Format:(Format:($row,40));
