Nagiosql - mysql error

Support forum for Nagios Core, Nagios Plugins, NCPA, NRPE, NSCA, NDOUtils and more. Engage with the community of users including those using the open source solutions.
Locked
ns@esprinet.com
Posts: 6
Joined: Wed Sep 28, 2016 5:10 am

Nagiosql - mysql error

Post by ns@esprinet.com »

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
User avatar
cdienger
Support Tech
Posts: 5045
Joined: Tue Feb 07, 2017 11:26 am

Re: Nagiosql - mysql error

Post by cdienger »

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.
Locked