-
Type:
Problem report
-
Resolution: Done
-
Priority:
Critical
-
None
-
Affects Version/s: 3.4.4
-
Component/s: Frontend (F)
-
None
-
Environment:Centos 7.3
Steps to reproduce:
Hosts->host>Macros->Inherited and host macros
change Macro value
when i Update this host.
it report SQL error
Result:
Cannot update host Details Error in query [INSERT INTO hostmacro (macro,value,hostid,hostmacroid) VALUES ('{$MAX_RESPONSE}','0.51','11411','365')] [Duplicate entry '365' for key 'PRIMARY'] SQL statement execution has failed "INSERT INTO hostmacro (macro,value,hostid,hostmacroid) VALUES ('{$MAX_RESPONSE}','0.51','11411','365')". [hosts.php:598 ? CApiWrapper->__call() ? CFrontendApiWrapper->callMethod() ? CApiWrapper->callMethod() ? CFrontendApiWrapper->callClientMethod() ? CLocalApiClient->callMethod() ? CHost->update() ? CUserMacro->replaceMacros() ? CUserMacro->create() ? DB::insert() ? DB::exception() in include/classes/db/DB.php:468]