[ZBX-8537] Error "Unknown column 'e.value_changed'" Created: 2014 Jul 28  Updated: 2017 May 30  Resolved: 2014 Jul 28

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 2.2.5
Fix Version/s: None

Type: Incident report Priority: Critical
Reporter: Amos Assignee: Unassigned
Resolution: Won't fix Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Debian


Attachments: JPEG File ZabbixBug.jpg     JPEG File ZabbixBug2.jpg    
Issue Links:
Duplicate
duplicates ZBX-8534 Bug Mysqli Error in query Closed

 Description   

Error in query [SELECT COUNT(DISTINCT e.eventid) AS rowscount,e.objectid FROM events e WHERE 1=0 AND e.objectid BETWEEN 000000000000000 AND 099999999999999 AND ( (e.object IN ('0')) AND (e.value_changed IN ('1')) AND (e.acknowledged IN ('0')) AND (e.value IN ('1')) ) GROUP BY e.objectid] [Unknown column 'e.value_changed' in 'where clause']
mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given [include/db.inc.php:564]
mysqli_free_result() expects parameter 1 to be mysqli_result, boolean given [include/db.inc.php:565]

And

Error in query [SELECT MAX(e.eventid) AS eventid,e.objectid FROM events e WHERE e.object=0 AND 1=0 AND (e.value IN ('1')) AND e.value_changed=1 GROUP BY e.objectid] [Unknown column 'e.value_changed' in 'where clause']
mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given [include/db.inc.php:564]
mysqli_free_result() expects parameter 1 to be mysqli_result, boolean given [include/db.inc.php:565]



 Comments   
Comment by richlv [ 2014 Jul 28 ]

your screenshots clearly show 2.0.2 frontend version. please, do not open that many issues, thanks

Generated at Thu Jul 17 09:11:41 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.