Радар Групп
Официальный дилер Volkswagen
Спецпредложения сервиса
Акции сервиса
[Bitrix\Main\DB\SqlQueryException] 
Mysql query error: (1054) Unknown column 'kodix_dws_dealers.AVAILABLE_PROGRAMS' in 'field list' (400)
SELECT 
	`kodix_dws_dealers`.`ID` AS `ID`,
	`kodix_dws_dealers`.`ACTIVE` AS `ACTIVE`,
	`kodix_dws_dealers`.`NAME` AS `NAME`,
	`kodix_dws_dealers`.`SHORT_NAME` AS `SHORT_NAME`,
	`kodix_dws_dealers`.`SORT` AS `SORT`,
	`kodix_dws_dealers`.`DATE_CREATE` AS `DATE_CREATE`,
	`kodix_dws_dealers`.`DATE_CHANGED` AS `DATE_CHANGED`,
	`kodix_dws_dealers`.`CREATED_USER_ID` AS `CREATED_USER_ID`,
	`kodix_dws_dealers`.`CHANGED_USER_ID` AS `CHANGED_USER_ID`,
	`kodix_dws_dealers`.`CODE` AS `CODE`,
	`kodix_dws_dealers`.`SITE_ID` AS `SITE_ID`,
	`kodix_dws_dealers`.`XML_ID` AS `XML_ID`,
	`kodix_dws_dealers`.`SPECIALIZATIONS` AS `SPECIALIZATIONS`,
	`kodix_dws_dealers`.`USE_AS_DEFAULT` AS `USE_AS_DEFAULT`,
	`kodix_dws_dealers`.`REGION` AS `REGION`,
	`kodix_dws_dealers`.`DISTRICT` AS `DISTRICT`,
	`kodix_dws_dealers`.`CITY` AS `CITY`,
	`kodix_dws_dealers`.`STREET` AS `STREET`,
	`kodix_dws_dealers`.`BUILD` AS `BUILD`,
	`kodix_dws_dealers`.`ZIP_CODE` AS `ZIP_CODE`,
	`kodix_dws_dealers`.`MAIN_EMAIL` AS `MAIN_EMAIL`,
	`kodix_dws_dealers`.`MAIN_PHONE` AS `MAIN_PHONE`,
	`kodix_dws_dealers`.`CALL_TRACKING` AS `CALL_TRACKING`,
	`kodix_dws_dealers`.`COORD` AS `COORD`,
	`kodix_dws_dealers`.`WORK_HOURS` AS `WORK_HOURS`,
	`kodix_dws_dealers`.`RECEIVER` AS `RECEIVER`,
	`kodix_dws_dealers`.`ACHIEVEMENTS` AS `ACHIEVEMENTS`,
	`kodix_dws_dealers`.`CTA` AS `CTA`,
	`kodix_dws_dealers`.`TITLE` AS `TITLE`,
	`kodix_dws_dealers`.`DESCRIPTION` AS `DESCRIPTION`,
	`kodix_dws_dealers`.`PHOTO` AS `PHOTO`,
	`kodix_dws_dealers`.`GALLERY` AS `GALLERY`,
	`kodix_dws_dealers`.`TIME_ZONE` AS `TIME_ZONE`,
	`kodix_dws_dealers`.`SERVER_NAME` AS `SERVER_NAME`,
	`kodix_dws_dealers`.`DOCUMENT_ROOT` AS `DOCUMENT_ROOT`,
	`kodix_dws_dealers`.`NOT_USED_IN_TD_MODELS` AS `NOT_USED_IN_TD_MODELS`,
	`kodix_dws_dealers`.`AVAILABLE_PROGRAMS` AS `AVAILABLE_PROGRAMS`,
	`kodix_dws_dealers`.`FORBIDDEN_PROGRAMS` AS `FORBIDDEN_PROGRAMS`,
	`kodix_dws_dealers_dealer_department_dealer_department`.`ID` AS `DEP_ID`,
	`kodix_dws_dealers_dealer_department_dealer_department`.`ACTIVE` AS `DEP_ACTIVE`,
	`kodix_dws_dealers_dealer_department_dealer_department`.`NAME` AS `DEP_NAME`,
	`kodix_dws_dealers_dealer_department_dealer_department`.`SORT` AS `DEP_SORT`,
	`kodix_dws_dealers_dealer_department_dealer_department`.`DATE_CREATE` AS `DEP_DATE_CREATE`,
	`kodix_dws_dealers_dealer_department_dealer_department`.`DATE_CHANGED` AS `DEP_DATE_CHANGED`,
	`kodix_dws_dealers_dealer_department_dealer_department`.`CREATED_USER_ID` AS `DEP_CREATED_USER_ID`,
	`kodix_dws_dealers_dealer_department_dealer_department`.`CHANGED_USER_ID` AS `DEP_CHANGED_USER_ID`,
	`kodix_dws_dealers_dealer_department_dealer_department`.`CODE` AS `DEP_CODE`,
	`kodix_dws_dealers_dealer_department_dealer_department`.`EMAIL` AS `DEP_EMAIL`,
	`kodix_dws_dealers_dealer_department_dealer_department`.`PHONE` AS `DEP_PHONE`,
	`kodix_dws_dealers_dealer_department_dealer_department`.`CALL_TRACKING` AS `DEP_CALL_TRACKING`,
	`kodix_dws_dealers_dealer_department_dealer_department`.`PHONE_EXT` AS `DEP_PHONE_EXT`,
	`kodix_dws_dealers_dealer_department_dealer_department`.`SCHEDULE` AS `DEP_SCHEDULE`,
	`kodix_dws_dealers_dealer_department_dealer_department`.`ICON` AS `DEP_ICON`
