SQL Upgrade

Tman Jooma's Avatar

Tman Jooma

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 ( [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.

  1. Support Staff 1 Posted by Ryan Haudenschi... on 26 Nov, 2018 03:53 PM

    Ryan Haudenschilt's Avatar

    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-...

  2. Support Staff 2 Posted by Ryan Haudenschi... on 26 Nov, 2018 03:55 PM

    Ryan Haudenschilt's Avatar

    What page or action does this error occur?

  3. 3 Posted by Tman Jooma on 26 Nov, 2018 04:30 PM

    Tman Jooma's Avatar

    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.

  4. Support Staff 4 Posted by Ryan Haudenschi... on 26 Nov, 2018 05:37 PM

    Ryan Haudenschilt's Avatar

    Awesome, thanks.

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

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.

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

Recent Discussions

07 Dec, 2018 09:37 PM
07 Dec, 2018 04:55 PM
26 Nov, 2018 05:38 PM
26 Nov, 2018 05:37 PM
26 Nov, 2018 03:44 PM