Nagios Support Forum

Posted: **Fri Sep 07, 2018 8:50 am**

Here's the issue - your duration is smallint(6)...

| duration | smallint(6) | NO | | 0 | |

It should be int(11).

Run the following command to modify it:

echo 'ALTER TABLE nagios_scheduleddowntime MODIFY duration int(11) NOT NULL;' | mysql -uroot -pnagiosxi nagios

then verify that it was actually changed by running:

echo 'describe nagios_scheduleddowntime;' | mysql -t -uroot -pnagiosxi nagios | grep duration

Let us know if this fixes your issue. Thanks!

Posted: **Fri Sep 07, 2018 9:23 am**

That was it, I've tested it again after the change and now the duration will display 11h.
Thank you and have a nice weekend!

Posted: **Fri Sep 07, 2018 10:06 am**

Thank you! You too have a nice weekend! I am glad your issue has been resolved!

I am locking this topic.

Scheduled downtime duration field