Ошибка приложения

An exception has been thrown during the rendering of a template ("Prepare error: ERROR: column TOURS_DATES.ACTUAL does not exist LINE 3: ("TOURS_DATES"."SYS_GUIDFK"= $1) and ("TOURS_DATES"."ACTUAL... ^").

GET /tour/index/B68EACBE52A198746398CC8823E1153F
02.12.2024 23:20:16
3.145.91.152

Техническая информация

Файл

/var/www/webapps/portal/templates/tour/description/tours_dates.twig:1

Трассировка

#0 /var/www/vendor/twig/twig/src/Template.php(420): Twig\Template->displayWithErrorHandling(Array, Array)
#1 /var/www/tmp/twig/13/1339f97449c550c8b4fe2c9b43938b8ed24dbc15406cbdd36473743a1dbd035f.php(107): Twig\Template->display(Array)
#2 /var/www/vendor/twig/twig/src/Template.php(453): __TwigTemplate_46323308bebae0d57766feae6414c113c5109de0e7ed563b144fd84f31fd222b->doDisplay(Array, Array)
#3 /var/www/vendor/twig/twig/src/Template.php(420): Twig\Template->displayWithErrorHandling(Array, Array)
#4 /var/www/vendor/twig/twig/src/Template.php(432): Twig\Template->display(Array)
#5 /var/www/vendor/twig/twig/src/TemplateWrapper.php(47): Twig\Template->render(Array, Array)
#6 /var/www/vendor/twig/twig/src/Environment.php(384): Twig\TemplateWrapper->render(Array)
#7 /var/www/library/X1/View/Renderer/TwigRenderer.php(53): Twig\Environment->render('/var/www/webapp...', Array)
#8 /var/www/library/X1/View/View.php(200): X1\View\Renderer\TwigRenderer->render(Object(X1\View\View), Array, '/var/www/webapp...', Array)
#9 /var/www/library/X1/View/Helper/AbstractHelper.php(23): X1\View\View->render('/tour/accordion...', Array)
#10 /var/www/webapps/portal/helpers/TourDescription.php(144): Travel\TourDescription->render(Array)
#11 /var/www/vendor/twig/twig/src/Template.php(702): Travel\TourDescription->renderTour(Array)
#12 /var/www/tmp/twig/5d/5d635ed8dc297fbe2ca5a73b2f8d942f2e710121286705dec79ecb40643188a1.php(126): Twig\Template->getAttribute(Object(Travel\TourDescription), 'renderTour', Array, 'method')
#13 /var/www/vendor/twig/twig/src/Template.php(214): __TwigTemplate_348a35a0ecea8f483095dedfcfa8c56c583a4308b6565f6036ff55f877846b15->block_content(Array, Array)
#14 /var/www/tmp/twig/5d/5d635ed8dc297fbe2ca5a73b2f8d942f2e710121286705dec79ecb40643188a1.php(31): Twig\Template->displayBlock('content', Array, Array)
#15 /var/www/vendor/twig/twig/src/Template.php(453): __TwigTemplate_348a35a0ecea8f483095dedfcfa8c56c583a4308b6565f6036ff55f877846b15->doDisplay(Array, Array)
#16 /var/www/vendor/twig/twig/src/Template.php(420): Twig\Template->displayWithErrorHandling(Array, Array)
#17 /var/www/vendor/twig/twig/src/Template.php(432): Twig\Template->display(Array)
#18 /var/www/vendor/twig/twig/src/TemplateWrapper.php(47): Twig\Template->render(Array, Array)
#19 /var/www/vendor/twig/twig/src/Environment.php(384): Twig\TemplateWrapper->render(Array)
#20 /var/www/library/X1/View/Renderer/TwigRenderer.php(53): Twig\Environment->render('/var/www/webapp...', Array)
#21 /var/www/library/X1/View/View.php(200): X1\View\Renderer\TwigRenderer->render(Object(X1\View\View), Array, '/var/www/webapp...', Array)
#22 /var/www/library/X1/MVC/Control.php(85): X1\View\View->render('tour/index.twig', Array)
#23 /var/www/library/X1/MVC/Controller.php(60): X1\MVC\Control->run(Object(X1\MVC\Request))
#24 /var/www/library/X1/MVC/Dispatcher.php(84): X1\MVC\Controller->run(Object(X1\MVC\Request))
#25 /var/www/library/X1/App/FrontController.php(144): X1\MVC\Dispatcher->dispatch()
#26 /var/www/public/index.php(36): X1\App\FrontController->run()
#27 {main}

Последний sql запрос

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"."ALIAS"= ?)