Class: CRatings File: /var/www/domains/rostransport.com/bitrix/modules/main/classes/mysql/ratings.php Function: BuildRating Line: 60 MySQL Query Error:
UPDATE
b_rating_results RR,
( SELECT 'USER' ENTITY_TYPE_ID, RC.ENTITY_ID, SUM(RC.CURRENT_VALUE) CURRENT_VALUE
FROM b_rating_component_results RC INNER JOIN b_rating_results RR on RR.RATING_ID = RC.RATING_ID and RR.ENTITY_ID = RC.ENTITY_ID
WHERE RC.RATING_ID = 4
GROUP BY RC.ENTITY_ID
) as RCR
SET
RR.PREVIOUS_VALUE = IF(RR.CURRENT_VALUE = RCR.CURRENT_VALUE, RR.PREVIOUS_VALUE, RR.CURRENT_VALUE),
RR.CURRENT_VALUE = RCR.CURRENT_VALUE
WHERE
RR.RATING_ID=4
and RR.ENTITY_TYPE_ID = RCR.ENTITY_TYPE_ID
and RR.ENTITY_ID = RCR.ENTITY_ID
[Deadlock found when trying to get lock; try restarting transaction]