$strSql = "INSERT INTO it_catalog_rmenu_index (ID, SECTION, LOGO, PRICE, ANONS_MENU, ACTIVE, NAME, ADDRESS, CITY, METRO, METRO_ID, TYPE, KITCHEN, DELIVERY_CONDITION, COUNTRY, CITY_ID, TYPE_ID, KITCHEN_ID, LATITUDE, LONGITUDE, PREVIEW_PICTURE, DETAIL_PAGE_URL) VALUES (".$arItemsMenu['FIELDS']['ID'], $arItemsMenu['FIELDS']['IBLOCK_SECTION_ID'], CFile::GetPath($arInfoRestorans['FIELDS']['PREVIEW_PICTURE']), $ar_res['PRICES']['1']['PRICE'], $arItemsMenu['FIELDS']['PREVIEW_TEXT'], 1, $arItemsMenu['FIELDS']['NAME'], $arInfoRestorans['PROP']['ADDRESS']['VALUE'], $arInfoRestorans['PROP']['CITYTXT']['VALUE'], $arRestMetro['NAME'], $arInfoRestorans['PROP']['METRO']['VALUE'], $arInfoRestorans['PROP']['TYPE']['VALUE'], implode($arInfoRestorans['PROP']['KITCHEN']['VALUE']), $arInfoRestorans['PROP']['DELIVERY_CONDITION']['VALUE'], $arInfoRestorans['PROP']['CITY']['VALUE'], $arInfoRestorans['PROP']['VALUE_ENUM_ID']['VALUE'], implode($arInfoRestorans['PROP']['KITCHEN']['VALUE_ENUM_ID']), $arCoords[0], $arCoords[1], CFile::GetPath($arItemsMenu['FIELDS']['PREVIEW_PICTURE']), $detailpage.")";

I guess I messed up something and incorrectly set / not set apostrophes.

    1 answer 1

    Read about string concatenation in PCP.
    You are trying to combine strings with a comma for example here.

     $arItemsMenu['FIELDS']['ID'], $arItemsMenu['FIELDS']['IBLOCK_SECTION_ID'],

    must be

     $arItemsMenu['FIELDS']['ID'].", ".$arItemsMenu['FIELDS']['IBLOCK_SECTION_ID'].", ".
    • Bitrix is ​​so apparently driving))) - Vfvtnjd