Ты снова и снова меня удивляешь, АВИЛОН!

SQL[1055] Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'sitebs.cm.author' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

{KERNEL_DIR}/include/mysql.php: 50
query_mysql->query("SELECT h.com_public,(CASE WHEN cnt>0 THEN cnt ELSE 0 END)cnt,(CASE WHEN md>0 THEN md ELSE 0 END)mid FROM htdocs h LEFT JOIN (SELECT COUNT(cm.id) cnt,AVG(cm.rate) md,cm.htdoc_id,cm.author FROM comments cm INNER JOIN users u ON (cm.author=u.id) WHERE cm.public='1' AND 1=1 GROUP BY cm.htdoc_id) as c ON (h.id=c.htdoc_id) WHERE h.id='36354'");
{KERNEL_DIR}/modules/comments/main.php: 29
query_mysql->format("SELECT h.com_public,(CASE WHEN cnt>0 THEN cnt ELSE 0 END)cnt,(CASE WHEN md>0 THEN md ELSE 0 END)mid FROM htdocs h LEFT JOIN (SELECT COUNT(cm.id) cnt,AVG(cm.rate) md,cm.htdoc_id,cm.author FROM comments cm INNER JOIN users u ON (cm.author=u.id) WHERE cm.public='1' AND 1=1 GROUP BY cm.htdoc_id) as c ON (h.id=c.htdoc_id) WHERE h.id='%d'", "36354");
{KERNEL_DIR}/include/common.php: 46
include("{KERNEL_DIR}/modules/comments/main.php");
{DOCUMENT_ROOT}/ajax/comments.php: 7
module("/comments/main.php");
{KERNEL_DIR}/modules/htdocs/templates/postfix.phpt: 41
require_once("{DOCUMENT_ROOT}/ajax/comments.php");
{KERNEL_DIR}/include/common.php: 64
include("{KERNEL_DIR}/modules/htdocs/templates/postfix.phpt");

{KERNEL_DIR}/modules/htdocs/postfix.php: 33
template("{KERNEL_DIR}/modules/htdocs/templates/postfix.phpt", Array ( [tape] => Array ( [0] => Array ( [id] => 113913 [title] => «Лидер Казань» – профессионал в организации туров и экскурсий [created] => 1746127756 [published] => 1746127756 [updated] => 0 [path] => /blogs/113913.html ) [1] => Array ( [id] => 113912 [title] => Огнев.бай: качество мангалов для дачи [created] => 1746121483 [published] => 1746121483 [updated] => 0 [path] => /blogs/113912.html ) [2] => Array ( [id] => 113911 [title] => Как можно оплачивать доставку еды: наличные, карты, бонусы [created] => 1746112294 [published] => 1746112294 [updated] => 0 [path] => /blogs/113911.html ) [3] => Array ( [id] => 113910 [title] => ТОП казино онлайн 2025 [created] => 1746106754 [published] => 1746106754 [updated] => 0 [path] => /blogs/113910.html ) [4] => Array ( [id] => 113909 [title] => Как и чем очистить шторы без снятия? [created] => 1746105044 [published] => 1746105044 [updated] => 0 [path] => /blogs/113909.html ) ) [tags] => Array ( [0] => Array ( [id] => 32970 [name] => AVILON ) [1] => Array ( [id] => 22582 [name] => mercedes-benz ) [2] => Array ( [id] => 31909 [name] => АВИЛОН ) [3] => Array ( [id] => 32994 [name] => волгоградский ) [4] => Array ( [id] => 32995 [name] => Мерседес-Бенц ) ) [str_tags] => Array ( [0] => AVILON [1] => mercedes-benz [2] => АВИЛОН [3] => волгоградский [4] => Мерседес-Бенц ) [link_tag] => AVILON, mercedes-benz, АВИЛОН, волгоградский, Мерседес-Бенц ) );

{KERNEL_DIR}/include/common.php: 46
include("{KERNEL_DIR}/modules/htdocs/postfix.php");
{KERNEL_DIR}/tmp/maket#2.phpt: 264
module("/htdocs/postfix.php");
{KERNEL_DIR}/include/common.php: 64
include("{KERNEL_DIR}/tmp/maket#2.phpt");
{KERNEL_DIR}/include/common.php: 352
template("{KERNEL_DIR}/tmp/maket#2.phpt");
{KERNEL_DIR}/router.php: 254
maket(2);
{DOCUMENT_ROOT}/errdoc.php: 5
include_once("{KERNEL_DIR}/router.php");

Strict Standards: Only variables should be assigned by reference in /var/www/sitebs_ru_usr/data/www/sitebs.ru/aquilon/include/common.php on line 135

Strict Standards: Only variables should be assigned by reference in /var/www/sitebs_ru_usr/data/www/sitebs.ru/aquilon/include/session.php on line 60