Ошибка после установки обновлений системы

#
Ошибка после установки обновлений системы
Exception: Query error 42000: SQLSTATE[42000]: Syntax error or access violation: 1
064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near
'SELECT `shop_filter_seo_properties`.`shop_filter_seo_id`, COUNT(*) AS `dataCond' at line 4.

Query: SELECT `shop_filter_seos`.*, `t1`.`dataConditionsCount`, COUNT(*) AS `dataOriginalCount`
FROM `shop_filter_seos`
LEFT OUTER JOIN SELECT `shop_filter_seo_properties`.`shop_filter_seo_id`, COUNT(*) AS `dataConditionsCount`
FROM `shop_filter_seo_properties` GROUP BY `shop_filter_seo_properties`.`shop_filter_seo_id` HAVING `dataConditionsCount` = 0 AS `t1`
ON `shop_filter_seos`.`id` = `t1`.`shop_filter_seo_id`
LEFT OUTER JOIN `shop_filter_seo_properties`
ON `shop_filter_seo_properties`.`shop_filter_seo_id` = `shop_filter_seos`.`id`
WHERE `shop_filter_seos`.`shop_id` = '1' AND `shop_filter_seos`.`active` = 1 AND `shop_filter_seos`.`shop_producer_id` = 0
AND `shop_filter_seo_properties`.`id` IS NULL AND `shop_filter_seos`.`shop_group_id` = 0 GROUP BY `shop_filter_seos`.`id`
ORDER BY `dataOriginalCount` DESC LIMIT 1


36 modules/core/exception.php
597 modules/core/database/pdo.php
80 modules/core/querybuilder/statement.php
2131 modules/shop/controller/show.php
25 hostcmsfiles/lib/lib_6/lib_config_6.php
490 modules/core/command/controller/default.php
195 modules/core/router/route.php
240 index.php


Версия HostCMS: 6.9.2



    Сервер: MySQL (Localhost via UNIX socket)
    Тип сервера: MariaDB
    Версия сервера: 5.5.60-MariaDB - MariaDB Server
    Версия протокола: 10
    Кодировка сервера: UTF-8 Unicode (utf8)
ArpaWeb
Модератор
#
Re: Ошибка после установки обновлений системы
arpaweb,
Ваш вопрос?
Авторизация