Prepare error: ERROR: column INFO_ROOM.D_COMPETATION_BLOCKS_FK does not exist LINE 3: ...COMPETATION_BLOCKS" as "DCB" on ("DCB"."SYS_GUID"="INFO_ROOM... ^
В файле: /var/www/library/X1/Db/Adapter/Pgsql.php:288
#0 /var/www/library/X1/Db/Statement.php(62): X1\Db\Adapter\Pgsql->prepare('select "INFO_R...') #1 /var/www/library/X1/Db/Adapter.php(111): X1\Db\Statement->__construct(Object(X1\Db\Adapter\Pgsql), 'select "INFO_R...', Array) #2 /var/www/library/X1/Db/Adapter/Pgsql.php(127): X1\Db\Adapter->query(Object(X1\ORM\ModelQuery), NULL) #3 /var/www/library/X1/ORM/Query.php(357): X1\Db\Adapter\Pgsql->fetchAll(Object(X1\ORM\ModelQuery), NULL, 2) #4 /var/www/library/X1/ORM/ModelQuery.php(209): X1\ORM\Query->fetchAll(2) #5 /var/www/webapps/auxiliary/library/UtilsCustom.php(423): X1\ORM\ModelQuery->fetchAll() #6 /var/www/webapps/copp/controllers/PartnersOrganizationsController.php(65): auxiliary\library\UtilsCustom::getItemsFromTable(Array) #7 /var/www/library/X1/MVC/Control.php(101): Ui\PartnersOrganizationsController->workshopList() #8 /var/www/library/X1/MVC/Control.php(66): X1\MVC\Control->tryAction('workshopList') #9 /var/www/library/X1/MVC/Controller.php(60): X1\MVC\Control->run(Object(X1\MVC\Request)) #10 /var/www/library/X1/MVC/Dispatcher.php(84): X1\MVC\Controller->run(Object(X1\MVC\Request)) #11 /var/www/library/X1/App/FrontController.php(144): X1\MVC\Dispatcher->dispatch() #12 /var/www/public/index.php(36): X1\App\FrontController->run() #13 {main}
select "PAGES".*,"$JVERFK"."VER" as "VER","$JVERFK"."CONTENT" as "CONTENT","$JVERFK"."MODIFIED" as "MODIFIED","$JVERFK"."SYS_GUID" as "VERID" from "PAGES" left join "PAGE_VERSIONS" as "$JVERFK" on ("$JVERFK"."SYS_GUID"="PAGES"."VERFK") where mod(coalesce("PAGES"."SYS_STATE",0),2)=0 and ("PAGES"."SYS_GUID"= ?)