Добрый день!
Возникла проблема с выгрузкой из УТ11 в битрикс, после переезда на новый выделенный сервер.
Не понятно почему не удается выполнить обработчиком запрос который вИнструменты SQL запрос выполняется без проблем, только если имя таблицы будет строчными буквами а не заглавными (с заглавными возникает та же ошибка). Подскажите в какую сторону копать?
Возникла проблема с выгрузкой из УТ11 в битрикс, после переезда на новый выделенный сервер.
Не понятно почему не удается выполнить обработчиком запрос который в
Код |
---|
том числе для каталога Основной каталог товаров: товаров: 255 предложений: 231 картинок: 1 098 файлов: 2 24.07.2012 13:03:32 Выгрузка на сайт завершилась с ошибками. offers.xml: Произошла ошибка на стороне сервера. Получен неизвестный статус импорта. Ответ сервера: <br><font color=#ff0000>MySQL Query Error: SELECT 'x' FROM B_CATALOG_CURRENCY WHERE UPPER(CURRENCY) = UPPER('RUB')</font>[Table 'apple.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: /var/www/nsp-center/data/www/apple-zone.ru/bitrix/modules/main/include/dbquery_error.php Query: SELECT 'x' FROM B_CATALOG_CURRENCY WHERE UPPER(CURRENCY) = UPPER('RUB') [Table 'apple.B_CATALOG_CURRENCY' doesn't exist] debug_backtrace: Array ( [0] => Array ( [file] => /var/www/nsp-center/data/www/apple-zone.ru/bitrix/modules/main/classes/mysql/database.php [line] => 227 [class] => [function] => include [args] => ) [1] => Array ( [file] => /var/www/nsp-center/data/www/apple-zone.ru/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] => /var/www/nsp-center/data/www/apple-zone.ru/bitrix/modules/currency/general/currency.php [line] => 124 [class] => CAllCurrency [function] => CheckFields [args] => Array ( [0] => ADD [1] => Array ( [CURRENCY] => RUB ) ) ) [3] => Array ( [file] => /var/www/nsp-center/data/www/apple-zone.ru/bitrix/modules/iblock/classes/general/cml2.php [line] => 440 [class] => CAllCurrency [function] => Add [args] => Array ( [0] => Array ( [CURRENCY] => RUB ) ) ) [4] => Array ( [file] => /var/www/nsp-center/data/www/apple-zone.ru/bitrix/modules/iblock/classes/general/cml2.php [line] => 2515 [class] => CIBlockCMLImport [function] => CheckCurrency [args] => Array ( [0] => RUB ) ) [5] => Array ( [file] => /var/www/nsp-center/data/www/apple-zone.ru/bitrix/modules/iblock/classes/general/cml2.php [line] => 2451 [class] => CIBlockCMLImport [function] => SetProductPrice [args] => Array ( [0] => 1323 [1] => Array ( [0] => Array ( [Представление] => 200 RUB Р·Р° шт [Р?дТипаЦены] => 7b0b3463-0bb0-11e1-8c8e-0025900b9a1c [ЦенаЗаЕдиницу] => 200.00 [Валюта] => RUB [Единица] => шт [Коэффициент] => 1 [PRICE] => Array ( [NAME] => РћСЃРЅРѕРІРЅРѕР№ РґРѕРіРѕРІРѕСЂ (Р Р¤) [XML_ID] => 7b0b3463-0bb0-11e1-8c8e-0025900b9a1c [CURRENCY] => RUB [TAX_NAME] => НДС [TAX_IN_SUM] => false [ID] => 8 ) ) ) [2] => Array ( ) ) ) [6] => Array ( [file] => /var/www/nsp-center/data/www/apple-zone.ru/bitrix/modules/iblock/classes/general/cml2.php [line] => 1514 [class] => CIBlockCMLImport [function] => ImportElementPrices [args] => Array ( [0] => Array ( [Р?Рґ] => a1604e14-26d5-11e1-81ac-0025900b9a1c [Наименование] => Доставка заказа [Цены] => Array ( [Цена] => Array ( [Представление] => 200 RUB Р·Р° шт [Р?дТипаЦены] => 7b0b3463-0bb0-11e1-8c8e-0025900b9a1c [ЦенаЗаЕдиницу] => 200.00 [Валюта] => RUB [Единица] => шт [Коэффициент] => 1 ) ) ) [1] => Array ( [ADD] => 0 [UPD] => 0 [DEL] => 0 [DEA] => 0 [ERR] => 0 [CRC] => 1 ) [2] => ) ) [7] => Array ( [file] => /var/www/nsp-center/data/www/apple-zone.ru/bitrix/components/bitrix/catalog.import.1c/component.php [line] => 381 [class] => CIBlockCMLImport [function] => ImportElements [args] => Array ( [0] => 1343120612 [1] => 30 ) ) [8] => Array ( [file] => /var/www/nsp-center/data/www/apple-zone.ru/bitrix/modules/main/classes/general/component.php [line] => 211 [class] => [function] => include [args] => Array ( [0] => /var/www/nsp-center/data/www/apple-zone.ru/bitrix/components/bitrix/catalog.import.1c/component.php ) ) [9] => Array ( [file] => /var/www/nsp-center/data/www/apple-zone.ru/bitrix/modules/main/classes/general/component.php [line] => 250 [class] => CBitrixComponent [function] => __IncludeComponent [args] => Array ( ) ) [10] => Array ( [file] => /var/www/nsp-center/data/www/apple-zone.ru/bitrix/modules/main/classes/general/main.php [line] => 1165 [class] => CBitrixComponent [function] => IncludeComponent [args] => Array ( [0] => [1] => Array ( [IBLOCK_TYPE] => applezone [SITE_LIST] => Array ( [0] => - ) [INTERVAL] => 30 [GROUP_PERMISSIONS] => Array ( [0] => 1 [1] => 5 ) [GENERATE_PREVIEW] => N [PREVIEW_WIDTH] => [PREVIEW_HEIGHT] => [DETAIL_RESIZE] => N [DETAIL_WIDTH] => [DETAIL_HEIGHT] => [ELEMENT_ACTION] => D [SECTION_ACTION] => D [FILE_SIZE_LIMIT] => 204800 [USE_CRC] => Y [USE_ZIP] => Y [USE_OFFERS] => N [USE_IBLOCK_TYPE_ID] => Y [USE_IBLOCK_PICTURE_SETTINGS] => Y [TRANSLIT_ON_ADD] => Y [TRANSLIT_ON_UPDATE] => Y [SKIP_ROOT_SECTION] => N ) [2] => ) ) [11] => Array ( [file] => /var/www/nsp-center/data/www/apple-zone.ru/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] => applezone [SITE_LIST] => Array ( [0] => - ) [INTERVAL] => 30 [GROUP_PERMISSIONS] => Array ( [0] => 1 [1] => 5 ) [GENERATE_PREVIEW] => N [PREVIEW_WIDTH] => [PREVIEW_HEIGHT] => [DETAIL_RESIZE] => N [DETAIL_WIDTH] => [DETAIL_HEIGHT] => [ELEMENT_ACTION] => D [SECTION_ACTION] => D [FILE_SIZE_LIMIT] => 204800 [USE_CRC] => Y [USE_ZIP] => Y [USE_OFFERS] => N [USE_IBLOCK_TYPE_ID] => Y [USE_IBLOCK_PICTURE_SETTINGS] => Y [TRANSLIT_ON_ADD] => Y [TRANSLIT_ON_UPDATE] => Y [SKIP_ROOT_SECTION] => N ) ) ) [12] => Array ( [file] => /var/www/nsp-center/data/www/apple-zone.ru/bitrix/admin/1c_exchange.php [line] => 2 [class] => [function] => require_once [args] => Array ( [0] => /var/www/nsp-center/data/www/apple-zone.ru/bitrix/modules/sale/admin/1c_exchange.php ) ) ) "> <input type="hidden" name="sessid" id="sessid" value="19de878eefcbf58a29e39992a49834d3" /> <input type="submit" value="Send error report to support"> </form> </td> </tr> </table></td> </tr> </table> <br><br><br> 24.07.2012 13:03:34 Завершена выгрузка товаров |