Цитата |
---|
Vegard пишет: Доброго времени суток! Возникла небольшая проблема, на сайте работала интеграция до поры до времени пока чьито ручки не залезли и не поправили, если с Битрикс я както знаком то вот с 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>
Выгрузка товаров завершена с ошибками!!! |
|
Попробуйте выгрузить в каталог из 1С. Если ок, значит на стороне сайта что-то. Установите локально демо сайт и настройте синхронизацию с ним.
Проверьте свободное место на хостинге.
Проверьте сайт на ошибки.
Попробуйте выгрузить в другой инфоблок.