похожая ошибка:
File: /home/bitrix/www/bitrix/modules/sale/mysql/order_props.php
Line: 225
MySQL Query Error: SEL ECT DISTINCT P.ID as ID, P.PERSON_TYPE_ID as PERSON_TYPE_ID, P.NAME as NAME, P.TYPE as TYPE, P.REQUIED as REQUIED, P.REQUIED as REQUIRED, P.SORT as SORT, P.USER_PROPS as USER_PROPS, P.IS_LOCATION as IS_LOCATION, P.PROPS_GROUP_ID as PROPS_GROUP_ID, P.SIZE1 as SIZE1, P.SIZE2 as SIZE2, P.DESCRIPTION as DESCRIPTION, P.IS_EMAIL as IS_EMAIL, P.IS_PROFILE_NAME as IS_PROFILE_NAME, P.IS_PAYER as IS_PAYER, P.IS_LOCATION4TAX as IS_LOCATION4TAX, P.IS_FILTERED as IS_FILTERED, P.IS_ZIP as IS_ZIP, P.CODE as CODE, P.ACTIVE as ACTIVE, P.UTIL as UTIL, P.INPUT_FIELD_LOCATION as INPUT_FIELD_LOCATION, P.MULTIPLE as MULTIPLE, PG.ID as GROUP_ID, PG.PERSON_TYPE_ID as GROUP_PERSON_TYPE_ID, PG.NAME as GROUP_NAME, PG.SORT as GROUP_SORT, SPT.LID as PERSON_TYPE_LID, SPT.NAME as PERSON_TYPE_NAME, SPT.SORT as PERSON_TYPE_SORT, SPT.ACTIVE as PERSON_TYPE_ACTIVE, SOP.PROPERTY_ID as PAYSYSTEM_ID, SOD.PROPERTY_ID as DELIVERY_ID, P.DEFAULT_VALUE as DEFAULT_VALUE FR OM b_sale_order_props P LEFT JOIN b_sale_order_props_group PG ON (P.PROPS_GROUP_ID = PG.ID) LEFT JOIN b_sale_person_type SPT ON (P.PERSON_TYPE_ID = SPT.ID) LEFT JOIN b_sale_order_props_relation SOP ON P.ID = SOP.PROPERTY_ID LEFT JOIN b_sale_order_props_relation SOD ON P.ID = SOD.PROPERTY_ID WHERE ((((P.PERSON_TYPE_ID = 3 )))) AND ((((P.ACTIVE = 'Y' )))) AND ((((P.UTIL = 'N' )))) AND ((())) AND ((SOP.ENTITY_TYPE = 'P' AND SOP.ENTITY_ID = 2)) [[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 ((SOP.ENTITY_TYPE = 'P' AND SOP.ENTITY_ID = 2))' at line 1]
лицензию клиент обновлять больше не будет, подскажите, как решить
File: /home/bitrix/www/bitrix/modules/sale/mysql/order_props.php
Line: 225
MySQL Query Error: SEL ECT DISTINCT P.ID as ID, P.PERSON_TYPE_ID as PERSON_TYPE_ID, P.NAME as NAME, P.TYPE as TYPE, P.REQUIED as REQUIED, P.REQUIED as REQUIRED, P.SORT as SORT, P.USER_PROPS as USER_PROPS, P.IS_LOCATION as IS_LOCATION, P.PROPS_GROUP_ID as PROPS_GROUP_ID, P.SIZE1 as SIZE1, P.SIZE2 as SIZE2, P.DESCRIPTION as DESCRIPTION, P.IS_EMAIL as IS_EMAIL, P.IS_PROFILE_NAME as IS_PROFILE_NAME, P.IS_PAYER as IS_PAYER, P.IS_LOCATION4TAX as IS_LOCATION4TAX, P.IS_FILTERED as IS_FILTERED, P.IS_ZIP as IS_ZIP, P.CODE as CODE, P.ACTIVE as ACTIVE, P.UTIL as UTIL, P.INPUT_FIELD_LOCATION as INPUT_FIELD_LOCATION, P.MULTIPLE as MULTIPLE, PG.ID as GROUP_ID, PG.PERSON_TYPE_ID as GROUP_PERSON_TYPE_ID, PG.NAME as GROUP_NAME, PG.SORT as GROUP_SORT, SPT.LID as PERSON_TYPE_LID, SPT.NAME as PERSON_TYPE_NAME, SPT.SORT as PERSON_TYPE_SORT, SPT.ACTIVE as PERSON_TYPE_ACTIVE, SOP.PROPERTY_ID as PAYSYSTEM_ID, SOD.PROPERTY_ID as DELIVERY_ID, P.DEFAULT_VALUE as DEFAULT_VALUE FR OM b_sale_order_props P LEFT JOIN b_sale_order_props_group PG ON (P.PROPS_GROUP_ID = PG.ID) LEFT JOIN b_sale_person_type SPT ON (P.PERSON_TYPE_ID = SPT.ID) LEFT JOIN b_sale_order_props_relation SOP ON P.ID = SOP.PROPERTY_ID LEFT JOIN b_sale_order_props_relation SOD ON P.ID = SOD.PROPERTY_ID WHERE ((((P.PERSON_TYPE_ID = 3 )))) AND ((((P.ACTIVE = 'Y' )))) AND ((((P.UTIL = 'N' )))) AND ((())) AND ((SOP.ENTITY_TYPE = 'P' AND SOP.ENTITY_ID = 2)) [[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 ((SOP.ENTITY_TYPE = 'P' AND SOP.ENTITY_ID = 2))' at line 1]
лицензию клиент обновлять больше не будет, подскажите, как решить