SQL Upgrade
Hi there, I have upgraded MySQL to 5.7 ,now my hosted fcms website is giving me this error:
" Array ( [0] => 42000 [1] => 1055 [2] => Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'kdymffnf_fcms303.p.category' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by )"
Please assist how to fix this. It works well on MySQL 5.6 but getting error on 5.7. Can anyone kindly assist.
Keyboard shortcuts
Generic
? | Show this help |
---|---|
ESC | Blurs the current field |
Comment Form
r | Focus the comment reply box |
---|---|
^ + ↩ | Submit the comment |
You can use Command ⌘
instead of Control ^
on Mac
Support Staff 1 Posted by Ryan Haudenschi... on 26 Nov, 2018 03:53 PM
Not sure what the problem here is, I'll create a new ticket for this.
For my own personal reference:
https://stackoverflow.com/questions/34115174/error-related-to-only-...
Support Staff 2 Posted by Ryan Haudenschi... on 26 Nov, 2018 03:55 PM
What page or action does this error occur?
3 Posted by Tman Jooma on 26 Nov, 2018 04:30 PM
Hi there Ryan, it's on home page "What's New" and also on Family News page. It does not read the information from the database for these pages.
Support Staff 4 Posted by Ryan Haudenschi... on 26 Nov, 2018 05:37 PM
Awesome, thanks.
5 Posted by Pat Hayes on 02 Mar, 2019 12:14 AM
Hello all,
I seem to be having the same issue. Mysql version 5.7.25
` Could not get What's New data.
Array ( [0] => 42000 [1] => 1055 [2] => Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mrpat_mhf.p.category' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by )`
Should I just hang out for version 3.8.0 or is this not going to work on my host?
Thanks,
Pat
Support Staff 6 Posted by Ryan Haudenschi... on 04 Mar, 2019 04:38 PM
This bug is a problem with mysql 5.7 and later.
It should be fixed in 3.8.0, but I have no idea how long that may be. If your host offers mysql verision earlier than 5.7 that would be the quickest way.