infoRouter Version 8.6 requires a small change to the MySQL ini file.


    infoRouter 8.6.X release no longer requires the MySql backslash escaping parameters.
    If this parameter exists, it may cause SQL errors in some cases.

    To change back to the default "string encoding parameter", perform the following for MySQL servers.
    Open the "my.ini" file located in the MySQL installation directory with notepad.
    remove the NO_BACKSLASH_ESCAPES text from the "sql-mode" parameter if it exists.
	The final version should look like the example below.

                # Set the SQL mode to strict


    Save the my.ini file.
    Restart the MySQL Service
    How to stop and start MySQL from the command line:
                net stop mysql
                net start mysql