For example:
report3.php?serviceid=1&year=20161 produces SQL errors:
PostgreSQL:
pg_query(): Query failed: ERROR: syntax error at or near ")"
LINE 1: ...ROM service_alarms sa WHERE sa.serviceid='1' AND () ORDER BY...
^ [include/db.inc.php:440]
Error in query [SELECT * FROM service_alarms sa WHERE sa.serviceid='1' AND () ORDER BY sa.clock,sa.servicealarmid] [ERROR: syntax error at or near ")"
LINE 1: ...ROM service_alarms sa WHERE sa.serviceid='1' AND () ORDER BY...
^]
MySQL:
Error in query [SELECT * FROM service_alarms sa WHERE sa.serviceid='1' AND () ORDER BY sa.clock,sa.servicealarmid] [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 ') ORDER BY sa.clock,sa.servicealarmid' at line 1]
3.0.0alpha5 has a different link: zabbix.php?action=report.services&serviceid=1&year=20161