Ad Widget

Collapse

Error in query ( Configuration of Items )

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • HFF
    Junior Member
    • Jan 2009
    • 5

    #1

    Error in query ( Configuration of Items )

    Hello to All,

    I got an error when I choose Configuration -> Items ( slected item ) -> copy selected to -> and the Combox "Target type" I choose option "Host groups"


    Code:
     * Error in query [SELECT DISTINCT g.groupid as target_id, g.name as target_name FROM groups g, hosts_groups hg WHERE hg.groupid=g.groupid ORDER BY g.name order by target_name] [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 target_name' at line 1]
        * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/home/zabbix/web/include/db.inc.php:519]
    I am using Zabbix 1.6.2 + Mysql on Ubuntu 8.10... Any idea or solution?

    My best regards,
    Hugo Fernandes
Working...