NagiosQL error in your SQL syntax
Posted: Mon Sep 24, 2018 5:06 am
I am having an error with symptoms similar to this post.
Specifically, when I go into NagiosQL, and click Supervision - Host, then click the wrench icon next to any host to edit it, under the Common Settings frame displays this message.
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
My main question is if there are any logs that would show instances when this error has occurred, ideally with timestamp, so I could gauge when it started occurring. That might point me in the direction of cause and resolution. Unfortunately I didn't find this error in my main nagios log. Or alternatively, would the mysqlcheck command mentioned in the linked post be a good next step?
Nagios 4.3.1, NagiosQL 3.3.0. I know those aren't the latest, but my preference would be to not just have "upgrade to latest" be the next step.
Specifically, when I go into NagiosQL, and click Supervision - Host, then click the wrench icon next to any host to edit it, under the Common Settings frame displays this message.
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
My main question is if there are any logs that would show instances when this error has occurred, ideally with timestamp, so I could gauge when it started occurring. That might point me in the direction of cause and resolution. Unfortunately I didn't find this error in my main nagios log. Or alternatively, would the mysqlcheck command mentioned in the linked post be a good next step?
Nagios 4.3.1, NagiosQL 3.3.0. I know those aren't the latest, but my preference would be to not just have "upgrade to latest" be the next step.