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
Nagiosql - mysql error
Re: Nagiosql - mysql error
Sounds like the problem has been resolved then?
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.