Продать недвижимость
[PommProject\Foundation\Exception\SqlException] 

SQL error state '42703' [ERROR]
====
ERROR:  column ot.type does not exist
LINE 8:  WHERE o.active=1 AND  ot.deal LIKE $1  AND  ot.type LIKE $2...
                                                     ^

====
«PREPARE ===

        select
            count(DISTINCT(o.id)) as id
        from
            public.realty_requests o
            
            LEFT JOIN public.realty_requests_types ot ON (ot.id=o.request_type_id)
 WHERE o.active=1 AND  ot.deal LIKE $1  AND  ot.type LIKE $2 
 ===». (0)
/home/bitrix/www/vendor/pomm-project/foundation/sources/lib/Session/Connection.php:327
#0: PommProject\Foundation\Session\Connection->getQueryResult(string)
	/home/bitrix/www/vendor/pomm-project/foundation/sources/lib/Session/Connection.php:450
#1: PommProject\Foundation\Session\Connection->sendPrepareQuery(string, string)
	/home/bitrix/www/vendor/pomm-project/foundation/sources/lib/PreparedQuery/PreparedQuery.php:173
#2: PommProject\Foundation\PreparedQuery\PreparedQuery->prepare()
	/home/bitrix/www/vendor/pomm-project/foundation/sources/lib/PreparedQuery/PreparedQuery.php:124
#3: PommProject\Foundation\PreparedQuery\PreparedQuery->execute(array)
	/home/bitrix/www/vendor/pomm-project/model-manager/sources/lib/Model/Model.php:165
#4: PommProject\ModelManager\Model\Model->query(string, array)
	/home/bitrix/www/local/lib/Intrumnet/Entity/Requests.php:575
#5: Redramka\Intrumnet\Entity\Requests->getCount(boolean)
	/home/bitrix/www/local/lib/Intrumnet/Entity/Requests.php:673
#6: Redramka\Intrumnet\Entity\Requests->get(integer, integer, NULL)
	/home/bitrix/www/local/components/redramka/salerequest.section/class.php:406
#7: CRedramkaSaleSection->getItemsList(array, integer, integer, NULL)
	/home/bitrix/www/local/components/redramka/salerequest.section/class.php:505
#8: CRedramkaSaleSection->executeComponent()
	/home/bitrix/www/bitrix/modules/main/classes/general/component.php:638
#9: CBitrixComponent->includeComponent(string, array, object)
	/home/bitrix/www/bitrix/modules/main/classes/general/main.php:1043
#10: CAllMain->IncludeComponent(string, string, array, object)
	/home/bitrix/www/local/templates/alatartsev/components/redramka/catalog/sale/section.php:88
#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(string)
	/home/bitrix/www/local/components/redramka/catalog/component.php:153
#16: include(string)
	/home/bitrix/www/bitrix/modules/main/classes/general/component.php:594
#17: CBitrixComponent->__includeComponent()
	/home/bitrix/www/bitrix/modules/main/classes/general/component.php:653
#18: CBitrixComponent->includeComponent(string, array, boolean)
	/home/bitrix/www/bitrix/modules/main/classes/general/main.php:1043
#19: CAllMain->IncludeComponent(string, string, array, boolean)
	/home/bitrix/www/sale/catalog/index.php:48
#20: include_once(string)
	/home/bitrix/www/bitrix/modules/main/include/urlrewrite.php:159
#21: include_once(string)
	/home/bitrix/www/bitrix/urlrewrite.php:2