[op5-users] Errors on ninja

[Per Åsberg]

On Mon, Oct 19, 2009 at 5:08 PM, Pier <pierg75 at yahoo.it> wrote:

> Now i cannot even enter in the index.php:
>
> 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: You have an error in your SQL syntax; check the
> manual that corresponds to your MySQL server version for the right syntax to
> use near 'WHERE c.host_name='batchvisure2' AND (c.service_description='' OR
> c.service_desc' at line 1 - (SELECT c.* FROM comment c , WHERE
> c.host_name='batchvisure2' AND (c.service_description='' OR
> c.service_description is null) ) UNION (SELECT c.* FROM comment c , host AS
> auth_host, service AS auth_service, contact AS auth_contact,
> contact_contactgroup AS auth_contact_contactgroup, service_contactgroup AS
> auth_service_contactgroup WHERE c.host_name='batchvisure2' AND
> (c.service_description='' OR c.service_description is null) AND
> auth_service.id = auth_service_contactgroup.service AND
> auth_service_contactgroup.contactgroup =
> auth_contact_contactgroup.contactgroup AND
> auth_contact_contactgroup.contact=auth_contact.id AND
> auth_contact.contact_name='nagiosadmin')


This is odd. I still can't reproduce this error, no matter what privileges I
login with.
Anyway, I made a new commit just recently that really addresses some other
issues in the comment model (where the error above comes from).
The patch also includes one small change that should prevent the error from
occurring again. Please try with the latest code and let me know.

Thanks again for taking the time to report this issue.

Regards,

/Per

----------------------
Per Asberg
Senior Developer
www.op5.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.op5.com/pipermail/op5-users/attachments/20091020/29aefb08/attachment.html