I-doit pro update 1.2.5 auf 1.3.0 db Error

StefanP74

Hallo,

beim Updaten der 1.2.5 auf 1.3.0 werden folgende Fehler beim Installationsprozess angezeigt:
Ist ein Testsystem, kann sein, dass da unfertige Nagios-Objekte dfiniert waren ….. ich poste es dennoch zur Info
Ich konnte nach dem Update keinen Fehler feststellen, läuft eigentlich perfekt.

Adding the nagios export host field (nagios def) Added. ERROR
Database error : Query error: 'ALTER TABLE isys_catg_nagios_host_tpl_def_list ADD isys_catg_nagios_host_tpl_def_list__export_host INT(10) UNSIGNED NULL, ADD FOREIGN KEY (isys_catg_nagios_host_tpl_def_list__export_host) REFERENCES isys_monitoring_export_config (isys_monitoring_export_config__id) ON DELETE SET NULL ON UPDATE CASCADE':Failed to add the foreign key constraint 'idoit_data/isys_catg_nagios_host_tpl_def_list_ibfk_1' to system tables

Adding the nagios export host field (nagios tpl def) Added. ERROR
Database error : Query error: 'ALTER TABLE isys_catg_nagios_list ADD isys_catg_nagios_list__export_host INT(10) UNSIGNED NULL, ADD FOREIGN KEY (isys_catg_nagios_list__export_host) REFERENCES isys_monitoring_export_config (isys_monitoring_export_config__id) ON DELETE SET NULL ON UPDATE CASCADE':Failed to add the foreign key constraint 'idoit_data/isys_catg_nagios_list_ibfk_1' to system tables

Bei der dB Migration dann noch:

Migrating "NDO Parameter" category data to "Monitoring" category.
Moving data in object "server04" (#164)…
Database error : Query error: 'SELECT isys_obj., isys_obj_type., isys_monitoring_export_config., isys_catg_ip_list., isys_nagios_commands., isys_nagios_commands_plus., isys_nagios_timeperiods., isys_nagios_timeperiods_plus., isys_catg_nagios_list.* FROM isys_obj INNER JOIN isys_catg_nagios_list ON isys_catg_nagios_list__isys_obj__id = isys_obj__id INNER JOIN isys_obj_type ON isys_obj__isys_obj_type__id = isys_obj_type__id LEFT JOIN isys_monitoring_export_config ON isys_catg_nagios_list.isys_catg_nagios_list__export_host = isys_monitoring_export_config.isys_monitoring_export_config__id LEFT JOIN isys_catg_ip_list ON isys_catg_nagios_list.isys_catg_nagios_list__isys_catg_ip_list__id = isys_catg_ip_list.isys_catg_ip_list__id LEFT JOIN isys_nagios_commands ON isys_catg_nagios_list.isys_catg_nagios_list__check_command = isys_nagios_commands.isys_nagios_commands__id LEFT JOIN isys_nagios_commands_plus ON isys_catg_nagios_list.isys_catg_nagios_list__check_command_plus = isys_nagios_commands_plus.isys_nagios_commands_plus__id LEFT JOIN isys_nagios_timeperiods ON isys_catg_nagios_list.isys_catg_nagios_list__check_period = isys_nagios_timeperiods.isys_nagios_timeperiods__id LEFT JOIN isys_nagios_timeperiods_plus ON isys_catg_nagios_list.isys_catg_nagios_list__check_period_plus = isys_nagios_timeperiods_plus.isys_nagios_timeperiods_plus__id WHERE TRUE AND (isys_obj.isys_obj__id = 164)': Unknown column 'isys_catg_nagios_list.isys_catg_nagios_list__export_host' in 'on clause'

Glückwunsch zum Release ….. welch lange Changelist

LG Stefan

vqh

Hallo Stefan,

versuch mal folgende Queries:

ALTER TABLE isys_catg_nagios_host_tpl_def_list ADD isys_catg_nagios_host_tpl_def_list__export_host INT(10) UNSIGNED NULL,
ADD CONSTRAINT isys_catg_nagios_host_tpl_def_list__export_host FOREIGN KEY (isys_catg_nagios_host_tpl_def_list__export_host) REFERENCES isys_monitoring_export_config (isys_monitoring_export_config__id) ON DELETE SET NULL ON UPDATE CASCADE;

ALTER TABLE isys_catg_nagios_list ADD isys_catg_nagios_list__export_host INT(10) UNSIGNED NULL,
ADD CONSTRAINT isys_catg_nagios_list__export_host FOREIGN KEY (isys_catg_nagios_list__export_host) REFERENCES isys_monitoring_export_config (isys_monitoring_export_config__id) ON DELETE SET NULL ON UPDATE CASCADE;

Gruß
vqh

StefanP74

Ja, damit ist der Fehler behoben.
Der Folgefehler dadurch war ein SQL Fehler, wenn man bei einem Host auf Nagios in der Objektsturktur klickte.

Ist damit behoben.

Danke

LG Stefan