Only_Full_Group_By Should Be Disabled

Asked 5 years ago

Hi, We Have a dedicated cPanel server with many clients,
How Could we disable " only_full_group_by " on whm / cpanel
for a selected user rather than affect the whole server users ?

Current Version
MariaDB 10.3.28-MariaDB
PHP 7.3

MS
Mian Saleem
Answered 5 years ago
Accepted
Hello,

You don't need to disable the group as SMA does this on session.

Please let me know the issue details so that I can suggest. Are you getting any errors? Please share screenshots.

Thank you
RC
Rise Company
Answered 5 years ago
Inside the Whm Variables We found " only_full_group_by " not used by default, We have only
" STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION "
So, We have no issue also everything is OK with installation, Thanks.
MS
Mian Saleem
Answered 5 years ago
Hello,

I am glad to know that installation is okay.

Thank you for updating
Login to Reply

0	Votes
3	Answers
863	Views

Question: Only_Full_Group_By Should Be Disabled

Only_Full_Group_By Should Be Disabled

Hi, We Have a dedicated cPanel server with many clients, How Could we disable " only_full_group_by " on whm / cpanel for a selected user rather than affect the whole server users ? Current