Class: CRatings File: /home/admin/web/sport-premia.ru/public_html/bitrix/modules/main/classes/mysql/ratings.php Function: DeleteByUser Line: 233 MySQL Query Error:
UPDATE
b_rating_voting_reaction RVR,
(
SELECT
ENTITY_TYPE_ID,
ENTITY_ID,
SUM(case when VALUE > 0 AND USER_ID <> 248721 then '1' else '0' end) as TOTAL_POSITIVE_VOTES
FROM b_rating_vote
WHERE RATING_VOTING_ID IN (
SELECT DISTINCT RV0.RATING_VOTING_ID FROM b_rating_vote RV0 WHERE RV0.USER_ID=248721
)
GROUP BY RATING_VOTING_ID
) as RP
SET
RVR.TOTAL_VOTES = RP.TOTAL_POSITIVE_VOTES
WHERE
RVR.ENTITY_TYPE_ID = RP.ENTITY_TYPE_ID
AND RVR.ENTITY_ID = RP.ENTITY_ID
[[1055] Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'admin_premia.b_rating_vote.ENTITY_TYPE_ID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]