Hello,
After try to adding news custom fiel, i have DB Error #1054 and now i can't see any ticket with any queues !
[SELECT A1.number AS number, A1.ticket_id AS ticket_id, A1.source AS source, A1.lastupdate AS lastupdate, B4.subject AS cdata__subject, A1.isoverdue AS isoverdue, B6.name AS user__name, B7.name AS user__org__name, B6.org_id AS user__org_id, B4.priority AS cdata__priority, B8.firstname AS staff__firstname, B8.lastname AS staff__lastname, C0.name AS team__name, A1.team_id AS team_id, (SELECT COUNT(R0.id) AS count FROM ost_thread Q7 JOIN ost_ticket Q8 ON (Q7.object_type = 'T' AND Q7.object_id = Q8.ticket_id) LEFT JOIN ost_thread_event R0 ON (Q7.id = R0.thread_id) WHERE Q8.ticket_id = A1.ticket_id AND R0.annulled = 0 AND R0.event_id = 3) AS _reopen_count, B4.priority REGEXP '\"?4(\"|,|$)' AS wD6Rq8G, A1.isanswered = '0' AS 2GkBZxz, (SELECT COUNT(R0.id) AS count FROM ost_thread Q7 JOIN ost_ticket Q8 ON (Q7.object_type = 'T' AND Q7.object_id = Q8.ticket_id) LEFT JOIN ost_thread_entry R0 ON (Q7.id = R0.thread_id) WHERE Q8.ticket_id = A1.ticket_id AND NOT R0.flags & 4 != 0) AS _thread_count, (SELECT COUNT(R1.id) AS count FROM ost_thread Q7 JOIN ost_ticket Q8 ON (Q7.object_type = 'T' AND Q7.object_id = Q8.ticket_id) LEFT JOIN ost_thread_entry R0 ON (Q7.id = R0.thread_id) LEFT JOIN ost_attachment R1 ON (R1.type = 'H' AND R0.id = R1.object_id) WHERE Q8.ticket_id = A1.ticket_id AND R1.inline = 0) AS _att_count, C1.expire > NOW() AND NOT C1.staff_id = 8 AS _locked, (SELECT COUNT(R0.id) AS count FROM ost_thread Q7 JOIN ost_ticket Q8 ON (Q7.object_type = 'T' AND Q7.object_id = Q8.ticket_id) LEFT JOIN ost_thread_collaborator R0 ON (Q7.id = R0.thread_id) WHERE Q8.ticket_id = A1.ticket_id) AS _collabs, COALESCE(B8.firstname, B8.lastname, C0.name, 'zzz') AS assignee FROM ost_ticket A1 JOIN ost_ticket_status A2 ON (A1.status_id = A2.id) LEFT JOIN ost_thread A3 ON (A3.object_type = 'T' AND A1.ticket_id = A3.object_id) LEFT JOIN ost_thread_referral A4 ON (A3.id = A4.thread_id) LEFT JOIN ost_staff A5 ON (A4.object_type = 'S' AND A4.object_id = A5.staff_id) LEFT JOIN ost_thread A6 ON (A1.ticket_id = A6.object_id AND A6.object_type = 'C') LEFT JOIN ost_thread_referral A7 ON (A6.id = A7.thread_id) LEFT JOIN ost_staff A8 ON (A7.object_type = 'S' AND A7.object_id = A8.staff_id) LEFT JOIN ost_team B0 ON (A4.object_type = 'E' AND A4.object_id = B0.team_id) LEFT JOIN ost_team B1 ON (A7.object_type = 'E' AND A7.object_id = B1.team_id) LEFT JOIN ost_department B2 ON (A4.object_type = 'D' AND A4.object_id = B2.id) LEFT JOIN ost_department B3 ON (A7.object_type = 'D' AND A7.object_id = B3.id) LEFT JOIN ost_ticket__cdata B4 ON (A1.ticket_id = B4.ticket_id) LEFT JOIN ost_ticket_priority B5 ON (B4.priority = B5.priority_id) LEFT JOIN ost_user B6 ON (A1.user_id = B6.id) LEFT JOIN ost_organization B7 ON (B6.org_id = B7.id) LEFT JOIN ost_staff B8 ON (A1.staff_id = B8.staff_id) LEFT JOIN ost_team C0 ON (A1.team_id = C0.team_id) LEFT JOIN ost_lock C1 ON (A1.lock_id = C1.lock_id) WHERE A2.state = 'open' AND ((A2.state = 'open' AND (A1.staff_id = 8 OR A5.staff_id = 8 OR A6.object_type = 'C' AND A8.staff_id = 8 OR A1.team_id IN (1) OR B0.team_id IN (1) OR A6.object_type = 'C' AND B1.team_id IN (1))) OR A1.dept_id IN (1) OR B2.id IN (1) OR A6.object_type = 'C' AND B3.id IN (1)) AND (A1.ticket_pid IS NULL OR A1.flags & 8 != 0) GROUP BY A1.ticket_id ORDER BY B5.priority_urgency ASC, A1.lastupdate DESC LIMIT 25]
Unknown column 'B4.subject' in 'field list'<br /> <br />
---- Backtrace ----<br />
#0 (root)/include/mysqli.php(207): osTicket->logDBError()<br />
#1 (root)/include/class.orm.php(3482): db_query()<br />
#2 (root)/include/class.orm.php(3529): MySqlExecutor->execute()<br />
#3 (root)/include/class.orm.php(2104): MySqlExecutor->getArray()<br />
#4 (root)/include/class.orm.php(2054): HashArrayIterator->{closure}()<br />
#5 (root)/include/class.orm.php(2033): CallbackSimpleIterator->next()<br />
#6 (root)/include/class.orm.php(2042): CallbackSimpleIterator->rewind()<br />
#7 (root)/include/class.orm.php(1713): CallbackSimpleIterator->valid()<br />
#8 (root)/include/class.orm.php(1723): CachedResultSet->fillTo()<br />
#9 (root)/include/class.orm.php(1739): CachedResultSet->asArray()<br />
#10 (root)/include/staff/templates/queue-tickets.tmpl.php(258): CachedResultSet->getIterator()<br />
#11 (root)/scp/tickets.php(569): require_once('...')<br />
#12 (root)/scp/index.php(17): require('...')<br />
#13 {main}
