search

staudenmeir / eloquent-eager-limit

Laravel Eloquent eager loading with limit
MIT License
880 stars 62 forks source link

The trait cannot been seen #49

Closed kingdomac closed 2 years ago

kingdomac commented 2 years ago

SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

staudenmeir commented 2 years ago

What database and version are you using? What query are you running?

kingdomac commented 2 years ago

I added a group by for all the columns of the second table result and it works fine.