-
Problem report
-
Resolution: Unresolved
-
Major
-
7.4.0rc1 (master)
-
S25-W16/17
-
2
Steps to reproduce:
- Create template 1 and template group 1
- Create template 2 with LLD and Host prototype in template group 2
- Edit template 1 and link template 2 to it
two_templates.yaml
- Create admin user with Admin role
- Create user group with read-write permissions only to template 1 group
- Login as admin user
- Open host prototypes on template 1
Result:
empty host prototypes list. Error "System error occurred. Please contact Zabbix administrator."
phpruntime error
Error in query [SELECT DISTINCT h.hostid,h.host,h.name,h.status,h.templateid,h.discover,h.custom_interfaces,h.uuid,COALESCE(hinv.inventory_mode,-1) AS inventory_mode FROM host_hgset hh,permission p,host_discovery hd,hosts h LEFT JOIN host_inventory hinv ON h.hostid=hinv.hostid WHERE h.flags=2 AND i.hostid=hh.hostid AND hh.hgsetid=p.hgsetid AND p.ugsetid=3 AND p.permission=3 AND h.hostid=hd.hostid AND hd.parent_itemid=48342 ORDER BY h.name LIMIT 1001] [ERROR: missing FROM-clause entry for table "i"
LINE 1: ... hinv ON h.hostid=hinv.hostid WHERE h.flags=2 AND i.hostid=h...
^] [host_prototypes.php:594 -> CApiWrapper->__call() -> CFrontendApiWrapper->callMethod() -> CApiWrapper->callMethod() -> CApiWrapper->callClientMethod() -> CLocalApiClient->callMethod() -> CHostPrototype->get() -> DBselect() -> trigger_error() -> CConfigFile->{closure:/.../.../.../.../ui/conf/zabbix.conf.php:83}() in include/db.inc.php:207]
Expected:
Should be host prototype with "Inaccessible template"
- caused by
-
ZBXNEXT-7527 Nested host prototypes
-
- IN DOCUMENTING
-
