sql-mode="NO_ENGINE_SUBSTITUTION" - where to add?

Discussion in 'General' started by sjau, Jul 21, 2017.

  1. sjau

    sjau Local Meanie Moderator

    Hi

    I just upgraded Jessie to Stretch and now I'm trying to upgrade ISPC 3.1.2. to 3.1.6. But it keeps telling me to:
    However I did that and even restarted the server:

    Code:
    root@ispc:~# cat /etc/mysql/mariadb.conf.d/50-server.cnf  
#  
# These groups are read by MariaDB server.  
# Use it for options that only the server (but not clients) should see  
#  
# See the examples of server my.cnf files in /usr/share/mysql/  
#  
 
# this is read by the standalone daemon and embedded servers  
[server]  
 
# this is only for the mysqld standalone daemon  
[mysqld]  
sql-mode="NO_ENGINE_SUBSTITUTION"  
#  
# * Basic Settings
    So, where else does this need to be added?
     
    sjau, Jul 21, 2017
    #1
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    If you have a /etc/mysql/my.cnf file, try to add it there in the [mysqld] section.
     
    till, Jul 21, 2017
    #2
  3. sjau

    sjau Local Meanie Moderator

    yeah, found it out meanwhile :)
     
    sjau, Jul 21, 2017
    #3

Share This Page