Osticket was working fine on a windows 2008 server using a MySql database until we had to set the MySql database to ANSI in order to link Microsoft SQL2008 to MySql for databases not related to osTicket.
To set the link between mssql and mysql, in mysql we used
SET GLOBAL sql_mode='ansi';
This stopped our osTicket system from working.
Is there a config setting in osTicket that we can use to tell it mysql is now in ANSI mode?
IosTicket seems to be confusing single and double quotes in the insert queries and throwing errors.
Or is there a way to individually set the Mysql osTicket Databases to Not ANSI mode, which is I quess "no mode set", and leave the others as ANSI?
