Struggling to turn off Strict SQL

Harry-Sm

• August 08, 2016 09:02

Any advice? Struggling to turn it off. I've got WHM 58 and adjusted the /etc/my.cnf and /usr/my.cnf both the same but to no avail. It's driving me nuts.

• 

  Harry-Sm

  • August 08, 2016 14:11

  To add to this: [root@vps usr]# mysql -e 'select @@GLOBAL.sql_mode;' +-------------------+ | @@GLOBAL.sql_mode | +-------------------+ | | +-------------------+ [root@vps usr]# It's showing as disabled, however it's not in the WHMCS upgrade tool.

  0
• 

  cPanelMichael

  • August 08, 2016 14:35

  It's showing as disabled, however it's not in the WHMCS upgrade tool.

  
  Hello, Please let us know if last post on the following thread is helpful: disable mysql strict mode Thank you.

  0
• 

  Harry-Sm

  • August 08, 2016 14:45

  Hi, Unfortunately not, followed and still no luck. WHMCS still reporting as not working even with sql_mode=NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

  0
• 

  kernow

  • August 08, 2016 16:28

  In /etc/my.cnf try adding this:
  sql_mode=""
  Then restart mysql

  0
• 

  ruzbehraja

  • August 26, 2016 10:37

  Most probably the culprit is the server default settings in /usr/my.cnf Those defaults will override your /etc/my.cnf everytime mysql restarts. cat /usr/my.cnf should show you something like this for it to work:
  # For advice on how to change settings please see # http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html [mysqld] # Remove leading # and set to the amount of RAM for the most important data # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. # innodb_buffer_pool_size = 128M # Remove leading # to turn on a very important data integrity option: logging # changes to the binary log between backups. # log_bin # These are commonly set, remove the # and set as required. # basedir = ..... # datadir = ..... # port = ..... # server_id = ..... # socket = ..... # Remove leading # to set options mainly useful for reporting servers. # The server defaults are faster for transactions and fast SELECTs. # Adjust sizes as needed, experiment to find the optimal values. # join_buffer_size = 128M # sort_buffer_size = 2M # read_rnd_buffer_size = 2M sql_mode=NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
  

  0

Please sign in to leave a comment.