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.

    XMLWordPrintable

Details

    • Incident report
    • Status: Closed
    • Trivial
    • Resolution: Fixed
    • 2.2.14, 3.0.4, 3.2.0beta1
    • 2.2.15rc1, 3.0.5rc1, 3.2.0rc1
    • API (A)

    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

            Unassigned Unassigned
            dlamberts Dmitrijs Lamberts
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: