[ZBX-1437] "Undefined index: clock" in eventview Created: 2009 Dec 07  Updated: 2017 May 30  Resolved: 2009 Dec 07

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

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

rev 8537



 Description   

monitoring -> events

PHP Notice: Undefined index: clock in /usr/local/apache2/htdocs/trunk/include/triggers.inc.php on line 1392, referer: http://localhost/trunk/events.php?sid=e46d02a6379f7d2c&form=1&form_refresh=1&nav_time=1231316220&trigger
id=0&hide_unknown=0&nav_day=07&nav_month=1&nav_year=2009&nav_hour=10&nav_minute=17&trigger=&filter_set=Filter&start=990
PHP Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/local/apache2/htdocs/trunk/include/db.inc.php on line 546, referer: http://localhost/trunk/events.php?sid=e46d02a6379f7d2c&for
m=1&form_refresh=1&nav_time=1231316220&triggerid=0&hide_unknown=0&nav_day=07&nav_month=1&nav_year=2009&nav_hour=10&nav_minute=17&trigger=&f
ilter_set=Filter&start=990
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /usr/local/apache2/htdocs/trunk/include/db.inc.php on line 548, referer: http://localhost/trunk/events.php?sid=e46d02a6379f7d2c&for
m=1&form_refresh=1&nav_time=1231316220&triggerid=0&hide_unknown=0&nav_day=07&nav_month=1&nav_year=2009&nav_hour=10&nav_minute=17&trigger=&f
ilter_set=Filter&start=990

and :

Error in query [select value from history_uint where itemid=22238 and clock<= order by itemid,clock desc LIMIT 1 OFFSET 0] [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by itemid,clock desc LIMIT 1 OFFSET 0' at line 1]



 Comments   
Comment by Alexey Fukalov [ 2009 Dec 07 ]

fixed in 8539

Comment by richlv [ 2009 Dec 07 ]

confirming fix in trunk rev 8540.

Generated at Tue Apr 23 12:04:03 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.