whats your table structure? and an example row from it?

Here it is.

id
group_id
song_title_id

Song_title_id relates to:

id
song_title

In the first table, there can be multiple instances of the same song_title_id. And when results are returned, I want there to only one instance of each song_title_id in the results.

Previously, I'd have done:

DB::table('group_songs')
         ->groupBy('song_title_id')
         ->get();

Since updating to PHP 7, I get an error:

Syntax error or access violation: 1055 '[table/column name]' isn't in GROUP BY

Anyone have any ideas? Blocked by this issue on my project.

there are two single quotes in your 'group_songs''

That was when I typed it here. This is happening everywhere I use groupBy.

see http://stackoverflow.com/questions/36228836/syntax-error-or-access-violation-1055-expression-8-of-select-list-is-not-in-gr

I don't have a field to aggregate, though.

Can anyone help me with this groupBy problem? Is there an alternate way to select unique columns? Or is there something wrong with my query above?