<?xml version="1.0" encoding="iso-8859-1"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>MySQL Fatal Error</title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251" />
<style type="text/css">
<!--
body {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 10px;
font-style: normal;
color: #000000;
}
-->
</style>
</head>
<body>
<font size="4">MySQL Error!</font>
<br />------------------------<br />
<br />
<u>The Error returned was:</u>
<br />
<strong>Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'werty_holodilnik.dle_post.date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by</strong>
<br /><br />
</strong><u>Error Number:</u>
<br />
<strong>1055</strong>
<br />
<br />
<textarea name="" rows="10" cols="52" wrap="virtual">SELECT DATE_FORMAT(date,'%b %Y') AS m_date, COUNT(id) AS cnt FROM dle_post WHERE approve AND date < '2025-04-06 12:50:50' GROUP BY m_date ORDER BY date desc</textarea><br />
</body>
</html>