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

MAGIQ Documents 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"

• 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.
• 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