-
Incident report
-
Resolution: Fixed
-
Critical
-
2.0.16, 2.2.11, 2.4.7, 3.0.0alpha5
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