After upgrade to version 2.2.1 from 2.0 I get the following error whenever I try to link a template to a host (where Application name is the name of the application and value is the items contained in that application:
"Error in query [INSERT INTO applications (name,hostid,applicationid) VALUES ('[Application name]','[value]','[value]' ,] [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]SQL statement execution has failed "INSERT INTO applications (name,hostid,applicationid) VALUES ('[Application name]','[value]','[value]' ,"."
The error occurs on all templates that contains an application with a name containing any of the following letters; å,ä,ö (swedish alphabet). The error disappears and I can successfully link a template to a host if I rename the application that contains any of the above mentioned characters. It will only complain when these characters are in the application. using the characters in items, triggers or graphs does not cause any errors.
This is a new problem since upgrading to 2.2.1.