Итак после переноса bitrix на новый VPS, вылезла такая ошибка на одной из страниц: модуль "объявления"
База была скопирована как и файлы.
1. на одной из страниц:
MySQL Query Error:
SEL ECT
BS.*
,B.LIST_PAGE_URL
,B.SECTION_PAGE_URL
,B.IBLOCK_TYPE_ID
,B.CODE as IBLOCK_CODE
,B.XML_ID as IBLOCK_EXTERNAL_ID
,BS.XML_ID as EXTERNAL_ID
,SE.IBLOCK_ELEMENT_ID
FR OM
b_iblock_section_element SE
INNER JOIN b_iblock_section BS ON SE.IBLOCK_SECTION_ID = BS.ID
INNER JOIN b_iblock B ON B.ID = BS.IBLOCK_ID
WHERE
SE.IBLOCK_ELEMENT_ID in ()
[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 ')' at line 15]
База была скопирована как и файлы.
1. на одной из страниц:
MySQL Query Error:
SEL ECT
BS.*
,B.LIST_PAGE_URL
,B.SECTION_PAGE_URL
,B.IBLOCK_TYPE_ID
,B.CODE as IBLOCK_CODE
,B.XML_ID as IBLOCK_EXTERNAL_ID
,BS.XML_ID as EXTERNAL_ID
,SE.IBLOCK_ELEMENT_ID
FR OM
b_iblock_section_element SE
INNER JOIN b_iblock_section BS ON SE.IBLOCK_SECTION_ID = BS.ID
INNER JOIN b_iblock B ON B.ID = BS.IBLOCK_ID
WHERE
SE.IBLOCK_ELEMENT_ID in ()
[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 ')' at line 15]