hello,
got a trouble with mysql query, when i copy trigger for host group get an error:
* 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[/usr/home/zabbix/www/zabbix/include/db.inc.php:519]
i'm using: freebsd 7.1, mysql 5.1.30, apache 2.2.11_3, php 5.2.8
got a trouble with mysql query, when i copy trigger for host group get an error:
* 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[/usr/home/zabbix/www/zabbix/include/db.inc.php:519]
i'm using: freebsd 7.1, mysql 5.1.30, apache 2.2.11_3, php 5.2.8
Comment