Scale up as you grow — whether you're running one virtual machine or ten thousand.

From GPU-powered inference and Kubernetes to managed databases and storage, get everything you need to build, scale, and deploy intelligent applications.

Hi, We’re using DO managed database for two of our Wordpress sites, one of them shows the following error with debug=true in wp-config.php
WordPress database error: [Expression #1 of ORDER BY clause is not in SELECT list, references column ‘wordpress-programs.wp_posts.post_date’ which is not in SELECT list; this is incompatible with DISTINCT] SELECT DISTINCT YEAR( post_date ) AS year, MONTH( post_date ) AS month FROM wp_posts WHERE post_type = ‘attachment’ ORDER BY post_date DESC
Wordpress 5.2.3. PHP 7.3.9-1+ubuntu18.04.1+deb.sury.org+1, MySQL 8.0.16 - Linux
The other site is just fine, see config below and the content is identical i.e we have similar posts on both
Wordpress 5.2.3 PHP 7.2.19-0ubuntu0.18.04.2, MySQL 8.0.16 - Linux
We’ve tried the fixes for Disable ONLY_FULL_GROUP_BY from the following link but didn’t help. Can you please review and help?
https://stackoverflow.com/questions/23921117/disable-only-full-group-by
Thanks James
Chris
twcinnovations
richard.wilson
richard.wilson
richard.wilson
rich
b4dbf29d32f847318da467ebae7220
Yakin
caio_fr_sp
Abhishek M S
lnxfsf