Доброго времени суток!
Возникла небольшая проблема, на сайте работала интеграция до поры до времени пока чьито ручки не залезли и не поправили, если с Битрикс я както знаком то вот с 1С уже сложнее. Со стороны сайта все проверено все согласно мануалам и документации, со стороны 1С - проверка связи с сайтом проходит на отлично но вот сама выгрузка дает такое:
Возникла небольшая проблема, на сайте работала интеграция до поры до времени пока чьито ручки не залезли и не поправили, если с Битрикс я както знаком то вот с 1С уже сложнее. Со стороны сайта все проверено все согласно мануалам и документации, со стороны 1С - проверка связи с сайтом проходит на отлично но вот сама выгрузка дает такое:
Код |
---|
Выгружено товаров: 19 Выгружено картинок: 15 Произошла ошибка на стороне сервера. Получен неизвестный статус импорта. Обмен не выполнен Ответ сервера: select ID, ATTRIBUTES from b_xml_tree where (ID = 1) and (NAME = 'КоммерческаяИнформация') </font>[Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (cp1251_general_ci,COERCIBLE) for operation '=']<br><br> <table cellpadding="1" cellspacing="0" width="35%" bgcolor="#9C9A9C"> <tr> <td><table cellpadding="5" cellspacing="0" width="100%"> <tr> <td bgcolor="#FFFFFF" align="center"> <FONT face="Verdana, Arial, Helvetica, sans-serif" size="-1"> <font color="#FF0000"><b>DB query error.</b></font><br> Please try later. </font><br> </form> <form method="post" action="/bitrix/admin/site_checker.php?tabControl_active_tab=edit5#edit5"> <input type="hidden" name="last_error_query" value="File: ........../bitrix/modules/main/include/dbquery_error.php Query: select ID, ATTRIBUTES from b_xml_tree where (ID = 1) and (NAME = 'КоммерческаяИнформация') [Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (cp1251_general_ci,COERCIBLE) for operation '='] debug_backtrace: Array ( [0] => Array ( [file] => .......... /bitrix/modules/main/classes/mysql/database.php [line] => 175 [class] => [function] => include [args] => ) [1] => Array ( [file] => .......... /bitrix/modules/iblock/classes/mysql/cml2.php [line] => 607 [class] => CDatabase [function] => Query [args] => Array ( [0] => select ID, ATTRIBUTES from b_xml_tree where (ID = 1) and (NAME = 'КоммерческаяИнформация') ) ) [2] => Array ( [file] => .......... /bitrix/modules/iblock/classes/general/cml2.php [line] => 370 [class] => CIBlockXMLFile [function] => GetList [args] => Array ( [0] => Array ( ;) [1] => Array ( [ID] => 1 [NAME] => КоммерческаяИнформация ;) [2] => Array ( [0] => ID [1] => ATTRIBUTES ;) ) ) [3] => Array ( [file] => .......... /bitrix/components/bitrix/catalog.import.1c/component.php [line] => 243 [class] => CIBlockCMLImport [function] => ImportMetaData [args] => Array ( [0] => 1 [1] => xmlcatalog [2] => Array ( [0] => s1 ;) ) ) [4] => Array ( [file] => .......... /bitrix/modules/main/classes/general/component.php [line] => 192 [class] => [function] => include [args] => Array ( [0] => .......... /bitrix/components/bitrix/catalog.import.1c/component.php ) ) [5] => Array ( [file] => .......... /bitrix/modules/main/classes/general/component.php [line] => 228 [class] => CBitrixComponent [function] => __IncludeComponent [args] => Array ( ) ) [6] => Array ( [file] => .......... /bitrix/modules/main/classes/general/main.php [line] => 979 [class] => CBitrixComponent [function] => IncludeComponent [args] => Array ( [0] => [1] => Array ( [IBLOCK_TYPE] => xmlcatalog [SITE_LIST] => Array ( [0] => s1 ) [INTERVAL] => 30 [GROUP_PERMISSIONS] => Array ( [0] => 5 ) [GENERATE_PREVIEW] => Y [PREVIEW_WIDTH] => 100 [PREVIEW_HEIGHT] => 100 [DETAIL_RESIZE] => Y [DETAIL_WIDTH] => 300 [DETAIL_HEIGHT] => 300 [ELEMENT_ACTION] => A [SECTION_ACTION] => A [FILE_SIZE_LIMIT] => 204800 [USE_CRC] => Y [USE_ZIP] => Y [USE_OFFERS] => N [USE_IBLOCK_TYPE_ID] => Y ;) [2] => ) ) [7] => Array ( [file] => .......... /bitrix/modules/sale/admin/1c_exchange.php [line] => 41 [class] => CAllMain [function] => IncludeComponent [args] => Array ( [0] => bitrix:catalog.import.1c [1] => [2] => Array ( [IBLOCK_TYPE] => xmlcatalog [SITE_LIST] => Array ( [0] => s1 ) [INTERVAL] => 30 [GROUP_PERMISSIONS] => Array ( [0] => 5 ) [GENERATE_PREVIEW] => Y [PREVIEW_WIDTH] => 100 [PREVIEW_HEIGHT] => 100 [DETAIL_RESIZE] => Y [DETAIL_WIDTH] => 300 [DETAIL_HEIGHT] => 300 [ELEMENT_ACTION] => A [SECTION_ACTION] => A [FILE_SIZE_LIMIT] => 204800 [USE_CRC] => Y [USE_ZIP] => Y [USE_OFFERS] => N [USE_IBLOCK_TYPE_ID] => Y ;) ) ) [8] => Array ( [file] => .......... /bitrix/admin/1c_exchange.php [line] => 2 [class] => [function] => require_once [args] => Array ( [0] => .......... /bitrix/modules/sale/admin/1c_exchange.php ) ) ) "> <input type="submit" value="Send error report to support"> </form> </td> </tr> </table></td> </tr> </table> <br><br><br> Выгрузка товаров завершена с ошибками!!! |