# aNNiMON (20.04.2020 / 16:15)Запрос можно исправить, что бы настройки не трогать.
Нужно исключить ONLY_FULL_GROUP_BY из sql_mode
*** (+/-)
SELECT `qa_questions`.*,
COALESCE(u1.`name`, qa_questions.author_name) as `author_name`,
u1.`rights` as `author_rights`,
u1.`lastdate`,
u2.`name` as `editor_name`,
UNIX_TIMESTAMP(`created_at`) as `asking_time`,
UNIX_TIMESTAMP(`edited_at`) as `editing_time`,
(SELECT COALESCE(SUM(`value`), 0) FROM qa_question_votes WHERE `qa_questions`.`id` = `question_id`) AS `rating`
FROM `qa_questions`
LEFT JOIN `users` u1 ON `qa_questions`.`author_id` = u1.`id`
LEFT JOIN `users` u2 ON `qa_questions`.`edited_by` = u2.`id`
-- LEFT JOIN `qa_question_votes` ON `qa_questions`.`id` = `qa_question_votes`.`question_id`
WHERE `qa_questions`.`id` = ?И в файле /modules/qa/classes/Actions/AbstractAction.php
на 32-х битных системах могут появиться отрицательные значения(со знаком)
$hash = sprintf("%u", crc32(mb_strtolower($tag)));