The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Is mysql strict mode default or has that changed recently?

Discussion in 'Database Discussions' started by delia, Feb 5, 2016.

  1. delia

    delia Member

    Joined:
    Feb 11, 2008
    Messages:
    20
    Likes Received:
    1
    Trophy Points:
    3
    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
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    651
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  3. vanessa

    vanessa Well-Known Member
    PartnerNOC

    Joined:
    Sep 26, 2006
    Messages:
    817
    Likes Received:
    22
    Trophy Points:
    18
    Location:
    Virginia Beach, VA
    cPanel Access Level:
    DataCenter Provider
    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.
     
    cPanelMichael likes this.
Loading...

Share This Page