@ntozier yes, Help Desk Audit means Audit Log plugin

I searched GitHub first but I didn't find an adequate answer, so I ask here.

Bump
Nothing?
I am not alone: https://forum.osticket.com/d/97244-unknown-column-a1-attachment-count-in-where-clause

Hi Kevin. Great, many thanks.

Unfortunately, I found that the error was not corrected completely. Previously, I received an error message at least 50 times a day. Since repair approximately 10x.
According to LOG, this is not the same error.

[SELECT A1.number AS number, A1.ticket_id AS ticket_id, A1.source AS source, A1.ticket_pid AS ticket_pid, A1.flags AS flags, A1.lastupdate AS lastupdate, B2.subject AS cdata__subject, A1.isoverdue AS isoverdue, B3.name AS user__name, B2.priority AS cdata__priority, B4.firstname AS staff__firstname, B4.lastname AS staff__lastname, B5.name AS team__name, A1.team_id AS team_id, attachment_count = 0 AS R5b71xp, 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, B6.expire > NOW() AND NOT B6.staff_id = 109 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(B4.lastname, B4.firstname, B5.name, 'zzz') AS assignee, (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 collaborator_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 attachment_count, (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(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 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_department B0 ON (A4.object_type = 'D' AND A4.object_id = B0.id) LEFT JOIN ost_department B1 ON (A7.object_type = 'D' AND A7.object_id = B1.id) LEFT JOIN ost_ticket__cdata B2 ON (A1.ticket_id = B2.ticket_id) JOIN ost_user B3 ON (A1.user_id = B3.id) LEFT JOIN ost_staff B4 ON (A1.staff_id = B4.staff_id) LEFT JOIN ost_team B5 ON (A1.team_id = B5.team_id) LEFT JOIN ost_lock B6 ON (A1.lock_id = B6.lock_id) WHERE A2.state = 'open' AND A2.state = 'open' AND A1.isanswered = '0' AND ((A2.state = 'open' AND (A1.staff_id = 109 OR A5.staff_id = 109 OR A6.object_type = 'C' AND A8.staff_id = 109)) OR A1.dept_id IN (13) OR B0.id IN (13) OR A6.object_type = 'C' AND B1.id IN (13)) AND A3.object_type = 'T' GROUP BY A1.ticket_id ORDER BY A1.created DESC LIMIT 50]

Champ 'attachment_count' inconnu dans field list<br /> <br />
---- Vzetí zpět ----<br />
#0 C:\wamp\www\cis-ticket\include\mysqli.php(200): osTicket->logDBError('DB Error #1054', '[SELECT A1.num...')<br />
#1 C:\wamp\www\cis-ticket\include\class.orm.php(3482): db_query('SELECT A1.numb...', true, true)<br />
#2 C:\wamp\www\cis-ticket\include\class.orm.php(3529): MySqlExecutor->execute()<br />
#3 C:\wamp\www\cis-ticket\include\class.orm.php(2093): MySqlExecutor->getArray()<br />
#4 C:\wamp\www\cis-ticket\include\class.orm.php(2043): HashArrayIterator->{closure}()<br />
#5 C:\wamp\www\cis-ticket\include\class.orm.php(2022): CallbackSimpleIterator->next()<br />
#6 C:\wamp\www\cis-ticket\include\class.orm.php(2031): CallbackSimpleIterator->rewind()<br />
#7 C:\wamp\www\cis-ticket\include\class.orm.php(1703): CallbackSimpleIterator->valid()<br />
#8 C:\wamp\www\cis-ticket\include\class.orm.php(1713): CachedResultSet->fillTo(9223372036854775807)<br />
#9 C:\wamp\www\cis-ticket\include\class.orm.php(1729): CachedResultSet->asArray()<br />
#10 C:\wamp\www\cis-ticket\include\staff\templates\queue-tickets.tmpl.php(263): CachedResultSet->getIterator()<br />
#11 C:\wamp\www\cis-ticket\scp\tickets.php(569): require_once('C:\wamp\www\cis...')<br />
#12 {main}

Form server log:

[03-Apr-2020 07:41:15 UTC] PHP Fatal error: Uncaught InconsistentModelException: Unable to prepare query: SELECT A1.number AS number, A1.ticket_id AS ticket_id, A1.source AS source, A1.ticket_pid AS ticket_pid, A1.flags AS flags, A1.lastupdate AS lastupdate, B2.subject AS cdata__subject, A1.isoverdue AS isoverdue, B3.name AS user__name, B2.priority AS cdata__priority, B4.firstname AS staff__firstname, B4.lastname AS staff__lastname, B5.name AS team__name, A1.team_id AS team_id, attachment_count = 0 AS R5b71xp, 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 R in C:\wamp\www\cis-ticket\include\class.orm.php on line 3483

Okay, I got it alone.
The problem was in the definition of the condition in one queue.
You can close this thread.