Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Aiheen aloitti: sirfpsycho - syyskuu 19, 2019, 10:10:36 IP

Otsikko: DB Error
Kirjoitti: sirfpsycho - syyskuu 19, 2019, 10:10:36 IP
'ab***_rthjt75.m.subject' isn't in GROUP BY
File: /home/ab***/public_html/Sources/SayThanks.php
Line: 903

'ab***_rthjt75.b.id_board' isn't in GROUP BY
File: /home/ab***/public_html/Sources/SayThanks.php
Line: 455

'ab***_rthjt75.m.subject' isn't in GROUP BY
File: /home/ab***/public_html/Sources/LikePosts/DB/LikePostsProfileDB.php
Line: 143

Can anyone pllease tell me why this error is coming? Is there any server side work to fix it? If yes then please tell me what to do so that it can be fixed? I have my own server and cPanel installed.
Otsikko: Re: DB Error
Kirjoitti: vbgamer45 - syyskuu 19, 2019, 11:30:42 IP
Yes edit your my.cnf or mysql config file

And remove ONLY_FULL_GROUP_BY in the sql_mode= line


https://stackoverflow.com/questions/23921117/disable-only-full-group-by
Otsikko: Re: DB Error
Kirjoitti: sirfpsycho - syyskuu 20, 2019, 01:54:44 AP
Lainaus käyttäjältä: vbgamer45 - syyskuu 19, 2019, 11:30:42 IP
Yes edit your my.cnf or mysql config file

And remove ONLY_FULL_GROUP_BY in the sql_mode= line


https://stackoverflow.com/questions/23921117/disable-only-full-group-by

Done, Do I need to reinstall mod?
Otsikko: Re: DB Error
Kirjoitti: sirfpsycho - syyskuu 20, 2019, 03:08:17 AP
I reinstalled say thanks mod but still same error. How to fix?
Otsikko: Re: DB Error
Kirjoitti: SpacePhoenix - syyskuu 20, 2019, 04:02:55 AP
Did you remember to reboot the server after making the change to the MySQL configuration file?
Otsikko: Re: DB Error
Kirjoitti: sirfpsycho - syyskuu 20, 2019, 04:08:20 AP
Ok I am checking after reboot. But I changed some names in Modifications.english.php and after reinstalling say thanks these renamed names are not showing on my site. How to fix it? While in Modifications.english.php already names are renamed.
Otsikko: Re: DB Error
Kirjoitti: sirfpsycho - syyskuu 20, 2019, 05:33:30 AP
rebooting couldn't resolve the problem. So I rechecked the lines and corrected the sql-mode to sql_mode and it fixed the issue.

Now the problem is I changed some names in Modifications.english.php and after reinstalling say thanks these renamed names are not showing on my site. How to fix it? While in Modifications.english.php already names are renamed.