Здравствуйте. Перенесли на сайт на VPS (CentOS 7 + bitrixVM) то ли сразу не заметил, то ли не было ошибки и позже появилась, но суть такая, если:
Зайти на сайт turistsibiri.ru
Положить любой товар в корзину
Перейти в корзину
Нажать Оформить
То появляется Ошибка DB query error. Please try later
Включил Debug. вот что показывает:
Скрытый текст |
---|
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 = 1 )))) AND ((((P.ACTIVE = 'Y' )))) AND ((((P.UTIL = 'N' )))) AND ((())) AND ((SOP.ENTITY_TYPE = 'P' AND SOP.ENTITY_ID = 1)) [[1064] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '))) AND ((SOP.ENTITY_TYPE = 'P' AND SOP.ENTITY_ID = 1))' at line 1] |
Поддержка хостинга старается, но пока не понимает в чем причина. В битрикс поддержку написал.. молчат.. хотя вроде как прошло часов.. Но пока ждем, может здесь кто то подскажет?