I had a problem with mysql. After fixing mysql issue I could run opsview and opsview-web. When I open opsview web interface, it gives following error. Please advice me. I tried to restore the system to a past day. But opsview-web is not reloading well.
Opsview error: Caught exception in Opsview::Web::Controller::Status::Hostgroup->default "DBD::mysql::st execute failed: Incorrect information in file: './runtime/nagios_scheduleddowntime.frm' [for Statement "SELECT opsview_hostgroups.id, nagios_scheduleddowntime.was_started as started FROM opsview_hostgroups, opsview_hostgroup_hosts, opsview_host_services, nagios_scheduleddowntime WHERE ( ( ( nagios_scheduleddowntime.object_id = opsview_hostgroup_hosts.host_object_id OR nagios_scheduleddowntime.object_id = opsview_host_services.service_object_id ) AND opsview_hostgroup_hosts.host_object_id = opsview_host_services.host_object_id AND opsview_hostgroup_hosts.hostgroup_id = opsview_hostgroups.id AND opsview_hostgroups.parentid = ? ) )" with ParamValues: 0='1'] at /usr/local/nagios/perl/lib/DBIx/ContextualFetch.pm line 52." _______________________________________________ Opsview-users mailing list Opsview-users@lists.opsview.org http://lists.opsview.org/lists/listinfo/opsview-users
