Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-5026

Error messages when creating IT Service

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Minor Minor
    • 2.0.1rc1, 2.1.0
    • 2.0.0rc6
    • Frontend (F)
    • Linux zabbix 3.2.0-23-generic #36-Ubuntu SMP Tue Apr 10 20:39:51 UTC 2012 x86_64 x86_64 x86_64 GNU/Linux
      postgres (PostgreSQL) 9.1.3

      Following error message is displayed after adding IT Service:

      pg_query(): Query failed: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list LINE 1: ...9999999 AND sl.servicedownid=s.serviceid ORDER BY s.sortorde... ^ [include/db.inc.php:430]
      Error in query [SELECT DISTINCT sl.linkid,sl.servicedownid,sl.soft,sl.serviceupid FROM services_links sl,services s WHERE ( (sl.serviceupid IN ('7')) ) AND sl.linkid BETWEEN 000000000000000 AND 099999999999999 AND sl.servicedownid=s.serviceid ORDER BY s.sortorder, s.serviceid] [ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list LINE 1: ...9999999 AND sl.servicedownid=s.serviceid ORDER BY s.sortorde... ^]
      pg_fetch_assoc() expects parameter 1 to be resource, boolean given [include/db.inc.php:565]
      pg_free_result() expects parameter 1 to be resource, boolean given [include/db.inc.php:566]
      pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [include/db.inc.php:430]
      Error in query [SELECT DISTINCT s.* FROM services s,services_links slc WHERE s.serviceid=slc.serviceupid AND slc.soft=0 AND (slc.servicedownid IN ('7')) AND s.serviceid BETWEEN 000000000000000 AND 099999999999999] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
      pg_fetch_assoc() expects parameter 1 to be resource, boolean given [include/db.inc.php:565]
      pg_free_result() expects parameter 1 to be resource, boolean given [include/db.inc.php:566]
      pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [include/db.inc.php:430]
      Error in query [SELECT t.triggerid,t.description FROM triggers t WHERE (t.triggerid IN ('0')) ] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
      pg_fetch_assoc() expects parameter 1 to be resource, boolean given [include/db.inc.php:565]
      pg_free_result() expects parameter 1 to be resource, boolean given [include/db.inc.php:566]

            Unassigned Unassigned
            ennerr ennerr
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: