-
Problem report
-
Resolution: Fixed
-
Critical
-
7.4.0beta1
-
S25-W14/15, S25-W16/17
-
1
Steps to reproduce:
Precondition: some problem exists
- Open Problems page
- Open context menu for a problem, Configuration -> trigger
Result:
Access denied
You are logged in as "Admin". You have no permissions to access this page.
If you think this message is wrong, please consult your administrators about getting the necessary permissions.
Error:
Undefined array key "hostid" [zabbix.php:17 -> require_once() -> ZBase->run() -> ZBase->processRequest() -> CController->run() -> CControllerTriggerEdit->checkPermissions() -> CController->getInput() -> CConfigFile->{closure}() in include/classes/mvc/CController.php:353]
array_flip(): Can only flip string and integer values, entry skipped [zabbix.php:17 -> require_once() -> ZBase->run() -> ZBase->processRequest() -> CController->run() -> CControllerTriggerEdit->checkPermissions() -> CApiWrapper->__call() -> CFrontendApiWrapper->callMethod() -> CApiWrapper->callMethod() -> CApiWrapper->callClientMethod() -> CLocalApiClient->callMethod() -> CHost->get() -> dbConditionInt() -> array_flip() -> CConfigFile->{closure}() in include/db.inc.php:496]
pg_query(): Query failed: ERROR: syntax error at or near "AND"
LINE 1: ...h,functions f,items i WHERE h.flags IN (0,4) AND AND f.trig...
^ [zabbix.php:17 -> require_once() -> ZBase->run() -> ZBase->processRequest() -> CController->run() -> CControllerTriggerEdit->checkPermissions() -> CApiWrapper->__call() -> CFrontendApiWrapper->callMethod() -> CApiWrapper->callMethod() -> CApiWrapper->callClientMethod() -> CLocalApiClient->callMethod() -> CHost->get() -> CApiService->customFetch() -> DBselect() -> pg_query() -> CConfigFile->{closure}() in include/db.inc.php:206]
Error in query [SELECT DISTINCT h.hostid FROM hosts h,functions f,items i WHERE h.flags IN (0,4) AND AND f.triggerid=25084 AND h.hostid=i.hostid AND f.itemid=i.itemid AND h.status IN (0,1)] [ERROR: syntax error at or near "AND"
LINE 1: ...h,functions f,items i WHERE h.flags IN (0,4) AND AND f.trig...
^] [zabbix.php:17 -> require_once() -> ZBase->run() -> ZBase->processRequest() -> CController->run() -> CControllerTriggerEdit->checkPermissions() -> CApiWrapper->__call() -> CFrontendApiWrapper->callMethod() -> CApiWrapper->callMethod() -> CApiWrapper->callClientMethod() -> CLocalApiClient->callMethod() -> CHost->get() -> CApiService->customFetch() -> DBselect() -> trigger_error() -> CConfigFile->{closure}() in include/db.inc.php:207]
