First log in to you server using SSH (you will need sudo privileges), first you need to find your
my.cnffile (make sure you edit the correct file, the one that MySQL loads), open it and then change the
sql_modeparameter (located below the [mysqld] text) to this (if it does not already exist, add it) OR you could add a new file inside the
/etc/mysql/conf.d/directory, name it
disable_strict_mode.cnfand add the lines below.
Code: Select all
Save and exit your text editor. Then restart mysql.
sudo systemctl restart mysql
Now you're done and Koken should work just fine and not mess up your database tables!
If you'd like to dive more into why I've selected these modes, check out the MySQL documentation.
You can read about some of the Koken issues with strict mode on these urls: