1054 Unknown column 'm.publish_up' in 'where clause' #0 /users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php(1089): Joomla\Database\Mysqli\MysqliStatement->__construct(Object(mysqli), 'SELECT `m`.`id`...') #1 /users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/libraries/vendor/joomla/database/src/DatabaseDriver.php(1900): Joomla\Database\Mysqli\MysqliDriver->prepareStatement('SELECT `m`.`id`...') #2 /users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/libraries/src/Menu/SiteMenu.php(166): Joomla\Database\DatabaseDriver->setQuery(Object(Joomla\Database\Mysqli\MysqliQuery)) #3 /users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/libraries/src/Cache/Controller/CallbackController.php(51): Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() #4 /users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/libraries/src/Menu/SiteMenu.php(179): Joomla\CMS\Cache\Controller\CallbackController->get(Object(Closure), Array, 'd17e8e13b99b4d9...', false) #5 /users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/libraries/src/Menu/AbstractMenu.php(333): Joomla\CMS\Menu\SiteMenu->load() #6 /users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/libraries/src/Menu/AbstractMenu.php(272): Joomla\CMS\Menu\AbstractMenu->getMenu() #7 /users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/libraries/src/Menu/SiteMenu.php(257): Joomla\CMS\Menu\AbstractMenu->getItems(Array, Array, false) #8 /users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/libraries/src/Router/SiteRouter.php(216): Joomla\CMS\Menu\SiteMenu->getItems(Array, Array) #9 /users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/libraries/src/Router/Router.php(384): Joomla\CMS\Router\SiteRouter->parseSefRoute(Object(Joomla\CMS\Router\SiteRouter), Object(Joomla\CMS\Uri\Uri)) #10 /users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/libraries/src/Router/Router.php(147): Joomla\CMS\Router\Router->processParseRules(Object(Joomla\CMS\Uri\Uri)) #11 /users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/libraries/src/Application/SiteApplication.php(746): Joomla\CMS\Router\Router->parse(Object(Joomla\CMS\Uri\Uri), true) #12 /users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/libraries/src/Application/SiteApplication.php(232): Joomla\CMS\Application\SiteApplication->route() #13 /users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/libraries/src/Application/CMSApplication.php(293): Joomla\CMS\Application\SiteApplication->doExecute() #14 /users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/includes/app.php(61): Joomla\CMS\Application\CMSApplication->execute() #15 /users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/index.php(32): require_once('/users/bf-schnu...') #16 {main} Unknown column 'm.publish_up' in 'where clause' (500 Whoops, looks like something went wrong.)

PrepareStatementFailureException

HTTP 500 Whoops, looks like something went wrong.

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

Exception

Joomla\Database\Exception\ PrepareStatementFailureException

