[wp-trac] [WordPress Trac] #48280: orderby meta_value breaks with newer versions of MySQL

[WordPress Trac]

#48280: orderby meta_value breaks with newer versions of MySQL
---------------------------+------------------------------
 Reporter:  KodieGrantham  |       Owner:  (none)
     Type:  defect (bug)   |      Status:  new
 Priority:  normal         |   Milestone:  Awaiting Review
Component:  Query          |     Version:  5.2.3
 Severity:  normal         |  Resolution:
 Keywords:                 |     Focuses:
---------------------------+------------------------------

Comment (by rfair404):

 In case it is helpful to anyone finding this ticket, I had a similar
 problem. On a fresh install of WP 5.3.2 running on Digital Ocean,
 utilizing their managed database service. I was getting the same error.
 After some research I found that it was related to the ONLY_FULL_GROUP_BY
 setting, as suggested by this article:
 https://www.percona.com/blog/2019/05/13/solve-query-failures-regarding-
 only_full_group_by-sql-mode/ and
 https://www.digitalocean.com/community/questions/sql_mode-
 only_full_group_by

 I changed this setting in my database configuration (added the
 STRICT_TRANS_TABLE) - which resolved the issue.

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/48280#comment:2>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform