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

Missing space in api/services/CTrigger.php SQL query.

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Trivial
    • Resolution: Fixed
    • Affects Version/s: 2.2.14, 3.0.4, 3.2.0beta1
    • Fix Version/s: 2.2.15rc1, 3.0.5rc1, 3.2.0rc1
    • Component/s: API (A)
    • Labels:

      Description

      /frontends/php/include/classes/api/services/CTrigger.php

      'SELECT t.triggerid,t.description,t.expression'.
       ' FROM triggers t'.
       ' WHERE '.dbConditionInt('t.triggerid', $triggerIds).
       'AND t.templateid IS NOT NULL',
      

      Missing space before last AND.

      If the frontend is modified to use query without apostrophe symbols, this causes syntax error.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              dmitrijs.lamberts Dmitrijs Lamberts
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: