Имя: Пароль:
1C
 
 Ошибка обмена Управление торговли 11.2 с битриксом сайт
☑
0 sitdv
 
16.03.17
✎
05:24
Фоновый обмен
15.03.2017 1:01:35 Запуск выгрузки товаров
15.03.2017 1:03:20 Выгрузка на сайт завершилась с ошибками.
import0_1.xml: Произошла ошибка на стороне сервера. Получен неизвестный статус импорта.
Ответ сервера:
<br><font color=#ff0000>MySQL Query Error:
            select
                ID
            from
                b_xml_tree
            where (PARENT_ID+0 = 0) and (LEFT_MARGIN = 87051)
            
        </font>[Table 'bitrix_88.b_xml_tree' 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="/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:
            select
                ID
            from
                b_xml_tree
            where (PARENT_ID+0 = 0) and (LEFT_MARGIN = 87051)
            
        
[Table 'bitrix_88.b_xml_tree' doesn't exist]
debug_backtrace:
Array
(
    [0] =&gt; Array
        (
            [file] =&gt; /home/bitrix/www/bitrix/modules/main/classes/mysql/database.php
            [line] =&gt; 229
            [class] =&gt;
            [function] =&gt; include
            [args] =&gt;
        )

    [1] =&gt; Array
        (
            [file] =&gt; /home/bitrix/www/bitrix/modules/iblock/classes/mysql/cml2.php
            [line] =&gt; 608
            [class] =&gt; CDatabase
            [function] =&gt; Query
            [args] =&gt; Array
                (
                    [0] =&gt;
            select
                ID
            from
                b_xml_tree
            where (PARENT_ID+0 = 0) and (LEFT_MARGIN = 87051)
            
        
                )

        )

    [2] =&gt; Array
        (
            [file] =&gt; /home/bitrix/www/bitrix/modules/iblock/classes/general/cml2.php
            [line] =&gt; 3147
            [class] =&gt; CIBlockXMLFile
            [function] =&gt; GetList
            [args] =&gt; Array
                (
                    [0] =&gt; Array
                        (
                        )

                    [1] =&gt; Array
                        (
                            [PARENT_ID+0] =&gt; 0
                            [LEFT_MARGIN] =&gt; 87051
                        )

                    [2] =&gt; Array
                        (
                            [0] =&gt; ID
                        )

                )

        )

    [3] =&gt; Array
        (
            [file] =&gt; /home/bitrix/www/bitrix/components/bitrix/catalog.import.1c/component.php
            [line] =&gt; 424
            [class] =&gt; CIBlockCMLImport
            [function] =&gt; DeactivateElement
            [args] =&gt; Array
                (
                    [0] =&gt; A
                    [1] =&gt; 1489503799
                    [2] =&gt; 30
                )

        )

    [4] =&gt; Array
        (
            [file] =&gt; /home/bitrix/www/bitrix/modules/main/classes/general/component.php
            [line] =&gt; 443
            [class] =&gt;
            [function] =&gt; include
            [args] =&gt; Array
                (
                    [0] =&gt; /home/bitrix/www/bitrix/components/bitrix/catalog.import.1c/component.php
                )

        )

    [5] =&gt; Array
        (
            [file] =&gt; /home/bitrix/www/bitrix/modules/main/classes/general/component.php
            [line] =&gt; 482
            [class] =&gt; CBitrixComponent
            [function] =&gt; __includeComponent
            [args] =&gt; Array
                (
                )

        )

    [6] =&gt; Array
        (
            [file] =&gt; /home/bitrix/www/bitrix/modules/main/classes/general/main.php
            [line] =&gt; 1435
            [class] =&gt; CBitrixComponent
            [function] =&gt; includeComponent
            [args] =&gt; Array
                (
                    [0] =&gt;
                    [1] =&gt; Array
                        (
                            [IBLOCK_TYPE] =&gt; 1c_catalog
                            [SITE_LIST] =&gt; Array
                                (
                                    [0] =&gt; s1
                                )

                            [INTERVAL] =&gt; 30
                            [GROUP_PERMISSIONS] =&gt; Array
                                (
                                    [0] =&gt; 1
                                    [1] =&gt; 5
                                    [2] =&gt; 6
                                )

                            [GENERATE_PREVIEW] =&gt; Y
                            [PREVIEW_WIDTH] =&gt; 100
                            [PREVIEW_HEIGHT] =&gt; 100
                            [DETAIL_RESIZE] =&gt; N
                            [DETAIL_WIDTH] =&gt; 300
                            [DETAIL_HEIGHT] =&gt; 300
                            [ELEMENT_ACTION] =&gt; A
                            [SECTION_ACTION] =&gt; A
                            [FILE_SIZE_LIMIT] =&gt; 2097152
                            [USE_CRC] =&gt; Y
                            [USE_ZIP] =&gt; Y
                            [USE_OFFERS] =&gt; Y
                            [USE_IBLOCK_TYPE_ID] =&gt; N
                            [USE_IBLOCK_PICTURE_SETTINGS] =&gt; N
                            [TRANSLIT_ON_ADD] =&gt; Y
                            [TRANSLIT_ON_UPDATE] =&gt; Y
                            [SKIP_ROOT_SECTION] =&gt; Y
                        )

                    [2] =&gt;
                )

        )

    [7] =&gt; Array
        (
            [file] =&gt; /home/bitrix/www/bitrix/modules/sale/admin/1c_exchange.php
            [line] =&gt; 66
            [class] =&gt; CAllMain
            [function] =&gt; IncludeComponent
            [args] =&gt; Array
                (
                    [0] =&gt; bitrix:catalog.import.1c
                    [1] =&gt;
                    [2] =&gt; Array
                        (
                            [IBLOCK_TYPE] =&gt; 1c_catalog
                            [SITE_LIST] =&gt; Array
                                (
                                    [0] =&gt; s1
                                )

                            [INTERVAL] =&gt; 30
                            [GROUP_PERMISSIONS] =&gt; Array
                                (
                                    [0] =&gt; 1
                                    [1] =&gt; 5
                                    [2] =&gt; 6
                                )

                            [GENERATE_PREVIEW] =&gt; Y
                            [PREVIEW_WIDTH] =&gt; 100
                            [PREVIEW_HEIGHT] =&gt; 100
                            [DETAIL_RESIZE] =&gt; N
                            [DETAIL_WIDTH] =&gt; 300
                            [DETAIL_HEIGHT] =&gt; 300
                            [ELEMENT_ACTION] =&gt; A
                            [SECTION_ACTION] =&gt; A
                            [FILE_SIZE_LIMIT] =&gt; 2097152
                            [USE_CRC] =&gt; Y
                            [USE_ZIP] =&gt; Y
                            [USE_OFFERS] =&gt; Y
                            [USE_IBLOCK_TYPE_ID] =&gt; N
                            [USE_IBLOCK_PICTURE_SETTINGS] =&gt; N
                            [TRANSLIT_ON_ADD] =&gt; Y
                            [TRANSLIT_ON_UPDATE] =&gt; Y
                            [SKIP_ROOT_SECTION] =&gt; Y
                        )

                )

        )

    [8] =&gt; Array
        (
            [file] =&gt; /home/bitrix/www/bitrix/admin/1c_exchange.php
            [line] =&gt; 2
            [class] =&gt;
            [function] =&gt; require_once
            [args] =&gt; Array
                (
                    [0] =&gt; /home/bitrix/www/bitrix/modules/sale/admin/1c_exchange.php
                )

        )

)

">
                            <input type="hidden" name="sessid" id="sessid" value="f93763d3c6b8c9d828de85712bbff253" />                            <input type="submit" value="Send error report to support">
                        </form>
                                    </td>
            </tr>
        </table></td>
    </tr>
</table>
<br><br><br>

15.03.2017 1:03:20 Завершена выгрузка товаров
Вопрос Кто нибудь сталкивался с этим?
Сам я с битриксом плохо знаком, но почитав эту ошибку я понял что проблема с таблицой MYSql, и он не может записать в нее данные,
Может нужно сделать бэкап и регламентные работы с базой MYSQL?
1 mexanik_96
 
16.03.17
✎
05:43
поймал ограничение на хостинге по числу запросов к бд или место на хостинге кончилось.