Nagios Support Forum

Hi all,

someone can help me with this error in Nagiosql Hosts page?

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 ‘`value’ at line 4

edit:
sorry error found in nag_class.php, was missing an ` near "ORDER BY `value`";"

$strSQL = "SELECT `tbl_service`.`id` AS `key`, CONCAT(`tbl_service`.`config_name`, ' - ', `tbl_service`.`service_description`) AS `value`, `active`
FROM `tbl_service` WHERE $strDomainWhere1 AND `tbl_service`.`config_name` <> ''
AND `tbl_service`.`config_name` IS NOT NULL AND `tbl_service`.`service_description` <> '' AND `tbl_service`.`service_description` IS NOT NULL
AND `access_group` IN ($strAccess) ORDER BY `value`";


thanks in advance

Sounds like the problem has been resolved then?