Is mysql strict mode default or has that changed recently?

delia

• February 05, 2016 16:37

I have whmcs installed and after an upgrade, I can no longer update things. Their support says it's because I have mysql strict mode enabled. So my question is, has any cpanel upgrade recently changed this on a server? I did not deliberately choose strict mode. To my knowledge the server has always set this way. I'm on whm 54

• 

  cPanelMichael

  • February 08, 2016 17:23

  Hello :) Could you let us know the contents of your /etc/my.cnf file? Thank you.

  0
• 

  vanessa

  • February 08, 2016 18:33

  Also check to see if /usr/my.cnf exists and has this setting in it. It should be: sql_mode = NO_ENGINE_SUBSTITUTION I've seen quite a few servers where this extra my.cnf exists and since it loads after /etc/my.cnf, it overwrites anything in there. You could also just delete this file.

  0

Please sign in to leave a comment.