[Bitrix\Main\DB\SqlQueryException]
Mysql query error: (1054) Unknown column 'documentgenerator_model_template.PREVIEW_ID' in 'field list' (400)
SEL ECT
`documentgenerator_model_template`.`ID` AS `ID`,
`documentgenerator_model_template`.`ACTIVE` AS `ACTIVE`,
`documentgenerator_model_template`.`NAME` AS `NAME`,
`documentgenerator_model_template`.`CODE` AS `CODE`,
`documentgenerator_model_template`.`REGION` AS `REGION`,
`documentgenerator_model_template`.`SORT` AS `SORT`,
`documentgenerator_model_template`.`PREVIEW_ID` AS `PREVIEW_ID`,
`documentgenerator_model_template`.`CREATE_TIME` AS `CREATE_TIME`,
`documentgenerator_model_template`.`UPDATE_TIME` AS `UPDATE_TIME`,
`documentgenerator_model_template`.`CREATED_BY` AS `CREATED_BY`,
`documentgenerator_model_template`.`UPDATED_BY` AS `UPDATED_BY`,
`documentgenerator_model_template`.`SITE_ID` AS `SITE_ID`,
`documentgenerator_model_template`.`MODULE_ID` AS `MODULE_ID`,
`documentgenerator_model_template`.`FILE_ID` AS `FILE_ID`,
`documentgenerator_model_template`.`BODY_TYPE` AS `BODY_TYPE`,
`documentgenerator_model_template`.`NUMERATOR_ID` AS `NUMERATOR_ID`,
`documentgenerator_model_template`.`WITH_STAMPS` AS `WITH_STAMPS`
FR OM `b_documentgenerator_template` `documentgenerator_model_template`
LEFT JOIN `b_documentgenerator_template_provider` `documentgenerator_model_template_provider` ON `documentgenerator_model_template`.`ID` = `documentgenerator_model_template_provider`.`TEMPLATE_ID`
LEFT JOIN `b_documentgenerator_template_user` `documentgenerator_model_template_user` ON `documentgenerator_model_template`.`ID` = `documentgenerator_model_template_user`.`TEMPLATE_ID`
WHERE (`documentgenerator_model_template_provider`.`PROVIDER` = 'bitrix\\crm\\integration\\documentgenerator\\dataprovider\\contact' AND `documentgenerator_model_template`.`ACTIVE` = 'Y' AND (`documentgenerator_model_template_user`.`ACCESS_CODE` IN (SELECT
`main_user_access`.`ACCESS_CODE` AS `ACCESS_CODE`
FR OM `b_user_access` `main_user_access`
WH ERE `main_user_access`.`USER_ID` = 5) OR `documentgenerator_model_template_user`.`ACCESS_CODE` = 'UA'))
GROUP BY `documentgenerator_model_template`.`ID`, `documentgenerator_model_template`.`ACTIVE`, `documentgenerator_model_template`.`NAME`, `documentgenerator_model_template`.`CODE`, `documentgenerator_model_template`.`REGION`, `documentgenerator_model_template`.`SORT`, `documentgenerator_model_template`.`PREVIEW_ID`, `documentgenerator_model_template`.`CREATE_TIME`, `documentgenerator_model_template`.`UPDATE_TIME`, `documentgenerator_model_template`.`CREATED_BY`, `documentgenerator_model_template`.`UPDATED_BY`, `documentgenerator_model_template`.`SITE_ID`, `documentgenerator_model_template`.`MODULE_ID`, `documentgenerator_model_template`.`FILE_ID`, `documentgenerator_model_template`.`BODY_TYPE`, `documentgenerator_model_template`.`NUMERATOR_ID`, `documentgenerator_model_template`.`WITH_STAMPS`
ORDER BY `SORT` ASC, `ID` ASC
/home/bitrix/www/bitrix/modules/main/lib/db/mysqliconnection.php:137
#0: Bitrix\Main\DB\MysqliConnection->queryInternal(string, array, NULL)
/home/bitrix/www/bitrix/modules/main/lib/db/connection.php:330
#1: Bitrix\Main\DB\Connection->query(string)
/home/bitrix/www/bitrix/modules/main/lib/orm/query/query.php:3137
#2: Bitrix\Main\ORM\Query\Query->query(string)
/home/bitrix/www/bitrix/modules/main/lib/orm/query/query.php:806
#3: Bitrix\Main\ORM\Query\Query->exec()
/home/bitrix/www/bitrix/modules/main/lib/orm/data/datamanager.php:407
#4: Bitrix\Main\ORM\Data\DataManager::getList(array)
/home/bitrix/www/bitrix/modules/documentgenerator/lib/model/template.php:139
#5: Bitrix\DocumentGenerator\Model\TemplateTable::getListByClassName(string, string, integer)
/home/bitrix/www/bitrix/modules/crm/lib/integration/documentgeneratormanager.php:82
#6: Bitrix\Crm\Integration\DocumentGeneratorManager->getPreviewList(string, integer)
/home/bitrix/www/bitrix/components/bitrix/crm.contact.menu/component.php:133
#7: include(string)
/home/bitrix/www/bitrix/modules/main/classes/general/component.php:594
#8: CBitrixComponent->__includeComponent()
/home/bitrix/www/bitrix/modules/main/classes/general/component.php:653
#9: CBitrixComponent->includeComponent(string, array, object)
/home/bitrix/www/bitrix/modules/main/classes/general/main.php:1037
#10: CAllMain->IncludeComponent(string, string, array, object)
/home/bitrix/www/bitrix/components/bitrix/crm.contact.details/templates/.default/template.php:51
#11: include(string)
/home/bitrix/www/bitrix/modules/main/classes/general/component_template.php:720
#12: CBitrixComponentTemplate->__IncludePHPTemplate(array, array, string)
/home/bitrix/www/bitrix/modules/main/classes/general/component_template.php:815
#13: CBitrixComponentTemplate->IncludeTemplate(array)
/home/bitrix/www/bitrix/modules/main/classes/general/component.php:735
#14: CBitrixComponent->showComponentTemplate()
/home/bitrix/www/bitrix/modules/main/classes/general/component.php:683
#15: CBitrixComponent->includeComponentTemplate()
/home/bitrix/www/bitrix/components/bitrix/crm.contact.details/class.php:627
#16: CCrmContactDetailsComponent->executeComponent()
/home/bitrix/www/bitrix/modules/main/classes/general/component.php:638
#17: CBitrixComponent->includeComponent(string, array, NULL)
/home/bitrix/www/bitrix/modules/main/classes/general/main.php:1037
#18: CAllMain->IncludeComponent(string, string, array)
/home/bitrix/www/bitrix/components/bitrix/crm.entity.details.frame/templates/.default/template.php:148
#19: include(string)
/home/bitrix/www/bitrix/modules/main/classes/general/component_template.php:720
#20: CBitrixComponentTemplate->__IncludePHPTemplate(array, array, string)
/home/bitrix/www/bitrix/modules/main/classes/general/component_template.php:815
#21: CBitrixComponentTemplate->IncludeTemplate(array)
/home/bitrix/www/bitrix/modules/main/classes/general/component.php:735
#22: CBitrixComponent->showComponentTemplate()
/home/bitrix/www/bitrix/modules/main/classes/general/component.php:683
#23: CBitrixComponent->includeComponentTemplate()
/home/bitrix/www/bitrix/components/bitrix/crm.entity.details.frame/class.php:34
#24: CCrmEntityDetailsFrameComponent->executeComponent()
/home/bitrix/www/bitrix/modules/main/classes/general/component.php:638
#25: CBitrixComponent->includeComponent(string, array, NULL)
/home/bitrix/www/bitrix/modules/main/classes/general/main.php:1037
#26: CAllMain->IncludeComponent(string, string, array)
/home/bitrix/www/bitrix/components/bitrix/crm.contact/templates/.default/details.php:11
#27: include(string)
/home/bitrix/www/bitrix/modules/main/classes/general/component_template.php:720
#28: CBitrixComponentTemplate->__IncludePHPTemplate(array, array, string)
/home/bitrix/www/bitrix/modules/main/classes/general/component_template.php:815
#29: CBitrixComponentTemplate->IncludeTemplate(array)
/home/bitrix/www/bitrix/modules/main/classes/general/component.php:735
#30: CBitrixComponent->showComponentTemplate()
/home/bitrix/www/bitrix/modules/main/classes/general/component.php:683
#31: CBitrixComponent->includeComponentTemplate(string)
/home/bitrix/www/bitrix/components/bitrix/crm.contact/component.php:163
#32: include(string)
/home/bitrix/www/bitrix/modules/main/classes/general/component.php:594
#33: CBitrixComponent->__includeComponent()
/home/bitrix/www/bitrix/modules/main/classes/general/component.php:653
#34: CBitrixComponent->includeComponent(string, array, NULL)
/home/bitrix/www/bitrix/modules/main/classes/general/main.php:1037
#35: CAllMain->IncludeComponent(string, string, array)
/home/bitrix/www/crm/contact/index.php:9
#36: include_once(string)
/home/bitrix/www/bitrix/modules/main/include/urlrewrite.php:159
#37: include_once(string)
/home/bitrix/www/bitrix/urlrewrite.php:2
|