Class: CRatings File: /var/www/didrik-shop/data/www/didrik-shop.ru/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 <> 8055 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=8055
)
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
[[1267] Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=']