in /users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php (line 141)
  2.         $this->statement  = $connection->prepare($query);
  4.         if (!$this->statement)
  5.         {
  6.             throw new PrepareStatementFailureException($this->connection->error, $this->connection->errno);
  7.         }
  8.     }
  10.     /**
  11.      * Replace named parameters with numbered parameters
in /users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php -> __construct (line 1089)
  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.     }
  9.     /**
  10.      * Unlocks tables in the database.
  11.      *
in /users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/libraries/vendor/joomla/database/src/DatabaseDriver.php -> prepareStatement (line 1900)
  2.         $query->setLimit($limit, $offset);
  4.         $sql = $this->replacePrefix((string) $query);
  6.         $this->statement = $this->prepareStatement($sql);
  8.         $this->sql    = $query;
  9.         $this->limit  = (int) max(0, $limit);
  10.         $this->offset = (int) max(0, $offset);
DatabaseDriver->setQuery(object(MysqliQuery)) in /users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/libraries/src/Menu/SiteMenu.php (line 166)
  1.                 )
  2.                 ->bind(':currentDate2', $currentDate)
  3.                 ->order($this->db->quoteName('m.lft'));
  5.             $items    = [];
  6.             $iterator = $this->db->setQuery($query)->getIterator();
  8.             foreach ($iterator as $item) {
  9.                 $items[$item->id] = new MenuItem((array) $item);
  10.             }
SiteMenu->Joomla\CMS\Menu\{closure}() in /users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/libraries/src/Cache/Controller/CallbackController.php (line 51)
  1.             $referenceArgs = &$args;
  2.         }
  4.         // Just execute the callback if caching is disabled.
  5.         if (empty($this->options['caching'])) {
  6.             return \call_user_func_array($callback, $referenceArgs);
  7.         }
  9.         if (!$id) {
  10.             // Generate an ID
  11.             $id = $this->_makeId($callback, $args);
CallbackController->get(object(Closure), array(), 'd17e8e13b99b4d9bf23a7d0b83a466c3', false) in /users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/libraries/src/Menu/SiteMenu.php (line 179)
  2.         try {
  3.             /** @var CallbackController $cache */
  4.             $cache = $this->getCacheControllerFactory()->createCacheController('callback', ['defaultgroup' => 'com_menus']);
  6.             $this->items = $cache->get($loader, [], md5(\get_class($this)), false);
  7.         } catch (CacheExceptionInterface $e) {
  8.             try {
  9.                 $this->items = $loader();
  10.             } catch (ExecutionFailureException $databaseException) {
  11.                 $this->app->enqueueMessage(Text::sprintf('JERROR_LOADING_MENUS', $databaseException->getMessage()), 'warning');
SiteMenu->load() in /users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/libraries/src/Menu/AbstractMenu.php (line 333)
  1.      * @since   1.5
  2.      */
  3.     public function getMenu()
  4.     {
  5.         if (!$this->itemsLoaded) {
  6.             $this->load();
  8.             foreach ($this->items as $item) {
  9.                 if ($item->home) {
  10.                     $this->default[trim($item->language)] = $item->id;
  11.                 }
AbstractMenu->getMenu() in /users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/libraries/src/Menu/AbstractMenu.php (line 164)
  1.      */
  2.     public function getItem($id)
  3.     {
  4.         $result = null;
  6.         if (isset($this->getMenu()[$id])) {
  7.             $result = &$this->getMenu()[$id];
  8.         }
  10.         return $result;
  11.     }
AbstractMenu->getItem(null) in /users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/libraries/src/Application/SiteApplication.php (line 422)
  1.         // Get the id of the active menu item
  2.         $menu = $this->getMenu();
  3.         $item = $menu->getActive();
  5.         if (!$item) {
  6.             $item = $menu->getItem($this->input->getInt('Itemid', null));
  7.         }
  9.         $id = 0;
  11.         if (\is_object($item)) {
SiteApplication->getTemplate(true) in /users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/plugins/system/debug/src/DataCollector/InfoCollector.php (line 135)
  1.             'phpVersion'    => PHP_VERSION,
  2.             'joomlaVersion' => JVERSION,
  3.             'requestId'     => $this->requestId,
  4.             'identity'      => $this->getIdentityInfo($application->getIdentity()),
  5.             'response'      => $this->getResponseInfo($application->getResponse()),
  6.             'template'      => $this->getTemplateInfo($application->getTemplate(true)),
  7.             'database'      => $this->getDatabaseInfo($model->getInfo()),
  8.         ];
  9.     }
  11.     /**
in /users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/libraries/vendor/maximebf/debugbar/src/DebugBar/DebugBar.php -> collect (line 238)
  1.                 $request_variables
  2.             )
  3.         );
  5.         foreach ($this->collectors as $name => $collector) {
  6.             $this->data[$name] = $collector->collect();
  7.         }
  9.         // Remove all invalid (non UTF-8) characters
  10.         array_walk_recursive($this->data, function (&$item) {
  11.                 if (is_string($item) && !mb_check_encoding($item, 'UTF-8')) {
in /users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/libraries/vendor/maximebf/debugbar/src/DebugBar/DebugBar.php -> collect (line 265)
  1.      * @return array
  2.      */
  3.     public function getData()
  4.     {
  5.         if ($this->data === null) {
  6.             $this->collect();
  7.         }
  8.         return $this->data;
  9.     }
  11.     /**
in /users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/libraries/vendor/maximebf/debugbar/src/DebugBar/DebugBar.php -> getData (line 340)
  1.     {
  2.         $http = $this->initStackSession();
  4.         $data = null;
  5.         if (!$this->isDataPersisted() || $this->stackAlwaysUseSessionStorage) {
  6.             $data = $this->getData();
  7.         } elseif ($this->data === null) {
  8.             $this->collect();
  9.         }
  11.         $stack = $http->getSessionValue($this->stackSessionNamespace);
DebugBar->stackData() in /users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/plugins/system/debug/debug.php (line 333)
  1.             $this->debugBar->addCollector(new LanguageErrorsCollector($this->params));
  2.         }
  4.         // Only render for HTML output.
  5.         if (!($this->app->getDocument() instanceof HtmlDocument)) {
  6.             $this->debugBar->stackData();
  8.             return;
  9.         }
  11.         $debugBarRenderer = new JavascriptRenderer($this->debugBar, Uri::root(true) . '/media/vendor/debugbar/');
in /users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/libraries/vendor/joomla/event/src/Dispatcher.php -> onAfterRespond (line 486)
  1.                 if ($event->isStopped())
  2.                 {
  3.                     return $event;
  4.                 }
  6.                 $listener($event);
  7.             }
  8.         }
  10.         return $event;
  11.     }
Dispatcher->dispatch('onAfterRespond') in /users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/libraries/src/Application/CMSApplication.php (line 332)
  2.         // Send the application response.
  3.         $this->respond();
  5.         // Trigger the onAfterRespond event.
  6.         $this->getDispatcher()->dispatch('onAfterRespond');
  7.     }
  9.     /**
  10.      * Check if the user is required to reset their password.
  11.      *
CMSApplication->execute() in /users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/includes/app.php (line 61)
  2. // Set the application as global app
  3. \Joomla\CMS\Factory::$application = $app;
  5. // Execute the application.
  6. $app->execute();
require_once('/users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/includes/app.php') in /users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/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);
  5. // Run the application - All executable code should be triggered through this file
  6. require_once dirname(__FILE__) . '/includes/app.php';

Stack Trace

PrepareStatementFailureException 
Joomla\Database\Exception\PrepareStatementFailureException:
Unknown column 'm.publish_up' in 'where clause'

  at /users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/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 `jbu54_menu` AS `m`LEFT JOIN `jbu54_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`')
     (/users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:1089)
  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 `jbu54_menu` AS `m`LEFT JOIN `jbu54_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`')
     (/users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/libraries/vendor/joomla/database/src/DatabaseDriver.php:1900)
  at Joomla\Database\DatabaseDriver->setQuery(object(MysqliQuery))
     (/users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/libraries/src/Menu/SiteMenu.php:166)
  at Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()
     (/users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/libraries/src/Cache/Controller/CallbackController.php:51)
  at Joomla\CMS\Cache\Controller\CallbackController->get(object(Closure), array(), 'd17e8e13b99b4d9bf23a7d0b83a466c3', false)
     (/users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/libraries/src/Menu/SiteMenu.php:179)
  at Joomla\CMS\Menu\SiteMenu->load()
     (/users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/libraries/src/Menu/AbstractMenu.php:333)
  at Joomla\CMS\Menu\AbstractMenu->getMenu()
     (/users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/libraries/src/Menu/AbstractMenu.php:164)
  at Joomla\CMS\Menu\AbstractMenu->getItem(null)
     (/users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/libraries/src/Application/SiteApplication.php:422)
  at Joomla\CMS\Application\SiteApplication->getTemplate(true)
     (/users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/plugins/system/debug/src/DataCollector/InfoCollector.php:135)
  at Joomla\Plugin\System\Debug\DataCollector\InfoCollector->collect()
     (/users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/libraries/vendor/maximebf/debugbar/src/DebugBar/DebugBar.php:238)
  at DebugBar\DebugBar->collect()
     (/users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/libraries/vendor/maximebf/debugbar/src/DebugBar/DebugBar.php:265)
  at DebugBar\DebugBar->getData()
     (/users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/libraries/vendor/maximebf/debugbar/src/DebugBar/DebugBar.php:340)
  at DebugBar\DebugBar->stackData()
     (/users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/plugins/system/debug/debug.php:333)
  at PlgSystemDebug->onAfterRespond(object(Event))
     (/users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/libraries/vendor/joomla/event/src/Dispatcher.php:486)
  at Joomla\Event\Dispatcher->dispatch('onAfterRespond')
     (/users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/libraries/src/Application/CMSApplication.php:332)
  at Joomla\CMS\Application\CMSApplication->execute()
     (/users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/includes/app.php:61)
  at require_once('/users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/includes/app.php')
     (/users/bf-schnuffingen/www/Feuerwehr-Schnuffingen/index.php:32)