MySQL Query Error:
SELECT COUNT(DISTINCT BE.ID) as C
FROM
b_iblock B
INNER JOIN b_lang L ON B.LID=L.LID
INNER JOIN b_iblock_element BE ON BE.IBLOCK_ID = B.ID
INNER JOIN b_iblock_property FP0 ON FP0.IBLOCK_ID = B.ID AND FP0.CODE='PRIMENIMOST'
INNER JOIN b_iblock_element_property FPV0 ON FPV0.IBLOCK_PROPERTY_ID = FP0.ID AND FPV0.IBLOCK_ELEMENT_ID = BE.ID
left join b_catalog_product as PRD on (PRD.ID = BE.ID)
WHERE 1=1
AND (
(EXISTS (
SELECT IBLOCK_ID FROM b_iblock_site WHERE IBLOCK_ID = B.ID
AND (((SITE_ID='s1')))
))
AND (((BE.ACTIVE_TO >= now() OR BE.ACTIVE_TO IS NULL) AND (BE.ACTIVE_FROM <= now() OR BE.ACTIVE_FROM IS NULL)))
AND ((((BE.ACTIVE='Y'))))
AND ((((BE.IBLOCK_ID = '21'))))
AND ((((FPV0.VALUE LIKE '1220')) OR ((FPV0.VALUE LIKE '1226')) OR ((FPV0.VALUE LIKE '1228')) OR ((FPV0.VALUE LIKE '1229')) OR ((FPV0.VALUE LIKE '4814')) OR ((FPV0.VALUE LIKE '1232')) OR ((FPV0.VALUE LIKE '1233')) OR ((FPV0.VALUE LIKE '1234')) OR ((FPV0.VALUE LIKE '3642')) OR ((FPV0.VALUE LIKE '1235')) OR ((FPV0.VALUE LIKE '1237')) OR ((FPV0.VALUE LIKE '1238')) OR ((FPV0.VALUE LIKE '1241')) OR ((FPV0.VALUE LIKE '1242')) OR ((FPV0.VALUE LIKE '1243')) OR ((FPV0.VALUE LIKE '2794')) OR ((FPV0.VALUE LIKE '1245')) OR ((FPV0.VALUE LIKE '2773')) OR ((FPV0.VALUE LIKE '1248')) OR ((FPV0.VALUE LIKE '1249')) OR ((FPV0.VALUE LIKE '1250')) OR ((FPV0.VALUE LIKE '1252')) OR ((FPV0.VALUE LIKE '1253')) OR ((FPV0.VALUE LIKE '1254')) OR ((FPV0.VALUE LIKE '1255')) OR ((FPV0.VALUE LIKE '4435')) OR ((FPV0.VALUE LIKE '4082')) OR ((FPV0.VALUE LIKE '1259')) OR ((FPV0.VALUE LIKE '3053')) OR ((FPV0.VALUE LIKE '1261')) OR ((FPV0.VALUE LIKE '1262')) OR ((FPV0.VALUE LIKE '1264')) OR ((FPV0.VALUE LIKE '1265')) OR ((FPV0.VALUE LIKE '1257')) OR ((FPV0.VALUE LIKE '4655')) OR ((FPV0.VALUE LIKE '1267')) OR ((FPV0.VALUE LIKE '1269')) OR ((FPV0.VALUE LIKE '3641'))))
)
AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL)))
AND ((
B.ID IN (
SELECT IBLOCK_ID
FROM b_iblock_group IBG
WHERE IBG.GROUP_ID IN (2)
AND IBG.PERMISSION >= 'R'
AND (IBG.PERMISSION='X' OR B.ACTIVE='Y')
)
OR (B.RIGHTS_MODE = 'E' AND EXISTS (
SELECT ER.ELEMENT_ID
FROM b_iblock_element_right ER
INNER JOIN b_iblock_right IBR ON IBR.ID = ER.RIGHT_ID
INNER JOIN b_user_access UA ON UA.ACCESS_CODE = IBR.GROUP_CODE AND UA.USER_ID = 0
WHERE ER.ELEMENT_ID = BE.ID
AND IBR.OP_EREAD = 'Y'
))
))
[[2006] MySQL server has gone away]
DB query error.
Please try later.
|
|
Fatal error: Uncaught Bitrix\Main\DB\SqlQueryException: Mysql query error: (2006) MySQL server has gone away in /home/bitrix/ext_www/xn--80apgbidj1a.xn--p1ai/bitrix/modules/main/lib/db/mysqliconnection.php:145
Stack trace:
#0 /home/bitrix/ext_www/xn--80apgbidj1a.xn--p1ai/bitrix/modules/main/lib/db/connection.php(330): Bitrix\Main\DB\MysqliConnection->queryInternal()
#1 /home/bitrix/ext_www/xn--80apgbidj1a.xn--p1ai/bitrix/modules/main/lib/orm/query/query.php(3304): Bitrix\Main\DB\Connection->query()
#2 /home/bitrix/ext_www/xn--80apgbidj1a.xn--p1ai/bitrix/modules/main/lib/orm/query/query.php(816): Bitrix\Main\ORM\Query\Query->query()
#3 /home/bitrix/ext_www/xn--80apgbidj1a.xn--p1ai/bitrix/modules/main/lib/orm/data/datamanager.php(500): Bitrix\Main\ORM\Query\Query->exec()
#4 /home/bitrix/ext_www/xn--80apgbidj1a.xn--p1ai/bitrix/modules/main/lib/analytics/sitespeed.php(95): Bitrix\Main\ORM\Data\DataManager::getList()
#5 /home/bitrix/ext_www/xn--80apgbidj1a.xn--p1ai/bitrix/modules/main/lib/analytics/counter.php(92): Bitrix\Main in
/home/bitrix/ext_www/xn--80apgbidj1a.xn--p1ai/bitrix/modules/main/lib/db/mysqliconnection.php on line
145