2021/8/25 Yannis：不推荐使用，还请修改前请备份有关数据文件 beta.15 以上不支持中文搜索拓展 jjandxa/flarum-ext-chinese-search 本文首发于： Flarum/22321#L15 有能力的用户，可以使用 xunsearch 实现更加完美的中文搜索。 MySQL 自 5.7 开始支持多语种文字全文索引。使用下面的优化，经测试能搜索到中日韩（CJK）关键字，其他语言的搜索效果没有测试。请注意，此方法会在一定程度上影响数据库性能，且还是会存在部分标题中的关键词无法搜索到的问题，但总体来说这个方法是目前成本最低、最稳定的方法。题外话，Flarum开发者曾经讨论过，在将来的版本会使用 ElasticSearch 分布式全文搜索引擎，因为 ElasticSeatch 比此方法好，但直到现在也没有用上。。。已测试的可行的服务器条件：系统 CentOS 7.4 64位 MySQL 5.7 找到数据库配置文件：我的配置文件在服务器上的路径: /etc/my.cnf if(window.hljsLoader && !document.currentScript.parentNode.hasAttribute('data-s9e-livepreview-onupdate')) { window.hljsLoader.highlightBlocks(document.currentScript.parentNode); } 在配置文件中加入以下内容： [mysqld] ngram_token_size=2 if(window.hljsLoader && !document.currentScript.parentNode.hasAttribute('data-s9e-livepreview-onupdate')) { window.hljsLoader.highlightBlocks(document.currentScript.parentNode); } 前往 phpMyAdmin 重建数据库索引。分别执行以下两段： USE YourFlarumDataBaseName; // 这里替换为你的 Flarum 数据库的名字 ALTER TABLE posts DROP INDEX content; // 如果你有表前缀，给 posts 加上前缀即可，下面都是如此。 CREATE FULLTEXT INDEX content ON `posts` (`content`) WITH PARSER ngram; // 注意表前缀 if(window.hljsLoader && !document.currentScript.parentNode.hasAttribute('data-s9e-livepreview-onupdate')) { window.hljsLoader.highlightBlocks(document.currentScript.parentNode); } USE YourFlarumDataBaseName; // 这里替换为你的 Flarum 数据库的名字 ALTER TABLE discussions DROP INDEX title; // 注意表前缀 CREATE FULLTEXT INDEX title ON `discussions` (`title`) WITH PARSER ngram; if(window.hljsLoader && !document.currentScript.parentNode.hasAttribute('data-s9e-livepreview-onupdate')) { window.hljsLoader.highlightBlocks(document.currentScript.parentNode); } 完成！等待一会儿，强制刷新浏览器，查看效果。 🇨🇳 中文搜索 🇯🇵 日文搜索 🇺🇸 英文搜索

感谢贡献解决方案，但是我的数据库是带flarum_前缀的，执行会出错……要怎么改呢？😅

于长野把表名加上前缀即可： USE YourFlarumDataBaseName; // 这里替换为你的 Flarum 数据库的名字 ALTER TABLE posts DROP INDEX content; CREATE FULLTEXT INDEX content ON `flarum_posts` (`content`) WITH PARSER ngram; if(window.hljsLoader && !document.currentScript.parentNode.hasAttribute('data-s9e-livepreview-onupdate')) { window.hljsLoader.highlightBlocks(document.currentScript.parentNode); } 最后一句，跟原始教程的区别： CREATE FULLTEXT INDEX content ON `posts` (`content`) WITH PARSER ngram; if(window.hljsLoader && !document.currentScript.parentNode.hasAttribute('data-s9e-livepreview-onupdate')) { window.hljsLoader.highlightBlocks(document.currentScript.parentNode); }

[未知用户] emm,报错了……

报错是别的问题？成功了吗？

@Golden ……这都看到了，我刚才试了下，不行，然后第二行也修改成了带flarum_前缀的，又报错了，我刚刚去英文论坛找了找，看到了可能是你发的解决办法下边的Gif，准备手动试下😂

（beta11）还是不行，posts表下面没有content

于长野 content 索引已经被删除了，难道是你之前重复操作了？去看看索引是不是没有了，没有了的话，就直接执行下一步吧

Golden 确实是重复操作了。两条命令都执行了，ctrl+f5刷新了下貌似没有效果

