PrepareStatementFailureException PrepareStatementFailureException

HTTP 500 Whoops, looks like something went wrong.

Unknown column 'm.publish_up' in 'where clause'

Exceptions 2

Joomla\Database\Exception\ PrepareStatementFailureException

  1.         $this->statement  $connection->prepare($query);
  2.         if (!$this->statement)
  3.         {
  4.             throw new PrepareStatementFailureException($this->connection->error$this->connection->errno);
  5.         }
  6.     }
  7.     /**
  8.      * Replace named parameters with numbered parameters
  1.      * @since   2.0.0
  2.      * @throws  PrepareStatementFailureException
  3.      */
  4.     protected function prepareStatement(string $query): StatementInterface
  5.     {
  6.         return new MysqliStatement($this->connection$query);
  7.     }
  8.     /**
  9.      * Unlocks tables in the database.
  10.      *
  1.         $query->setLimit($limit$offset);
  2.         $sql $this->replacePrefix((string) $query);
  3.         $this->statement $this->prepareStatement($sql);
  4.         $this->sql    $query;
  5.         $this->limit  = (int) max(0$limit);
  6.         $this->offset = (int) max(0$offset);
DatabaseDriver->setQuery(object(MysqliQuery)) in /var/www/suriyan.dk/public_html/libraries/src/Menu/SiteMenu.php (line 155)
  1.                 )
  2.                 ->bind(':currentDate2'$currentDate)
  3.                 ->order($this->db->quoteName('m.lft'));
  4.             $items    = [];
  5.             $iterator $this->db->setQuery($query)->getIterator();
  6.             foreach ($iterator as $item)
  7.             {
  8.                 $items[$item->id] = new MenuItem((array) $item);
  9.             }
  1.         $coptions['nomodules'] = $woptions['nomodules'] ?? 1;
  2.         ob_start();
  3.         ob_implicit_flush(false);
  4.         $result = \call_user_func_array($callback$referenceArgs);
  5.         $output ob_get_clean();
  6.         $data = array('result' => $result);
  7.         if ($wrkarounds)
CallbackController->get(object(Closure), array(), 'd17e8e13b99b4d9bf23a7d0b83a466c3', false) in /var/www/suriyan.dk/public_html/libraries/src/Menu/SiteMenu.php (line 171)
  1.         {
  2.             /** @var CallbackController $cache */
  3.             $cache Factory::getContainer()->get(CacheControllerFactoryInterface::class)
  4.                 ->createCacheController('callback', ['defaultgroup' => 'com_menus']);
  5.             $this->items $cache->get($loader, array(), md5(\get_class($this)), false);
  6.         }
  7.         catch (CacheExceptionInterface $e)
  8.         {
  9.             try
  10.             {
  1.      */
  2.     public function getMenu()
  3.     {
  4.         if (!$this->itemsLoaded)
  5.         {
  6.             $this->load();
  7.             foreach ($this->items as $item)
  8.             {
  9.                 if ($item->home)
  10.                 {
  1.      */
  2.     public function getItem($id)
  3.     {
  4.         $result null;
  5.         if (isset($this->getMenu()[$id]))
  6.         {
  7.             $result = &$this->getMenu()[$id];
  8.         }
  9.         return $result;
  1.         $menu $this->getMenu();
  2.         $item $menu->getActive();
  3.         if (!$item)
  4.         {
  5.             $item $menu->getItem($this->input->getInt('Itemid'null));
  6.         }
  7.         $id 0;
  8.         if (\is_object($item))
  1.     public function render(\Throwable $error): string
  2.     {
  3.         $app Factory::getApplication();
  4.         // Get the current template from the application
  5.         $template $app->getTemplate(true);
  6.         // Push the error object into the document
  7.         $this->getDocument()->setError($error);
  8.         // Add registry file for the template asset
HtmlRenderer->render(object(PrepareStatementFailureException)) in /var/www/suriyan.dk/public_html/libraries/src/Exception/ExceptionHandler.php (line 128)
  1.             // Reset the document object in the factory, this gives us a clean slate and lets everything render properly
  2.             Factory::$document $renderer->getDocument();
  3.             Factory::getApplication()->loadDocument(Factory::$document);
  4.             $data $renderer->render($error);
  5.             // If nothing was rendered, just use the message from the Exception
  6.             if (empty($data))
  7.             {
  8.                 $data $error->getMessage();
ExceptionHandler::render(object(PrepareStatementFailureException)) in /var/www/suriyan.dk/public_html/libraries/src/Exception/ExceptionHandler.php (line 71)
  1.      * @since   3.10.0
  2.      */
  3.     public static function handleException(\Throwable $error)
  4.     {
  5.         static::logException($error);
  6.         static::render($error);
  7.     }
  8.     /**
  9.      * Render the error page based on an exception.
  10.      *
ExceptionHandler::handleException(object(PrepareStatementFailureException)) in /var/www/suriyan.dk/public_html/libraries/src/Application/CMSApplication.php (line 311)
  1.             );
  2.             // Trigger the onError event.
  3.             $this->triggerEvent('onError'$event);
  4.             ExceptionHandler::handleException($event->getError());
  5.         }
  6.         // Send the application response.
  7.         $this->respond();
CMSApplication->execute() in /var/www/suriyan.dk/public_html/includes/app.php (line 63)
  1. // Set the application as global app
  2. \Joomla\CMS\Factory::$application $app;
  3. // Execute the application.
  4. $app->execute();
require_once('/var/www/suriyan.dk/public_html/includes/app.php') in /var/www/suriyan.dk/public_html/index.php (line 32)
  1.  * define() is used rather than "const" to not error for PHP 5.2 and lower
  2.  */
  3. define('_JEXEC'1);
  4. // Run the application - All executable code should be triggered through this file
  5. require_once dirname(__FILE__) . '/includes/app.php';

Joomla\Database\Exception\ PrepareStatementFailureException

Unknown column 'm.publish_up' in 'where clause'

  1.         $this->statement  $connection->prepare($query);
  2.         if (!$this->statement)
  3.         {
  4.             throw new PrepareStatementFailureException($this->connection->error$this->connection->errno);
  5.         }
  6.     }
  7.     /**
  8.      * Replace named parameters with numbered parameters
  1.      * @since   2.0.0
  2.      * @throws  PrepareStatementFailureException
  3.      */
  4.     protected function prepareStatement(string $query): StatementInterface
  5.     {
  6.         return new MysqliStatement($this->connection$query);
  7.     }
  8.     /**
  9.      * Unlocks tables in the database.
  10.      *
  1.         $query->setLimit($limit$offset);
  2.         $sql $this->replacePrefix((string) $query);
  3.         $this->statement $this->prepareStatement($sql);
  4.         $this->sql    $query;
  5.         $this->limit  = (int) max(0$limit);
  6.         $this->offset = (int) max(0$offset);
DatabaseDriver->setQuery(object(MysqliQuery)) in /var/www/suriyan.dk/public_html/libraries/src/Menu/SiteMenu.php (line 155)
  1.                 )
  2.                 ->bind(':currentDate2'$currentDate)
  3.                 ->order($this->db->quoteName('m.lft'));
  4.             $items    = [];
  5.             $iterator $this->db->setQuery($query)->getIterator();
  6.             foreach ($iterator as $item)
  7.             {
  8.                 $items[$item->id] = new MenuItem((array) $item);
  9.             }
  1.         $coptions['nomodules'] = $woptions['nomodules'] ?? 1;
  2.         ob_start();
  3.         ob_implicit_flush(false);
  4.         $result = \call_user_func_array($callback$referenceArgs);
  5.         $output ob_get_clean();
  6.         $data = array('result' => $result);
  7.         if ($wrkarounds)
CallbackController->get(object(Closure), array(), 'd17e8e13b99b4d9bf23a7d0b83a466c3', false) in /var/www/suriyan.dk/public_html/libraries/src/Menu/SiteMenu.php (line 171)
  1.         {
  2.             /** @var CallbackController $cache */
  3.             $cache Factory::getContainer()->get(CacheControllerFactoryInterface::class)
  4.                 ->createCacheController('callback', ['defaultgroup' => 'com_menus']);
  5.             $this->items $cache->get($loader, array(), md5(\get_class($this)), false);
  6.         }
  7.         catch (CacheExceptionInterface $e)
  8.         {
  9.             try
  10.             {
  1.      */
  2.     public function getMenu()
  3.     {
  4.         if (!$this->itemsLoaded)
  5.         {
  6.             $this->load();
  7.             foreach ($this->items as $item)
  8.             {
  9.                 if ($item->home)
  10.                 {
  1.      */
  2.     public function getItem($id)
  3.     {
  4.         $result null;
  5.         if (isset($this->getMenu()[$id]))
  6.         {
  7.             $result = &$this->getMenu()[$id];
  8.         }
  9.         return $result;
  1.      */
  2.     public function parseRawRoute(&$router, &$uri)
  3.     {
  4.         if ($uri->getVar('Itemid'))
  5.         {
  6.             $item $this->menu->getItem($uri->getVar('Itemid'));
  7.         }
  8.         else
  9.         {
  10.             $item $this->menu->getDefault($this->app->getLanguage()->getTag());
  11.         }
SiteRouter->parseRawRoute(object(SiteRouter), object(Uri)) in /var/www/suriyan.dk/public_html/libraries/src/Router/Router.php (line 400)
  1.             throw new \InvalidArgumentException(sprintf('The %s stage is not registered. (%s)'$stage__METHOD__));
  2.         }
  3.         foreach ($this->rules['parse' $stage] as $rule)
  4.         {
  5.             $rule($this$uri);
  6.         }
  7.     }
  8.     /**
  9.      * Process the build uri query data based on custom defined rules
Router->processParseRules(object(Uri)) in /var/www/suriyan.dk/public_html/libraries/src/Router/Router.php (line 144)
  1.     {
  2.         // Do the preprocess stage of the URL parse process
  3.         $this->processParseRules($uriself::PROCESS_BEFORE);
  4.         // Do the main stage of the URL parse process
  5.         $this->processParseRules($uri);
  6.         // Do the postprocess stage of the URL parse process
  7.         $this->processParseRules($uriself::PROCESS_AFTER);
  8.         // Check if all parts of the URL have been parsed.
  1.     {
  2.         // Get the full request URI.
  3.         $uri = clone Uri::getInstance();
  4.         $router = static::getRouter();
  5.         $result $router->parse($uritrue);
  6.         $active $this->getMenu()->getActive();
  7.         if ($active !== null
  8.             && $active->type === 'alias'
  1.      * @since   3.2
  2.      */
  3.     protected function route()
  4.     {
  5.         // Execute the parent method
  6.         parent::route();
  7.         $Itemid $this->input->getInt('Itemid'null);
  8.         $this->authorise($Itemid);
  9.     }
  1.         // Mark afterInitialise in the profiler.
  2.         JDEBUG $this->profiler->mark('afterInitialise') : null;
  3.         // Route the application
  4.         $this->route();
  5.         // Mark afterRoute in the profiler.
  6.         JDEBUG $this->profiler->mark('afterRoute') : null;
  7.         /*
  1.             $this->sanityCheckSystemVariables();
  2.             $this->setupLogging();
  3.             $this->createExtensionNamespaceMap();
  4.             // Perform application routines.
  5.             $this->doExecute();
  6.             // If we have an application document object, render it.
  7.             if ($this->document instanceof \Joomla\CMS\Document\Document)
  8.             {
  9.                 // Render the application output.
CMSApplication->execute() in /var/www/suriyan.dk/public_html/includes/app.php (line 63)
  1. // Set the application as global app
  2. \Joomla\CMS\Factory::$application $app;
  3. // Execute the application.
  4. $app->execute();
require_once('/var/www/suriyan.dk/public_html/includes/app.php') in /var/www/suriyan.dk/public_html/index.php (line 32)
  1.  * define() is used rather than "const" to not error for PHP 5.2 and lower
  2.  */
  3. define('_JEXEC'1);
  4. // Run the application - All executable code should be triggered through this file
  5. require_once dirname(__FILE__) . '/includes/app.php';

Stack Traces 2

[2/2] PrepareStatementFailureException
Joomla\Database\Exception\PrepareStatementFailureException:
Unknown column 'm.publish_up' in 'where clause'

  at /var/www/suriyan.dk/public_html/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:141
  at Joomla\Database\Mysqli\MysqliStatement->__construct(object(mysqli), 'SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component`FROM `d65pa_menu` AS `m`LEFT JOIN `d65pa_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id`WHERE ((`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= ?)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= ?)ORDER BY `m`.`lft`')
     (/var/www/suriyan.dk/public_html/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:1048)
  at Joomla\Database\Mysqli\MysqliDriver->prepareStatement('SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component`FROM `d65pa_menu` AS `m`LEFT JOIN `d65pa_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id`WHERE ((`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2)ORDER BY `m`.`lft`')
     (/var/www/suriyan.dk/public_html/libraries/vendor/joomla/database/src/DatabaseDriver.php:1900)
  at Joomla\Database\DatabaseDriver->setQuery(object(MysqliQuery))
     (/var/www/suriyan.dk/public_html/libraries/src/Menu/SiteMenu.php:155)
  at Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()
     (/var/www/suriyan.dk/public_html/libraries/src/Cache/Controller/CallbackController.php:124)
  at Joomla\CMS\Cache\Controller\CallbackController->get(object(Closure), array(), 'd17e8e13b99b4d9bf23a7d0b83a466c3', false)
     (/var/www/suriyan.dk/public_html/libraries/src/Menu/SiteMenu.php:171)
  at Joomla\CMS\Menu\SiteMenu->load()
     (/var/www/suriyan.dk/public_html/libraries/src/Menu/AbstractMenu.php:329)
  at Joomla\CMS\Menu\AbstractMenu->getMenu()
     (/var/www/suriyan.dk/public_html/libraries/src/Menu/AbstractMenu.php:148)
  at Joomla\CMS\Menu\AbstractMenu->getItem(229)
     (/var/www/suriyan.dk/public_html/libraries/src/Application/SiteApplication.php:431)
  at Joomla\CMS\Application\SiteApplication->getTemplate(true)
     (/var/www/suriyan.dk/public_html/libraries/src/Error/Renderer/HtmlRenderer.php:47)
  at Joomla\CMS\Error\Renderer\HtmlRenderer->render(object(PrepareStatementFailureException))
     (/var/www/suriyan.dk/public_html/libraries/src/Exception/ExceptionHandler.php:128)
  at Joomla\CMS\Exception\ExceptionHandler::render(object(PrepareStatementFailureException))
     (/var/www/suriyan.dk/public_html/libraries/src/Exception/ExceptionHandler.php:71)
  at Joomla\CMS\Exception\ExceptionHandler::handleException(object(PrepareStatementFailureException))
     (/var/www/suriyan.dk/public_html/libraries/src/Application/CMSApplication.php:311)
  at Joomla\CMS\Application\CMSApplication->execute()
     (/var/www/suriyan.dk/public_html/includes/app.php:63)
  at require_once('/var/www/suriyan.dk/public_html/includes/app.php')
     (/var/www/suriyan.dk/public_html/index.php:32)                
[1/2] PrepareStatementFailureException
Joomla\Database\Exception\PrepareStatementFailureException:
Unknown column 'm.publish_up' in 'where clause'

  at /var/www/suriyan.dk/public_html/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:141
  at Joomla\Database\Mysqli\MysqliStatement->__construct(object(mysqli), 'SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component`FROM `d65pa_menu` AS `m`LEFT JOIN `d65pa_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id`WHERE ((`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= ?)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= ?)ORDER BY `m`.`lft`')
     (/var/www/suriyan.dk/public_html/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:1048)
  at Joomla\Database\Mysqli\MysqliDriver->prepareStatement('SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component`FROM `d65pa_menu` AS `m`LEFT JOIN `d65pa_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id`WHERE ((`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2)ORDER BY `m`.`lft`')
     (/var/www/suriyan.dk/public_html/libraries/vendor/joomla/database/src/DatabaseDriver.php:1900)
  at Joomla\Database\DatabaseDriver->setQuery(object(MysqliQuery))
     (/var/www/suriyan.dk/public_html/libraries/src/Menu/SiteMenu.php:155)
  at Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()
     (/var/www/suriyan.dk/public_html/libraries/src/Cache/Controller/CallbackController.php:124)
  at Joomla\CMS\Cache\Controller\CallbackController->get(object(Closure), array(), 'd17e8e13b99b4d9bf23a7d0b83a466c3', false)
     (/var/www/suriyan.dk/public_html/libraries/src/Menu/SiteMenu.php:171)
  at Joomla\CMS\Menu\SiteMenu->load()
     (/var/www/suriyan.dk/public_html/libraries/src/Menu/AbstractMenu.php:329)
  at Joomla\CMS\Menu\AbstractMenu->getMenu()
     (/var/www/suriyan.dk/public_html/libraries/src/Menu/AbstractMenu.php:148)
  at Joomla\CMS\Menu\AbstractMenu->getItem('229')
     (/var/www/suriyan.dk/public_html/libraries/src/Router/SiteRouter.php:335)
  at Joomla\CMS\Router\SiteRouter->parseRawRoute(object(SiteRouter), object(Uri))
     (/var/www/suriyan.dk/public_html/libraries/src/Router/Router.php:400)
  at Joomla\CMS\Router\Router->processParseRules(object(Uri))
     (/var/www/suriyan.dk/public_html/libraries/src/Router/Router.php:144)
  at Joomla\CMS\Router\Router->parse(object(Uri), true)
     (/var/www/suriyan.dk/public_html/libraries/src/Application/CMSApplication.php:1066)
  at Joomla\CMS\Application\CMSApplication->route()
     (/var/www/suriyan.dk/public_html/libraries/src/Application/SiteApplication.php:822)
  at Joomla\CMS\Application\SiteApplication->route()
     (/var/www/suriyan.dk/public_html/libraries/src/Application/SiteApplication.php:230)
  at Joomla\CMS\Application\SiteApplication->doExecute()
     (/var/www/suriyan.dk/public_html/libraries/src/Application/CMSApplication.php:278)
  at Joomla\CMS\Application\CMSApplication->execute()
     (/var/www/suriyan.dk/public_html/includes/app.php:63)
  at require_once('/var/www/suriyan.dk/public_html/includes/app.php')
     (/var/www/suriyan.dk/public_html/index.php:32)