Forge + This Package: SQLSTATE[42000]: Syntax error or access violation: 1463 Non-grouping field 'relevance' is used in HAVING clause

[sheyworth]

I have tried turning off MYSQL Strict Tables mode and still get the same issue.

[erikrorstrom]

1+

[simplethemes]

L5.3 has strict mode set to true by default. Check in config/database.php and try:

'strict' => false,

[erikrorstrom]

@simplethemes Thanks! That did it.

[SapneshNaik]

even after disabling strict mode in laravel I have the same issue

Illuminate\Database\QueryException with message 'SQLSTATE[42000]: Syntax error or access violation: 1055 'financetest1.customers.first_name' isn't in GROUP BY (SQL: select * from (select customers.*, max((case when LOWER(customers.first_name) LIKE s then 150 else 0 end) + (case when LOWER(customers.first_name) LIKE s% then 50 else 0 end) + (case when LOWER(customers.first_name) LIKE %s% then 10 else 0 end) + (case when LOWER(customers.last_name) LIKE s then 150 else 0 end) + (case when LOWER(customers.last_name) LIKE s% then 50 else 0 end) + (case when LOWER(customers.last_name) LIKE %s% then 10 else 0 end) + (case when LOWER(customers.id) LIKE s then 120 else 0 end) + (case when LOWER(customers.id) LIKE s% then 40 else 0 end) + (case when LOWER(customers.id) LIKE %s% then 8 else 0 end)) as relevance from customerswherecustomers.deleted_atis null group bycustomers.idhaving relevance >= 7.00 order byrelevancedesc) ascustomerswherecustomers.deleted_at is null)'

[muhajirinlpu]

@SapneshNaik i have same issue

[vdellangela]

I had the same issue with some fields not being part of the GROUP BY. By setting up strict mode to false, it fixes the issue. Thanks!

[hung-f]

thanks sir, i have same problem and to change config/database.php mysql "strict => false" 👍