/docs/bitrix/modules/sale/mysql/discount.php
[COLOR=#ff0000]MySQL Query Error: SEL ECT DISTINCT D.ID as ID, D.LID as LID, D.LID as SITE_ID, D.PRICE_FR OM 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 FR OM b_sale_discount D WH ERE ((((D.LID = 's1' )))) AND ((((D.ACTIVE = 'Y' )))) AND ((( D.ACTIVE_FROM IS NULL OR NOT (D.ACTIVE_FROM > '2012-03-25 10:27:16')))) AND ((( D.ACTIVE_TO IS NULL OR NOT (D.ACTIVE_TO < '2012-03-25 10:27:16')))) AND (((((D.CURRENCY = 'RUB' AND (D.PRICE_FROM <= 167300 OR D.PRICE_FROM IS NULL OR D.PRICE_FROM = 0)) OR (D.CURRENCY = 'USD' AND (D.PRICE_FROM <= 7149,57 OR D.PRICE_FROM IS NULL OR D.PRICE_FROM = 0)) OR (D.CURRENCY = 'EUR' AND (D.PRICE_FROM <= 4509,43 OR D.PRICE_FROM IS NULL OR D.PRICE_FROM = 0)))))) AND (((((D.CURRENCY = 'RUB' AND (D.PRICE_TO >= 167300 OR D.PRICE_TO IS NULL OR D.PRICE_TO = 0)) OR (D.CURRENCY = 'USD' AND (D.PRICE_TO >= 7149,57 OR D.PRICE_TO IS NULL OR D.PRICE_TO = 0)) OR (D.CURRENCY = 'EUR' AND (D.PRICE_TO >= 4509,43 OR D.PRICE_TO IS NULL OR D.PRICE_TO = 0)))))) ORDER BY D.SORT ASC [/COLOR][Operand should contain 1 column(s)]
[TABLE]
[TR][TD]
[TABLE]
[TR][TD][SIZE=-1][COLOR=#FF0000][B]DB query error.[/B][/COLOR]
Please try later. [/SIZE]
[/TD][/TR]
[/TABLE]
[/TD][/TR]
[/TABLE]
[B][SIZE=4]подскажите в чем может быть проблема? на ровном месте упало не знаем на что валить, вроде ничего не делали[/SIZE][/B]
[COLOR=#ff0000]MySQL Query Error: SEL ECT DISTINCT D.ID as ID, D.LID as LID, D.LID as SITE_ID, D.PRICE_FR OM 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 FR OM b_sale_discount D WH ERE ((((D.LID = 's1' )))) AND ((((D.ACTIVE = 'Y' )))) AND ((( D.ACTIVE_FROM IS NULL OR NOT (D.ACTIVE_FROM > '2012-03-25 10:27:16')))) AND ((( D.ACTIVE_TO IS NULL OR NOT (D.ACTIVE_TO < '2012-03-25 10:27:16')))) AND (((((D.CURRENCY = 'RUB' AND (D.PRICE_FROM <= 167300 OR D.PRICE_FROM IS NULL OR D.PRICE_FROM = 0)) OR (D.CURRENCY = 'USD' AND (D.PRICE_FROM <= 7149,57 OR D.PRICE_FROM IS NULL OR D.PRICE_FROM = 0)) OR (D.CURRENCY = 'EUR' AND (D.PRICE_FROM <= 4509,43 OR D.PRICE_FROM IS NULL OR D.PRICE_FROM = 0)))))) AND (((((D.CURRENCY = 'RUB' AND (D.PRICE_TO >= 167300 OR D.PRICE_TO IS NULL OR D.PRICE_TO = 0)) OR (D.CURRENCY = 'USD' AND (D.PRICE_TO >= 7149,57 OR D.PRICE_TO IS NULL OR D.PRICE_TO = 0)) OR (D.CURRENCY = 'EUR' AND (D.PRICE_TO >= 4509,43 OR D.PRICE_TO IS NULL OR D.PRICE_TO = 0)))))) ORDER BY D.SORT ASC [/COLOR][Operand should contain 1 column(s)]
[TABLE]
[TR][TD]
[TABLE]
[TR][TD][SIZE=-1][COLOR=#FF0000][B]DB query error.[/B][/COLOR]
Please try later. [/SIZE]
[/TD][/TR]
[/TABLE]
[/TD][/TR]
[/TABLE]
[B][SIZE=4]подскажите в чем может быть проблема? на ровном месте упало не знаем на что валить, вроде ничего не делали[/SIZE][/B]
