crater.users.name isn't in GROUP BY about crater

[mshoaibdev]

I found a solution to this error. In the database config, if you change the strict value to false, It works.

[mohitpanjwani]

Hey! Thanks for reporting the issue.

Can you mention your OS, PHP Version, Database driver(mysql / postgres)?

[mshoaibdev]

When listings customers it shows same error.

PHP version: 7.3.*
Database driver: Mysql

[bee-interactive]

Hey! Thanks for reporting the issue.

Can you mention your OS, PHP Version, Database driver(mysql / postgres)?

Hi !

I'm using a Mac with Mojave, php 7.3, laravel valet and the la test version of mysql. Does this informations help ?

[mohitpanjwani]

Hey! Thanks for reporting the issue.
Can you mention your OS, PHP Version, Database driver(mysql / postgres)?

Hi !

I'm using a Mac with Mojave, php 7.3, laravel valet and the la test version of mysql. Does this informations help ?

Thanks for the info. I think I've got an idea of what the issue might be.

Can you mention your MySQL version? Its happening in newer versions of mysql.

[mohitpanjwani]

I found a solution to this error. In the database config, if you change the strict value to false, It works.

You're right! that would fix it. You can disable the strict mode, for now, to get the job done :)

but we're looking for an alternative solution ( modifying the query itself so it follows the rules).

More info here:
https://stackoverflow.com/questions/41571271/group-by-not-working-laravel

[mohitpanjwani]

Issue has been fixed on following commit: f010712

We'll release a new update asap for users who've already installed the app so they can use the "Update App" feature to get this issue fixed automatically.