Здравствуйте коллеги!
После обновления Битрикса на версию 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 Завершена выгрузка товаров |
Хотя таблица, на которую ругается выгрузка существует. Что делать?!