WordPress database error: [Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 's062acac_weblog.wp_posts.post_date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]
SELECT DISTINCT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHERE post_date < '2024-05-05 11:39:24' AND post_date != '0000-00-00 00:00:00' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC
buscar en la bitácora
WordPress database error: [Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 's062acac_weblog.wp_posts.post_date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]
SELECT DISTINCT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHERE post_date < '2024-05-05 11:39:24' AND post_date != '0000-00-00 00:00:00' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC
Os recomiendo este programa, que llevo mucho tiempo utilizando. Añade una opción “FileNote” al menú que se abre con el botón derecho del ratón cuando se pulsa en el nombre de un archivo. Te permite abrir un archivo de texto con el mismo nombre del archivo y extensión TXT. Es estupendo cuando te bajas algún programa, y asà ponerle una descripción, para más adelante poder saber que es. Cosa que me pasa muy a menudo 