Solved Plugin 'Smart Search - Kunena Forum' SQL error in Maintenance - Optimise

Expected behaviour
Smart Search - Maintenance - Optimise runs normally.

Actual behaviour
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 5

Workaround
Disable  the  'Smart Search - Kunena Forum' and Maintenance - Optimise runs normally.

Environment
Kunena 6.0.2 2022-08-15
Joomla 4.2.3-dev
PHP 8.1.9
MySQL 8.0.27
Wampserver 3.2.9
Windows 11

Hello,

Thanks for the report i will take a look

Here is the call stack, if that helps:


An error has occurred.
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 5
Call stack
# Function Location
1 () JROOT\libraries\vendor\joomla\database\src\Mysqli\:137
2 mysqli->prepare() JROOT\libraries\vendor\joomla\database\src\Mysqli\:137
3 Joomla\Database\Mysqli\MysqliStatement->__construct() JROOT\libraries\vendor\joomla\database\src\Mysqli\:1048
4 Joomla\Database\Mysqli\MysqliDriver->prepareStatement() JROOT\libraries\vendor\joomla\database\src\:1900
5 Joomla\Database\DatabaseDriver->setQuery() JROOT\administrator\components\com_finder\src\Indexer\:281
6 Joomla\Component\Finder\Administrator\Indexer\Adapter->onFinderGarbageCollection() JROOT\libraries\src\Plugin\:279
7 Joomla\CMS\Plugin\CMSPlugin->Joomla\CMS\Plugin\{closure}() JROOT\libraries\vendor\joomla\event\src\:486
8 Joomla\Event\Dispatcher->dispatch() JROOT\libraries\src\Application\:107
9 Joomla\CMS\Application\WebApplication->triggerEvent() JROOT\administrator\components\com_finder\src\Controller\:58
10 Joomla\Component\Finder\Administrator\Controller\IndexController->optimise() JROOT\libraries\src\MVC\Controller\:672
11 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT\libraries\src\Dispatcher\:143
12 Joomla\CMS\Dispatcher\ComponentDispatcher->dispatch() JROOT\libraries\src\Component\:355
13 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT\libraries\src\Application\:143
14 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT\libraries\src\Application\:186
15 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT\libraries\src\Application\:294
16 Joomla\CMS\Application\CMSApplication->execute() JROOT\administrator\includes\:61
17 require_once() JROOT\administrator\:32

Can-you confirm that you have just enabled the smart search plugins for Kunena and Joomla!, but not others plugins ?

All the six (6) standard Joomla Smart Search plugins plus Smart Search - Kunena Forum were enabled. All the Kunena plugins were enabled, except Jomsocial, Community Builder, EasySocial and Gravatar integration plugins.

I'am not able to reproduce it, so to try to get the query open the file : /libraries/vendor/joomla/database/src/DatabaseDriver.php and at line 1857 add :

Then re-try the optimise