于长野那直接执行最后一句重建索引吧

Golden 按照你的方法，结果应该是这样吧？但是网站强制刷新还是没有效果

【推荐】Flarum 中文搜索功能支持（不完美）

pptt12year

Golden 也就是直接下一步？

Golden

pptt12year 恩恩，不行的话试试 phpMyadmin 操作：

pptt12year

Golden 谢谢，可是就很尴尬，没有title这个

Golden

pptt12year 没有自己创建一个 title 全文索引就行了

pptt12year

Golden 你好，我自己创建并执行了语句，并没有报错，然后也清楚浏览器缓存刷新了，还是无效

Golden

pptt12year 睡一觉起来再看看吧，这个有时候明明执行完了，但是就是没效果，然后不管了，过一段时间就有效果了。当然之前站里有小伙伴发现了，如果一篇帖子标题的关键词，在正文内是没有的，那么这个关键词就搜索不到。

pptt12year

Golden 我需要对网站强制刷新吗？可是我没有搜到站内强制刷新的命令，您能告知吗？

Golden

pptt12year 没有这个命令，执行一次重建索引就相当于是「刷新」了，现在是只有标题搜索没效果还是正文搜索也没效果呢？

pptt12year

Golden 都没有效果

pptt12year

Golden 而且还会报错

Golden

pptt12year 刚刚看了没问题，是修好了？然后就是你应该是 beta 14 版本吧？中文语言包装的版本不对，装的是 Beta 13 版本的，14 的安装命令在这里有写 https://discuss.flarum.org.cn/d/1211

pptt12year

Golden 好的我先按一下中文语言包。您来syq777.com, 随便搜个“法律”、“电商”、“论坛”，都出不来

sky7

不確定有沒有設置錯誤，但是可以正常搜索
感謝分享 😊

肆意妄为

第一段重构后报错发现并没有content这个索引，第二段执行成功，但搜索时依旧报错500

Golden

肆意妄为没有就创建索引，用phpmyadmin 的图形界面

肆意妄为

报错：

GET https://qiyukan.club/api/discussions

