1. Home / Knowledge Base Articles Version 8.0 / MySQL produces errors when MySQL settings are not configured properly

Changes to the MySQL ini file that is required for infoRouter version 8.6

SYMPTOMS/REQUIREMENTS:

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

RESOLUTION:

    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.

    Example:
                ...
                ...
                # Set the SQL mode to strict
                sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

                ...
                ...

    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