Class: CRatings File: /home/deloshop/public_html/bitrix/modules/main/classes/mysql/ratings.php Function: BuildRating Line: 41 MySQL Query Error:
INSERT INTO b_rating_results
(RATING_ID, ENTITY_TYPE_ID, ENTITY_ID, CURRENT_VALUE, PREVIOUS_VALUE)
SELECT
3 RATING_ID,
'USER' ENTITY_TYPE_ID,
RC.ENTITY_ID,
SUM(RC.CURRENT_VALUE) CURRENT_VALUE,
0 PREVIOUS_VALUE
FROM
b_rating_component_results RC LEFT JOIN b_rating_results RR ON RR.RATING_ID = RC.RATING_ID and RR.ENTITY_ID = RC.ENTITY_ID
WHERE
RC.RATING_ID = 3 and RR.ID IS NULL
GROUP BY RC.ENTITY_ID[Table './deloshop_info9/b_rating_component_results' is marked as crashed and should be repaired]