[ZBX-11143] Missing space in api/services/CTrigger.php SQL query. Created: 2016 Aug 30  Updated: 2017 May 30  Resolved: 2016 Sep 07

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: API (A)
Affects Version/s: 2.2.14, 3.0.4, 3.2.0beta1
Fix Version/s: 2.2.15rc1, 3.0.5rc1, 3.2.0rc1

Type: Incident report Priority: Trivial
Reporter: Dmitrijs Lamberts Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: sql
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate

 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.

 Comments   
Comment by vitalijs.cemeris (Inactive) [ 2016 Sep 07 ]

(1) No translation strings changed.

sasha CLOSED

Comment by vitalijs.cemeris (Inactive) [ 2016 Sep 07 ]

Fixed in:

  • pre-2.2.15rc1 r62359
  • pre-3.0.5rc1 r62360
  • pre-3.2.0beta3 r62361
Generated at Sat Apr 20 00:49:12 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.