PDOException: SQLSTATE[HY000]: General error: 1191 Can't find FULLTEXT index matching the column list in /www/wwwroot/qiyukan.club/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:78
Stack trace:
#0 /www/wwwroot/qiyukan.club/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(78): PDO->prepare()
#1 /www/wwwroot/qiyukan.club/vendor/illuminate/database/Connection.php(331): Doctrine\DBAL\Driver\PDOConnection->prepare()
#2 /www/wwwroot/qiyukan.club/vendor/illuminate/database/Connection.php(662): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /www/wwwroot/qiyukan.club/vendor/illuminate/database/Connection.php(629): Illuminate\Database\Connection->runQueryCallback()
#4 /www/wwwroot/qiyukan.club/vendor/illuminate/database/Connection.php(338): Illuminate\Database\Connection->run()
#5 /www/wwwroot/qiyukan.club/vendor/illuminate/database/Query/Builder.php(2159): Illuminate\Database\Connection->select()
#6 /www/wwwroot/qiyukan.club/vendor/illuminate/database/Query/Builder.php(2147): Illuminate\Database\Query\Builder->runSelect()
#7 /www/wwwroot/qiyukan.club/vendor/illuminate/database/Query/Builder.php(2619): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#8 /www/wwwroot/qiyukan.club/vendor/illuminate/database/Query/Builder.php(2148): Illuminate\Database\Query\Builder->onceWithColumns()
#9 /www/wwwroot/qiyukan.club/vendor/illuminate/database/Eloquent/Builder.php(546): Illuminate\Database\Query\Builder->get()
#10 /www/wwwroot/qiyukan.club/vendor/illuminate/database/Eloquent/Builder.php(530): Illuminate\Database\Eloquent\Builder->getModels()
#11 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Discussion/Search/DiscussionSearcher.php(79): Illuminate\Database\Eloquent\Builder->get()
#12 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Api/Controller/ListDiscussionsController.php(86): Flarum\Discussion\Search\DiscussionSearcher->search()
#13 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Api/Controller/AbstractSerializeController.php(115): Flarum\Api\Controller\ListDiscussionsController->data()
#14 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Http/RouteHandlerFactory.php(38): Flarum\Api\Controller\AbstractSerializeController->handle()
#15 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#16 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ExecuteRoute->process()
#17 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#18 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Api\Middleware\ThrottleApi->process()
#19 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(40): Laminas\Stratigility\Next->handle()
#20 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\CheckCsrfToken->process()
#21 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(67): Laminas\Stratigility\Next->handle()
#22 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ResolveRoute->process()
#23 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Http/Middleware/SetLocale.php(50): Laminas\Stratigility\Next->handle()
#24 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\SetLocale->process()
#25 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(55): Laminas\Stratigility\Next->handle()
#26 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\AuthenticateWithHeader->process()
#27 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(32): Laminas\Stratigility\Next->handle()
#28 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\AuthenticateWithSession->process()
#29 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(51): Laminas\Stratigility\Next->handle()
#30 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\RememberFromCookie->process()
#31 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#32 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\StartSession->process()
#33 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\Stratigility\Next->handle()
#34 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Api\Middleware\FakeHttpMethods->process()
#35 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle()
#36 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ParseJsonBody->process()
#37 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#38 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\HandleErrors->process()
#39 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\Stratigility\Next->handle()
#40 /www/wwwroot/qiyukan.club/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process()
#41 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\RequestHandler->process()
#42 /www/wwwroot/qiyukan.club/vendor/middlewares/base-path-router/src/BasePathRouter.php(97): Laminas\Stratigility\Next->handle()
#43 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\BasePathRouter->process()
#44 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(42): Laminas\Stratigility\Next->handle()
#45 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Laminas\Stratigility\Middleware\OriginalMessages->process()
#46 /www/wwwroot/qiyukan.club/vendor/middlewares/base-path/src/BasePath.php(53): Laminas\Stratigility\Next->handle()
#47 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\BasePath->process()
#48 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\Stratigility\Next->handle()
#49 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(73): Laminas\Stratigility\MiddlewarePipe->process()
#50 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(96): Laminas\Stratigility\MiddlewarePipe->handle()
#51 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Http/Server.php(42): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#52 /www/wwwroot/qiyukan.club/public/index.php(26): Flarum\Http\Server->listen()
#53 {main}

Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[HY000]: General error: 1191 Can't find FULLTEXT index matching the column list in /www/wwwroot/qiyukan.club/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /www/wwwroot/qiyukan.club/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(83): Doctrine\DBAL\Driver\PDO\Exception::new()
#1 /www/wwwroot/qiyukan.club/vendor/illuminate/database/Connection.php(331): Doctrine\DBAL\Driver\PDOConnection->prepare()
#2 /www/wwwroot/qiyukan.club/vendor/illuminate/database/Connection.php(662): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /www/wwwroot/qiyukan.club/vendor/illuminate/database/Connection.php(629): Illuminate\Database\Connection->runQueryCallback()
#4 /www/wwwroot/qiyukan.club/vendor/illuminate/database/Connection.php(338): Illuminate\Database\Connection->run()
#5 /www/wwwroot/qiyukan.club/vendor/illuminate/database/Query/Builder.php(2159): Illuminate\Database\Connection->select()
#6 /www/wwwroot/qiyukan.club/vendor/illuminate/database/Query/Builder.php(2147): Illuminate\Database\Query\Builder->runSelect()
#7 /www/wwwroot/qiyukan.club/vendor/illuminate/database/Query/Builder.php(2619): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#8 /www/wwwroot/qiyukan.club/vendor/illuminate/database/Query/Builder.php(2148): Illuminate\Database\Query\Builder->onceWithColumns()
#9 /www/wwwroot/qiyukan.club/vendor/illuminate/database/Eloquent/Builder.php(546): Illuminate\Database\Query\Builder->get()
#10 /www/wwwroot/qiyukan.club/vendor/illuminate/database/Eloquent/Builder.php(530): Illuminate\Database\Eloquent\Builder->getModels()
#11 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Discussion/Search/DiscussionSearcher.php(79): Illuminate\Database\Eloquent\Builder->get()
#12 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Api/Controller/ListDiscussionsController.php(86): Flarum\Discussion\Search\DiscussionSearcher->search()
#13 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Api/Controller/AbstractSerializeController.php(115): Flarum\Api\Controller\ListDiscussionsController->data()
#14 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Http/RouteHandlerFactory.php(38): Flarum\Api\Controller\AbstractSerializeController->handle()
#15 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#16 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ExecuteRoute->process()
#17 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#18 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Api\Middleware\ThrottleApi->process()
#19 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(40): Laminas\Stratigility\Next->handle()
#20 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\CheckCsrfToken->process()
#21 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(67): Laminas\Stratigility\Next->handle()
#22 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ResolveRoute->process()
#23 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Http/Middleware/SetLocale.php(50): Laminas\Stratigility\Next->handle()
#24 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\SetLocale->process()
#25 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(55): Laminas\Stratigility\Next->handle()
#26 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\AuthenticateWithHeader->process()
#27 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(32): Laminas\Stratigility\Next->handle()
#28 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\AuthenticateWithSession->process()
#29 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(51): Laminas\Stratigility\Next->handle()
#30 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\RememberFromCookie->process()
#31 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#32 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\StartSession->process()
#33 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\Stratigility\Next->handle()
#34 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Api\Middleware\FakeHttpMethods->process()
#35 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle()
#36 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ParseJsonBody->process()
#37 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#38 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\HandleErrors->process()
#39 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\Stratigility\Next->handle()
#40 /www/wwwroot/qiyukan.club/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process()
#41 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\RequestHandler->process()
#42 /www/wwwroot/qiyukan.club/vendor/middlewares/base-path-router/src/BasePathRouter.php(97): Laminas\Stratigility\Next->handle()
#43 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\BasePathRouter->process()
#44 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(42): Laminas\Stratigility\Next->handle()
#45 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Laminas\Stratigility\Middleware\OriginalMessages->process()
#46 /www/wwwroot/qiyukan.club/vendor/middlewares/base-path/src/BasePath.php(53): Laminas\Stratigility\Next->handle()
#47 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\BasePath->process()
#48 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\Stratigility\Next->handle()
#49 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(73): Laminas\Stratigility\MiddlewarePipe->process()
#50 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(96): Laminas\Stratigility\MiddlewarePipe->handle()
#51 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Http/Server.php(42): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#52 /www/wwwroot/qiyukan.club/public/index.php(26): Flarum\Http\Server->listen()
#53 {main}

