When creating a new Agent if you click on the Audit Tab there is a PHP Warning:
Also the following database error are email over when the new agent button is pressed:
[SELECT count(*) FROM osti_audit audit WHERE audit.staff_id= AND event_id !=10]
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND event_id !=10' at line 1<br />
<br />
---- Backtrace ----<br />
#0 (root)/include/mysqli.php(200): osTicket->logDBError('DB Error #1064', '[SELECT count(...')<br />
#1 (root)/include/mysqli.php(212): 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:///home/eu...')<br />
#5 (root)/include/class.signal.php(98): AuditPlugin->{closure}(Object(Staff), Object(ArrayObject))<br />
#6 (root)/include/staff/staff.inc.php(449): Signal::send('agent.audit', Object(Staff), Object(ArrayObject))<br />
#7 (root)/scp/staff.php(190): require('/home/europein/...')<br />
#8 {main}
[SELECT audit.* FROM osti_audit audit WHERE audit.staff_id= AND event_id !=10 ORDER BY audit.timestamp DESC LIMIT 0,50]
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND event_id !=10 ORDER BY audit.timestamp DESC LIMIT 0,50' at line 1<br />
<br />
---- Backtrace ----<br />
#0 (root)/include/mysqli.php(200): osTicket->logDBError('DB Error #1064', '[SELECT audit....')<br />
#1 phar://(root)/include/plugins/audit.phar/class.audit.php(513): db_query('SELECT audit. ...')<br />
#2 phar://(root)/include/plugins/audit.phar/templates/agent-audit.tmpl.php(6): AuditEntry::getTableInfo(Object(Staff))<br />
#3 phar://(root)/include/plugins/audit.phar/audit.php(64): include('phar:///home/eu...')<br />
#4 (root)/include/class.signal.php(98): AuditPlugin->{closure}(Object(Staff), Object(ArrayObject))<br />
#5 (root)/include/staff/staff.inc.php(449): Signal::send('agent.audit', Object(Staff), Object(ArrayObject))<br />
#6 (root)/scp/staff.php(190): require('/home/europein/...')<br />
#7 {main}
[SELECT count(*) FROM osti_audit audit WHERE audit.staff_id= AND event_id !=10]
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND event_id !=10' at line 1<br />
<br />
---- Backtrace ----<br />
#0 (root)/include/mysqli.php(200): osTicket->logDBError('DB Error #1064', '[SELECT count(...')<br />
#1 (root)/include/mysqli.php(212): 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/class.audit.php(511): AuditEntry::getPageNav(' WHERE audit.st...')<br />
#4 phar://(root)/include/plugins/audit.phar/templates/agent-audit.tmpl.php(6): AuditEntry::getTableInfo(Object(Staff))<br />
#5 phar://(root)/include/plugins/audit.phar/audit.php(64): include('phar:///home/eu...')<br />
#6 (root)/include/class.signal.php(98): AuditPlugin->{closure}(Object(Staff), Object(ArrayObject))<br />
#7 (root)/include/staff/staff.inc.php(449): Signal::send('agent.audit', Object(Staff), Object(ArrayObject))<br />
#8 (root)/scp/staff.php(190): require('/home/europein/...')<br />
#9 {main}