Kunena / Kunena-Forum

Kunena Forum - Forum / Bulletin Board / Discussions component for Joomla - This is the 6.x/5.x main development branch. Please do not open issues regarding earlier versions of Kunena
https://www.kunena.org
GNU General Public License v3.0
1.75k stars 812 forks source link

Recounting statistics causes errors #9653

Closed rich20 closed 6 months ago

rich20 commented 6 months ago

To Reproduce Backend -> Kunena -> Tools Try to recount statistics

Actual result Unknown fetch type '8'

| Function | Location

-- | -- | -- 1 | () | JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:501 2 | Joomla\Database\Mysqli\MysqliStatement->fetch() | JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:725 3 | Joomla\Database\DatabaseDriver->fetchObject() | JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:1307 4 | Joomla\Database\DatabaseDriver->loadObjectList() | JROOT/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:528 5 | Kunena\Forum\Libraries\Attachment\KunenaAttachmentHelper::cleanup() | JROOT/administrator/components/com_kunena/src/Controller/ToolsController.php:532 6 | Kunena\Forum\Administrator\Controller\ToolsController->doRecount() | JROOT/libraries/src/MVC/Controller/BaseController.php:730 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/libraries/src/Dispatcher/ComponentDispatcher.php:143 8 | Joomla\CMS\Dispatcher\ComponentDispatcher->dispatch() | JROOT/libraries/src/Component/ComponentHelper.php:361 9 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/AdministratorApplication.php:150 10 | Joomla\CMS\Application\AdministratorApplication->dispatch() | JROOT/libraries/src/Application/AdministratorApplication.php:195 11 | Joomla\CMS\Application\AdministratorApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:306 12 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/administrator/includes/app.php:58 13 | require_once() | JROOT/administrator/index.php:32

System information

Desktop

Gindi50 commented 6 months ago

I have just recounted the statistics on my test server with K6.3.0-BETA2 and also with K6.3.0-BETA3-DEV and clicked on all four statistics defaults. The result was: All category statistics were recounted.

rich20 commented 6 months ago

Ok, found the issue. Due to the many tests, I had many orphaned database entries. After cleaning everything works again.