when upgrading from NagiosQL 3.2 to 3.4.4 the upgrade goes fine but some of the config targets are missing, when I try to apply the correct config targets I get this error
Unknown column 'port' in 'field list'
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Sounds like the database schema has not been updated. It is difficult to find the reason for this, perhaps a database user without sufficient rights was specified for the update. In the subdirectory install/sql are all adjustments that are made during the upgrade. You should check these in your database
OS Centos8
Nagios Core 4.4.6
when upgrading from NagiosQL 3.2 to 3.4.4 the upgrade goes fine but some of the config targets are missing, when I try to apply the correct config targets I get this error
Unknown column 'port' in 'field list'
Sounds like the database schema has not been updated. It is difficult to find the reason for this, perhaps a database user without sufficient rights was specified for the update. In the subdirectory install/sql are all adjustments that are made during the upgrade. You should check these in your database
port is added in this file:
update_340_341.sql
https://gitlab.com/wizonet/nagiosql/-/blob/3.4.1/install/sql/update_340_341.sql