Deprecated: Using ${var} in strings is deprecated, use {$var} instead in /home/dev/public_html/silvervalley/libraries/f0f/less/less.php on line 2428

Deprecated: Using ${var} in strings is deprecated, use {$var} instead in /home/dev/public_html/silvervalley/libraries/f0f/less/less.php on line 2428
Unknown column 'm.publish_up' in 'where clause' (500 Whoops, looks like something went wrong.)

ValueError mysqli_sql_exception

HTTP 500 Whoops, looks like something went wrong.

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

Exceptions 2

mysqli_sql_exception

in /home/dev/public_html/silvervalley/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php (line 137)
  1.         $this->connection   = $connection;
  2.         $this->query        = $query;
  4.         $query = $this->prepareParameterKeyMapping($query);
  6.         $this->statement  = $connection->prepare($query);
  8.         if (!$this->statement)
  9.         {
  10.             throw new PrepareStatementFailureException($this->connection->error, $this->connection->errno);
  11.         }
in /home/dev/public_html/silvervalley/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php -> prepare (line 137)
  1.         $this->connection   = $connection;
  2.         $this->query        = $query;
  4.         $query = $this->prepareParameterKeyMapping($query);
  6.         $this->statement  = $connection->prepare($query);
  8.         if (!$this->statement)
  9.         {
  10.             throw new PrepareStatementFailureException($this->connection->error, $this->connection->errno);
  11.         }
