Проблема обмена 1С с сайтом (через битрикс), помощь в решении
Есть проблемы с выгрузкой на сайт, иногда выгрузка проходит, иногда зависает.
При последней выгрузки вылезла эта ошибка в логах
Буду очень признателен если кто-то объяснит суть этой проблемы и сможет предложить пути решения этого вопроса.
06.07.2021 8:33:06--offers___90fe347b-8b20-4c32-8b3a-503e1d19b77e.xml: Произошла ошибка на стороне сервера. Получен неизвестный статус импорта.
Ответ сервера:
<br><font color=#ff0000>MySQL Query Error: INS ERT INTO b_xml_tree_import_1c (PARENT_ID, LEFT_MARGIN, RIGHT_MARGIN, DEPTH_LEVEL, NAME, VAL UE) VALUES (18, 33, 34, 4, 'РРґ', 'd5b1dd18-fcb1-11ea-8c58-902b34ee1d36')</font>[[1146] Table 'scripko_th32.b_xml_tree_import_1c' doesn't exist]<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="">
<input type="hidden" name="last_error_query" value="File: /home/s/scripko/th32.ru/public_html/bitrix/modules/main/include/dbquery_error.php
Query: INS ERT INTO b_xml_tree_import_1c (PARENT_ID, LEFT_MARGIN, RIGHT_MARGIN, DEPTH_LEVEL, NAME, VAL UE) VALUES (18, 33, 34, 4, 'РРґ', 'd5b1dd18-fcb1-11ea-8c58-902b34ee1d36')
[[1146] Table 'scripko_th32.b_xml_tree_import_1c' doesn't exist]
debug_backtrace:
Array
(
[0] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/modules/main/classes/mysql/database.php
[line] => 200
[class] =>
[function] => include
[args] => Array
(
[0] => /home/s/scripko/th32.ru/public_html/bitrix/modules/main/include/dbquery_error.php
)
)
[1] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/modules/iblock/classes/mysql/cml2.php
[line] => 268
[class] => CDatabaseMysql
[function] => Query
[args] =>
)
[2] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/modules/iblock/classes/mysql/cml2.php
[line] => 645
[class] => CIBlockXMLFile
[function] => Add
[args] =>
)
[3] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/modules/iblock/classes/mysql/cml2.php
[line] => 350
[class] => CIBlockXMLFile
[function] => _start_element
[args] =>
)
[4] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/components/bitrix/catalog.import.1c/component.php
[line] => 409
[class] => CIBlockXMLFile
[function] => ReadXMLToDatabase
[args] =>
)
[5] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/modules/main/classes/general/component.php
[line] => 605
[class] =>
[function] => include
[args] => Array
(
[0] => /home/s/scripko/th32.ru/public_html/bitrix/components/bitrix/catalog.import.1c/component.php
)
)
[6] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/modules/main/classes/general/component.php
[line] => 103
[class] => CBitrixComponent
[function] => __includeComponent
[args] =>
)
[7] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/modules/main/classes/general/component.php
[line] => 656
[class] => CBitrixComponent
[function] => executeComponent
[args] =>
)
[8] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/modules/main/classes/general/main.php
[line] => 1041
[class] => CBitrixComponent
[function] => includeComponent
[args] =>
)
[9] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/modules/sale/admin/1c_exchange.php
[line] => 90
[class] => CAllMain
[function] => IncludeComponent
[args] =>
)
[10] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/admin/1c_exchange.php
[line] => 2
[class] =>
[function] => require_once
[args] => Array
(
[0] => /home/s/scripko/th32.ru/public_html/bitrix/modules/sale/admin/1c_exchange.php
)
)
)
">
<input type="hidden" name="sessid" id="sessid" value="d0b72a842e04994c8bf0bd82d8b5670f" /> <input type="hidden" name="send_ticket" value="Y">
<input type="submit" value="Send error report to support">
</form>
</td>
</tr>
</table></td>
</tr>
</table>
<br><br><br>
06.07.2021 8:33:06--Ответ сервера: <br><font color=#ff0000>MySQL Query Error: INS ERT INTO b_xml_tree_import_1c (PARENT_ID, LEFT_MARGIN, RIGHT_MARGIN, DEPTH_LEVEL, NAME, VAL UE) VALUES (18, 33, 34, 4, 'РРґ', 'd5b1dd18-fcb1-11ea-8c58-902b34ee1d36')</font>[[1146] Table 'scripko_th32.b_xml_tree_import_1c' doesn't exist]<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="">
<input type="hidden" name="last_error_query" value="File: /home/s/scripko/th32.ru/public_html/bitrix/modules/main/include/dbquery_error.php
Query: INS ERT INTO b_xml_tree_import_1c (PARENT_ID, LEFT_MARGIN, RIGHT_MARGIN, DEPTH_LEVEL, NAME, VAL UE) VALUES (18, 33, 34, 4, 'РРґ', 'd5b1dd18-fcb1-11ea-8c58-902b34ee1d36')
[[1146] Table 'scripko_th32.b_xml_tree_import_1c' doesn't exist]
debug_backtrace:
Array
(
[0] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/modules/main/classes/mysql/database.php
[line] => 200
[class] =>
[function] => include
[args] => Array
(
[0] => /home/s/scripko/th32.ru/public_html/bitrix/modules/main/include/dbquery_error.php
)
)
[1] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/modules/iblock/classes/mysql/cml2.php
[line] => 268
[class] => CDatabaseMysql
[function] => Query
[args] =>
)
[2] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/modules/iblock/classes/mysql/cml2.php
[line] => 645
[class] => CIBlockXMLFile
[function] => Add
[args] =>
)
[3] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/modules/iblock/classes/mysql/cml2.php
[line] => 350
[class] => CIBlockXMLFile
[function] => _start_element
[args] =>
)
[4] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/components/bitrix/catalog.import.1c/component.php
[line] => 409
[class] => CIBlockXMLFile
[function] => ReadXMLToDatabase
[args] =>
)
[5] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/modules/main/classes/general/component.php
[line] => 605
[class] =>
[function] => include
[args] => Array
(
[0] => /home/s/scripko/th32.ru/public_html/bitrix/components/bitrix/catalog.import.1c/component.php
)
)
[6] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/modules/main/classes/general/component.php
[line] => 103
[class] => CBitrixComponent
[function] => __includeComponent
[args] =>
)
[7] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/modules/main/classes/general/component.php
[line] => 656
[class] => CBitrixComponent
[function] => executeComponent
[args] =>
)
[8] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/modules/main/classes/general/main.php
[line] => 1041
[class] => CBitrixComponent
[function] => includeComponent
[args] =>
)
[9] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/modules/sale/admin/1c_exchange.php
[line] => 90
[class] => CAllMain
[function] => IncludeComponent
[args] =>
)
[10] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/admin/1c_exchange.php
[line] => 2
[class] =>
[function] => require_once
[args] => Array
(
[0] => /home/s/scripko/th32.ru/public_html/bitrix/modules/sale/admin/1c_exchange.php
)
)
)
">
<input type="hidden" name="sessid" id="sessid" value="d0b72a842e04994c8bf0bd82d8b5670f" /> <input type="hidden" name="send_ticket" value="Y">
<input type="submit" value="Send error report to support">
</form>
</td>
</tr>
</table></td>
</tr>
</table>
<br><br><br>
Есть проблемы с выгрузкой на сайт, иногда выгрузка проходит, иногда зависает.
При последней выгрузки вылезла эта ошибка в логах
Буду очень признателен если кто-то объяснит суть этой проблемы и сможет предложить пути решения этого вопроса.
06.07.2021 8:33:06--offers___90fe347b-8b20-4c32-8b3a-503e1d19b77e.xml: Произошла ошибка на стороне сервера. Получен неизвестный статус импорта.
Ответ сервера:
<br><font color=#ff0000>MySQL Query Error: INS ERT INTO b_xml_tree_import_1c (PARENT_ID, LEFT_MARGIN, RIGHT_MARGIN, DEPTH_LEVEL, NAME, VAL UE) VALUES (18, 33, 34, 4, 'РРґ', 'd5b1dd18-fcb1-11ea-8c58-902b34ee1d36')</font>[[1146] Table 'scripko_th32.b_xml_tree_import_1c' doesn't exist]<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="">
<input type="hidden" name="last_error_query" value="File: /home/s/scripko/th32.ru/public_html/bitrix/modules/main/include/dbquery_error.php
Query: INS ERT INTO b_xml_tree_import_1c (PARENT_ID, LEFT_MARGIN, RIGHT_MARGIN, DEPTH_LEVEL, NAME, VAL UE) VALUES (18, 33, 34, 4, 'РРґ', 'd5b1dd18-fcb1-11ea-8c58-902b34ee1d36')
[[1146] Table 'scripko_th32.b_xml_tree_import_1c' doesn't exist]
debug_backtrace:
Array
(
[0] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/modules/main/classes/mysql/database.php
[line] => 200
[class] =>
[function] => include
[args] => Array
(
[0] => /home/s/scripko/th32.ru/public_html/bitrix/modules/main/include/dbquery_error.php
)
)
[1] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/modules/iblock/classes/mysql/cml2.php
[line] => 268
[class] => CDatabaseMysql
[function] => Query
[args] =>
)
[2] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/modules/iblock/classes/mysql/cml2.php
[line] => 645
[class] => CIBlockXMLFile
[function] => Add
[args] =>
)
[3] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/modules/iblock/classes/mysql/cml2.php
[line] => 350
[class] => CIBlockXMLFile
[function] => _start_element
[args] =>
)
[4] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/components/bitrix/catalog.import.1c/component.php
[line] => 409
[class] => CIBlockXMLFile
[function] => ReadXMLToDatabase
[args] =>
)
[5] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/modules/main/classes/general/component.php
[line] => 605
[class] =>
[function] => include
[args] => Array
(
[0] => /home/s/scripko/th32.ru/public_html/bitrix/components/bitrix/catalog.import.1c/component.php
)
)
[6] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/modules/main/classes/general/component.php
[line] => 103
[class] => CBitrixComponent
[function] => __includeComponent
[args] =>
)
[7] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/modules/main/classes/general/component.php
[line] => 656
[class] => CBitrixComponent
[function] => executeComponent
[args] =>
)
[8] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/modules/main/classes/general/main.php
[line] => 1041
[class] => CBitrixComponent
[function] => includeComponent
[args] =>
)
[9] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/modules/sale/admin/1c_exchange.php
[line] => 90
[class] => CAllMain
[function] => IncludeComponent
[args] =>
)
[10] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/admin/1c_exchange.php
[line] => 2
[class] =>
[function] => require_once
[args] => Array
(
[0] => /home/s/scripko/th32.ru/public_html/bitrix/modules/sale/admin/1c_exchange.php
)
)
)
">
<input type="hidden" name="sessid" id="sessid" value="d0b72a842e04994c8bf0bd82d8b5670f" /> <input type="hidden" name="send_ticket" value="Y">
<input type="submit" value="Send error report to support">
</form>
</td>
</tr>
</table></td>
</tr>
</table>
<br><br><br>
06.07.2021 8:33:06--Ответ сервера: <br><font color=#ff0000>MySQL Query Error: INS ERT INTO b_xml_tree_import_1c (PARENT_ID, LEFT_MARGIN, RIGHT_MARGIN, DEPTH_LEVEL, NAME, VAL UE) VALUES (18, 33, 34, 4, 'РРґ', 'd5b1dd18-fcb1-11ea-8c58-902b34ee1d36')</font>[[1146] Table 'scripko_th32.b_xml_tree_import_1c' doesn't exist]<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="">
<input type="hidden" name="last_error_query" value="File: /home/s/scripko/th32.ru/public_html/bitrix/modules/main/include/dbquery_error.php
Query: INS ERT INTO b_xml_tree_import_1c (PARENT_ID, LEFT_MARGIN, RIGHT_MARGIN, DEPTH_LEVEL, NAME, VAL UE) VALUES (18, 33, 34, 4, 'РРґ', 'd5b1dd18-fcb1-11ea-8c58-902b34ee1d36')
[[1146] Table 'scripko_th32.b_xml_tree_import_1c' doesn't exist]
debug_backtrace:
Array
(
[0] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/modules/main/classes/mysql/database.php
[line] => 200
[class] =>
[function] => include
[args] => Array
(
[0] => /home/s/scripko/th32.ru/public_html/bitrix/modules/main/include/dbquery_error.php
)
)
[1] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/modules/iblock/classes/mysql/cml2.php
[line] => 268
[class] => CDatabaseMysql
[function] => Query
[args] =>
)
[2] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/modules/iblock/classes/mysql/cml2.php
[line] => 645
[class] => CIBlockXMLFile
[function] => Add
[args] =>
)
[3] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/modules/iblock/classes/mysql/cml2.php
[line] => 350
[class] => CIBlockXMLFile
[function] => _start_element
[args] =>
)
[4] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/components/bitrix/catalog.import.1c/component.php
[line] => 409
[class] => CIBlockXMLFile
[function] => ReadXMLToDatabase
[args] =>
)
[5] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/modules/main/classes/general/component.php
[line] => 605
[class] =>
[function] => include
[args] => Array
(
[0] => /home/s/scripko/th32.ru/public_html/bitrix/components/bitrix/catalog.import.1c/component.php
)
)
[6] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/modules/main/classes/general/component.php
[line] => 103
[class] => CBitrixComponent
[function] => __includeComponent
[args] =>
)
[7] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/modules/main/classes/general/component.php
[line] => 656
[class] => CBitrixComponent
[function] => executeComponent
[args] =>
)
[8] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/modules/main/classes/general/main.php
[line] => 1041
[class] => CBitrixComponent
[function] => includeComponent
[args] =>
)
[9] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/modules/sale/admin/1c_exchange.php
[line] => 90
[class] => CAllMain
[function] => IncludeComponent
[args] =>
)
[10] => Array
(
[file] => /home/s/scripko/th32.ru/public_html/bitrix/admin/1c_exchange.php
[line] => 2
[class] =>
[function] => require_once
[args] => Array
(
[0] => /home/s/scripko/th32.ru/public_html/bitrix/modules/sale/admin/1c_exchange.php
)
)
)
">
<input type="hidden" name="sessid" id="sessid" value="d0b72a842e04994c8bf0bd82d8b5670f" /> <input type="hidden" name="send_ticket" value="Y">
<input type="submit" value="Send error report to support">
</form>
</td>
</tr>
</table></td>
</tr>
</table>
<br><br><br>