Здравствуйте коллеги!
После обновления Битрикса на версию 11.5.4 возникла ошибка:
Хотя таблица, на которую ругается выгрузка существует. Что делать?!
После обновления Битрикса на версию 11.5.4 возникла ошибка:
| Код |
|---|
24.07.2012 9:39:59 Выгрузка на сайт завершилась с ошибками.
offers.xml: Произошла ошибка на стороне сервера. Получен неизвестный статус импорта.
Ответ сервера:
<br><font color=#ff0000>MySQL Query Error: SELECT 'x' FROM B_CATALOG_CURRENCY WHERE UPPER(CURRENCY) = UPPER('RUB')</font>[Table 'bitrix.B_CATALOG_CURRENCY' 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 'x' FROM B_CATALOG_CURRENCY WHERE UPPER(CURRENCY) = UPPER('RUB')
[Table 'bitrix.B_CATALOG_CURRENCY' doesn't exist]
debug_backtrace:
Array
(
[0] => Array
(
[file] => /home/bitrix/www/bitrix/modules/main/classes/mysql/database.php
[line] => 227
[class] =>
[function] => include
[args] =>
)
[1] => Array
(
[file] => /home/bitrix/www/bitrix/modules/currency/general/currency.php
[line] => 55
[class] => CDatabase
[function] => Query
[args] => Array
(
[0] => SELECT 'x' FROM B_CATALOG_CURRENCY WHERE UPPER(CURRENCY) = UPPER('RUB')
)
)
[2] => Array
(
[file] => /home/bitrix/www/bitrix/modules/currency/general/currency.php
[line] => 124
[class] => CAllCurrency
[function] => CheckFields
[args] => Array
(
[0] => ADD
[1] => Array
(
[CURRENCY] => RUB
)
)
)
[3] => Array
(
[file] => /home/bitrix/www/bitrix/modules/iblock/classes/general/cml2.php
[line] => 440
[class] => CAllCurrency
[function] => Add
[args] => Array
(
[0] => Array
(
[CURRENCY] => RUB
)
)
)
[4] => Array
(
[file] => /home/bitrix/www/bitrix/modules/iblock/classes/general/cml2.php
[line] => 2515
[class] => CIBlockCMLImport
[function] => CheckCurrency
[args] => Array
(
[0] => RUB
)
)
[5] => Array
(
[file] => /home/bitrix/www/bitrix/modules/iblock/classes/general/cml2.php
[line] => 2299
[class] => CIBlockCMLImport
[function] => SetProductPrice
[args] => Array
(
[0] => 42553
[1] => Array
(
[0] => Array
(
[�������������] => 4�130 RUB �� ��
[����������] => bd020010-be9e-11e0-89a8-001bb974cbac
[�������������] => 4130.00
[������] => RUB
[�������] => ��
[�����������] => 1
[PRICE] => Array
(
[NAME] => ��������� ����������
[XML_ID] => bd020010-be9e-11e0-89a8-001bb974cbac
[CURRENCY] => RUB
[TAX_NAME] => ���
[TAX_IN_SUM] => true
[ID] => 2
)
)
)
[2] => Array
(
)
)
)
[6] => Array
(
[file] => /home/bitrix/www/bitrix/modules/iblock/classes/general/cml2.php
[line] => 1516
[class] => CIBlockCMLImport
[function] => ImportElement
[args] => Array
(
[0] => Array
(
[��] => 3b28d209-d251-11e1-f589-406186e76d9e
[������������] => ������������� ������ MaxHunter ��������
[����] => Array
(
[����] => Array
(
[�������������] => 4�130 RUB �� ��
[����������] => bd020010-be9e-11e0-89a8-001bb974cbac
[�������������] => 4130.00
[������] => RUB
[�������] => ��
[�����������] => 1
)
)
)
[1] => Array
(
[ADD] => 1
[UPD] => 0
[DEL] => 0
[DEA] => 0
[ERR] => 0
[CRC] => 27
)
[2] =>
[3] => Array
(
[ID] => 332
[LEFT_MARGIN] => 660
[RIGHT_MARGIN] => 681
)
)
)
[7] => Array
(
[file] => /home/bitrix/www/bitrix/components/bitrix/catalog.import.1c/component.php
[line] => 381
[class] => CIBlockCMLImport
[function] => ImportElements
[args] => Array
(
[0] => 1343108398
[1] => 15
)
)
[8] => 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/bitrix/catalog.import.1c/component.php
)
)
[9] => Array
(
[file] => /home/bitrix/www/bitrix/modules/main/classes/general/component.php
[line] => 250
[class] => CBitrixComponent
[function] => __IncludeComponent
[args] => Array
(
)
)
[10] => Array
(
[file] => /home/bitrix/www/bitrix/modules/main/classes/general/main.php
[line] => 1165
[class] => CBitrixComponent
[function] => IncludeComponent
[args] => Array
(
[0] =>
[1] => Array
(
[IBLOCK_TYPE] => -
[SITE_LIST] => Array
(
[0] => -
)
[INTERVAL] => 15
[GROUP_PERMISSIONS] => Array
(
[0] => 1
[1] => 7
[2] => 5
)
[GENERATE_PREVIEW] => N
[PREVIEW_WIDTH] =>
[PREVIEW_HEIGHT] =>
[DETAIL_RESIZE] => N
[DETAIL_WIDTH] =>
[DETAIL_HEIGHT] =>
[ELEMENT_ACTION] => A
[SECTION_ACTION] => A
[FILE_SIZE_LIMIT] => 102400
[USE_CRC] => Y
[USE_ZIP] => Y
[USE_OFFERS] => Y
[USE_IBLOCK_TYPE_ID] => N
[USE_IBLOCK_PICTURE_SETTINGS] => N
[TRANSLIT_ON_ADD] => Y
[TRANSLIT_ON_UPDATE] => Y
[SKIP_ROOT_SECTION] => N
)
[2] =>
)
)
[11] => Array
(
[file] => /home/bitrix/www/bitrix/modules/sale/admin/1c_exchange.php
[line] => 67
[class] => CAllMain
[function] => IncludeComponent
[args] => Array
(
[0] => bitrix:catalog.import.1c
[1] =>
[2] => Array
(
[IBLOCK_TYPE] => -
[SITE_LIST] => Array
(
[0] => -
)
[INTERVAL] => 15
[GROUP_PERMISSIONS] => Array
(
[0] => 1
[1] => 7
[2] => 5
)
[GENERATE_PREVIEW] => N
[PREVIEW_WIDTH] =>
[PREVIEW_HEIGHT] =>
[DETAIL_RESIZE] => N
[DETAIL_WIDTH] =>
[DETAIL_HEIGHT] =>
[ELEMENT_ACTION] => A
[SECTION_ACTION] => A
[FILE_SIZE_LIMIT] => 102400
[USE_CRC] => Y
[USE_ZIP] => Y
[USE_OFFERS] => Y
[USE_IBLOCK_TYPE_ID] => N
[USE_IBLOCK_PICTURE_SETTINGS] => N
[TRANSLIT_ON_ADD] => Y
[TRANSLIT_ON_UPDATE] => Y
[SKIP_ROOT_SECTION] => N
)
)
)
[12] => 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="hidden" name="sessid" id="sessid" value="bfbd5ab35734d86bdf4b65a97b369e42" /> <input type="submit" value="Send error report to support">
</form>
</td>
</tr>
</table></td>
</tr>
</table>
<br><br><br>
24.07.2012 9:39:59 Завершена выгрузка товаров
|
Хотя таблица, на которую ругается выгрузка существует. Что делать?!
