Здравствуйте! На вкладке «Синхронизация ресторанов» сделал настройки. После синхронизации появилась ошибка:
[Bitrix\Main\DB\SqlQueryException]
Mysql query error: (1146) Table 'mango-nchr_new.b_grain_iiko_delivery_terminal' doesn't exist (400)
SEL ECT
`grain_iiko_delivery_terminal`.`ID` AS `ID`,
`grain_iiko_delivery_terminal`.`ORGANIZATION_ID` AS `ORGANIZATION_ID`,
`grain_iiko_delivery_terminal`.`DELIVERY_TERMINAL_ID` AS `DELIVERY_TERMINAL_ID`,
`grain_iiko_delivery_terminal`.`DELIVERY_GROUP_NAME` AS `DELIVERY_GROUP_NAME`,
`grain_iiko_delivery_terminal`.`DELIVERY_RESTAURANT_NAME` AS `DELIVERY_RESTAURANT_NAME`,
`grain_iiko_delivery_terminal`.`NAME` AS `NAME`,
`grain_iiko_delivery_terminal`.`ADDRESS` AS `ADDRESS`,
`grain_iiko_delivery_terminal`.`OPENING_HOURS` AS `OPENING_HOURS`,
`grain_iiko_delivery_terminal`.`EXTERNAL_REVISION` AS `EXTERNAL_REVISION`,
`grain_iiko_delivery_terminal`.`TECHNICAL_INFORMATION` AS `TECHNICAL_INFORMATION`
FR OM `b_grain_iiko_delivery_terminal` `grain_iiko_delivery_terminal`
WHERE UPPER(`grain_iiko_delivery_terminal`.`ORGANIZATION_ID`) like upper('854bac38-99ca-47f0-a4fa-1540480f9972')
/home/mango-nchr/mango-nch-new.ru/docs/bitrix/modules/main/lib/db/mysqliconnection.php:153
#0: Bitrix\Main\DB\MysqliConnection->queryInternal(string, array, NULL)
/home/mango-nchr/mango-nch-new.ru/docs/bitrix/modules/main/lib/db/connection.php:327
#1: Bitrix\Main\DB\Connection->query(string)
/home/mango-nchr/mango-nch-new.ru/docs/bitrix/modules/main/lib/orm/query/query.php:3558
#2: Bitrix\Main\ORM\Query\Query->query(string)
/home/mango-nchr/mango-nch-new.ru/docs/bitrix/modules/main/lib/orm/query/query.php:952
#3: Bitrix\Main\ORM\Query\Query->exec()
/home/mango-nchr/mango-nch-new.ru/docs/bitrix/modules/main/lib/orm/data/datamanager.php:513
#4: Bitrix\Main\ORM\Data\DataManager::getList(array)
/home/mango-nchr/mango-nch-new.ru/docs/bitrix/modules/grain.iiko/options.php:306
#5: include(string)
/home/mango-nchr/mango-nch-new.ru/docs/bitrix/modules/main/admin/settings.php:64
#6: require_once(string)
/home/mango-nchr/mango-nch-new.ru/docs/bitrix/admin/settings.php:2
----------
Сами рестораны в инфоблок записались. Как решить данную проблему?
При включении "&debug=rest" получаю следующее:
Array
(
[0] => Array
(
[result] => Array
(
[0] => Array
(
[id] => 854bac38-99ca-47f0-a4fa-1540480f9972
[name] => МАНГО
[latitude] => 55.7127701
[longitude] => 52.3919911
[address] => Татарстан, Набережные Челны, ул Орловская д 143Б помещ 1005
)
)
[account] => Array
(
[ID] => 0
[HOST] => api-ru.iiko.services
[PORT] => 443
[LOGIN] => ***
[PASSWORD] =>
[API_VERSION] => 1
)
)
)
[Bitrix\Main\DB\SqlQueryException]
Mysql query error: (1146) Table 'mango-nchr_new.b_grain_iiko_delivery_terminal' doesn't exist (400)
SEL ECT
`grain_iiko_delivery_terminal`.`ID` AS `ID`,
`grain_iiko_delivery_terminal`.`ORGANIZATION_ID` AS `ORGANIZATION_ID`,
`grain_iiko_delivery_terminal`.`DELIVERY_TERMINAL_ID` AS `DELIVERY_TERMINAL_ID`,
`grain_iiko_delivery_terminal`.`DELIVERY_GROUP_NAME` AS `DELIVERY_GROUP_NAME`,
`grain_iiko_delivery_terminal`.`DELIVERY_RESTAURANT_NAME` AS `DELIVERY_RESTAURANT_NAME`,
`grain_iiko_delivery_terminal`.`NAME` AS `NAME`,
`grain_iiko_delivery_terminal`.`ADDRESS` AS `ADDRESS`,
`grain_iiko_delivery_terminal`.`OPENING_HOURS` AS `OPENING_HOURS`,
`grain_iiko_delivery_terminal`.`EXTERNAL_REVISION` AS `EXTERNAL_REVISION`,
`grain_iiko_delivery_terminal`.`TECHNICAL_INFORMATION` AS `TECHNICAL_INFORMATION`
FR OM `b_grain_iiko_delivery_terminal` `grain_iiko_delivery_terminal`
WHERE UPPER(`grain_iiko_delivery_terminal`.`ORGANIZATION_ID`) like upper('854bac38-99ca-47f0-a4fa-1540480f9972')
/home/mango-nchr/mango-nch-new.ru/docs/bitrix/modules/main/lib/db/mysqliconnection.php:153
#0: Bitrix\Main\DB\MysqliConnection->queryInternal(string, array, NULL)
/home/mango-nchr/mango-nch-new.ru/docs/bitrix/modules/main/lib/db/connection.php:327
#1: Bitrix\Main\DB\Connection->query(string)
/home/mango-nchr/mango-nch-new.ru/docs/bitrix/modules/main/lib/orm/query/query.php:3558
#2: Bitrix\Main\ORM\Query\Query->query(string)
/home/mango-nchr/mango-nch-new.ru/docs/bitrix/modules/main/lib/orm/query/query.php:952
#3: Bitrix\Main\ORM\Query\Query->exec()
/home/mango-nchr/mango-nch-new.ru/docs/bitrix/modules/main/lib/orm/data/datamanager.php:513
#4: Bitrix\Main\ORM\Data\DataManager::getList(array)
/home/mango-nchr/mango-nch-new.ru/docs/bitrix/modules/grain.iiko/options.php:306
#5: include(string)
/home/mango-nchr/mango-nch-new.ru/docs/bitrix/modules/main/admin/settings.php:64
#6: require_once(string)
/home/mango-nchr/mango-nch-new.ru/docs/bitrix/admin/settings.php:2
----------
