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

Error when trying to view 2nd page of triggers in a host or template: No permissions to referred object or it does not exist!

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Duplicate
    • Icon: Major Major
    • None
    • None
    • None
    • None

      Zabbix 3.2.2
      Postgresql 9.3

      Template configured with 60 triggers, when clicking to view page 2 of the template or host it is linked to the following error is generated

      No permissions to referred object or it does not exist!
      Details
      array_flip(): Can only flip STRING and INTEGER values! [triggers.php:149 ? CFrontendApiWrapper->isWritable() ? CApiWrapper->__call() ? CFrontendApiWrapper->callMethod() ? CApiWrapper->callMethod() ? CFrontendApiWrapper->callClientMethod() ? CLocalApiClient->callMethod() ? call_user_func_array() ? CHostGroup->isWritable() ? CHostGroup->get() ? dbConditionInt() ? array_flip() in include/db.inc.php:875]
      pg_query(): Query failed: ERROR: syntax error at end of input
      LINE 1: ... COUNT(DISTINCT g.groupid) AS rowscount FROM groups g WHERE
      ^ [triggers.php:149 ? CFrontendApiWrapper->isWritable() ? CApiWrapper->__call() ? CFrontendApiWrapper->callMethod() ? CApiWrapper->callMethod() ? CFrontendApiWrapper->callClientMethod() ? CLocalApiClient->callMethod() ? call_user_func_array() ? CHostGroup->isWritable() ? CHostGroup->get() ? DBselect() ? pg_query() in include/db.inc.php:409]
      Error in query [SELECT COUNT(DISTINCT g.groupid) AS rowscount FROM groups g WHERE ] [ERROR: syntax error at end of input
      LINE 1: ... COUNT(DISTINCT g.groupid) AS rowscount FROM groups g WHERE
      ^]
      

            Unassigned Unassigned
            aschaffer Asher Schaffer
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: