Hi Sakis,
When the omtimize function in the Smart search component is executed, we get an SQL error. 1064, You have an error in your SQL syntax; check the manual corresponds to your MariaDB server version fo the right syntax to use near ')' at line 5
See attached image.
This is triggered in: administrator/components/com_finder/src/Indexer/Adapter.php
You override the adapter in your plugin but the onFinderGarbageCollection is not used, so 0 could be returned. This will prevent the error.
* Method to remove outdated index entries
*
* @return integer
*
* @since 4.2.0
*/
public function onFinderGarbageCollection()
{
return 0;
}
