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.

  5. 5 Posted by Pat Hayes on 02 Mar, 2019 12:14 AM

    Pat Hayes's Avatar

    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

  6. Support Staff 6 Posted by Ryan Haudenschi... on 04 Mar, 2019 04:38 PM

    Ryan Haudenschilt's Avatar

    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.

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

27 Jun, 2019 05:03 PM
19 Apr, 2019 12:58 PM
18 Apr, 2019 03:28 PM
09 Apr, 2019 01:16 AM
12 Mar, 2019 03:10 PM