При обмене УТ 10.3 и битриксом периодически происходит ошибка
| Код |
|---|
Выгружено товаров: 1 361
Произошла ошибка на стороне сервера. Получен неизвестный статус импорта.
Обмен не выполнен
Ответ сервера:
INSERT INTO b_iblock_property_enum
(
PROPERTY_ID
,SORT
,VALUE
,XML_ID
) VALUES (
2
,1800
,'Текстиль с отделкой из кожи'
,'Текстиль с отделкой из кожи'
)
</font>[Duplicate entry '2-Текстиль с отделкой из кожи' for key 2]<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: /home/bitrix/www/bitrix/modules/main/include/dbquery_error.php
Query:
INSERT INTO b_iblock_property_enum
(
PROPERTY_ID
,SORT
,VALUE
,XML_ID
) VALUES (
2
,1800
,'Текстиль с отделкой из кожи'
,'Текстиль с отделкой из кожи'
)
[Duplicate entry '2-Текстиль с отделкой из кожи' for key 2]
debug_backtrace:
Array
(
[0] => Array
(
[file] => /home/bitrix/www/bitrix/modules/main/classes/mysql/database.php
[line] => 223
[class] =>
[function] => include
[args] =>
)
[1] => Array
(
[file] => /home/bitrix/www/bitrix/modules/iblock/classes/general/iblockproperty.php
[line] => 676
[class] => CDatabase
[function] => Query
[args] => Array
(
[0] =>
INSERT INTO b_iblock_property_enum
(
PROPERTY_ID
,SORT
,VALUE
,XML_ID
) VALUES (
2
,1800
,'Текстиль с отделкой из кожи'
,'Текстиль с отделкой из кожи'
)
)
)
[2] => Array
(
[file] => /home/bitrix/www/bitrix/modules/iblock/classes/general/cml2.php
[line] => 1173
[class] => CAllIBlockProperty
[function] => UpdateEnum
[args] => Array
(
[0] => 2
[1] => Array
(
[245] => Array
(
[ID] => 245
[PROPERTY_ID] => 2
[VALUE] => Джинса
[DEF] => N
[SORT] => 200
[XML_ID] => Джинса
[TMP_ID] =>
[EXTERNAL_ID] => Джинса
[CML2_EXPORT_FLAG] => 1
)
[246] => Array
(
[ID] => 246
[PROPERTY_ID] => 2
[VALUE] => наплак
[DEF] => N
[SORT] => 300
[XML_ID] => Наплак
[TMP_ID] =>
[EXTERNAL_ID] => Наплак
[CML2_EXPORT_FLAG] => 1
)
[248] => Array
(
[ID] => 248
[PROPERTY_ID] => 2
[VALUE] => замша
[DEF] => N
[SORT] => 500
[XML_ID] => Замша
[TMP_ID] =>
[EXTERNAL_ID] => Замша
[CML2_EXPORT_FLAG] => 1
)
[253] => Array
(
[ID] => 253
[PROPERTY_ID] => 2
[VALUE] => Мех
[DEF] => N
[SORT] => 600
[XML_ID] => Мех
[TMP_ID] =>
[EXTERNAL_ID] => Мех
[CML2_EXPORT_FLAG] => 1
)
[254] => Array
(
[ID] => 254
[PROPERTY_ID] => 2
[VALUE] => Шерсть
[DEF] => N
[SORT] => 700
[XML_ID] => Шерсть
[TMP_ID] =>
[EXTERNAL_ID] => Шерсть
[CML2_EXPORT_FLAG] => 1
)
[258] => Array
(
[ID] => 258
[PROPERTY_ID] => 2
[VALUE] => калф
[DEF] => N
[SORT] => 800
[XML_ID] => Калф
[TMP_ID] =>
[EXTERNAL_ID] => Калф
[CML2_EXPORT_FLAG] => 1
)
[259] => Array
(
[ID] => 259
[PROPERTY_ID] => 2
[VALUE] => натуральная кожа
[DEF] => N
[SORT] => 900
[XML_ID] => Кожа
[TMP_ID] =>
[EXTERNAL_ID] => Кожа
[CML2_EXPORT_FLAG] => 1
)
[260] => Array
(
[ID] => 260
[PROPERTY_ID] => 2
[VALUE] => Нейлон
[DEF] => N
[SORT] => 1000
[XML_ID] => Нейлон
[TMP_ID] =>
[EXTERNAL_ID] => Нейлон
[CML2_EXPORT_FLAG] => 1
)
[261] => Array
(
[ID] => 261
[PROPERTY_ID] => 2
[VALUE] => РєСЂРѕРєРѕРґРёР»
[DEF] => N
[SORT] => 1100
[XML_ID] => РљСЂРѕРєРѕРґРёР»
[TMP_ID] =>
[EXTERNAL_ID] => РљСЂРѕРєРѕРґРёР»
[CML2_EXPORT_FLAG] => 1
)
[270] => Array
(
[ID] => 270
[PROPERTY_ID] => 2
[VALUE] => Анаконда
[DEF] => N
[SORT] => 1200
[XML_ID] => Анаконда
[TMP_ID] =>
[EXTERNAL_ID] => Анаконда
[CML2_EXPORT_FLAG] => 1
)
[271] => Array
(
[ID] => 271
[PROPERTY_ID] => 2
[VALUE] => аватар
[DEF] => N
[SORT] => 1300
[XML_ID] => Аватар
[TMP_ID] =>
[EXTERNAL_ID] => Аватар
[CML2_EXPORT_FLAG] => 1
)
[273] => Array
(
[ID] => 273
[PROPERTY_ID] => 2
[VALUE] => текстиль с отделкой из кожи
[DEF] => N
[SORT] => 1400
[XML_ID] => текстиль с отделкой из кожи
[TMP_ID] =>
[EXTERNAL_ID] => текстиль с отделкой из кожи
)
[275] => Array
(
[ID] => 275
[PROPERTY_ID] => 2
[VALUE] => кожа с отделкой из текстиля
[DEF] => N
[SORT] => 1400
[XML_ID] => кожа с отделкой из текстиля
[TMP_ID] =>
[EXTERNAL_ID] => кожа с отделкой из текстиля
)
[279] => Array
(
[ID] => 279
[PROPERTY_ID] => 2
[VALUE] => Нубук с выделкой под рептилию
[DEF] => N
[SORT] => 1400
[XML_ID] => РќСѓР±СѓРє
[TMP_ID] =>
[EXTERNAL_ID] => РќСѓР±СѓРє
[CML2_EXPORT_FLAG] => 1
)
[280] => Array
(
[ID] => 280
[PROPERTY_ID] => 2
[VALUE] => кожа с отделкой из иск.меха
[DEF] => N
[SORT] => 1500
[XML_ID] => кожа с отделкой из иск.меха
[TMP_ID] =>
[EXTERNAL_ID] => кожа с отделкой из иск.меха
)
[286] => Array
(
[ID] => 286
[PROPERTY_ID] => 2
[VALUE] => иск.кожа
[DEF] => N
[SORT] => 1500
[XML_ID] => иск.кожа
[TMP_ID] =>
[EXTERNAL_ID] => иск.кожа
[CML2_EXPORT_FLAG] => 1
)
[281] => Array
(
[ID] => 281
[PROPERTY_ID] => 2
[VALUE] => полиэстр
[DEF] => N
[SORT] => 1600
[XML_ID] => полиэстр
[TMP_ID] =>
[EXTERNAL_ID] => полиэстр
[CML2_EXPORT_FLAG] => 1
)
[284] => Array
(
[ID] => 284
[PROPERTY_ID] => 2
[VALUE] => Черный
[DEF] => N
[SORT] => 1600
[XML_ID] => 000000
[TMP_ID] =>
[EXTERNAL_ID] => 000000
)
[287] => Array
(
[ID] => 287
[PROPERTY_ID] => 2
[VALUE] => Вакетта
[DEF] => N
[SORT] => 1600
[XML_ID] => Вакетта
[TMP_ID] =>
[EXTERNAL_ID] => Вакетта
[CML2_EXPORT_FLAG] => 1
)
[330] => Array
(
[ID] => 330
[PROPERTY_ID] => 2
[VALUE] => лак
[DEF] => N
[SORT] => 1600
[XML_ID] => лак
[TMP_ID] =>
[EXTERNAL_ID] => лак
[CML2_EXPORT_FLAG] => 1
)
[331] => Array
(
[ID] => 331
[PROPERTY_ID] => 2
[VALUE] => нат.кожа с выделкой под рептилии
[DEF] => N
[SORT] => 1600
[XML_ID] => нат.кожа с выделкой под рептилии
[TMP_ID] =>
[EXTERNAL_ID] => нат.кожа с выделкой под рептилии
)
[332] => Array
(
[ID] => 332
[PROPERTY_ID] => 2
[VALUE] => нат.кожа с выделкой под страуса
[DEF] => N
[SORT] => 1700
[XML_ID] => нат.кожа с выделкой под страуса
[TMP_ID] =>
[EXTERNAL_ID] => нат.кожа с выделкой под страуса
[CML2_EXPORT_FLAG] => 1
)
[333] => Array
(
[ID] => 333
[PROPERTY_ID] => 2
[VALUE] => нат.кожа с выделкой под рептилию
[DEF] => N
[SORT] => 1800
[XML_ID] => нат.кожа с выделкой под рептилию
[TMP_ID] =>
[EXTERNAL_ID] => нат.кожа с выделкой под рептилию
[CML2_EXPORT_FLAG] => 1
)
[n0] => Array
(
[CML2_EXPORT_FLAG] => 1
[XML_ID] => Текстиль с отделкой из кожи
[VALUE] => Текстиль с отделкой из кожи
[SORT] => 1800
)
)
)
)
[3] => Array
(
[file] => /home/bitrix/www/bitrix/modules/iblock/classes/general/cml2.php
[line] => 818
[class] => CIBlockCMLImport
[function] => ImportProperties
[args] => Array
(
[0] => 246
[1] => 2
)
)
[4] => Array
(
[file] => /home/bitrix/www/bitrix/components/idex/catalog.import.1c/component.php
[line] => 299
[class] => CIBlockCMLImport
[function] => ImportMetaData
[args] => Array
(
[0] => 1
[1] => catalog
[2] => Array
(
[0] => s1
)
)
)
[5] => Array
(
[file] => /home/bitrix/www/bitrix/modules/main/classes/general/component.php
[line] => 211
[class] =>
[function] => include
[args] => Array
(
[0] => /home/bitrix/www/bitrix/components/idex/catalog.import.1c/component.php
)
)
[6] => Array
(
[file] => /home/bitrix/www/bitrix/modules/main/classes/general/component.php
[line] => 247
[class] => CBitrixComponent
[function] => __IncludeComponent
[args] => Array
(
)
)
[7] => Array
(
[file] => /home/bitrix/www/bitrix/modules/main/classes/general/main.php
[line] => 1170
[class] => CBitrixComponent
[function] => IncludeComponent
[args] => Array
(
[0] =>
[1] => Array
(
[IBLOCK_TYPE] => catalog
[SITE_LIST] => Array
(
[0] => s1
)
[INTERVAL] => 30
[GROUP_PERMISSIONS] => Array
(
[0] => 1
[1] => 7
[2] => 8
)
[GENERATE_PREVIEW] => N
[PREVIEW_WIDTH] => 100
[PREVIEW_HEIGHT] => 100
[DETAIL_RESIZE] => N
[DETAIL_WIDTH] => 300
[DETAIL_HEIGHT] => 300
[ELEMENT_ACTION] => N
[SECTION_ACTION] => N
[FILE_SIZE_LIMIT] => 204800
[USE_CRC] => Y
[USE_ZIP] => Y
[USE_OFFERS] => N
[USE_IBLOCK_TYPE_ID] => N
[USE_IBLOCK_PICTURE_SETTINGS] => N
[TRANSLIT_ON_ADD] => N
[TRANSLIT_ON_UPDATE] => N
)
[2] =>
)
)
[8] => Array
(
[file] => /home/bitrix/www/bitrix/modules/sale/admin/1c_exchange.php
[line] => 46
[class] => CAllMain
[function] => IncludeComponent
[args] => Array
(
[0] => idex:catalog.import.1c
[1] =>
[2] => Array
(
[IBLOCK_TYPE] => catalog
[SITE_LIST] => Array
(
[0] => s1
)
[INTERVAL] => 30
[GROUP_PERMISSIONS] => Array
(
[0] => 1
[1] => 7
[2] => 8
)
[GENERATE_PREVIEW] => N
[PREVIEW_WIDTH] => 100
[PREVIEW_HEIGHT] => 100
[DETAIL_RESIZE] => N
[DETAIL_WIDTH] => 300
[DETAIL_HEIGHT] => 300
[ELEMENT_ACTION] => N
[SECTION_ACTION] => N
[FILE_SIZE_LIMIT] => 204800
[USE_CRC] => Y
[USE_ZIP] => Y
[USE_OFFERS] => N
[USE_IBLOCK_TYPE_ID] => N
[USE_IBLOCK_PICTURE_SETTINGS] => N
[TRANSLIT_ON_ADD] => N
[TRANSLIT_ON_UPDATE] => N
)
)
)
[9] => Array
(
[file] => /home/bitrix/www/bitrix/admin/1c_exchange.php
[line] => 2
[class] =>
[function] => require_once
[args] => Array
(
[0] => /home/bitrix/www/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>
Выгрузка товаров завершена с ошибками!!!
Изменения заказов не зарегистрированы. Выгрузка заказов не произведена.
Обмен заказами успешно завершен
|
в чем может быть проблема?
Соглашение об использовании сайта