SQL Server Variables Resetting after Update

kgs

• December 15, 2020 08:51

Howdy! I recently upgraded our VPS's MySQL to 5.7 and had to disable strict mode in order to continue running an old PHP app. This is how I did it: WHM > phpmyadmin > variables tab > sql mode [edit] Then I just removed STRICT_TRANS_TABLES from the sql mode settings. I noticed that those settings had recently reverted to default, I assume because of a CPanel update, but I don't know for sure. So I just removed STRICT_TRANS_TABLES again. My question is: is there a way to keep these settings from reverting? Thanks!

• 

  cPRex Jurassic Moderator

  • December 15, 2020 18:48

  Hey there! We have an article that explains how to make this change in a way that sticks here:

  0
• 

  kgs

  • December 15, 2020 18:56

  Thank you! I will try it!

  0
• 

  kgs

  • December 15, 2020 20:22

  Rockin'! Easy peasy. Hopefully that will hold now. :) Thanks so much!

  0
• 

  cPRex Jurassic Moderator

  • December 15, 2020 20:24

  If you run into any other issues, you know where to find me!

  0

Please sign in to leave a comment.