This article covers Nagios error, mysql_error out of range value for column which is evident in the /var/log/messages file on the Nagios XI server.
To resolve this issue you will need to define the SQL Mode in the MySQL / MariaDB my.cnf configuration file:
1. Locate the [mysqld] section and check to see if there is an sql_mode already defined:
# Recommended in standard MySQL setup
2. If the sql_mode= line already exists you will need to replace it with the following.
If the line does not exist you will need to add the following line: