Start a conversation

How do I disable MySQL strict mode on the server?

In order for Kayako Classic Download to run on your server, you'll need to disable 'strict mode' in your MySQL database. You can do this by making a quick change to your configuration file: 

  1. Open either your my.ini or my.cnf file for editing.
    NOTE: Which file you have will depend on whether you're running Windows or Linux. 
  2. Find the following line:
          sql-mode = "STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" 
  3. Change it to:
    sql-mode="" 
  4. After setting this value to blank, you'll need to restart  the MySQL service for the change to take effect.
Choose files or drag and drop files
Was this article helpful?
Yes
No
  1. Varun Shoor

  2. Posted
  3. Updated