[op5-users] Errors on ninja

Pier pierg75 at yahoo.it
Mon Oct 19 14:35:58 CEST 2009


Hi.
Since last week, i had some error with the latest version of ninja (cvs).
When i go to "Host Problems" i get this:

Database Error

A database error occurred while performing the requested procedure. Please review the database error below for more information.

/etc/nagios/addons/ninja/system/libraries/drivers/Database/Mysql.php [367]:

There was an SQL error: Unknown column 'auth_host.current_state' in 'where clause' - SELECT h.id AS host_id, h.host_name, h.address, h.alias, h.current_state, h.last_check, h.next_check, h.should_be_scheduled, h.notes_url, h.notifications_enabled, h.active_checks_enabled, h.icon_image, h.icon_image_alt, h.is_flapping, h.action_url, (UNIX_TIMESTAMP() - h.last_state_change) AS duration, UNIX_TIMESTAMP() AS cur_time, h.current_attempt, h.max_check_attempts, h.problem_has_been_acknowledged, h.scheduled_downtime_depth, h.output FROM host h WHERE 1 AND 1 << auth_host.current_state & 6 ORDER BY host_name ASC

and the the stack trace.
Then under the "Service Problems" i get an empty page when i should see some services down (in the Tactical Overview it show many problems).
In the services detail it shows me only the services from nagios (localhost)...i should see more then 1000 services.

Thanks

Pier


      


More information about the op5-users mailing list