#1055 – Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this is incompatible with sql_mode=only_full_group_by

I had a struggle getting this to work i’ve tested it and it’s working on lamp server mysql version 5.12

So, steps to success:

  1. sudo vim /etc/mysql/conf.d/mysql.cnf
  2. Scroll to the bottom of file Copy and paste[mysqld] sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

to the bottom of the file

  1. save and exit input mode
  2. sudo service mysql restart to restart MySQL.

Done!

Related Posts:

  1. SELECT list is not in GROUP BY clause and contains nonaggregated column …. incompatible with sql_mode=only_full_group_by
  2. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  3. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  4. MySQL Error “Operand should contain 1 column”
  5. How to use MySQL DECIMAL?
  6. MySQL ERROR 1290 (HY000) –secure-file-priv option
  7. MySQL server startup error ‘The server quit without updating PID file’
  8. MySQL DROP all tables, ignoring foreign keys
  9. When to use SELECT … FOR UPDATE?
  10. Setting up foreign keys in phpMyAdmin?
  11. ERROR 1396 (HY000): Operation CREATE USER failed for ‘jack’@’localhost’
  12. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  13. ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111)
  14. mysql is not recognised as an internal or external command,operable program or batch
  15. MySQL error code: 1175 during UPDATE in MySQL Workbench
  16. java.sql.SQLException: Access denied for user ‘root’@’localhost’ (using password: YES)
  17. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  18. Data truncated for column?
  19. How to convert a string to date in MySQL?
  20. MySQL COUNT DISTINCT
  21. Access denied; you need (at least one of) the SUPER privilege(s) for this operation
  22. How to find MySQL process list and to kill those processes?
  23. MySQL date format DD/MM/YYYY select query?
  24. Create a temporary table in a SELECT statement without a separate CREATE TABLE
  25. MySQL Server on MAMP-Windows Will Not Start
  26. SQL statement not working – “Operand type clash: date is incompatible with int’
  27. How can I output MySQL query results in CSV format?
  28. Error: select command denied to user ‘‘@’‘ for table ‘‘
  29. How can I search (case-insensitive) in a column using LIKE wildcard?
  30. #1214 – The used table type doesn’t support FULLTEXT indexes
  31. importing a CSV into phpmyadmin
  32. How can I rebuild indexes and update stats in MySQL innoDB?
  33. MySQL Error 1215: Cannot add foreign key constraint
  34. Node.js MySQL – Error: connect ECONNREFUSED
  35. How to use the keyword ‘references’ in MySQL?
  36. select * from table where column = something or, when unavailable, column = something else
  37. Differences between utf8 and latin1
  38. There can be only one auto column
  39. What are the recommended database permissions for WordPress?
  40. What’s a good strategy for planning WordPress DB growth?
  41. How can I find the source of slow queries in WordPress?
  42. $wpdb and MySQL Create Trigger
  43. Problems with DBDelta with FOREIGN key?
  44. Fulltext search in posts sorted by relevancy
  45. Error: MySQL shutdown unexpectedly. XAMPP local conf running WordPress
  46. How can I SQL update a meta_value to remove the dollar signs that were entered with the value? (so just the value remains)
  47. How can I make wordpress suppress mysql errors?
  48. How to bulk delete all WordPress subscribers?
  49. Error while importing database
  50. What are the issues associated with upgrading MySQL for WordPress?
  51. Changing Table Prefix for an Existing WordPresss Site
  52. Set meta_key and meta_value for all registered user in wordpress using sql query [closed]
  53. Connect another DB and fetch records from some tables
  54. Can I restart MySQL engine when WordPress website is live?
  55. Error: MySQL shutdown unexpectedly [closed]
  56. Why my wordpress loopback traffic while socket is setup?
  57. Slow wp-admin due to “SELECT DISTINCT post_mime_type FROM wp_posts WHERE post_type = ‘attachment'”
  58. Update or insert meta key value – On Duplicate key update
  59. Connect to MySQL using Windows Authentication
  60. Defining the same price to all WooCommerce Products
  61. Database Structure on Different Servers
  62. Changing MySQL password via WHM – does this affect WordPress?
  63. How to get INSERT errors from $wpdb?
  64. How to set MYSQLI_OPT_INT_AND_FLOAT_NATIVE option
  65. Export Yoast Keywords from MySQL/phpMyAdmin
  66. Same database; different WordPress
  67. How to insert dash (-) into database using wpdb and new_to_publish hook?
  68. MySQL: How to change url in posts from xxx.com to yyy.org?
  69. How to fetch all meta_key and meta_value using post_id wihout duplication of post meta using sql query
  70. WordPress unescape text on mysql?
  71. Getting data from Mysql Table..confusing
  72. Upgrade DB Loop – WordPress DB Version Conflict
  73. WordPress & MySQL , problem with use many array in meta_query
  74. mysql – Delete keyword with link from wordpress post database
  75. Creating dynamic content and pages for 1000’s of locations
  76. Remove duplicate media entries from mysql database
  77. Button writing to MYSQL database
  78. In a MySQL query, one of the columns in the LEFT JOIN returns “Unknown column”
  79. DB option update with wp-cli
  80. MySQL ‘duplicate entry’ error
  81. WordPress Dutch characters encoding problem
  82. How to show result of sql query in a page?
  83. Why can’t i come back to older working version of php after ugrade with error log on php 7.2 and 7.3
  84. 403 Forbidden home on localhost with nginx server
  85. How do I insert content of various MySQL fields in post?
  86. Select latest 2 articles, but only from given category
  87. CONCAT_WS in custom sql query
  88. Query does not filter duplicate _sku numbers
  89. Ordering topics by most replies in X days using MYSQL statement
  90. MySQL Select within WP Page template
  91. #1115 – Unknown character set: ‘utf8mb4’
  92. wp_postmeta – lot of meta fields
  93. Running WordPress from MySQL Cluster with HAPRoxy
  94. Delete posts with word count less than x number of words
  95. MySQL: get post_tag items that are tags (not SEO keywords)
  96. $wpdb->get_var returns 0
  97. cannot log in to the mysql server (wamp and wordpress)
  98. SQL command to export post_content from wp_posts using phpMyAdmin
  99. InnoDB: Error: log file ./ib_logfile0 is of different size
  100. Postgres equivalent to MySQL’s \G?

Leave a Comment

error code: 523