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='4422'");
{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'", "4422");
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