On a fresh install, group by function error is obtained

andreaselia / laravel-analytics

Analytics for the Laravel framework.

MIT License

165 stars 25 forks source link

On a fresh install, group by function error is obtained #21

Closed nachete1987 closed 3 years ago

nachete1987 commented 3 years ago

I installed analytics componen via composer and executed the steps indicated in installation github guide and when I go to analytics page I'm obtaining this error:

SQLSTATE[42000]: Syntax error or access violation: 1055 'page_views.id' isn't in GROUP BY (SQL: select * frompage_viewswhere date(created_at) = 2021-02-20 group bysession)

nachete1987 commented 3 years ago

sorry, the solution was change strict mode in database.php config file to strict => false

andreaselia commented 3 years ago

No worries, I'm happy you sorted it.

Take care.

andreaselia commented 3 years ago

Reopening to apply a fix so the need to disable strict isn't required.

andreaselia commented 3 years ago

@nachete1987 I have tagged a new release, v1.3.3, which should now allow you to keep strict enabled.