Ad Widget

Collapse

history.php: error is SQL statement

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • pattieja
    Junior Member
    • Mar 2005
    • 14

    #1

    history.php: error is SQL statement

    I don't know if this has been reported for ZABBIX 1.1beta8 yet, or not, but on line 293 of .../php/frontends/history.php the SQL statement has 'item i' instead of 'items i'. I'm getting the following error whenever I select '500 latest values' for a specific host:

    Error in query [select h.clock, h.value, i.valuemapid from history h, item i where h.itemid=i.itemid and i.itemid=17651 order by clock desc limit 500] [Table 'zabbix.item' doesn't exist]

    After changing 'item i' to 'items i', the '500 latest values' screen works properly.
Working...