SQL Server Variables Resetting after Update

[kgs]

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]

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

How to disable MySQL Strict Mode

Introduction On MySQL 5.7, strict mode is enabled by default. Often at time, there are some applications, such as WHMCS that would requires you to disable MySQL strict mode. Here are some of th...

support.cpanel.net

Can you try that and let me know if that works well for you?

 

[kgs]

Thank you! I will try it!

 

[kgs]

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

 

[cPRex]

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