[ZBX-4251] Not working range selection from DB Created: 2011 Oct 18  Updated: 2017 May 30  Resolved: 2011 Oct 18

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

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

MySQL



 Description   

after rev22463 - ZBXNEXT-429 make range select work in a more intutive fashion

we have in dashboard thise message:
Incorrect parameters for limit and/or offset. Query [SELECT t.* FROM triggers t WHERE (1=1) AND NOT EXISTS ( SELECT ff.functionid FROM functions ff WHERE ff.triggerid=t.triggerid AND EXISTS ( SELECT ii.itemid FROM items ii, hosts hh WHERE ff.itemid=ii.itemid AND hh.hostid=ii.hostid AND ( ii.status<>0 OR hh.status<>0 ) ) ) AND t.status=0 AND ( (t.value IN ('1')) AND (t.flags IN ('0','4')) ) ORDER BY lastchange DESC] Limit [] Offset [0]
mysql_fetch_assoc() expects parameter 1 to be resource, boolean given [include/db.inc.php:594]
mysql_free_result() expects parameter 1 to be resource, boolean given [include/db.inc.php:596]



 Comments   
Comment by Alexey Pustovalov [ 2011 Oct 18 ]

excuse me
after rev22477 - ZBX-3743 fixed no triggers returned when api trigger.get is called with "limit" and "withLastEventUnacknowledged" options
[merged svn://svn.zabbix.com/branches/1.8 -c22476]

Comment by Alexey Fukalov [ 2011 Oct 18 ]

should be fixed in rev. 22483

Comment by Alexey Pustovalov [ 2011 Oct 18 ]

yes, confirm

Comment by Alexey Fukalov [ 2011 Oct 18 ]

closed

Comment by Oleksii Zagorskyi [ 2011 Oct 19 ]

Damn, 9 miutes for fix !
COOL !!!

Generated at Fri Mar 29 10:06:40 EET 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.