Database Error Occurred
Error Number: 1055
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'databasename.pi.product_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
How do i make them work ? well i used xampp previously and now at laragon it doesnt
also i used Stored Procedure will this work ?
@manigopal : You can change the settings in my.ini:
I dont find that file,
i found a file in the path C:\laragon\bin\mysql\mysql-5.7.24-winx64
but nothing like this,
so i updated sql_mode=only_full_group_by in that file
Like this and restarted the laragon but nothing worked
well it works good with xampp (PhpMyAdmin) hope there is some setup to be done with Heidel SQL.
onething i found it difficult from migrating (xampp) to laragon.
Switching to PHP versions are easy with Apache but in xampp its PhpMyAdmin but here its Heidel SQL
if there is any separate to upgrade / downgrade the versions that will be good for us.
and as of now the default one is Heidel SQL but for me PhpMyAdmin is better (as i have used longtime) i need to set it as default one.
Also i wanted to have latest Apache / PHP / MySQL (PhpMyAdmin) version could you create a separate thread for it.
@manigopal : It is not a problem of Laragon. It is MySQL recommendation.
The version of MySQL in Laragon is newer and MySQL team suggest you not to use this kind of query. There is better way.
Also, you can down grade to the version like Xampp.
You can add phpMyAdmin to Laragon just 1 click:
**Menu > Tool > Quick add > phpMyAdmin