[op5-users] Errors on ninja

[Per Åsberg]

Pier skrev:
> 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.

Hi Pier,

Thank you for taking the time to report this issue.

I believe this should be fixed in the current version - I can't reproduce it 
anyway. I have been doing quite some work on the host model lately and I 
suspect that this error occurred somewhere along the way.

Please get back to me if you still are having this issue after downloading the 
latest code.

Regards,

/Per

---------------
Per Asberg
Senior Developer
www.op5.com