Next Illuminate\Database\QueryException: SQLSTATE[HY000]: General error: 1191 Can't find FULLTEXT index matching the column list (SQL: select `pre_discussions`.*, `pre_posts_ft`.`most_relevant_post_id` from `pre_discussions` inner join (select `pre_posts`.`discussion_id`, SUM(MATCH(`pre_posts`.`content`) AGAINST (111)) as score, SUBSTRING_INDEX(GROUP_CONCAT(`pre_posts`.`id` ORDER BY MATCH(`pre_posts`.`content`) AGAINST (111) DESC, `pre_posts`.`number`), ',', 1) as most_relevant_post_id from `pre_posts` where exists (select 1 from `pre_discussions` where `pre_discussions`.`id` = `pre_posts`.`discussion_id` and (`pre_discussions`.`id` not in (select `discussion_id` from `pre_discussion_tag` where 0 = 1)) and (`pre_discussions`.`is_private` = 0 or (`pre_discussions`.`is_approved` = 0))) and (`pre_posts`.`is_private` = 0 or (`pre_posts`.`is_approved` = 0)) and `pre_posts`.`type` = comment and MATCH(`pre_posts`.`content`) AGAINST (111 IN BOOLEAN MODE) and `type` in (discussionLocked, discussionStickied, discussionTagged, comment, discussionRenamed) group by `pre_posts`.`discussion_id`) `pre_posts_ft` on `pre_posts_ft`.`discussion_id` = `pre_discussions`.`id` where (`pre_discussions`.`id` not in (select `discussion_id` from `pre_discussion_tag` where 0 = 1)) and (`pre_discussions`.`is_private` = 0 or (`pre_discussions`.`is_approved` = 0)) and (MATCH(`pre_discussions`.`title`) AGAINST (111 IN BOOLEAN MODE) or `pre_posts_ft`.`score` is not null) order by MATCH(`pre_discussions`.`title`) AGAINST (111) desc, `pre_posts_ft`.`score` desc limit 4) in /www/wwwroot/qiyukan.club/vendor/illuminate/database/Connection.php:669
Stack trace:
#0 /www/wwwroot/qiyukan.club/vendor/illuminate/database/Connection.php(629): Illuminate\Database\Connection->runQueryCallback()
#1 /www/wwwroot/qiyukan.club/vendor/illuminate/database/Connection.php(338): Illuminate\Database\Connection->run()
#2 /www/wwwroot/qiyukan.club/vendor/illuminate/database/Query/Builder.php(2159): Illuminate\Database\Connection->select()
#3 /www/wwwroot/qiyukan.club/vendor/illuminate/database/Query/Builder.php(2147): Illuminate\Database\Query\Builder->runSelect()
#4 /www/wwwroot/qiyukan.club/vendor/illuminate/database/Query/Builder.php(2619): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#5 /www/wwwroot/qiyukan.club/vendor/illuminate/database/Query/Builder.php(2148): Illuminate\Database\Query\Builder->onceWithColumns()
#6 /www/wwwroot/qiyukan.club/vendor/illuminate/database/Eloquent/Builder.php(546): Illuminate\Database\Query\Builder->get()
#7 /www/wwwroot/qiyukan.club/vendor/illuminate/database/Eloquent/Builder.php(530): Illuminate\Database\Eloquent\Builder->getModels()
#8 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Discussion/Search/DiscussionSearcher.php(79): Illuminate\Database\Eloquent\Builder->get()
#9 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Api/Controller/ListDiscussionsController.php(86): Flarum\Discussion\Search\DiscussionSearcher->search()
#10 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Api/Controller/AbstractSerializeController.php(115): Flarum\Api\Controller\ListDiscussionsController->data()
#11 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Http/RouteHandlerFactory.php(38): Flarum\Api\Controller\AbstractSerializeController->handle()
#12 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#13 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ExecuteRoute->process()
#14 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#15 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Api\Middleware\ThrottleApi->process()
#16 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(40): Laminas\Stratigility\Next->handle()
#17 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\CheckCsrfToken->process()
#18 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(67): Laminas\Stratigility\Next->handle()
#19 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ResolveRoute->process()
#20 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Http/Middleware/SetLocale.php(50): Laminas\Stratigility\Next->handle()
#21 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\SetLocale->process()
#22 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(55): Laminas\Stratigility\Next->handle()
#23 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\AuthenticateWithHeader->process()
#24 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(32): Laminas\Stratigility\Next->handle()
#25 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\AuthenticateWithSession->process()
#26 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(51): Laminas\Stratigility\Next->handle()
#27 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\RememberFromCookie->process()
#28 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#29 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\StartSession->process()
#30 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\Stratigility\Next->handle()
#31 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Api\Middleware\FakeHttpMethods->process()
#32 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle()
#33 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ParseJsonBody->process()
#34 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#35 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\HandleErrors->process()
#36 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\Stratigility\Next->handle()
#37 /www/wwwroot/qiyukan.club/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process()
#38 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\RequestHandler->process()
#39 /www/wwwroot/qiyukan.club/vendor/middlewares/base-path-router/src/BasePathRouter.php(97): Laminas\Stratigility\Next->handle()
#40 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\BasePathRouter->process()
#41 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(42): Laminas\Stratigility\Next->handle()
#42 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Laminas\Stratigility\Middleware\OriginalMessages->process()
#43 /www/wwwroot/qiyukan.club/vendor/middlewares/base-path/src/BasePath.php(53): Laminas\Stratigility\Next->handle()
#44 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\BasePath->process()
#45 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\Stratigility\Next->handle()
#46 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(73): Laminas\Stratigility\MiddlewarePipe->process()
#47 /www/wwwroot/qiyukan.club/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(96): Laminas\Stratigility\MiddlewarePipe->handle()
#48 /www/wwwroot/qiyukan.club/vendor/flarum/core/src/Http/Server.php(42): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#49 /www/wwwroot/qiyukan.club/public/index.php(26): Flarum\Http\Server->listen()
#50 {main}

肆意妄为

Golden 也不行

Golden

肆意妄为就是因为索引没创建出来，所以报错

肆意妄为

Golden
只能一次两个

Grizz

Golden 你好，目前社区用的搜索就是这个搜索吗？

Golden

肆意妄为索引类型是 FULLTEXT 全文索引，你选错了