Greetings fellow Centreon users,
i need i bit of guidance, while updating the minor patch i receive an error on step4, it reads: UPGRADE - 21.10.11: Impossible to update ‘services’ table (screenshot attached)
past minor updates have succeeded just fine.
the upgrade.log reads:
2022-10-03 16:58|0|0|UPGRADE - 21.10.11: Impossible to update 'services' table - Code : 22003 - Error : SQLSTATEL22003]: Numeric value out of range: 1264 Out of range value for column 'notification_number' at row 18 - Trace : #0 /usr/share/centreon/www/class/centreonDB.class.php(263): PDO->query()
#1 /usr/share/centreon/www/install/php/Update-21.10.11.php(37): CentreonDB->query()
#2 /usr/share/centreon/www/install/step_upgrade/process/process_step4.php(72): include_once('...')
#3 {main}
the sql-error.log reads:
2022-10-03 15:22|0|0| QUERY : ALTER TABLE services MODIFY notification_number BIGINT(20) UNSIGNED DEFAULT NULL
Please advise.
