А мне не подскажете?
При формировании заказа появляется такое:
File: /home/a/anomal/public_html/bitrix/modules/sale/mysql/deliver y.php
Line: 165
MySQL Query Error: SEL ECT DISTINCT D.ID as ID, D.NAME as NAME, D.LID as LID, D.PERIOD_FR OM as PERIOD_FROM, D.PERIOD_TO as PERIOD_TO, D.PERIOD_TYPE as PERIOD_TYPE, D.WEIGHT_FROM as WEIGHT_FROM, D.WEIGHT_TO as WEIGHT_TO, D.ORDER_PRICE_FROM as ORDER_PRICE_FROM, D.ORDER_PRICE_TO as ORDER_PRICE_TO, D.ORDER_CURRENCY as ORDER_CURRENCY, D.ACTIVE as ACTIVE, D.PRICE as PRICE, D.CURRENCY as CURRENCY, D.SORT as SORT, D.DESCRIPTION as DESCRIPTION FR OM b_sale_delivery D INNER JOIN b_sale_delivery2location D2L ON (D.ID = D2L.DELIVERY_ID) LEFT JOIN b_sale_location2location_group L2LG ON (D2L.LOCATION_TYPE = 'G' AND D2L.LOCATION_ID = L2LG.LOCATION_GROUP_ID) WH ERE ((((D.LID = 'ru' )))) AND ((((D.WEIGHT_FROM <= 1060 )) OR (D.WEIGHT_FROM IS NULL) OR (D.WEIGHT_FROM = 0))) AND ((((D.WEIGHT_TO >= 1060 )) OR (D.WEIGHT_TO IS NULL) OR (D.WEIGHT_TO = 0))) AND ((() OR (D.ORDER_PRICE_FROM IS NULL) OR (D.ORDER_PRICE_FROM = 0))) AND ((() OR (D.ORDER_PRICE_TO IS NULL) OR (D.ORDER_PRICE_TO = 0))) AND ((((D.ACTIVE = 'Y' )))) AND ((())) [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 ') OR (D.ORDER_PRICE_FROM IS NULL) OR (D.ORDER_PRICE_FROM = 0))) AND ((() OR (D.O' at line 1]
DB query error.
Please try later.
При формировании заказа появляется такое:
File: /home/a/anomal/public_html/bitrix/modules/sale/mysql/deliver
Line: 165
MySQL Query Error: SEL ECT DISTINCT D.ID as ID, D.NAME as NAME, D.LID as LID, D.PERIOD_FR OM as PERIOD_FROM, D.PERIOD_TO as PERIOD_TO, D.PERIOD_TYPE as PERIOD_TYPE, D.WEIGHT_FROM as WEIGHT_FROM, D.WEIGHT_TO as WEIGHT_TO, D.ORDER_PRICE_FROM as ORDER_PRICE_FROM, D.ORDER_PRICE_TO as ORDER_PRICE_TO, D.ORDER_CURRENCY as ORDER_CURRENCY, D.ACTIVE as ACTIVE, D.PRICE as PRICE, D.CURRENCY as CURRENCY, D.SORT as SORT, D.DESCRIPTION as DESCRIPTION FR OM b_sale_delivery D INNER JOIN b_sale_delivery2location D2L ON (D.ID = D2L.DELIVERY_ID) LEFT JOIN b_sale_location2location_group L2LG ON (D2L.LOCATION_TYPE = 'G' AND D2L.LOCATION_ID = L2LG.LOCATION_GROUP_ID) WH ERE ((((D.LID = 'ru' )))) AND ((((D.WEIGHT_FROM <= 1060 )) OR (D.WEIGHT_FROM IS NULL) OR (D.WEIGHT_FROM = 0))) AND ((((D.WEIGHT_TO >= 1060 )) OR (D.WEIGHT_TO IS NULL) OR (D.WEIGHT_TO = 0))) AND ((() OR (D.ORDER_PRICE_FROM IS NULL) OR (D.ORDER_PRICE_FROM = 0))) AND ((() OR (D.ORDER_PRICE_TO IS NULL) OR (D.ORDER_PRICE_TO = 0))) AND ((((D.ACTIVE = 'Y' )))) AND ((())) [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 ') OR (D.ORDER_PRICE_FROM IS NULL) OR (D.ORDER_PRICE_FROM = 0))) AND ((() OR (D.O' at line 1]
DB query error.
Please try later.