FROM `kdx_dealers` `kodix_dws_dealers` 
LEFT JOIN `kdx_dealer_department` `kodix_dws_dealers_dealer_department_dealer` ON `kodix_dws_dealers_dealer_department_dealer`.`DEALER_ID` = `kodix_dws_dealers`.`CODE`
LEFT JOIN `kdx_departments` `kodix_dws_dealers_dealer_department_dealer_department` ON `kodix_dws_dealers_dealer_department_dealer`.`DEPARTMENT_ID` = `kodix_dws_dealers_dealer_department_dealer_department`.`CODE`
ORDER BY `kodix_dws_dealers_dealer_department_dealer_department`.`SORT` ASC
/home/s/shnicks/d5-radar-group/pkw/public_html/bitrix/modules/main/lib/db/mysqliconnection.php:137
#0: Bitrix\Main\DB\MysqliConnection->queryInternal(string, array, NULL)
	/home/s/shnicks/d5-radar-group/pkw/public_html/bitrix/modules/main/lib/db/connection.php:329
#1: Bitrix\Main\DB\Connection->query(string)
	/home/s/shnicks/d5-radar-group/pkw/public_html/bitrix/modules/main/lib/entity/query.php:1924
#2: Bitrix\Main\Entity\Query->query(string)
	/home/s/shnicks/d5-radar-group/pkw/public_html/bitrix/modules/main/lib/entity/query.php:505
#3: Bitrix\Main\Entity\Query->exec()
	/home/s/shnicks/d5-radar-group/pkw/public_html/bitrix/modules/main/lib/entity/datamanager.php:256
#4: Bitrix\Main\Entity\DataManager::getList(array)
	/home/s/shnicks/d5-radar-group/pkw/public_html/local/modules/kodix.dws/lib/dealers.php:874
#5: Kodix\Dws\DealersTable::getList(array)
	/home/s/shnicks/d5-radar-group/pkw/public_html/local/modules/kodix.dws/lib/dealers.php:635
#6: Kodix\Dws\DealersTable::getDealers(array)
	/home/s/shnicks/d5-radar-group/pkw/public_html/local/components/dws/filter/class.php:97
#7: DwsFilter->getDealers(array)
	/home/s/shnicks/d5-radar-group/pkw/public_html/local/components/dws/filter/class.php:53
