[ZBX-2175] Cannot edit trigger for log item Created: 2010 Mar 16  Updated: 2017 May 30  Resolved: 2010 Mar 16

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: None
Affects Version/s: None
Fix Version/s: 1.8.2

Type: Incident report Priority: Major
Reporter: Alexey Pustovalov Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified


 Description   

SQL error [ORA-00933: SQL command not properly ended] in [SELECT DISTINCT f.functionid, f.function, f.parameter, t.expression, t.description, t.priority, t.comments, t.url, t.status, t.type FROM functions as f, triggers as t, items as i WHERE t.triggerid=217513 AND i.itemid=f.itemid AND f.triggerid = t.triggerid AND i.value_type IN (2 , 4, 1) AND i.key_ LIKE ('log[%')]

if i trying change trigger from popup menu.

 Comments   
Comment by richlv [ 2010 Mar 19 ]

seems to work fine with mysql, dev branch rev 10923.

Comment by Alexey Pustovalov [ 2010 Mar 19 ]

not working. other error:
item with key: log["/var/log/asterisk/messages.caller","res_agi.c",,5]
trigger with expression: ((

{TRIGGER.VALUE}=0)&(({Template_Asterisk_Caller:log["/var/log/asterisk/messages.caller","res_agi.c",,5].regexp(Failed)})#0))

popup URL:
https://domain/php/tr_logform.php?sform=1&itemid=573196&triggerid=217513&ltype=0&sid=efd8a1eeeee5887a

error in popup:
Incorrect trigger expression. [{TRIGGER.VALUE}

)&((regexp(Failed))]
Expression cannot be empty
An item key must be used in trigger expression

Comment by Alexey Fukalov [ 2010 Mar 22 ]

Initial problem with sql solved in branches/1.8 10955. Problem with trigger expression is different.

Could you please open new issue about expression preblem?

Generated at Thu Apr 25 02:47:10 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.