[ZBX-14670] Wrong column name in zabbix 4.0.0-1.1alpha9 Created: 2018 Aug 01  Updated: 2024 Apr 10  Resolved: 2018 Aug 01

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F), Server (S)
Affects Version/s: 4.0.0alpha9
Fix Version/s: 4.0.0beta1, 4.0 (plan)

Type: Problem report Priority: Blocker
Reporter: Minh Son Assignee: Vladislavs Sokurenko
Resolution: Fixed Votes: 0
Labels: lld
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

centos 7


Attachments: Text File image-2018-08-01-14-27-31-941.png     Text File image-2018-08-01-14-33-45-317.png     Text File image-2018-08-01-14-42-47-284.png    
Issue Links:
Causes
caused by ZBXNEXT-4569 "groups" (8.0.2) and "function" (8.0.... Closed
Team: Team A
Sprint: Sprint 39
Story Points: 0.125

 Description   

Steps to reproduce:

  1. Create a trigger using function : find string V in ... 
  2. The trigger will never be run because zabbix frontend can not update in database. The error output
     9146:20180801:141440.846 [Z3005] query failed: [1054] Unknown column 'function' in 'field list' [update triggers set expression='\{20010}=1' where triggerid=18300;
    update triggers set expression='\{44971}=1' where triggerid=41033;
    update functions set function='str',parameter='No' where functionid=20010;
    update functions set function='str',parameter='No' where functionid=44971;
    ] 
  3. Checked the table function :  there is no column name : function.


 Comments   
Comment by Alexey Pustovalov [ 2018 Aug 01 ]

Are you sure that you started Zabbix server 4.0.0alpha9? We renamed column.

Comment by Minh Son [ 2018 Aug 01 ]

this is what in my server

Comment by Alexey Pustovalov [ 2018 Aug 01 ]

Ok. Thank you! We will check it

Comment by Vladislavs Sokurenko [ 2018 Aug 01 ]

Fixed in:

  • pre-4.0.0alpha10 (trunk) r83352
Generated at Thu Apr 25 13:31:58 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.