Steps to reproduce:

1. link windows OS template (zabbix agent) on autodiscovery or registration rule
2. look in zabbix log for error Z3005

Result:

Autoregistration is not completed so host is not created.(if template link is in action)

autodiscovery does not link the template if there are 'zabbix-agent' triggers in it.

log file:

[Z3005] query failed: [1064] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB 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=10875 and]

I also testen with latest 3.0 from centos repository. Failes

Also tested with postgres sql backend.Failes

At this moment there is no way for me to automatic link the Windows OS template (for zabbix agent). Other templates with triggers (like Windows OS SNMP template, or self cerated wmi templates) are no problem.

When all triggers and trigger prototypes are removed, then it is possible to automatic link the template.

The error ends wiht a 'and' without an argument. If there is a way to work around this problem I would like to know. A want to automatically link the wondows OS template (zabbix agent version).