Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-10232

SQL errors with invalid parameter "year" in report3.php

XMLWordPrintable

      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

            Unassigned Unassigned
            sasha Alexander Vladishev
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: