search

silverstripe / silverstripe-widgets

Widgets subsystem for Silverstripe CMS
http://silverstripe.org
BSD 3-Clause "New" or "Revised" License
38 stars 55 forks source link

Expression #1 of SELECT list is not in GROUP BY clause #144

Closed sageworksstudio closed 6 years ago

sageworksstudio commented 7 years ago

Activating the 'Archive' widget produces this error:

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'abcdxyz.BlogPost_Live.PublishDate' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

MySQL server version: 5.7.17-0ubuntu0.16.04.1 - (Ubuntu)

micahsheets commented 7 years ago

I am also getting this error with the widgets module and MySQL version 5.7

robbieaverill commented 7 years ago

Hey @digi-brains + @micahsheets - which version of SilverStripe and widgets are you using?

LABCAT commented 7 years ago

hi @robbieaverill I am also getting this error with same server configuration. I am using tag 1.2.5 of widgets.

dhensby commented 7 years ago

Related: #5451

This is because MySQL 5.7 has changed it's default behaviour

sageworksstudio commented 7 years ago

@robbieaverill 1.2.4

micahsheets commented 7 years ago

I installed silverstripe 3.6.0 with composer set to * for both blog and widgets.

dhensby commented 7 years ago

I installed silverstripe 3.6.0 with composer set to * for both blog and widgets.

we need to know which version is installed. composer show might show you which version is installed

micahsheets commented 7 years ago

SS 3.6.0

Blog 2.4.5

Widgets 1.2.5

Micah Sheets

Sonic Eye Technologies 2647 E 33rd Ave. Spokane, WA 99223 509-939-4739 micah@soniceyetec.biz mailto:micah@soniceyetec.biz

On Jun 15, 2017, at 8:57 AM, Daniel Hensby notifications@github.com wrote:

I installed silverstripe 3.6.0 with composer set to * for both blog and widgets.

we need to know which version is installed. composer show might show you which version is installed

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/silverstripe/silverstripe-widgets/issues/144#issuecomment-308782401, or mute the thread https://github.com/notifications/unsubscribe-auth/AA-atNdOZas9bvZaRo0206mSQrCF1DVPks5sEVRsgaJpZM4Lv_o3.

sageworksstudio commented 7 years ago

Sorry...forgot to add which SS and blog version...

SS: 3.5.3 Widgets: 1.2.4 Blog: 2.4.5

robbieaverill commented 6 years ago

Fixed by https://github.com/silverstripe/silverstripe-blog/pull/446