Scheduled downtime duration field

[lmiltchev]

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:

Code: Select all

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

then verify that it was actually changed by running:

Code: Select all

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

Let us know if this fixes your issue. Thanks!

[CBoekhuis]

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!

[lmiltchev]

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

I am locking this topic.