NagiosQL error in your SQL syntax

[jrbnagios]

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.

[scottwilkerson]

This is a question you would have to ask the creators of NagiosQL. We at Nagios Enterprises are not the author of that software and are not famailar with what it logs and what options are available.

[martinQL]

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 could be the error fixed in one of the last commits to 3.3.0:
https://gitlab.com/wizonet/nagiosql/com ... 551128da61

Additional information may be available in the Apache error log or in MySQL/MariaDB general log (if enabled).

Thank you for posting the bug on https://sourceforge.net/projects/nagiosql/ - I only visit here sporadically.

[scottwilkerson]

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 could be the error fixed in one of the last commits to 3.3.0:
https://gitlab.com/wizonet/nagiosql/com ... 551128da61

Additional information may be available in the Apache error log or in MySQL/MariaDB general log (if enabled).

Thank you for posting the bug on https://sourceforge.net/projects/nagiosql/ - I only visit here sporadically.

thanks for the info @martinQL!