Всем доброго времени суток!
Компонент "bitrix:sale.personal.order.list" возвращает "MySQL Query Error.
Компонент стандартный.
Битрикс Управление сайтом 14.9.2.
Если кто то сталкивался с подобной проблемой, прошу помочь.
Заранее благодарю.
Компонент "bitrix:sale.personal.order.list" возвращает "MySQL Query Error.
Скрытый текст |
---|
File: /home/bitrix/www/bitrix/modules/sale/mysql/order.php Line: 779 MySQL Query Error: SEL ECT O.ID as ID, O.LID as LID, O.PERSON_TYPE_ID as PERSON_TYPE_ID, O.PAYED as PAYED, DATE_FORMAT(O.DATE_PAYED, '%d.%m.%Y %H:%i:%s') as DATE_PAYED, O.EMP_PAYED_ID as EMP_PAYED_ID, O.CANCELED as CANCELED, DATE_FORMAT(O.DATE_CANCELED, '%d.%m.%Y %H:%i:%s') as DATE_CANCELED, O.EMP_CANCELED_ID as EMP_CANCELED_ID, O.REASON_CANCELED as REASON_CANCELED, O.MARKED as MARKED, DATE_FORMAT(O.DATE_MARKED, '%d.%m.%Y %H:%i:%s') as DATE_MARKED, O.EMP_MARKED_ID as EMP_MARKED_ID, O.REASON_MARKED as REASON_MARKED, O.STATUS_ID as STATUS_ID, DATE_FORMAT(O.DATE_STATUS, '%d.%m.%Y %H:%i:%s') as DATE_STATUS, O.PAY_VOUCHER_NUM as PAY_VOUCHER_NUM, DATE_FORMAT(O.PAY_VOUCHER_DATE, '%d.%m.%Y') as PAY_VOUCHER_DATE, O.EMP_STATUS_ID as EMP_STATUS_ID, O.PRICE_DELIVERY as PRICE_DELIVERY, O.ALLOW_DELIVERY as ALLOW_DELIVERY, DATE_FORMAT(O.DATE_ALLOW_DELIVERY, '%d.%m.%Y %H:%i:%s') as DATE_ALLOW_DELIVERY, O.EMP_ALLOW_DELIVERY_ID as EMP_ALLOW_DELIVERY_ID, O.DEDUCTED as DEDUCTED, DATE_FORMAT(O.DA TE_DEDUCTED, '%d.%m.%Y %H:%i:%s') as DATE_DEDUCTED, O.EMP_DEDUCTED_ID as EMP_DEDUCTED_ID, O.REASON_UNDO_DEDUCTED as REASON_UNDO_DEDUCTED, O.RESERVED as RESERVED, O.PRICE as PRICE, O.CURRENCY as CURRENCY, O.DISCOUNT_VALUE as DISCOUNT_VALUE, O.SUM_PAID as SUM_PAID, O.USER_ID as USER_ID, O.PAY_SYSTEM_ID as PAY_SYSTEM_ID, O.DELIVERY_ID as DELIVERY_ID, DATE_FORMAT(O.DATE_INSERT, '%d.%m.%Y %H:%i:%s') as DATE_INSERT, DATE_FORMAT(O.DATE_INSERT, '%d.%m.%Y %H:%i:%s') as DATE_INSERT_FORMAT, DATE_FORMAT(O.DATE_UPDATE, '%d.%m.%Y %H:%i:%s') as DATE_UPDATE, O.USER_DESCRIPTION as USER_DESCRIPTION, O.ADDITIONAL_INFO as ADDITIONAL_INFO, O.PS_STATUS as PS_STATUS, O.PS_STATUS_CODE as PS_STATUS_CODE, O.PS_STATUS_DESCRIPTION as PS_STATUS_DESCRIPTION, O.PS_STATUS_MESSAGE as PS_STATUS_MESSAGE, O.PS_SUM as PS_SUM, O.PS_CURRENCY as PS_CURRENCY, DATE_FORMAT(O.PS_RESPONSE_DATE, '%d.%m.%Y %H:%i:%s') as PS_RESPONSE_DATE, O.COMMENTS as COMMENTS, O.TAX_VALUE as TAX_VALUE, O.STAT_GID as STAT_GID, O.RECURRIN G_ID as RECURRING_ID, O.RECOUNT_FLAG as RECOUNT_FLAG, U.LOGI! N as USER_LOGIN, U.NAME as USER_NAME, U.LAST_NAME as USER_LAST_NAME, U.EMAIL as USER_EMAIL, O.DELIVERY_DOC_NUM as DELIVERY_DOC_NUM, DATE_FORMAT(O.DELIVERY_DOC_DATE, '%d.%m.%Y') as DELIVERY_DOC_DATE, DATE_FORMAT(OD.DATE_REQUEST, '%d.%m.%Y %H:%i:%s') as DELIVERY_DATE_REQUEST, O.STORE_ID as STORE_ID, O.ORDER_TOPIC as ORDER_TOPIC, O.RESPONSIBLE_ID as RESPONSIBLE_ID, UR.LOGIN as RESPONSIBLE_LOGIN, UR.NAME as RESPONSIBLE_NAME, UR.LAST_NAME as RESPONSIBLE_LAST_NAME, UR.SECOND_NAME as RESPONSIBLE_SECOND_NAME, UR.EMAIL as RESPONSIBLE_EMAIL, UR.WORK_POSITION as RESPONSIBLE_WORK_POSITION, UR.PERSONAL_PHOTO as RESPONSIBLE_PERSONAL_PHOTO, DATE_FORMAT(O.DATE_PAY_BEFORE, '%d.%m.%Y %H:%i:%s') as DATE_PAY_BEFORE, DATE_FORMAT(O.DATE_BILL, '%d.%m.%Y %H:%i:%s') as DATE_BILL, O.ACCOUNT_NUMBER as ACCOUNT_NUMBER, O.TRACKING_NUMBER as TRACKING_NUMBER, O.XML_ID as XML_ID FR OM b_sale_order O INNER JOIN b_user U ON (O.USER_ID = U.ID) LEFT JOIN b_sale_order_delivery OD ON (O.ID = OD.ORDER_ID) LEFT JOI N b_user UR ON (O.RESPONSIBLE_ID = UR.ID) WHERE ((((O.USER_ID = 1 )))) AND ((((O.LID = 's1' )))) AND ((())) ORDER BY O.ID DESC [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 '))) ORDER BY O.ID DESC' at line 1] DB query error. Please try later |
Битрикс Управление сайтом 14.9.2.
Если кто то сталкивался с подобной проблемой, прошу помочь.
Заранее благодарю.