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

Details

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

    Description

      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
      ^]
      

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: