Class: CRatings File: /var/www/domains/rostransport.com/bitrix/modules/main/classes/mysql/ratings.php Function: AutoAssignGroup Line: 600 MySQL Query Error:
DELETE ug
FROM b_user_group ug
INNER JOIN (
SELECT
rr.ENTITY_ID as USER_ID
FROM
b_rating_results rr
WHERE
rr.RATING_ID = 4
AND rr.CURRENT_VALUE < 2
) R ON
ug.USER_ID = R.USER_ID AND ug.GROUP_ID = 4[Deadlock found when trying to get lock; try restarting transaction]