Здравствуйте.
Появилось ошибка при открытии "Рабочего стола" в панели администратора.
Создавался второй рабочий стол. Ошибка повторилась после добавления гаджета "Статистика по товаром".
Так же гаджет "Сканер безопасности" обнаружил около 300 попыток внедрения вируса. Проверка базы данных и проверка системы ничего не дала.
Прошу помочь.
Заранее спасибо.
[Bitrix\Main\DB\SqlQueryException]
Mysql query error: Subquery returns more than 1 row (400)
SEL ECT
`catalog_catalog_viewed_product`.`PRODUCT_ID` AS `PRODUCT_ID`,
`catalog_catalog_viewed_product_element`.`NAME` AS `NAME`,
(SEL ECT b_catalog_price.PRICE FR OM b_catalog_price
LEFT JOIN b_catalog_group ON b_catalog_group.ID = b_catalog_price.CATALOG_GROUP_ID
WHERE
b_catalog_price.PRODUCT_ID = `catalog_catalog_viewed_product_product`.`ID`
AND
b_catalog_group.base = 'Y'
AND
( b_catalog_price.quantity_from <= 1 OR b_catalog_price.quantity_from IS NULL )
AND
( b_catalog_price.quantity_to >= 1 OR b_catalog_price.quantity_to IS NULL)) AS `PRICE`,
(SEL ECT b_catalog_price.CURRENCY FR OM b_catalog_price
LEFT JOIN b_catalog_group ON b_catalog_group.ID = b_catalog_price.CATALOG_GROUP_ID
WHERE
b_catalog_price.PRODUCT_ID = `catalog_catalog_viewed_product_product`.`ID`
AND
b_catalog_group.base = 'Y'
AND
( b_catalog_price.quantity_from <= 1 OR b_catalog_price.quantity_from IS NULL )
AND
( b_catalog_price.quantity_to >= 1 OR b_catalog_price.quantity_to IS NULL)) AS `CURRENCY`,
(SELECT (CASE WHEN b_catalog_currency_rate.RATE IS NOT NULL THEN b_catalog_currency_rate.RATE ELSE b_catalog_currency.AMOUNT END)
FR OM b_catalog_product INNER JOIN b_catalog_currency ON 1=1
LEFT JOIN b_catalog_currency_rate ON (b_catalog_currency.CURRENCY = b_catalog_currency_rate.CURRENCY AND b_catalog_currency_rate.DATE_RATE <= DATE(b_catalog_product.TIMESTAMP_X))
WHERE b_catalog_product.ID = `catalog_catalog_viewed_product_product`.`ID` AND b_catalog_currency.CURRENCY = (SELECT b_catalog_price.CURRENCY FR OM b_catalog_price
LEFT JOIN b_catalog_group ON b_catalog_group.ID = b_catalog_price.CATALOG_GROUP_ID
WHERE
b_catalog_price.PRODUCT_ID = `catalog_catalog_viewed_product_product`.`ID`
AND
b_catalog_group.base = 'Y'
AND
( b_catalog_price.quantity_from <= 1 OR b_catalog_price.quantity_from IS NULL )
AND
( b_catalog_price.quantity_to >= 1 OR b_catalog_price.quantity_to IS NULL))
ORDER BY DATE_RATE DESC
LIM IT 1) AS `RATE`,
(SELECT (CASE WHEN b_catalog_currency_rate.RATE_CNT IS NOT NULL THEN b_catalog_currency_rate.RATE_CNT ELSE b_catalog_currency.AMOUNT_CNT END)
FR OM b_catalog_product INNER JOIN b_catalog_currency ON 1=1
LEFT JOIN b_catalog_currency_rate ON (b_catalog_currency.CURRENCY = b_catalog_currency_rate.CURRENCY AND b_catalog_currency_rate.DATE_RATE <= DATE(b_catalog_product.TIMESTAMP_X))
WHERE b_catalog_product.ID = `catalog_catalog_viewed_product_product`.`ID` AND b_catalog_currency.CURRENCY = (SELECT b_catalog_price.CURRENCY FR OM b_catalog_price
LEFT JOIN b_catalog_group ON b_catalog_group.ID = b_catalog_price.CATALOG_GROUP_ID
WH ERE
b_catalog_price.PRODUCT_ID = `catalog_catalog_viewed_product_product`.`ID`
AND
b_catalog_group.base = 'Y'
AND
( b_catalog_price.quantity_from <= 1 OR b_catalog_price.quantity_from IS NULL )
AND
( b_catalog_price.quantity_to >= 1 OR b_catalog_price.quantity_to IS NULL))
ORDER BY DATE_RATE DESC
LIM IT 1) AS `CURRENCY_RATE`
FR OM `b_catalog_viewed_product` `catalog_catalog_viewed_product`
INNER JOIN `b_iblock_element` `catalog_catalog_viewed_product_element` ON `catalog_catalog_viewed_product`.`PRODUCT_ID` = `catalog_catalog_viewed_product_element`.`ID`
LEFT JOIN `b_catalog_product` `catalog_catalog_viewed_product_product` ON `catalog_catalog_viewed_product`.`PRODUCT_ID` = `catalog_catalog_viewed_product_product`.`ID`
WH ERE `catalog_catalog_viewed_product`.`DATE_VISIT` >= '2016-06-11 00:00:00'
AND UPPER(`catalog_catalog_viewed_product`.`SITE_ID`) like upper('s1')
/var/www/art-lady/data/www/art-lady.ru/bitrix/modules/main/lib/db/mysqlconnection.php:104
#0: Bitrix\Main\DB\MysqlConnection->queryInternal(string, array, NULL)
/var/www/art-lady/data/www/art-lady.ru/bitrix/modules/main/lib/db/connection.php:332
#1: Bitrix\Main\DB\Connection->query(string)
/var/www/art-lady/data/www/art-lady.ru/bitrix/modules/main/lib/entity/query.php:1735
#2: Bitrix\Main\Entity\Query->query(string)
/var/www/art-lady/data/www/art-lady.ru/bitrix/modules/main/lib/entity/query.php:450
#3: Bitrix\Main\Entity\Query->exec()
/var/www/art-lady/data/www/art-lady.ru/bitrix/gadgets/bitrix/admin_products/index.php:104
#4: include(string)
/var/www/art-lady/data/www/art-lady.ru/bitrix/components/bitrix/desktop/include.php:105
#5: BXGadget->GetGadgetContent(array, array)
/var/www/art-lady/data/www/art-lady.ru/bitrix/components/bitrix/desktop/component.php:819
#6: include(string)
/var/www/art-lady/data/www/art-lady.ru/bitrix/modules/main/classes/general/component.php:472
#7: CBitrixComponent->__includeComponent()
/var/www/art-lady/data/www/art-lady.ru/bitrix/modules/main/classes/general/component.php:515
#8: CBitrixComponent->includeComponent(string, array, boolean)
/var/www/art-lady/data/www/art-lady.ru/bitrix/modules/main/classes/general/main.php:1011
#9: CAllMain->IncludeComponent(string, string, array, boolean, array)
/var/www/art-lady/data/www/art-lady.ru/bitrix/modules/main/interface/desktop.php:36
#10: require(string)
/var/www/art-lady/data/www/art-lady.ru/bitrix/admin/index.php:2
Появилось ошибка при открытии "Рабочего стола" в панели администратора.
Создавался второй рабочий стол. Ошибка повторилась после добавления гаджета "Статистика по товаром".
Так же гаджет "Сканер безопасности" обнаружил около 300 попыток внедрения вируса. Проверка базы данных и проверка системы ничего не дала.
Прошу помочь.
Заранее спасибо.
[Bitrix\Main\DB\SqlQueryException]
Mysql query error: Subquery returns more than 1 row (400)
SEL ECT
`catalog_catalog_viewed_product`.`PRODUCT_ID` AS `PRODUCT_ID`,
`catalog_catalog_viewed_product_element`.`NAME` AS `NAME`,
(SEL ECT b_catalog_price.PRICE FR OM b_catalog_price
LEFT JOIN b_catalog_group ON b_catalog_group.ID = b_catalog_price.CATALOG_GROUP_ID
WHERE
b_catalog_price.PRODUCT_ID = `catalog_catalog_viewed_product_product`.`ID`
AND
b_catalog_group.base = 'Y'
AND
( b_catalog_price.quantity_from <= 1 OR b_catalog_price.quantity_from IS NULL )
AND
( b_catalog_price.quantity_to >= 1 OR b_catalog_price.quantity_to IS NULL)) AS `PRICE`,
(SEL ECT b_catalog_price.CURRENCY FR OM b_catalog_price
LEFT JOIN b_catalog_group ON b_catalog_group.ID = b_catalog_price.CATALOG_GROUP_ID
WHERE
b_catalog_price.PRODUCT_ID = `catalog_catalog_viewed_product_product`.`ID`
AND
b_catalog_group.base = 'Y'
AND
( b_catalog_price.quantity_from <= 1 OR b_catalog_price.quantity_from IS NULL )
AND
( b_catalog_price.quantity_to >= 1 OR b_catalog_price.quantity_to IS NULL)) AS `CURRENCY`,
(SELECT (CASE WHEN b_catalog_currency_rate.RATE IS NOT NULL THEN b_catalog_currency_rate.RATE ELSE b_catalog_currency.AMOUNT END)
FR OM b_catalog_product INNER JOIN b_catalog_currency ON 1=1
LEFT JOIN b_catalog_currency_rate ON (b_catalog_currency.CURRENCY = b_catalog_currency_rate.CURRENCY AND b_catalog_currency_rate.DATE_RATE <= DATE(b_catalog_product.TIMESTAMP_X))
WHERE b_catalog_product.ID = `catalog_catalog_viewed_product_product`.`ID` AND b_catalog_currency.CURRENCY = (SELECT b_catalog_price.CURRENCY FR OM b_catalog_price
LEFT JOIN b_catalog_group ON b_catalog_group.ID = b_catalog_price.CATALOG_GROUP_ID
WHERE
b_catalog_price.PRODUCT_ID = `catalog_catalog_viewed_product_product`.`ID`
AND
b_catalog_group.base = 'Y'
AND
( b_catalog_price.quantity_from <= 1 OR b_catalog_price.quantity_from IS NULL )
AND
( b_catalog_price.quantity_to >= 1 OR b_catalog_price.quantity_to IS NULL))
ORDER BY DATE_RATE DESC
LIM IT 1) AS `RATE`,
(SELECT (CASE WHEN b_catalog_currency_rate.RATE_CNT IS NOT NULL THEN b_catalog_currency_rate.RATE_CNT ELSE b_catalog_currency.AMOUNT_CNT END)
FR OM b_catalog_product INNER JOIN b_catalog_currency ON 1=1
LEFT JOIN b_catalog_currency_rate ON (b_catalog_currency.CURRENCY = b_catalog_currency_rate.CURRENCY AND b_catalog_currency_rate.DATE_RATE <= DATE(b_catalog_product.TIMESTAMP_X))
WHERE b_catalog_product.ID = `catalog_catalog_viewed_product_product`.`ID` AND b_catalog_currency.CURRENCY = (SELECT b_catalog_price.CURRENCY FR OM b_catalog_price
LEFT JOIN b_catalog_group ON b_catalog_group.ID = b_catalog_price.CATALOG_GROUP_ID
WH ERE
b_catalog_price.PRODUCT_ID = `catalog_catalog_viewed_product_product`.`ID`
AND
b_catalog_group.base = 'Y'
AND
( b_catalog_price.quantity_from <= 1 OR b_catalog_price.quantity_from IS NULL )
AND
( b_catalog_price.quantity_to >= 1 OR b_catalog_price.quantity_to IS NULL))
ORDER BY DATE_RATE DESC
LIM IT 1) AS `CURRENCY_RATE`
FR OM `b_catalog_viewed_product` `catalog_catalog_viewed_product`
INNER JOIN `b_iblock_element` `catalog_catalog_viewed_product_element` ON `catalog_catalog_viewed_product`.`PRODUCT_ID` = `catalog_catalog_viewed_product_element`.`ID`
LEFT JOIN `b_catalog_product` `catalog_catalog_viewed_product_product` ON `catalog_catalog_viewed_product`.`PRODUCT_ID` = `catalog_catalog_viewed_product_product`.`ID`
WH ERE `catalog_catalog_viewed_product`.`DATE_VISIT` >= '2016-06-11 00:00:00'
AND UPPER(`catalog_catalog_viewed_product`.`SITE_ID`) like upper('s1')
/var/www/art-lady/data/www/art-lady.ru/bitrix/modules/main/lib/db/mysqlconnection.php:104
#0: Bitrix\Main\DB\MysqlConnection->queryInternal(string, array, NULL)
/var/www/art-lady/data/www/art-lady.ru/bitrix/modules/main/lib/db/connection.php:332
#1: Bitrix\Main\DB\Connection->query(string)
/var/www/art-lady/data/www/art-lady.ru/bitrix/modules/main/lib/entity/query.php:1735
#2: Bitrix\Main\Entity\Query->query(string)
/var/www/art-lady/data/www/art-lady.ru/bitrix/modules/main/lib/entity/query.php:450
#3: Bitrix\Main\Entity\Query->exec()
/var/www/art-lady/data/www/art-lady.ru/bitrix/gadgets/bitrix/admin_products/index.php:104
#4: include(string)
/var/www/art-lady/data/www/art-lady.ru/bitrix/components/bitrix/desktop/include.php:105
#5: BXGadget->GetGadgetContent(array, array)
/var/www/art-lady/data/www/art-lady.ru/bitrix/components/bitrix/desktop/component.php:819
#6: include(string)
/var/www/art-lady/data/www/art-lady.ru/bitrix/modules/main/classes/general/component.php:472
#7: CBitrixComponent->__includeComponent()
/var/www/art-lady/data/www/art-lady.ru/bitrix/modules/main/classes/general/component.php:515
#8: CBitrixComponent->includeComponent(string, array, boolean)
/var/www/art-lady/data/www/art-lady.ru/bitrix/modules/main/classes/general/main.php:1011
#9: CAllMain->IncludeComponent(string, string, array, boolean, array)
/var/www/art-lady/data/www/art-lady.ru/bitrix/modules/main/interface/desktop.php:36
#10: require(string)
/var/www/art-lady/data/www/art-lady.ru/bitrix/admin/index.php:2