BugReport
-
- XF\Db\InvalidQueryException: MySQL query error [1064]: syntax error, unexpected '+', expecting FTS_TERM or FTS_NUMB or '*'
-
- src/XF/Db/AbstractStatement.php:228
-
-
- Generiert von: ...
-
- 3 Februar 2020 um 17:59
-
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 ('+** +_md_node_10 -_md_node_190 -_md_node_181 -_md_node_140 -_md_node_14 -_md_node_85 -_md_node_171 -_md_node_128 -_md_node_129 -_md_node_130 -_md_node_131 -_md_node_89 -_md_node_16 -_md_node_82 -_md_node_45 -_md_node_132 -_md_node_27 -_md_node_39 -_md_node_40 -_md_node_41 -_md_node_57 -_md_node_156 -_md_node_91 -_md_node_146 -_md_node_162 -_md_node_137 -_md_node_138 -_md_node_93 -_md_node_97 -_md_node_98 -_md_node_118 -_md_node_94 -_md_node_96 -_md_node_95 -_md_node_99 -_md_node_100 -_md_node_101 -_md_node_102 -_md_node_103 -_md_node_106 -_md_node_108 -_md_node_109 -_md_node_110 -_md_node_111 -_md_node_112 -_md_node_113 -_md_node_114 -_md_node_115 -_md_node_116 -_md_node_107 -_md_node_84 -_md_node_42 -_md_node_44 -_md_node_49 -_md_node_52 -_md_node_133 -_md_hidden_1' IN BOOLEAN MODE) AND search_index.content_type = 'thread'
ORDER BY search_index.item_date DESC
LIMIT 200
------------
#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1064, '42000')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1064, '42000')
#2 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(160): XF\Db\AbstractAdapter->query('
SELECT sear...', Array)
#4 src/XF/Search/Source/MySqlFt.php(291): XF\Db\AbstractAdapter->fetchAllNum('
SELECT sear...')
#5 src/XF/Search/Search.php(164): XF\Search\Source\MySqlFt->search(Object(XF\Search\Query\Query), 200)
#6 src/XF/Repository/Search.php(34): XF\Search\Search->search(Object(XF\Search\Query\Query))
#7 src/addons/BS/SimilarThreads/Repository/SimilarThreads.php(17): XF\Repository\Search->runSearch(Object(XF\Search\Query\Query))
#8 src/addons/BS/SimilarThreads/XF/Pub/Controller/Forum.php(26): BS\SimilarThreads\Repository\SimilarThreads->getSimilarThreads('**', Object(XF\Entity\Forum))
#9 src/XF/Mvc/Dispatcher.php(350): BS\SimilarThreads\XF\Pub\Controller\Forum->actionSimilarThreads(Object(XF\Mvc\ParameterBag))
#10 src/XF/Mvc/Dispatcher.php(257): XF\Mvc\Dispatcher->dispatchClass('XF:Forum', 'SimilarThreads', Object(XF\Mvc\RouteMatch), Object(BS\SimilarThreads\XF\Pub\Controller\Forum), NULL)
#11 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(BS\SimilarThreads\XF\Pub\Controller\Forum), NULL)
#12 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#13 src/XF/App.php(2184): XF\Mvc\Dispatcher->run()
#14 src/XF.php(391): XF\App->run()
#15 index.php(20): XF::runApp('XF\\Pub\\App')
#16 {main}
Status der Anfrage
array(4) {
["url"] => string(178) "/forums/alg-ii.10/similar-threads?q=**&_xfRequestUri=%2Fforums%2Falg-ii.10%2Fpost-thread&_xfWithData=1&_xfToken=1580748703%2C1903a139a6c19fd8db2f334670e34ac1&_xfResponseType=json"
["referrer"] => string(54) "
https://www.elo-forum.org/forums/alg-ii.10/post-thread"
["_GET"] => array(5) {
["q"] => string(2) "**"
["_xfRequestUri"] => string(29) "/forums/alg-ii.10/post-thread"
["_xfWithData"] => string(1) "1"
["_xfToken"] => string(43) "1580748703,1903a139a6c19fd8db2f334670e34ac1"
["_xfResponseType"] => string(4) "json"
}
["_POST"] => array(0) {
}