Some kind of Sql errors

[REP13]

Affected version

v2.2.11

Hi there can someone explain what does mean this :

• XF\Db\InvalidQueryException: MySQL query error [1064]: syntax error, unexpected '+', expecting FTS_TERM or FTS_NUMB or '*'
• src/XF/Db/AbstractStatement.php:230

• ed '+', expecting FTS_TERM or FTS_NUMB or '*'
• src/XF/Db/AbstractStatement.php:230
• Generated by:  xxxx
• Feb 24, 2024 at 08:54

Stack trace​

SELECT search_index.content_type, search_index.content_id
FROM xf_search_index AS search_index

WHERE MATCH(search_index.title, search_index.message, search_index.metadata) AGAINST ('+word1 +word2 +word3 +word4 +word5 +*** +word6 -_md_node_17 -_md_hidden_1' IN BOOLEAN MODE)

ORDER BY search_index.item_date DESC
LIMIT 200

------------

#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL query err...', 1064, '42000')
#1 src/XF/Db/Mysqli/Statement.php(79): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1064, '42000')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(162): XF\Db\AbstractAdapter->query('
SELECT sear...', Array)
#4 src/XF/Search/Source/MySqlFt.php(293): XF\Db\AbstractAdapter->fetchAllNum('
SELECT sear...')
#5 src/addons/SV/SearchImprovements/XF/Search/Source/MySqlFt.php(58): XF\Search\Source\MySqlFt->search(Object(SV\SearchImprovements\XF\Search\Query\KeywordQuery), 200)
#6 src/XF/Search/Search.php(185): SV\SearchImprovements\XF\Search\Source\MySqlFt->search(Object(SV\SearchImprovements\XF\Search\Query\KeywordQuery), '200')
#7 src/XF/Search/Search.php(214): XF\Search\Search->XF\Search\{closure}(Object(SV\SearchImprovements\XF\Search\Query\KeywordQuery), '200')
#8 src/XF/Search/Search.php(181): XF\Search\Search->executeSearch(Object(SV\SearchImprovements\XF\Search\Query\KeywordQuery), '200', Object(Closure), true)
#9 src/XF/Repository/Search.php(33): XF\Search\Search->search(Object(SV\SearchImprovements\XF\Search\Query\KeywordQuery))
#10 src/addons/SV/SearchImprovements/XF/Repository/Search.php(103): XF\Repository\Search->runSearch(Object(SV\SearchImprovements\XF\Search\Query\KeywordQuery), Array, true)
#11 src/XF/Pub/Controller/Search.php(437): SV\SearchImprovements\XF\Repository\Search->runSearch(Object(SV\SearchImprovements\XF\Search\Query\KeywordQuery), Array, true)
#12 src/XF/Pub/Controller/Search.php(119): XF\Pub\Controller\Search->runSearch(Object(SV\SearchImprovements\XF\Search\Query\KeywordQuery), Array)
#13 src/addons/SV/SearchImprovements/XF/Pub/Controller/Search.php(87): XF\Pub\Controller\Search->actionSearch()
#14 src/XF/Mvc/Dispatcher.php(352): SV\SearchImprovements\XF\Pub\Controller\Search->actionSearch(Object(XF\Mvc\ParameterBag))
#15 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('XF:Search', 'Search', Object(XF\Mvc\RouteMatch), Object(SV\SearchImprovements\XF\Pub\Controller\SearchPatchFirst), NULL)
#16 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(SV\SearchImprovements\XF\Pub\Controller\SearchPatchFirst), NULL)
#17 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#18 src/XF/App.php(2353): XF\Mvc\Dispatcher->run()
#19 src/XF.php(524): XF\App->run()
#20 index.php(20): XF::runApp('XF\\Pub\\App')
#21 {main}