If I check all 4 Kunena Recount Statistics and click restore, I get the following error message..
Code:
An error has occurred.
[quote]1054 Unknown column 't.category_id' in 'WHERE'[/quote]
Call Stack[b]#[/b][b]Function[/b][b]Location[/b]1()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:9724Joomla\Database\Mysqli\MysqliDriver->prepareStatement()JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:17805Joomla\Database\DatabaseDriver->setQuery()JROOT/libraries/kunena/src/Forum/Category/KunenaCategoryHelper.php:10166Kunena\Forum\Libraries\Forum\Category\KunenaCategoryHelper::recountBatch()JROOT/administrator/components/com_kunena/src/Controller/ToolsController.php:5547Kunena\Forum\Administrator\Controller\ToolsController->doRecount()JROOT/libraries/src/MVC/Controller/BaseController.php:7308Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/libraries/src/Dispatcher/ComponentDispatcher.php:1439Joomla\CMS\Dispatcher\ComponentDispatcher->dispatch()JROOT/libraries/src/Component/ComponentHelper.php:36110Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/AdministratorApplication.php:15011Joomla\CMS\Application\AdministratorApplication->dispatch()JROOT/libraries/src/Application/AdministratorApplication.php:20612Joomla\CMS\Application\AdministratorApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:30413Joomla\CMS\Application\CMSApplication->execute()JROOT/administrator/includes/app.php:5814require_once()JROOT/administrator/index.php:32
if I change JROOT\administrator\components\com_kunena\src\Controller\ToolsController.php:554
Code:
KunenaCategoryHelper::recountBatch();
to
Code:
KunenaCategoryHelper::recount();
then it works correctly
