Service Detailpage emtpy and no Service Detail PopUp

[centreon]

---

Author Name: Lang Stephan (Lang Stephan)
Original Redmine Issue: 3194, https://forge.centreon.com/issues/3194
Original Date: 2012-03-30

---

my service detailpage is empty and the servicedetail popup is is also not showing up...

following errors i've found in the logs:

/usr/local/cenetreon/log/sql_error:
2012-03-30 10:56|0|0|DB Error: no such field QUERY : SELECT nss.current_state, no.name1 as hostname, no.name2 as service_description, unix_timestamp(nss.last_check) as last_check, unix_timestamp(nss.next_check) as next_check, unix_timestamp(nss.last_state_change) as last_state_change, unix_timestamp(nss.last_notification) as last_notification, unix_timestamp(nss.next_notification) as next_notification, unix_timestamp(nss.last_hard_state_change) as last_hard_state_change, nss.last_hard_state, nss.latency, unix_timestamp(nss.last_time_ok) as last_time_ok, unix_timestamp(nss.last_time_critical) as last_time_critical, unix_timestamp(nss.last_time_unknown) as last_time_unknown, unix_timestamp(nss.last_time_warning) as last_time_warning, nss.current_notification_number, nss.scheduled_downtime_depth, nss.output, nss.long_output, ns.notes, ROUND(nss.percent_state_change) as percent_state_change, nss.notifications_enabled, nss.perfdata, nss.state_type, nss.execution_time, nss.event_handler_enabled, ns.icon_image FROM nagios_servicestatus nss, nagios_objects no, nagios_services ns WHERE no.object_id = 2345 AND no.object_id = nss.service_object_id AND ns.service_object_id = no.object_id AND no.is_active = 1 AND no.objecttype_id = 2

2012-03-30 10:56|0|0|DB Error: no such field QUERY : SELECT nss.current_state, nss.output as plugin_output, nss.long_output as long_plugin_output, CONCAT( '', nss.output, '
', nss.long_output ) as plugin_output2, nss.current_check_attempt as current_attempt, nss.status_update_time as status_update_time, unix_timestamp(nss.last_state_change) as last_state_change, unix_timestamp(nss.last_check) as last_check, nss.notifications_enabled, unix_timestamp(nss.next_check) as next_check, nss.problem_has_been_acknowledged, nss.passive_checks_enabled, nss.active_checks_enabled, nss.event_handler_enabled, nss.perfdata as performance_data, nss.is_flapping, nss.scheduled_downtime_depth, nss.percent_state_change, nss.current_notification_number, nss.obsess_over_service, nss.check_type, nss.state_type, nss.latency as check_latency, nss.execution_time as check_execution_time, nss.flap_detection_enabled, unix_timestamp(nss.last_notification) as last_notification, no.name1 as host_name, no.name2 as service_description, ns.notes_url, ns.notes, ns.action_url, i.instance_name FROM nagios_servicestatus nss, nagios_objects no, nagios_services ns, nagios_instances i WHERE no.object_id = nss.service_object_id AND no.name1 like 'netapp1' AND no.object_id = ns.service_object_id AND no.instance_id = i.instance_id

following error in /var/log/httpd/error_log:

[Fri Mar 30 09:19:32 2012] [error] [client 192.168.1.3] PHP Fatal error: Call to undefined method DB_Error::fetchRow() in /usr/local/centreon/www/include/monitoring/status/Services/xml/ndo/makeXMLForOneService.php on line 175, referer: http://nagios/centreon/main.php?p=101

[Fri Mar 30 09:19:33 2012] [error] [client 192.168.1.3] PHP Fatal error: Call to undefined method DB_Error::fetchRow() in /usr/local/centreon/www/include/monitoring/objectDetails/serviceDetails.php on line 211, referer: http://nagios/centreon/main.php?p=101

[centreon]

---

Original Redmine Comment
Author Name: Tensibai - Bastien Jove (Tensibai - Bastien Jove)
Original Date: 2012-03-30T12:00:33Z

---

Seems your ndo DB is crashed ... more a worksforme than a bug IMHO (even if there's still something to do about the sql queries failing silently and so crashing the process)

[centreon]

---

Original Redmine Comment
Author Name: Sylvestre Ho (Sylvestre Ho)
Original Date: 2012-04-06T13:11:57Z

---

Did that occur after an upgrade?

More info is welcome