{"id":206771,"date":"2019-11-09T07:51:49","date_gmt":"2019-11-09T07:51:49","guid":{"rendered":"https:\/\/webkul.com\/blog\/?p=206771"},"modified":"2019-11-18T07:47:48","modified_gmt":"2019-11-18T07:47:48","slug":"disable-only_full_group_by-in-doctrine","status":"publish","type":"post","link":"https:\/\/webkul.com\/blog\/disable-only_full_group_by-in-doctrine\/","title":{"rendered":"Disable ONLY_FULL_GROUP_BY in doctrine"},"content":{"rendered":"\n

Anxious from getting an exception of ONLY_FULL_GROUP_BY with the Symfony project .?<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

There is a best and simple solution if you want to get rid of this exception from a particular Symfony project, all you need to do is, you have to update the configuration of the doctrine.<\/p>\n\n\n\n

# Doctrine Configuration\ndoctrine:\n    dbal:\n        driver:   pdo_mysql\n        host:     "%database_host%"\n        port:     "%database_port%"\n        dbname:   "%database_name%"\n        user:     "%database_user%"\n        password: "%database_password%"\n        charset:  UTF8<\/pre>\n\n\n\n
You need to add 1002 <\/strong>key inside the options<\/strong> key with the value ‘SET sql_mode=(SELECT REPLACE(@@sql_mode, “ONLY_FULL_GROUP_BY”, “”))’<\/strong> under the dbal configuration.
Like this:- <\/p>\n\n\n\n
# Doctrine Configuration\ndoctrine:\n    dbal:\n        driver:   pdo_mysql\n        host:     "%database_host%"\n        port:     "%database_port%"\n        dbname:   "%database_name%"\n        user:     "%database_user%"\n        password: "%database_password%"\n        charset:  UTF8\n        options:\n            1002: 'SET sql_mode=(SELECT REPLACE(@@sql_mode, "ONLY_FULL_GROUP_BY", ""))'<\/pre>\n\n\n\n
That’s it. Now clear the cache if you’re having any trouble otherwise you’re ready to go.<\/p>\n\n\n\n
moreover, if you want to change this configuration globally (for all of the projects),  you could either do it from MySQL console or from PHPMyAdmin.

1:- From MySQL console<\/p>\n\n\n\n
mysql > SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));<\/pre>\n\n\n\n
2:- From phpmyadmin<\/p>\n\n\n