Database Error Occurred


  • | 309 points

    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 ?


  • administrators
    | 128420 points

    sql_mode=only_full_group_by
    

    @manigopal : You can change the settings in my.ini:


  • | 309 points

    I dont find that file,

    i found a file in the path C:\laragon\bin\mysql\mysql-5.7.24-winx64
    my.ini

    but nothing like this,
    sql_mode=

    so i updated sql_mode=only_full_group_by in that file

    Like this and restarted the laragon but nothing worked

    [client]
    #password=your_password
    port=3306
    socket=/tmp/mysql.sock

    [mysqld]
    port=3306
    socket=/tmp/mysql.sock
    key_buffer_size=256M
    max_allowed_packet=512M
    table_open_cache=256
    sort_buffer_size=1M
    read_buffer_size=1M
    read_rnd_buffer_size=4M
    myisam_sort_buffer_size=64M
    thread_cache_size=8
    sql_mode=only_full_group_by

    secure-file-priv=""
    explicit_defaults_for_timestamp=1
    datadir= "C:/laragon/data/mysql"

    [mysqldump]
    quick
    max_allowed_packet=512M


  • administrators
    | 128420 points


  • | 309 points

    @leokhoa

    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.


  • administrators
    | 128420 points

    @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


Log in to reply
 

Looks like your connection to Laragon was lost, please wait while we try to reconnect.