Error message "You have an error in your SQL syntax"
Brought to you by:
wizonet
Menu
▾
▴
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 of this error, ideally with timestamp, so I could tell 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.
Note this is a cross-post from here.
Referring to your post on support.nagios.org you are still using version 3.3.0.
Unfortunately this version is no longer supported - so I recommend to upgrade to 3.4.0. We don't have the personnel capacity and the appropriate test systems to maintain every old version.
Nevertheless, this coud be the error fixed in one of the last commits to 3.3.0:
https://gitlab.com/wizonet/nagiosql/commit/d0a1aeae69a1c404f02925bb4e12fe551128da61