Kunena 7.0.6 & Kunena 6.4.12 – Security Updates Released

The Kunena team has announce the arrival of Kunena 7.0.6 [K 7.0.6] in stable which is now available for download as a native Joomla extension for J! 5.4.x/6.0.x. This version addresses most of the issues that were discovered in K 6.2 / K 6.3 / K 6.4 and issues discovered during the last development stages of K 7.0.

The Kunena team is also pleased to announce the twelfth version of Kunena 6.4, a native Joomla extension for Joomla! 5.0, 5.1, 5.2, 5.3, 5.4 and 6.0.

Solved Unknown column 'a.pages' in 'field list'

More
1 year 9 months ago #232126 by mlotziii
Unknown column 'a.pages' in 'field list' was created by mlotziii
Somewhere along my upgrade path from Joomla 3.10.9 to 5.1.4 I broke Kunena. I'm using Kunea v. 6.3.4 and default theme.

I get the following error message on the front end: 

Error while rendering KunenaLayout.Unknown column 'a.pages' in 'field list'


I get this error on the back end.  This is copied from: Template

An error has occurred.

1054 Unknown column 'a.pages' in 'field list'

Call Stack#FunctionLocation1()JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:1382mysqli->prepare()JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:1383Joomla\Database\Mysqli\MysqliStatement->__construct()JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:10204Joomla\Database\Mysqli\MysqliDriver->prepareStatement()JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:17855Joomla\Database\DatabaseDriver->setQuery()JROOT/components/com_community/libraries/user.php:1916CUser->init()JROOT/components/com_community/libraries/core.php:2167CFactory::getUser()JROOT/plugins/community/myvideos/myvideos.php:348plgCommunityMyVideos->__construct()JROOT/libraries/src/Extension/ExtensionManagerTrait.php:2429Joomla\CMS\Application\CMSApplication->loadPluginFromFilesystem()JROOT/libraries/src/Extension/ExtensionManagerTrait.php:16010Joomla\CMS\Application\CMSApplication->loadExtension()JROOT/libraries/src/Extension/ExtensionManagerTrait.php:9911Joomla\CMS\Application\CMSApplication->bootPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:23212Joomla\CMS\Plugin\PluginHelper::import()JROOT/libraries/src/Plugin/PluginHelper.php:19213Joomla\CMS\Plugin\PluginHelper::importPlugin()JROOT/components/com_community/libraries/apps.php:6314CAppPlugins->loadApplications()JROOT/components/com_community/libraries/core.php:114615CConfig::getInstance()JROOT/components/com_community/libraries/core.php:24916CFactory::getConfig()JROOT/components/com_community/libraries/user.php:15217CUser->init()JROOT/components/com_community/libraries/core.php:14818CFactory::loadUsers()JROOT/plugins/kunena/community/KunenaAvatarCommunity.php:6119Kunena\Forum\Plugin\Kunena\Community\KunenaAvatarCommunity->load()JROOT/libraries/kunena/src/User/KunenaUserHelper.php:11720Kunena\Forum\Libraries\User\KunenaUserHelper::initialize()JROOT/libraries/kunena/src/User/KunenaUserHelper.php:1821include()JROOT/libraries/vendor/composer/ClassLoader.php:57622Composer\Autoload\{closure}()JROOT/libraries/vendor/composer/ClassLoader.php:42723Composer\Autoload\ClassLoader->loadClass()JROOT/libraries/src/Autoload/ClassLoader.php:5924Joomla\CMS\Autoload\ClassLoader->loadClass()JROOT/administrator/components/com_kunena/src/Model/TemplatesModel.php:8125Kunena\Forum\Administrator\Model\TemplatesModel->__construct()JROOT/libraries/src/MVC/Factory/MVCFactory.php:16226Joomla\CMS\MVC\Factory\MVCFactory->createModel()JROOT/libraries/src/MVC/Controller/BaseController.php:57427Joomla\CMS\MVC\Controller\BaseController->createModel()JROOT/libraries/src/MVC/Controller/BaseController.php:76128Joomla\CMS\MVC\Controller\BaseController->getModel()JROOT/libraries/src/MVC/Controller/BaseController.php:121829Joomla\CMS\MVC\Controller\BaseController->prepareViewModel()JROOT/libraries/src/MVC/Controller/BaseController.php:65830Joomla\CMS\MVC\Controller\BaseController->display()JROOT/administrator/components/com_kunena/src/Controller/DisplayController.php:6231Kunena\Forum\Administrator\Controller\DisplayController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:73032Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/libraries/src/Dispatcher/ComponentDispatcher.php:14333Joomla\CMS\Dispatcher\ComponentDispatcher->dispatch()JROOT/libraries/src/Component/ComponentHelper.php:36134Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/AdministratorApplication.php:15035Joomla\CMS\Application\AdministratorApplication->dispatch()JROOT/libraries/src/Application/AdministratorApplication.php:19536Joomla\CMS\Application\AdministratorApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:30637Joomla\CMS\Application\CMSApplication->execute()JROOT/administrator/includes/app.php:5838require_once()JROOT/administrator/index.php:32


 

Please Log in or Create an account to join the conversation.

More
1 year 9 months ago #232133 by rich
Replied by rich on topic Unknown column 'a.pages' in 'field list'
Have you installed JomSocial? The errors indicate this.
Important! Always create a backup before you make any changes to your website!

Please Log in or Create an account to join the conversation.

More
1 year 9 months ago #232138 by mlotziii
Replied by mlotziii on topic Unknown column 'a.pages' in 'field list'
Ah, Yes, JomSocial is installed. Thanks for directing me away from Kunena for the error!

Please Log in or Create an account to join the conversation.

Time to create page: 0.281 seconds