Home → Problems, Issues and Bugs →

SQL Upgrade

• Edit

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

   

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

   • Edit

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

   

   What page or action does this error occur?

   • Edit

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

   • Edit

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

   

   Awesome, thanks.

   • Edit

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

   • Edit

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

   • Edit