Выполняем выгрузку товаров на сайт. До этого все работало нормально, но при переходе не выделенный сервер начались проблемы. Выгрузка заканчивается ошибкой:
Выгружено товаров: 2 743
Выгружено картинок: 2 069
Выгружено предложений: 2 743
Произошла ошибка на стороне сервера. Получен неизвестный статус импорта.
Обмен не выполнен
Ответ сервера:
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>
DB query error.<br> Please try later. <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: /var/www/nwdkfl77/data/www/xn----8sbfjuaaihfo3cne4d.xn--p1ai/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] => /var/www/nwdkfl77/data/www/xn----8sbfjuaaihfo3cne4d.xn--p1ai/bitrix/modules/main/classes/mysql/database.php [line] => 223 [class] => [function] => include [args] => )
[1] => Array ( [file] => /var/www/nwdkfl77/data/www/xn----8sbfjuaaihfo3cne4d.xn--p1ai/bitrix/modules/iblock/classes/mysql/cml2.php [line] => 610 [class] => CDatabase [function] => Query [args] => Array ( [0] => select ID, ATTRIBUTES from b_xml_tree where (ID = 1) and (NAME = 'КоммерческаяИнформация') )
)
[2] => Array ( [file] => /var/www/nwdkfl77/data/www/xn----8sbfjuaaihfo3cne4d.xn--p1ai/bitrix/modules/iblock/classes/general/cml2.php [line] => 468 [class] => CIBlockXMLFile [function] => GetList [args] => Array ( [0] => Array ( )
[1] => Array ( [ID] => 1 [NAME] => КоммерческаяИнформация )
[2] => Array ( [0] => ID [1] => ATTRIBUTES )
)
)
[3] => Array ( [file] => /var/www/nwdkfl77/data/www/xn----8sbfjuaaihfo3cne4d.xn--p1ai/bitrix/components/bitrix/catalog.import.1c/component.php [line] => 299 [class] => CIBlockCMLImport [function] => ImportMetaData [args] => Array ( [0] => 1 [1] => catalog [2] => Array ( [0] => - )
)
)
[4] => Array ( [file] => /var/www/nwdkfl77/data/www/xn----8sbfjuaaihfo3cne4d.xn--p1ai/bitrix/modules/main/classes/general/component.php [line] => 211 [class] => [function] => include [args] => Array ( [0] => /var/www/nwdkfl77/data/www/xn----8sbfjuaaihfo3cne4d.xn--p1ai/bitrix/components/bitrix/catalog.import.1c/component.php )
)
[5] => Array ( [file] => /var/www/nwdkfl77/data/www/xn----8sbfjuaaihfo3cne4d.xn--p1ai/bitrix/modules/main/classes/general/component.php [line] => 247 [class] => CBitrixComponent [function] => __IncludeComponent [args] => Array ( )
)
[6] => Array ( [file] => /var/www/nwdkfl77/data/www/xn----8sbfjuaaihfo3cne4d.xn--p1ai/bitrix/modules/main/classes/general/main.php [line] => 1165 [class] => CBitrixComponent [function] => IncludeComponent [args] => Array ( [0] => [1] => Array ( [IBLOCK_TYPE] => catalog [SITE_LIST] => Array ( [0] => - )
[INTERVAL] => 5 [GROUP_PERMISSIONS] => Array ( [0] => 1 [1] => 5 )
[GENERATE_PREVIEW] => Y [PREVIEW_WIDTH] => 100 [PREVIEW_HEIGHT] => 100 [DETAIL_RESIZE] => Y [DETAIL_WIDTH] => 1500 [DETAIL_HEIGHT] => 1500 [ELEMENT_ACTION] => D [SECTION_ACTION] => D [FILE_SIZE_LIMIT] => 3000000 [USE_CRC] => N [USE_ZIP] => N [USE_OFFERS] => N [USE_IBLOCK_TYPE_ID] => N [USE_IBLOCK_PICTURE_SETTINGS] => N [TRANSLIT_ON_ADD] => Y [TRANSLIT_ON_UPDATE] => Y )
[2] => )
)
[7] => Array ( [file] => /var/www/nwdkfl77/data/www/xn----8sbfjuaaihfo3cne4d.xn--p1ai/bitrix/modules/sale/admin/1c_exchange.php [line] => 46 [class] => CAllMain [function] => IncludeComponent [args] => Array ( [0] => bitrix:catalog.import.1c [1] => [2] => Array ( [IBLOCK_TYPE] => catalog [SITE_LIST] => Array ( [0] => - )
[INTERVAL] => 5 [GROUP_PERMISSIONS] => Array ( [0] => 1 [1] => 5 )
[GENERATE_PREVIEW] => Y [PREVIEW_WIDTH] => 100 [PREVIEW_HEIGHT] => 100 [DETAIL_RESIZE] => Y [DETAIL_WIDTH] => 1500 [DETAIL_HEIGHT] => 1500 [ELEMENT_ACTION] => D [SECTION_ACTION] => D [FILE_SIZE_LIMIT] => 3000000 [USE_CRC] => N [USE_ZIP] => N [USE_OFFERS] => N [USE_IBLOCK_TYPE_ID] => N [USE_IBLOCK_PICTURE_SETTINGS] => N [TRANSLIT_ON_ADD] => Y [TRANSLIT_ON_UPDATE] => Y )
)
)
[8] => Array ( [file] => /var/www/nwdkfl77/data/www/xn----8sbfjuaaihfo3cne4d.xn--p1ai/bitrix/admin/1c_exchange.php [line] => 2 [class] => [function] => require_once [args] => Array ( [0] => /var/www/nwdkfl77/data/www/xn----8sbfjuaaihfo3cne4d.xn--p1ai/bitrix/modules/sale/admin/1c_exchange.php )
)
)
"> <input type="submit" value="Send error report to support"> </form> |
|
<br><br><br>
Выгрузка товаров завершена с ошибками!!!
Кто нибудь! Помогите. Где копать?