Reply to thread

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}


Back
Top Bottom