When I just install Zabbix and I log in as Admin, I am not able to access the Configuration tab, so I am unable to do much with this as of yet, also I'm getting this error.
* pg_query() [function.pg-query]: Query failed: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list[/var/www/localhost/htdocs/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/localhost/htdocs/zabbix/include/db.inc.php:394]
Which I'm not sure if they are related, this I get when I'm under IT services under monitoring. Anyone experience this issues yet or can help point me towards a fix?
* pg_query() [function.pg-query]: Query failed: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list[/var/www/localhost/htdocs/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/localhost/htdocs/zabbix/include/db.inc.php:394]
Which I'm not sure if they are related, this I get when I'm under IT services under monitoring. Anyone experience this issues yet or can help point me towards a fix?