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

    Details

      Description

      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

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: