Доброго всем дня!) Вот такая проблема возникла после апгрейда PHP c 5ки на 7ку:
File: /var/www/arsenalsb.ru/data/www/arsenal-sb.ru/bitrix/modules/sale/mysql/discount.php
Line: 225
MySQL Query Error: sel ect D.ID as ID, D.LID as LID, D.LID as SITE_ID, D.PRICE_FROM as PRICE_FROM, D.PRICE_TO as PRICE_TO, D.CURRENCY as CURRENCY, D.DISCOUNT_VALUE as DISCOUNT_VALUE, D.DISCOUNT_TYPE as DISCOUNT_TYPE, D.ACTIVE as ACTIVE, D.SORT as SORT, DATE_FORMAT(D.ACTIVE_FROM, '%d.%m.%Y %H:%i:%s') as ACTIVE_FROM, DATE_FORMAT(D.ACTIVE_TO, '%d.%m.%Y %H:%i:%s') as ACTIVE_TO, D.PRIORITY as PRIORITY, D.LAST_DISCOUNT as LAST_DISCOUNT, D.VERSION as VERSION, D.NAME as NAME fr om b_sale_discount D where ((((D.LID = 's1' )))) AND ((((D.ACTIVE = 'Y' )))) AND ((( D.ACTIVE_FROM IS NULL OR NOT (D.ACTIVE_FROM > '2017-07-13 09:22:11')))) AND ((( D.ACTIVE_TO IS NULL OR NOT (D.ACTIVE_TO < '2017-07-13 09:22:11')))) AND ((())) AND ((())) order by D.SORT ASC[[1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))) AND ((())) order by D.SORT ASC' at line 1]
При этом сайт в целом прекрасно работает. Версия Битрикс 16.0.11 MySQL Server version: 5.1.73. Переходим в подтверждение заказа и нате)
Подскажите пожалуйста варианты решения.
Заранее спасибо)
File: /var/www/arsenalsb.ru/data/www/arsenal-sb.ru/bitrix/modules/sale/mysql/discount.php
Line: 225
MySQL Query Error: sel ect D.ID as ID, D.LID as LID, D.LID as SITE_ID, D.PRICE_FROM as PRICE_FROM, D.PRICE_TO as PRICE_TO, D.CURRENCY as CURRENCY, D.DISCOUNT_VALUE as DISCOUNT_VALUE, D.DISCOUNT_TYPE as DISCOUNT_TYPE, D.ACTIVE as ACTIVE, D.SORT as SORT, DATE_FORMAT(D.ACTIVE_FROM, '%d.%m.%Y %H:%i:%s') as ACTIVE_FROM, DATE_FORMAT(D.ACTIVE_TO, '%d.%m.%Y %H:%i:%s') as ACTIVE_TO, D.PRIORITY as PRIORITY, D.LAST_DISCOUNT as LAST_DISCOUNT, D.VERSION as VERSION, D.NAME as NAME fr om b_sale_discount D where ((((D.LID = 's1' )))) AND ((((D.ACTIVE = 'Y' )))) AND ((( D.ACTIVE_FROM IS NULL OR NOT (D.ACTIVE_FROM > '2017-07-13 09:22:11')))) AND ((( D.ACTIVE_TO IS NULL OR NOT (D.ACTIVE_TO < '2017-07-13 09:22:11')))) AND ((())) AND ((())) order by D.SORT ASC[[1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))) AND ((())) order by D.SORT ASC' at line 1]
При этом сайт в целом прекрасно работает. Версия Битрикс 16.0.11 MySQL Server version: 5.1.73. Переходим в подтверждение заказа и нате)
Подскажите пожалуйста варианты решения.
Заранее спасибо)
