or Create a profile
Problems, Issues and Bugs →
21 Nov, 2018 09:10 PM
Hi there, I have upgraded MySQL to 5.7 ,now my hosted fcms website is giving me this error:
" Array (  => 42000  => 1055  => 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.
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:
on 26 Nov, 2018 03:55 PM
What page or action does this error occur?
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.
on 26 Nov, 2018 05:37 PM
Formatting help /
(switch to plain text)
(switch to Markdown)
You can attach files up to 10MB
If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.
The Family Connections staff are involved and working on the issue.
This discussion is private.
Only you and Family Connections support staff can see and reply to it.
This discussion is public. Everyone can see and reply to it.
You can use Command ⌘ instead of Control ^ on Mac
Powered by Tender™.