operation system:centos 7
zabbix-server-mysql-3.4.13-1.el7.x86_64
No matter i use network discovery or active agent auto-registration to add clients to server,I get same error
18129:20180830:145902.508 [Z3005] query failed: [1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 [select t.triggerid,t.templateid from triggers t,functions f,items i where t.triggerid=f.triggerid and f.itemid=i.itemid and i.hostid=10260 and]
Network discovery:
Discovery work fine,It can find client.But discovery of actions work failure,If operations have two details("Add to host groups" and "Link to templates"),zabbix-server come the error,On the web,Hosts can find the client,but it doesn't has Templates,No Items,No Triggers and so on.if operations remove "Link to templates",It turn ok.
Active agent auto-registration:
The situation is the same as above,When operations has "Link to templates" work failure,And turn ok after remove "Link to templates".
zabbix-server-mysql-3.4.13-1.el7.x86_64
No matter i use network discovery or active agent auto-registration to add clients to server,I get same error
18129:20180830:145902.508 [Z3005] query failed: [1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 [select t.triggerid,t.templateid from triggers t,functions f,items i where t.triggerid=f.triggerid and f.itemid=i.itemid and i.hostid=10260 and]
Network discovery:
Discovery work fine,It can find client.But discovery of actions work failure,If operations have two details("Add to host groups" and "Link to templates"),zabbix-server come the error,On the web,Hosts can find the client,but it doesn't has Templates,No Items,No Triggers and so on.if operations remove "Link to templates",It turn ok.
Active agent auto-registration:
The situation is the same as above,When operations has "Link to templates" work failure,And turn ok after remove "Link to templates".
Comment