clarkwinkelmann
UPDATE
Next Illuminate\Database\QueryException: SQLSTATE[42000]: Syntax error or access violation: 1055 'baybky_yksforum.yksfrmdiscussions.title' isn't in GROUP BY (SQL: select `yksfrmdiscussions`.*, `yksfrmposts_ft`.`most_relevant_post_id` from `yksfrmdiscussions` inner join ((select `yksfrmposts`.`discussion_id`, SUM(MATCH(`yksfrmposts`.`content`) AGAINST (s)) as score, SUBSTRING_INDEX(GROUP_CONCAT(`yksfrmposts`.`id` ORDER BY MATCH(`yksfrmposts`.`content`) AGAINST (s) DESC, `yksfrmposts`.`number`), ',', 1) as most_relevant_post_id from `yksfrmposts` where exists (select 1 from `yksfrmdiscussions` where `yksfrmdiscussions`.`id` = `yksfrmposts`.`discussion_id` and (`yksfrmdiscussions`.`id` not in (select `discussion_id` from `yksfrmdiscussion_tag` where `tag_id` not in (select `yksfrmtags`.`id` from `yksfrmtags` where (`yksfrmtags`.`id` in (select `yksfrmperm_tags`.`id` from `yksfrmtags` as `yksfrmperm_tags`) and (`yksfrmtags`.`parent_id` in (select `yksfrmperm_tags`.`id` from `yksfrmtags` as `yksfrmperm_tags`) or `yksfrmtags`.`parent_id` is null))))) and (`yksfrmdiscussions`.`is_private` = 0 or (((`yksfrmdiscussions`.`is_approved` = 0))))) and (`yksfrmposts`.`is_private` = 0 or (((`yksfrmposts`.`is_approved` = 0)))) and `yksfrmposts`.`type` = comment and MATCH(`yksfrmposts`.`content`) AGAINST (s IN BOOLEAN MODE) and `type` in (discussionTagged, discussionStickied, discussionLocked, comment, discussionRenamed) group by `yksfrmposts`.`discussion_id`) union (select `id`, NULL as score, first_post_id as most_relevant_post_id from `yksfrmdiscussions` where MATCH(`yksfrmdiscussions`.`title`) AGAINST (s IN BOOLEAN MODE))) `yksfrmposts_ft` on `yksfrmposts_ft`.`discussion_id` = `yksfrmdiscussions`.`id` where (`yksfrmdiscussions`.`id` not in (select `discussion_id` from `yksfrmdiscussion_tag` where `tag_id` not in (select `yksfrmtags`.`id` from `yksfrmtags` where (`yksfrmtags`.`id` in (select `yksfrmperm_tags`.`id` from `yksfrmtags` as `yksfrmperm_tags`) and (`yksfrmtags`.`parent_id` in (select `yksfrmperm_tags`.`id` from `yksfrmtags` as `yksfrmperm_tags`) or `yksfrmtags`.`parent_id` is null))))) and (`yksfrmdiscussions`.`is_private` = 0 or (((`yksfrmdiscussions`.`is_approved` = 0)))) group by `yksfrmdiscussions`.`id` order by MATCH(`yksfrmdiscussions`.`title`) AGAINST (s) desc, `yksfrmposts_ft`.`score` desc limit 21) in /var/www/flarum/vendor/illuminate/database/Connection.php:692
Stack trace:
#0 /var/www/flarum/vendor/illuminate/database/Connection.php(652): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/flarum/vendor/illuminate/database/Connection.php(360): Illuminate\Database\Connection->run()
#2 /var/www/flarum/vendor/illuminate/database/Query/Builder.php(2351): Illuminate\Database\Connection->select()
#3 /var/www/flarum/vendor/illuminate/database/Query/Builder.php(2339): Illuminate\Database\Query\Builder->runSelect()
#4 /var/www/flarum/vendor/illuminate/database/Query/Builder.php(2905): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#5 /var/www/flarum/vendor/illuminate/database/Query/Builder.php(2340): Illuminate\Database\Query\Builder->onceWithColumns()
#6 /var/www/flarum/vendor/illuminate/database/Eloquent/Builder.php(604): Illuminate\Database\Query\Builder->get()
#7 /var/www/flarum/vendor/illuminate/database/Eloquent/Builder.php(588): Illuminate\Database\Eloquent\Builder->getModels()
#8 /var/www/flarum/vendor/flarum/core/src/Search/AbstractSearcher.php(68): Illuminate\Database\Eloquent\Builder->get()
#9 /var/www/flarum/vendor/flarum/core/src/Api/Controller/ListDiscussionsController.php(100): Flarum\Search\AbstractSearcher->search()
#10 /var/www/flarum/vendor/flarum/core/src/Api/Controller/AbstractSerializeController.php(110): Flarum\Api\Controller\ListDiscussionsController->data()
#11 /var/www/flarum/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\AbstractSerializeController->handle()
#12 /var/www/flarum/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#13 /var/www/flarum/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\ExecuteRoute->process()
#14 /var/www/flarum/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#15 /var/www/flarum/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Api\Middleware\ThrottleApi->process()
#16 /var/www/flarum/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(36): Laminas\Stratigility\Next->handle()
#17 /var/www/flarum/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\CheckCsrfToken->process()
#18 /var/www/flarum/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(67): Laminas\Stratigility\Next->handle()
#19 /var/www/flarum/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\ResolveRoute->process()
#20 /var/www/flarum/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#21 /var/www/flarum/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\SetLocale->process()
#22 /var/www/flarum/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(56): Laminas\Stratigility\Next->handle()
#23 /var/www/flarum/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\AuthenticateWithHeader->process()
#24 /var/www/flarum/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle()
#25 /var/www/flarum/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\AuthenticateWithSession->process()
#26 /var/www/flarum/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle()
#27 /var/www/flarum/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\RememberFromCookie->process()
#28 /var/www/flarum/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#29 /var/www/flarum/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\StartSession->process()
#30 /var/www/flarum/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\Stratigility\Next->handle()
#31 /var/www/flarum/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Api\Middleware\FakeHttpMethods->process()
#32 /var/www/flarum/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle()
#33 /var/www/flarum/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\ParseJsonBody->process()
#34 /var/www/flarum/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#35 /var/www/flarum/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\HandleErrors->process()
#36 /var/www/flarum/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle()
#37 /var/www/flarum/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\InjectActorReference->process()
#38 /var/www/flarum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(76): Laminas\Stratigility\Next->handle()
#39 /var/www/flarum/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process()
#40 /var/www/flarum/vendor/laminas/laminas-stratigility/src/Next.php(51): Middlewares\RequestHandler->process()
#41 /var/www/flarum/vendor/middlewares/base-path-router/src/BasePathRouter.php(101): Laminas\Stratigility\Next->handle()
#42 /var/www/flarum/vendor/laminas/laminas-stratigility/src/Next.php(51): Middlewares\BasePathRouter->process()
#43 /var/www/flarum/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(36): Laminas\Stratigility\Next->handle()
#44 /var/www/flarum/vendor/laminas/laminas-stratigility/src/Next.php(51): Laminas\Stratigility\Middleware\OriginalMessages->process()
#45 /var/www/flarum/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle()
#46 /var/www/flarum/vendor/laminas/laminas-stratigility/src/Next.php(51): Middlewares\BasePath->process()
#47 /var/www/flarum/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle()
#48 /var/www/flarum/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\ProcessIp->process()
#49 /var/www/flarum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(76): Laminas\Stratigility\Next->handle()
#50 /var/www/flarum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(65): Laminas\Stratigility\MiddlewarePipe->process()
#51 /var/www/flarum/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(96): Laminas\Stratigility\MiddlewarePipe->handle()
#52 /var/www/flarum/vendor/flarum/core/src/Http/Server.php(44): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#53 /var/www/flarum/public/index.php(26): Flarum\Http\Server->listen()
#54 {main}
