Database error in IT Services

[jpilldev]

Hello.

I has been installed Zabbix 1.4 with PostgreSQL 8.3 in a RHEL5, with 1.6 had problems with the clients.
Everything is fine but the IT Service Section shows me this error:

* pg_query() [function.pg-query]: Query failed: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list[/var/www/html/zabbix/include/db.inc.php:275]
* Error in query [SELECT DISTINCT s.serviceid, sl.servicedownid, sl_p.serviceupid as serviceupid, s.triggerid, s.name as caption, s.algorithm, t.description, s.sortorder, sl.linkid, s.showsla, s.goodsla, s.status FROM services s LEFT JOIN triggers t ON s.triggerid = t.triggerid LEFT JOIN services_links sl ON s.serviceid = sl.serviceupid and NOT(sl.soft=0) LEFT JOIN services_links sl_p ON s.serviceid = sl_p.servicedownid and sl_p.soft=0 WHERE (s.serviceid / 100000000000000)=0 ORDER BY s.sortorder, sl.serviceupid, s.serviceid] [ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list]
* pg_fetch_array() expects parameter 1 to be resource, boolean given[/var/www/html/zabbix/include/db.inc.php:394]

I had looking for the solution but no results.
Any ideas?

Thanks a lot

[Alexei]

Thanks for reporting this, It will be fixed asap.

[Aly]

It fixed since 1.4.1 is out.

[jpilldev]

Error fixed

Hello.

I changed the Query in the archive /var/www/html/zabbix/services.php

* Error in query [SELECT distinct s.serviceid, sl.servicedownid,
>sl_p.serviceupid as serviceupid, s.name caption, s.algorithm, t.triggerid,
^^^^^^^^^^^^^^
Changed s.name as caption

Later, Appears another Error:

SELECT distinct s.serviceid, sl.servicedownid, sl_p.serviceupid as
serviceupid, s.name as caption, s.algorithm, t.triggerid, s.sortorder,
sl.linkid FROM services s LEFT JOIN triggers t ON s.triggerid = t.triggerid
LEFT JOIN services_links sl ON s.serviceid = sl.serviceupid and
NOT(sl.soft=0) LEFT JOIN services_links sl_p ON s.serviceid =
sl_p.servicedownid and sl_p.soft=0 WHERE (s.serviceid / 100000000000000)=0
ORDER BY s.sortorder, sl.serviceupid, s.serviceid;
ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list

And change at the same file:
ORDER BY s.sortorder, sl.serviceupid, s.serviceid; by
ORDER BY s.sortorder, sl_p.serviceupid, s.serviceid;

Then I got another error of the same type, I fixed it and IT services works Fine.