Looking for some help, when trying to add a new agent in 1.15.4 I get an email with a DB Error #1064 as follows:
[SELECT count(*) FROM ost_audit audit WHERE audit.staff_id=]
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1<br /> <br />
---- Backtrace ----<br />
#0 (root)/include/mysqli.php(201): osTicket->logDBError('DB Error #1064', '[SELECT count(...')<br />
#1 (root)/include/mysqli.php(213): db_query('SELECT count()...')<br />
#2 phar://(root)/include/plugins/audit.phar/class.audit.php(411): db_count('SELECT count(*)...')<br />
#3 phar://(root)/include/plugins/audit.phar/templates/agent-audit.tmpl.php(9): AuditEntry::getPageNav(' WHERE audit.st...')<br />
#4 phar://(root)/include/plugins/audit.phar/audit.php(64): include('phar:///var/www...')<br />
#5 (root)/include/class.signal.php(98): AuditPlugin->{closure}(Object(Staff), Object(ArrayObject))<br />
#6 (root)/include/staff/staff.inc.php(480): Signal::send('agent.audit', Object(Staff), Object(ArrayObject))<br />
#7 (root)/scp/staff.php(194): require('(root)/includ...')<br />
#8 {main}
Here is a copy of my OS Ticket Information:
