Module: form (18.0.0) Class: CForm File: /var/www/www-root/data/www/efesto.pro/bitrix/modules/form/classes/mysql/form_cform.php Function: GetList Line: 155 MySQL Query Error:
SELECT
F.*,
F.SID VARNAME,
F.FIRST_SITE_ID,
F.FIRST_SITE_ID LID,
DATE_FORMAT(F.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') TIMESTAMP_X,
count(distinct D1.ID) C_FIELDS,
count(distinct D2.ID) QUESTIONS,
count(distinct S.ID) STATUSES
FROM
b_form F
LEFT JOIN b_form_2_group G ON (G.FORM_ID=F.ID and G.GROUP_ID in (2))
LEFT JOIN b_form_status S ON (S.FORM_ID = F.ID)
LEFT JOIN b_form_field D1 ON (D1.FORM_ID = F.ID and D1.ADDITIONAL='Y')
LEFT JOIN b_form_field D2 ON (D2.FORM_ID = F.ID and D2.ADDITIONAL<>'Y')
WHERE (1=1) AND (G.FORM_ID IS NULL OR G.PERMISSION>=10)
GROUP BY F.ID
ORDER BY F.C_SORT asc
[[1030] Got error 28 from storage engine]