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.