The standard empty query returns no results.
Looking at the database
SELECT DISTINCT callid FROM sip_trace WHERE status='' AND direction='in' ORDER BY id DESC;
gets
ERROR 3065 (HY000): Expression #1 of ORDER BY clause is not in SELECT list, references column 'opensips.sip_trace.id' which is not in SELECT list; this is incompatible with DISTINCT
I fixed it in opensips/web/tools/system/siptrace/template/tracer.main.php
where line 140 needed to change id to callid to match the postgres call below it,
The standard empty query returns no results.
Looking at the database
SELECT DISTINCT callid FROM sip_trace WHERE status='' AND direction='in' ORDER BY id DESC;
gets
ERROR 3065 (HY000): Expression #1 of ORDER BY clause is not in SELECT list, references column 'opensips.sip_trace.id' which is not in SELECT list; this is incompatible with DISTINCT
I fixed it in opensips/web/tools/system/siptrace/template/tracer.main.php
where line 140 needed to change id to callid to match the postgres call below it,