Добрый день!
Возникла проблема с выгрузкой из УТ11 в битрикс, после переезда на новый выделенный сервер.
Не понятно почему не удается выполнить обработчиком запрос который в [URL=http://apple-zone.ru/bitrix/admin/tools_index.php?lang=ru]Инструменты[/URL][IMG WIDTH=3 HEIGHT=5]http://apple-zone.ru/bitrix/themes/.default/images/chain_arrow.gif[/IMG][URL=http://apple-zone.ru/bitrix/admin/sql.php?lang=ru&del_query=Y]SQL запрос[/URL] выполняется без проблем, только если имя таблицы будет строчными буквами а не заглавными (с заглавными возникает та же ошибка). Подскажите в какую сторону копать?
[CODE] том числе для каталога Основной каталог товаров:
товаров: 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 Завершена выгрузка товаров
[/CODE]
Возникла проблема с выгрузкой из УТ11 в битрикс, после переезда на новый выделенный сервер.
Не понятно почему не удается выполнить обработчиком запрос который в [URL=http://apple-zone.ru/bitrix/admin/tools_index.php?lang=ru]Инструменты[/URL][IMG WIDTH=3 HEIGHT=5]http://apple-zone.ru/bitrix/themes/.default/images/chain_arrow.gif[/IMG][URL=http://apple-zone.ru/bitrix/admin/sql.php?lang=ru&del_query=Y]SQL запрос[/URL] выполняется без проблем, только если имя таблицы будет строчными буквами а не заглавными (с заглавными возникает та же ошибка). Подскажите в какую сторону копать?
[CODE] том числе для каталога Основной каталог товаров:
товаров: 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 Завершена выгрузка товаров
[/CODE]