Disable ONLY_FULL_GROUP_BY

Solution 1: Remove ONLY_FULL_GROUP_BY from mysql console

mysql > SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

you can read more here

Solution 2: Remove ONLY_FULL_GROUP_BY from phpmyadmin

  • Open phpmyadmin & select localhost
  • Click on menu Variables & scroll down for sql mode
  • Click on edit button to change the values & remove ONLY_FULL_GROUP_BY & click on save. 

Related Posts:

  1. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  2. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  3. What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate]
  4. Can’t connect to local MySQL server through socket ‘/var/mysql/mysql.sock’ (38)
  5. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  6. How do I restore a dump file from mysqldump?
  7. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  8. When to use SELECT … FOR UPDATE?
  9. ERROR 1396 (HY000): Operation CREATE USER failed for ‘jack’@’localhost’
  10. Create a new database with MySQL Workbench
  11. Column ‘user_id’ in field list is ambiguous
  12. Database sharding vs partitioning
  13. 1052: Column ‘id’ in field list is ambiguous
  14. Escape string Python for MySQL
  15. 1052: Column ‘id’ in field list is ambiguous
  16. SELECT list is not in GROUP BY clause and contains nonaggregated column …. incompatible with sql_mode=only_full_group_by
  17. Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
  18. difference between primary key and unique key
  19. how to overcome ERROR 1045 (28000): Access denied for user ‘ODBC’@’localhost’ (using password: NO) permanently
  20. SQL ZOO List each continent and the name of the country that comes first alphabetically
  21. MySQL Error #1133 – Can’t find any matching row in the user table
  22. How can I prevent SQL injection in PHP?
  23. Best way to store an array in MySQL database?
  24. Fatal error: Please read “Security” section of the manual to find out how to run mysqld as root
  25. ERROR 1044 (42000): Access denied for user ”@’localhost’ to database ‘db’
  26. MySQL date formats – difficulty Inserting a date
  27. How to install Python MySQLdb module using pip?
  28. Access denied for user ‘root’@’localhost’ (using password: YES) after new installation on Ubuntu
  29. Dump all tables in CSV format using ‘mysqldump’
  30. How to check if mysql database exists
  31. #1062 – Duplicate entry for key ‘PRIMARY’
  32. How to do a batch insert in MySQL
  33. If variable equals value php [duplicate]
  34. MySQL: Cloning a MySQL database on the same MySql instance
  35. mysqldump data only
  36. PHP date() format when inserting into datetime in MySQL
  37. WordPress mysqli and PDO
  38. MySQL Replication Latency Issues in wp-admin pages
  39. Alternative to mysql_real_escape_string
  40. Same option_id=0 for 2 options in wp_options?
  41. How to let a user choose an authors and save it to the database?
  42. How to remove ‘GROUP BY’ from SQL query produced from get_posts?
  43. MySQL LIKE not working
  44. Importing MariaDB into Mysql in WordPress
  45. Is a MySQL DATETIME or TIMESTAMP value retrieved through $wpdb in UTC?
  46. How to get a Google maps SQL->XML->map marker tutorial to work in WordPress
  47. Converting mysql to $wpdb
  48. Update a WordPress post or page takes 60+ seconds
  49. Join new table with SQL query
  50. WordPress installation on valet php 8 (PHP Fatal error: Uncaught mysqli_sql_exception Table ‘wp_options’ doesn’t exist in wp-includes/wp-db.php:2056)
  51. MySQL crashed because of the large number of requests
  52. Why doesn’t this code add a table to my database?
  53. SQL database export-import
  54. add_post_meta does not respect the content
  55. Can Someone Help Me Fix This WordPress Missing Argument Error?
  56. How do I get create a custom table showing the hours remaining for all customers in one page from this transactions page?
  57. Uncaught Error: Call to undefined function mysql_connect() – WordPress installation
  58. SQL Database, repeated tables?
  59. Visual/Text Editor displays blank pages in WP-Admin- but HTML on client side displays correctly
  60. Code to remove authors with no posts connected to them
  61. SQL Query in WordPress – Getting Impossible WHERE error
  62. WordPress create database not working
  63. database optimization and server errors
  64. Setting up WordPress Locally on WAMP for a new site (with one already)
  65. Will reducing mysql permissions hinder WP function? [duplicate]
  66. Calling mysql_query() on another database, assumes WordPress using that database
  67. WordPress VIP realpath Alternative?
  68. querying user bookmarks from a large number of bookmarks
  69. Pull post name from value of a specific meta key
  70. PHP variables in mysql query
  71. Php Mysql Terms
  72. Export SQL query based on custom field?
  73. How to fix the amount of comments displayed for each post?
  74. How do I echo all users’ display_name and their meta_value who have a certain meta_key?
  75. How to simulate web traffic to test performance of a website
  76. SQL query to change custom field in WordPress database
  77. SQL. Select category descendants
  78. MySQL Actibity without any active visitors via Google Analytics
  79. How to configure WordPress Database for CentOS 7
  80. Why should be SQL keywords, like CREATE TABLE and UPDATE, must be uppercase in WordPress?
  81. Why is local wordpress install calling live site executions?
  82. Display MySQL as part of a Page
  83. Migration of wordpress database from mariadb 10.0.20 to 5.5.50
  84. WP Meta Query – mixed AND / OR query doesn’t work
  85. get_results() query not working only when entering strings
  86. Geographical proximity query using post_meta
  87. Add value to array in database
  88. Second completely independent and disposable WordPress installation in subdirectory?
  89. Making CURDATE() recognize current_time()
  90. get_results suddenly not working on a single table
  91. Internal error (500) on local & Fatal error on live when trying to access post type edit screen
  92. Query sql for truncate post_content in wp_posts table
  93. How should I troubleshoot a database serialization issue with a WordPress migration
  94. Foreach only outputs if id is 0
  95. “Error 1064” when importing msql database after updating wordpress version to 4.2.1
  96. remove wordpress post links
  97. SQL get last entry of a specific gravity form
  98. mysqldump to a tar.gz
  99. Postgres equivalent to MySQL’s \G?
  100. Where is my mysql log on OS X?

Leave a Comment