#8: DwsFilter->executeComponent()
	/home/s/shnicks/d5-radar-group/pkw/public_html/bitrix/modules/main/classes/general/component.php:585
#9: CBitrixComponent->includeComponent(string, array, boolean)
	/home/s/shnicks/d5-radar-group/pkw/public_html/bitrix/modules/main/classes/general/main.php:1035
#10: CAllMain->IncludeComponent(string, string, array, boolean, array)
	/home/s/shnicks/d5-radar-group/pkw/public_html/local/templates/.default/components/dws/base.list/articles/template.php:42
#11: include(string)
	/home/s/shnicks/d5-radar-group/pkw/public_html/bitrix/modules/main/classes/general/component_template.php:714
#12: CBitrixComponentTemplate->__IncludePHPTemplate(array, array, string)
	/home/s/shnicks/d5-radar-group/pkw/public_html/bitrix/modules/main/classes/general/component_template.php:806
#13: CBitrixComponentTemplate->IncludeTemplate(array)
	/home/s/shnicks/d5-radar-group/pkw/public_html/bitrix/modules/main/classes/general/component.php:681
#14: CBitrixComponent->showComponentTemplate()
	/home/s/shnicks/d5-radar-group/pkw/public_html/bitrix/modules/main/classes/general/component.php:629
#15: CBitrixComponent->includeComponentTemplate()
	/home/s/shnicks/d5-radar-group/pkw/public_html/local/components/dws/base.list/component.php:227
#16: include(string)
	/home/s/shnicks/d5-radar-group/pkw/public_html/bitrix/modules/main/classes/general/component.php:548
#17: CBitrixComponent->__includeComponent()
	/home/s/shnicks/d5-radar-group/pkw/public_html/bitrix/modules/main/classes/general/component.php:94
#18: CBitrixComponent->executeComponent()
	/home/s/shnicks/d5-radar-group/pkw/public_html/bitrix/modules/main/classes/general/component.php:585
#19: CBitrixComponent->includeComponent(string, array, boolean)
	/home/s/shnicks/d5-radar-group/pkw/public_html/bitrix/modules/main/classes/general/main.php:1035
#20: CAllMain->IncludeComponent(string, string, array, boolean, array)
	/home/s/shnicks/d5-radar-group/pkw/public_html/local/templates/.default/components/dws/complex/specials/template.php:40
#21: include(string)
	/home/s/shnicks/d5-radar-group/pkw/public_html/bitrix/modules/main/classes/general/component_template.php:714
#22: CBitrixComponentTemplate->__IncludePHPTemplate(array, array, string)
	/home/s/shnicks/d5-radar-group/pkw/public_html/bitrix/modules/main/classes/general/component_template.php:806
#23: CBitrixComponentTemplate->IncludeTemplate(array)
	/home/s/shnicks/d5-radar-group/pkw/public_html/bitrix/modules/main/classes/general/component.php:681
#24: CBitrixComponent->showComponentTemplate()
	/home/s/shnicks/d5-radar-group/pkw/public_html/bitrix/modules/main/classes/general/component.php:629
#25: CBitrixComponent->includeComponentTemplate(string)
	/home/s/shnicks/d5-radar-group/pkw/public_html/local/components/dws/complex/component.php:38
#26: include(string)
	/home/s/shnicks/d5-radar-group/pkw/public_html/bitrix/modules/main/classes/general/component.php:548
#27: CBitrixComponent->__includeComponent()
	/home/s/shnicks/d5-radar-group/pkw/public_html/bitrix/modules/main/classes/general/component.php:600
#28: CBitrixComponent->includeComponent(string, array, boolean)
	/home/s/shnicks/d5-radar-group/pkw/public_html/bitrix/modules/main/classes/general/main.php:1035
#29: CAllMain->IncludeComponent(string, string, array, boolean, array)
	/home/s/shnicks/d5-radar-group/pkw/public_html/owners/specials/index.php:24