in /home/dev/public_html/silvervalley/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 /home/dev/public_html/silvervalley/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 /home/dev/public_html/silvervalley/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 /home/dev/public_html/silvervalley/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 /home/dev/public_html/silvervalley/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 /home/dev/public_html/silvervalley/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 /home/dev/public_html/silvervalley/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 /home/dev/public_html/silvervalley/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 /home/dev/public_html/silvervalley/libraries/src/Error/Renderer/HtmlRenderer.php (line 50)
  1.     public function render(\Throwable $error): string
  2.     {
  3.         $app = Factory::getApplication();
  5.         // Get the current template from the application
  6.         $template = $app->getTemplate(true);
  8.         // Push the error object into the document
  9.         $this->getDocument()->setError($error);
  11.         // Add registry file for the template asset
HtmlRenderer->render(object(ValueError)) in /home/dev/public_html/silvervalley/libraries/src/Exception/ExceptionHandler.php (line 126)
  2.             // Reset the document object in the factory, this gives us a clean slate and lets everything render properly
  3.             Factory::$document = $renderer->getDocument();
  4.             Factory::getApplication()->loadDocument(Factory::$document);
  6.             $data = $renderer->render($error);
  8.             // If nothing was rendered, just use the message from the Exception
  9.             if (empty($data)) {
  10.                 $data = $error->getMessage();
  11.             }
ExceptionHandler::render(object(ValueError)) in /home/dev/public_html/silvervalley/libraries/src/Exception/ExceptionHandler.php (line 72)
  1.      * @since   3.10.0
  2.      */
  3.     public static function handleException(\Throwable $error)
  4.     {
  5.         static::logException($error);
  6.         static::render($error);
  7.     }
  9.     /**
  10.      * Render the error page based on an exception.
  11.      *
ExceptionHandler::handleException(object(ValueError)) in /home/dev/public_html/silvervalley/libraries/src/Application/CMSApplication.php (line 322)
  1.             );
  3.             // Trigger the onError event.
  4.             $this->triggerEvent('onError', $event);
  6.             ExceptionHandler::handleException($event->getError());
  7.         }
  9.         // Trigger the onBeforeRespond event.
  10.         $this->getDispatcher()->dispatch('onBeforeRespond');
CMSApplication->execute() in /home/dev/public_html/silvervalley/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('/home/dev/public_html/silvervalley/includes/app.php') in /home/dev/public_html/silvervalley/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';

ValueError

version_compare(): Argument #3 ($operator) must be a valid comparison operator

in /home/dev/public_html/silvervalley/plugins/system/offlajnparams/offlajnjoomlacompat.php (line 12)
  1.  * @license   https://www.gnu.org/licenses/gpl-2.0.html
  2.  */
  4. defined( '_JEXEC' ) or die( 'Restricted access' );
  6. if(version_compare(JVERSION,'3.0.0','l')) {
  7.   function offlajn_jimport($key, $base = null) {
  8.     return jimport($key);
  9.   }
  10. } else {
  11.   defined('DS') or define('DS', DIRECTORY_SEPARATOR);
version_compare('4.4.3', '3.0.0', 'l') in /home/dev/public_html/silvervalley/plugins/system/offlajnparams/offlajnjoomlacompat.php (line 12)
  1.  * @license   https://www.gnu.org/licenses/gpl-2.0.html
  2.  */
  4. defined( '_JEXEC' ) or die( 'Restricted access' );
  6. if(version_compare(JVERSION,'3.0.0','l')) {
  7.   function offlajn_jimport($key, $base = null) {
  8.     return jimport($key);
  9.   }
  10. } else {
  11.   defined('DS') or define('DS', DIRECTORY_SEPARATOR);
require_once('/home/dev/public_html/silvervalley/plugins/system/offlajnparams/offlajnjoomlacompat.php') in /home/dev/public_html/silvervalley/plugins/system/offlajnparams/offlajnparams.php (line 17)
  1. $er = error_reporting();
  2. if ($er & E_STRICT || $er & E_DEPRECATED)
  3.   error_reporting($er & ~E_STRICT & ~E_DEPRECATED);
  5. jimport( 'joomla.plugin.plugin' );
  6. require_once dirname(__FILE__).'/offlajnjoomlacompat.php';
  8. $option = isset($_REQUEST['option']) ? $_REQUEST['option'] : '';
  9. $task = isset($_REQUEST['task']) ? $_REQUEST['task'] : '';
  11. if ($option == 'offlajnupload')
require_once('/home/dev/public_html/silvervalley/plugins/system/offlajnparams/offlajnparams.php') in /home/dev/public_html/silvervalley/libraries/src/Extension/ExtensionManagerTrait.php (line 217)
  1.         if (!is_file($path)) {
  2.             return new DummyPlugin($dispatcher);
  3.         }
  5.         // Include the file of the plugin
  6.         require_once $path;
  8.         // Compile the classname
  9.         $className = 'Plg' . str_replace('-', '', $type) . $plugin;
  11.         // Editors don't follow the convention
CMSApplication->loadPluginFromFilesystem('offlajnparams', 'system') in /home/dev/public_html/silvervalley/libraries/src/Extension/ExtensionManagerTrait.php (line 160)
  1.                 case ModuleInterface::class:
  2.                     $container->set($type, new Module(new ModuleDispatcherFactory(''), new HelperFactory('')));
  3.                     break;
  4.                 case PluginInterface::class:
  5.                     list($pluginName, $pluginType) = explode(':', $extensionName);
  6.                     $container->set($type, $this->loadPluginFromFilesystem($pluginName, $pluginType));
  7.             }
  8.         }
  10.         $container->get(DispatcherInterface::class)->dispatch(
  11.             'onAfterExtensionBoot',
CMSApplication->loadExtension('Joomla\\CMS\\Extension\\PluginInterface', 'offlajnparams:system', '/home/dev/public_html/silvervalley/plugins/system/offlajnparams') in /home/dev/public_html/silvervalley/libraries/src/Extension/ExtensionManagerTrait.php (line 99)
  1.         $plugin = str_starts_with($plugin, 'plg_') ? substr($plugin, 4) : $plugin;
  3.         // Path to look for services
  4.         $path = JPATH_SITE . '/plugins/' . $type . '/' . $plugin;
  6.         return $this->loadExtension(PluginInterface::class, $plugin . ':' . $type, $path);
  7.     }
  9.     /**
  10.      * Loads the extension.
  11.      *
CMSApplication->bootPlugin('offlajnparams', 'system') in /home/dev/public_html/silvervalley/libraries/src/Plugin/PluginHelper.php (line 232)
  1.             return;
  2.         }
  4.         $plugins[$hash] = true;
  6.         $plugin = Factory::getApplication()->bootPlugin($plugin->name, $plugin->type);
  8.         if ($dispatcher && $plugin instanceof DispatcherAwareInterface) {
  9.             $plugin->setDispatcher($dispatcher);
  10.         }
PluginHelper::import(object(stdClass), true, object(Dispatcher)) in /home/dev/public_html/silvervalley/libraries/src/Plugin/PluginHelper.php (line 192)
  1.             $plugins = static::load();
  3.             // Get the specified plugin(s).
  4.             for ($i = 0, $t = \count($plugins); $i < $t; $i++) {
  5.                 if ($plugins[$i]->type === $type && ($plugin === null || $plugins[$i]->name === $plugin)) {
  6.                     static::import($plugins[$i], $autocreate, $dispatcher);
  7.                     $results = true;
  8.                 }
  9.             }
  11.             // Bail out early if we're not using default args
PluginHelper::importPlugin('system') in /home/dev/public_html/silvervalley/libraries/src/Application/CMSApplication.php (line 744)
  2.         // Load the behaviour plugins
  3.         PluginHelper::importPlugin('behaviour');
  5.         // Trigger the onAfterInitialise event.
  6.         PluginHelper::importPlugin('system');
  7.         $this->triggerEvent('onAfterInitialise');
  8.     }
  10.     /**
  11.      * Checks if HTTPS is forced in the client configuration.
CMSApplication->initialiseApp(array('language' => 'en-GB')) in /home/dev/public_html/silvervalley/libraries/src/Application/SiteApplication.php (line 635)
  1.                 $options['language'] = 'en-GB';
  2.             }
  3.         }
  5.         // Finish initialisation
  6.         parent::initialiseApp($options);
  7.     }
  9.     /**
  10.      * Load the library language files for the application
  11.      *
SiteApplication->initialiseApp() in /home/dev/public_html/silvervalley/libraries/src/Application/SiteApplication.php (line 226)
  1.      * @since   3.2
  2.      */
  3.     protected function doExecute()
  4.     {
  5.         // Initialise the application
  6.         $this->initialiseApp();
  8.         // Mark afterInitialise in the profiler.
  9.         JDEBUG ? $this->profiler->mark('afterInitialise') : null;
  11.         // Route the application
SiteApplication->doExecute() in /home/dev/public_html/silvervalley/libraries/src/Application/CMSApplication.php (line 293)
  1.             $this->sanityCheckSystemVariables();
  2.             $this->setupLogging();
  3.             $this->createExtensionNamespaceMap();
  5.             // Perform application routines.
  6.             $this->doExecute();
  8.             // If we have an application document object, render it.
  9.             if ($this->document instanceof \Joomla\CMS\Document\Document) {
  10.                 // Render the application output.
  11.                 $this->render();
CMSApplication->execute() in /home/dev/public_html/silvervalley/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('/home/dev/public_html/silvervalley/includes/app.php') in /home/dev/public_html/silvervalley/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 Traces 2

[2/2] mysqli_sql_exception 
mysqli_sql_exception:
Unknown column 'm.publish_up' in 'where clause'

  at /home/dev/public_html/silvervalley/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:137
  at mysqli->prepare('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 `a4y9h_menu` AS `m`LEFT JOIN `a4y9h_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`')
     (/home/dev/public_html/silvervalley/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:137)
  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 `a4y9h_menu` AS `m`LEFT JOIN `a4y9h_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`')
     (/home/dev/public_html/silvervalley/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 `a4y9h_menu` AS `m`LEFT JOIN `a4y9h_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`')
     (/home/dev/public_html/silvervalley/libraries/vendor/joomla/database/src/DatabaseDriver.php:1900)
  at Joomla\Database\DatabaseDriver->setQuery(object(MysqliQuery))
     (/home/dev/public_html/silvervalley/libraries/src/Menu/SiteMenu.php:166)
  at Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()
     (/home/dev/public_html/silvervalley/libraries/src/Cache/Controller/CallbackController.php:51)
  at Joomla\CMS\Cache\Controller\CallbackController->get(object(Closure), array(), 'd17e8e13b99b4d9bf23a7d0b83a466c3', false)
     (/home/dev/public_html/silvervalley/libraries/src/Menu/SiteMenu.php:179)
  at Joomla\CMS\Menu\SiteMenu->load()
     (/home/dev/public_html/silvervalley/libraries/src/Menu/AbstractMenu.php:333)
  at Joomla\CMS\Menu\AbstractMenu->getMenu()
     (/home/dev/public_html/silvervalley/libraries/src/Menu/AbstractMenu.php:164)
  at Joomla\CMS\Menu\AbstractMenu->getItem(null)
     (/home/dev/public_html/silvervalley/libraries/src/Application/SiteApplication.php:422)
  at Joomla\CMS\Application\SiteApplication->getTemplate(true)
     (/home/dev/public_html/silvervalley/libraries/src/Error/Renderer/HtmlRenderer.php:50)
  at Joomla\CMS\Error\Renderer\HtmlRenderer->render(object(ValueError))
     (/home/dev/public_html/silvervalley/libraries/src/Exception/ExceptionHandler.php:126)
  at Joomla\CMS\Exception\ExceptionHandler::render(object(ValueError))
     (/home/dev/public_html/silvervalley/libraries/src/Exception/ExceptionHandler.php:72)
  at Joomla\CMS\Exception\ExceptionHandler::handleException(object(ValueError))
     (/home/dev/public_html/silvervalley/libraries/src/Application/CMSApplication.php:322)
  at Joomla\CMS\Application\CMSApplication->execute()
     (/home/dev/public_html/silvervalley/includes/app.php:61)
  at require_once('/home/dev/public_html/silvervalley/includes/app.php')
     (/home/dev/public_html/silvervalley/index.php:32)
[1/2] ValueError 
ValueError:
version_compare(): Argument #3 ($operator) must be a valid comparison operator

  at /home/dev/public_html/silvervalley/plugins/system/offlajnparams/offlajnjoomlacompat.php:12
  at version_compare('4.4.3', '3.0.0', 'l')
     (/home/dev/public_html/silvervalley/plugins/system/offlajnparams/offlajnjoomlacompat.php:12)
  at require_once('/home/dev/public_html/silvervalley/plugins/system/offlajnparams/offlajnjoomlacompat.php')
     (/home/dev/public_html/silvervalley/plugins/system/offlajnparams/offlajnparams.php:17)
  at require_once('/home/dev/public_html/silvervalley/plugins/system/offlajnparams/offlajnparams.php')
     (/home/dev/public_html/silvervalley/libraries/src/Extension/ExtensionManagerTrait.php:217)
  at Joomla\CMS\Application\CMSApplication->loadPluginFromFilesystem('offlajnparams', 'system')
     (/home/dev/public_html/silvervalley/libraries/src/Extension/ExtensionManagerTrait.php:160)
  at Joomla\CMS\Application\CMSApplication->loadExtension('Joomla\\CMS\\Extension\\PluginInterface', 'offlajnparams:system', '/home/dev/public_html/silvervalley/plugins/system/offlajnparams')
     (/home/dev/public_html/silvervalley/libraries/src/Extension/ExtensionManagerTrait.php:99)
  at Joomla\CMS\Application\CMSApplication->bootPlugin('offlajnparams', 'system')
     (/home/dev/public_html/silvervalley/libraries/src/Plugin/PluginHelper.php:232)
  at Joomla\CMS\Plugin\PluginHelper::import(object(stdClass), true, object(Dispatcher))
     (/home/dev/public_html/silvervalley/libraries/src/Plugin/PluginHelper.php:192)
  at Joomla\CMS\Plugin\PluginHelper::importPlugin('system')
     (/home/dev/public_html/silvervalley/libraries/src/Application/CMSApplication.php:744)
  at Joomla\CMS\Application\CMSApplication->initialiseApp(array('language' => 'en-GB'))
     (/home/dev/public_html/silvervalley/libraries/src/Application/SiteApplication.php:635)
  at Joomla\CMS\Application\SiteApplication->initialiseApp()
     (/home/dev/public_html/silvervalley/libraries/src/Application/SiteApplication.php:226)
  at Joomla\CMS\Application\SiteApplication->doExecute()
     (/home/dev/public_html/silvervalley/libraries/src/Application/CMSApplication.php:293)
  at Joomla\CMS\Application\CMSApplication->execute()
     (/home/dev/public_html/silvervalley/includes/app.php:61)
  at require_once('/home/dev/public_html/silvervalley/includes/app.php')
     (/home/dev/public_html/silvervalley/index.php:32)