Hello All, I've just upgraded one of our stand alone opsview servers (at client location) , to opsview 3.7.2. Previous version was 3.7.1 working without problems. The system is based on centos 5.2 and updated through yum update / yum upgrade. Now when I look at the configuration hosts I get all the hosts configured. However on the Alerts All unhandled page I get a error : There has been an error in the Opsview application. You can find further help at: http://docs.opsview.com/doku.php?id=opsview-community:webexception View Error Opsview error: Caught exception in Opsview::Web::Controller::Status::Service->default "DBD::mysql::st execute failed: Unknown column 'opsview_hosts.has_interfaces' in 'field list' [for Statement "SELECT DISTINCT(opsview_host_services.service_object_id) as service_object_id, opsview_hosts.id as host_object_id, opsview_hosts.name as host, opsview_hosts.alias as alias, opsview_hosts.icon_filename as icon, opsview_hosts.has_interfaces as has_interfaces, nagios_hoststatus.current_state as host_state, nagios_hoststatus.is_flapping as host_flapping, nagios_hoststatus.problem_has_been_acknowledged as host_acknowledged, (nagios_hoststatus.current_state != 0 and nagios_hoststatus.problem_has_been_acknowledged != 1 and nagios_hoststatus.scheduled_downtime_depth = 0) as host_unhandled, nagios_hoststatus.output as host_output, nagios_hoststatus.current_check_attempt as host_current_check_attempt, nagios_hoststatus.max_check_attempts as host_max_check_attempts, CONVERT_TZ(nagios_hoststatus.last_check, '+00:00', 'SYSTEM') as host_last_check, UNIX_TIMESTAMP(nagios_hoststatus.last_state_change) as host_last_state_change_timev, opsview_host_services.servicename as service, nagios_servicestatus.current_state as service_state, nagios_servicestatus.is_flapping as service_flapping, nagios_servicestatus.problem_has_been_acknowledged as service_acknowledged, nagios_servicestatus.output as service_output, (nagios_servicestatus.current_state != 0 and nagios_hoststatus.current_state = 0 and nagios_hoststatus.scheduled_downtime_depth = 0 and nagios_servicestatus.problem_has_been_acknowledged!=1 and nagios_servicestatus.scheduled_downtime_depth = 0) as service_unhandled, opsview_host_services.perfdata_available as perfdata_available, opsview_host_services.markdown_filter as markdown_filter, nagios_servicestatus.current_check_attempt as current_check_attempt, nagios_servicestatus.max_check_attempts as max_check_attempts, CONVERT_TZ(nagios_servicestatus.last_check, '+00:00', 'SYSTEM') as last_check, UNIX_TIMESTAMP(nagios_servicestatus.last_state_change) as last_state_change_timev, IF(nagios_hoststatus.current_state=0, IF(nagios_servicestatus.current_state=3, 0.5, nagios_servicestatus.current_state), nagios_hoststatus.current_state*10) as service_state_priority FROM opsview_host_services, opsview_hosts, nagios_hoststatus, nagios_servicestatus WHERE ( ( opsview_host_services.host_object_id = nagios_hoststatus.host_object_id AND opsview_host_services.service_object_id = nagios_servicestatus.service_object_id AND opsview_hosts.id = opsview_host_services.host_object_id ) ) HAVING ( service_unhandled = ? OR ( host_unhandled = ? AND service_state != ? ) ) ORDER BY service_state_priority DESC, host, service" with ParamValues: 0=1, 1=1, 2=0] at /usr/local/nagios/perl/lib/DBIx/ContextualFetch.pm line 52." This looks to me as if there went something wrong with the DB update , how can I confirm it is , and fix it ? (Showing Host Group Summary gives no output) Regards, Peter
_______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/lists/listinfo/opsview-users
