I am using share hosting, and my site was going well, when I published a discussion, my site went down. I can still login in to my account, admin page, but my home page turns blank except the logo.
Here is a bit information:
Flarum 1.8.5
PHP 8.1.29
MySQL 10.6.18-MariaDB-cll-lve
Queue Driver sync
Session Driver file
You will see the debug link if you visit: https://fh4u.org/u/freehosts4u/discussions
I guess it will show you the full picture?
What I did, run
Run the following SQL command:
sql command
SET SQL_BIG_SELECTS=1;
and
SET MAX_JOIN_SIZE=1000000000;
did not seem to make anything better, then I upgrade my site to the 1.8.5, I couldn't remember which version it was before.
I try to change
'host' => '127.0.0.1',
Any suggeston will be much appreciated. 🙂
Here is what I found on logs.
[2024-08-12 02:47:10] flarum.ERROR: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1104 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay in /home/account/domain/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117
Stack trace:
#0 /home/account/domain/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(117): PDOStatement->execute()
#1 /home/account/domain/flarum/vendor/illuminate/database/Connection.php(373): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /home/account/domain/flarum/vendor/illuminate/database/Connection.php(705): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /home/account/domain/flarum/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback()
#4 /home/account/domain/flarum/vendor/illuminate/database/Connection.php(376): Illuminate\Database\Connection->run()
#5 /home/account/domain/flarum/vendor/illuminate/database/Query/Builder.php(2414): Illuminate\Database\Connection->select()
#6 /home/account/domain/flarum/vendor/illuminate/database/Query/Builder.php(2402): Illuminate\Database\Query\Builder->runSelect()
#7 /home/account/domain/flarum/vendor/illuminate/database/Query/Builder.php(2936): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#8 /home/account/domain/flarum/vendor/illuminate/database/Query/Builder.php(2403): Illuminate\Database\Query\Builder->onceWithColumns()
#9 /home/account/domain/flarum/vendor/staudenmeir/eloquent-eager-limit/src/Builder.php(40): Illuminate\Database\Query\Builder->get()
#10 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Builder.php(625): Staudenmeir\EloquentEagerLimit\Builder->get()
#11 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Builder.php(609): Illuminate\Database\Eloquent\Builder->getModels()
#12 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Relations/Relation.php(195): Illuminate\Database\Eloquent\Builder->get()
#13 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Relations/Relation.php(160): Illuminate\Database\Eloquent\Relations\Relation->get()
#14 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Builder.php(673): Illuminate\Database\Eloquent\Relations\Relation->getEager()
#15 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Builder.php(642): Illuminate\Database\Eloquent\Builder->eagerLoadRelation()
#16 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Collection.php(60): Illuminate\Database\Eloquent\Builder->eagerLoadRelations()
#17 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Collection.php(231): Illuminate\Database\Eloquent\Collection->load()
#18 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Collection.php(206): Illuminate\Database\Eloquent\Collection->loadMissingRelation()
#19 /home/account/domain/flarum/vendor/flarum/core/src/Api/Controller/AbstractSerializeController.php(250): Illuminate\Database\Eloquent\Collection->loadMissing()
#20 /home/account/domain/flarum/vendor/flarum/core/src/Api/Controller/ListDiscussionsController.php(128): Flarum\Api\Controller\AbstractSerializeController->loadRelations()
#21 /home/account/domain/flarum/vendor/flarum/core/src/Api/Controller/AbstractSerializeController.php(116): Flarum\Api\Controller\ListDiscussionsController->data()
#22 /home/account/domain/flarum/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\AbstractSerializeController->handle()
#23 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#24 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ExecuteRoute->process()
#25 /home/account/domain/flarum/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#26 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Api\Middleware\ThrottleApi->process()
#27 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(69): Laminas\Stratigility\Next->handle()
#28 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ResolveRoute->process()
#29 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#30 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\SetLocale->process()
#31 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#32 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\HandleErrors->process()
#33 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(77): Laminas\Stratigility\Next->handle()
#34 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(66): Laminas\Stratigility\MiddlewarePipe->process()
#35 /home/account/domain/flarum/vendor/flarum/core/src/Api/Client.php(141): Laminas\Stratigility\MiddlewarePipe->handle()
#36 /home/account/domain/flarum/vendor/flarum/core/src/Api/Client.php(91): Flarum\Api\Client->send()
#37 /home/account/domain/flarum/vendor/flarum/core/src/Forum/Content/Index.php(108): Flarum\Api\Client->get()
#38 /home/account/domain/flarum/vendor/flarum/core/src/Forum/Content/Index.php(85): Flarum\Forum\Content\Index->getApiDocument()
#39 /home/account/domain/flarum/vendor/flarum/core/src/Frontend/Frontend.php(62): Flarum\Forum\Content\Index->__invoke()
#40 /home/account/domain/flarum/vendor/flarum/core/src/Frontend/Frontend.php(54): Flarum\Frontend\Frontend->populate()
#41 /home/account/domain/flarum/vendor/flarum/core/src/Frontend/Controller.php(32): Flarum\Frontend\Frontend->document()
#42 /home/account/domain/flarum/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Frontend\Controller->handle()
#43 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#44 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ExecuteRoute->process()
#45 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ContentTypeOptionsHeader.php(21): Laminas\Stratigility\Next->handle()
#46 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ContentTypeOptionsHeader->process()
#47 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ReferrerPolicyHeader.php(30): Laminas\Stratigility\Next->handle()
#48 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ReferrerPolicyHeader->process()
#49 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/FlarumPromotionHeader.php(30): Laminas\Stratigility\Next->handle()
#50 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\FlarumPromotionHeader->process()
#51 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ShareErrorsFromSession.php(57): Laminas\Stratigility\Next->handle()
#52 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ShareErrorsFromSession->process()
#53 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(36): Laminas\Stratigility\Next->handle()
#54 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\CheckCsrfToken->process()
#55 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(69): Laminas\Stratigility\Next->handle()
#56 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ResolveRoute->process()
#57 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#58 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\SetLocale->process()
#59 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle()
#60 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\AuthenticateWithSession->process()
#61 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle()
#62 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\RememberFromCookie->process()
#63 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#64 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\StartSession->process()
#65 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/CollectGarbage.php(46): Laminas\Stratigility\Next->handle()
#66 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\CollectGarbage->process()
#67 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle()
#68 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ParseJsonBody->process()
#69 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#70 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\HandleErrors->process()
#71 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle()
#72 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\InjectActorReference->process()
#73 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(77): Laminas\Stratigility\Next->handle()
#74 /home/account/domain/flarum/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process()
#75 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Middlewares\RequestHandler->process()
#76 /home/account/domain/flarum/vendor/middlewares/base-path-router/src/BasePathRouter.php(101): Laminas\Stratigility\Next->handle()
#77 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Middlewares\BasePathRouter->process()
#78 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(36): Laminas\Stratigility\Next->handle()
#79 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Laminas\Stratigility\Middleware\OriginalMessages->process()
#80 /home/account/domain/flarum/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle()
#81 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Middlewares\BasePath->process()
#82 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle()
#83 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ProcessIp->process()
#84 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(77): Laminas\Stratigility\Next->handle()
#85 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(66): Laminas\Stratigility\MiddlewarePipe->process()
#86 /home/account/domain/flarum/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(73): Laminas\Stratigility\MiddlewarePipe->handle()
#87 /home/account/domain/flarum/vendor/flarum/core/src/Http/Server.php(45): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#88 /home/account/domain/flarum/public/index.php(26): Flarum\Http\Server->listen()
#89 {main}
Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42000]: Syntax error or access violation: 1104 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay in /home/account/domain/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /home/account/domain/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(119): Doctrine\DBAL\Driver\PDO\Exception::new()
#1 /home/account/domain/flarum/vendor/illuminate/database/Connection.php(373): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /home/account/domain/flarum/vendor/illuminate/database/Connection.php(705): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /home/account/domain/flarum/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback()
#4 /home/account/domain/flarum/vendor/illuminate/database/Connection.php(376): Illuminate\Database\Connection->run()
#5 /home/account/domain/flarum/vendor/illuminate/database/Query/Builder.php(2414): Illuminate\Database\Connection->select()
#6 /home/account/domain/flarum/vendor/illuminate/database/Query/Builder.php(2402): Illuminate\Database\Query\Builder->runSelect()
#7 /home/account/domain/flarum/vendor/illuminate/database/Query/Builder.php(2936): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#8 /home/account/domain/flarum/vendor/illuminate/database/Query/Builder.php(2403): Illuminate\Database\Query\Builder->onceWithColumns()
#9 /home/account/domain/flarum/vendor/staudenmeir/eloquent-eager-limit/src/Builder.php(40): Illuminate\Database\Query\Builder->get()
#10 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Builder.php(625): Staudenmeir\EloquentEagerLimit\Builder->get()
#11 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Builder.php(609): Illuminate\Database\Eloquent\Builder->getModels()
#12 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Relations/Relation.php(195): Illuminate\Database\Eloquent\Builder->get()
#13 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Relations/Relation.php(160): Illuminate\Database\Eloquent\Relations\Relation->get()
#14 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Builder.php(673): Illuminate\Database\Eloquent\Relations\Relation->getEager()
#15 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Builder.php(642): Illuminate\Database\Eloquent\Builder->eagerLoadRelation()
#16 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Collection.php(60): Illuminate\Database\Eloquent\Builder->eagerLoadRelations()
#17 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Collection.php(231): Illuminate\Database\Eloquent\Collection->load()
#18 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Collection.php(206): Illuminate\Database\Eloquent\Collection->loadMissingRelation()
#19 /home/account/domain/flarum/vendor/flarum/core/src/Api/Controller/AbstractSerializeController.php(250): Illuminate\Database\Eloquent\Collection->loadMissing()
#20 /home/account/domain/flarum/vendor/flarum/core/src/Api/Controller/ListDiscussionsController.php(128): Flarum\Api\Controller\AbstractSerializeController->loadRelations()
#21 /home/account/domain/flarum/vendor/flarum/core/src/Api/Controller/AbstractSerializeController.php(116): Flarum\Api\Controller\ListDiscussionsController->data()
#22 /home/account/domain/flarum/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\AbstractSerializeController->handle()
#23 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#24 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ExecuteRoute->process()
#25 /home/account/domain/flarum/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#26 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Api\Middleware\ThrottleApi->process()
#27 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(69): Laminas\Stratigility\Next->handle()
#28 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ResolveRoute->process()
#29 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#30 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\SetLocale->process()
#31 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#32 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\HandleErrors->process()
#33 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(77): Laminas\Stratigility\Next->handle()
#34 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(66): Laminas\Stratigility\MiddlewarePipe->process()
#35 /home/account/domain/flarum/vendor/flarum/core/src/Api/Client.php(141): Laminas\Stratigility\MiddlewarePipe->handle()
#36 /home/account/domain/flarum/vendor/flarum/core/src/Api/Client.php(91): Flarum\Api\Client->send()
#37 /home/account/domain/flarum/vendor/flarum/core/src/Forum/Content/Index.php(108): Flarum\Api\Client->get()
#38 /home/account/domain/flarum/vendor/flarum/core/src/Forum/Content/Index.php(85): Flarum\Forum\Content\Index->getApiDocument()
#39 /home/account/domain/flarum/vendor/flarum/core/src/Frontend/Frontend.php(62): Flarum\Forum\Content\Index->__invoke()
#40 /home/account/domain/flarum/vendor/flarum/core/src/Frontend/Frontend.php(54): Flarum\Frontend\Frontend->populate()
#41 /home/account/domain/flarum/vendor/flarum/core/src/Frontend/Controller.php(32): Flarum\Frontend\Frontend->document()
#42 /home/account/domain/flarum/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Frontend\Controller->handle()
#43 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#44 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ExecuteRoute->process()
#45 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ContentTypeOptionsHeader.php(21): Laminas\Stratigility\Next->handle()
#46 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ContentTypeOptionsHeader->process()
#47 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ReferrerPolicyHeader.php(30): Laminas\Stratigility\Next->handle()
#48 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ReferrerPolicyHeader->process()
#49 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/FlarumPromotionHeader.php(30): Laminas\Stratigility\Next->handle()
#50 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\FlarumPromotionHeader->process()
#51 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ShareErrorsFromSession.php(57): Laminas\Stratigility\Next->handle()
#52 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ShareErrorsFromSession->process()
#53 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(36): Laminas\Stratigility\Next->handle()
#54 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\CheckCsrfToken->process()
#55 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(69): Laminas\Stratigility\Next->handle()
#56 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ResolveRoute->process()
#57 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#58 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\SetLocale->process()
#59 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle()
#60 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\AuthenticateWithSession->process()
#61 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle()
#62 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\RememberFromCookie->process()
#63 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#64 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\StartSession->process()
#65 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/CollectGarbage.php(46): Laminas\Stratigility\Next->handle()
#66 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\CollectGarbage->process()
#67 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle()
#68 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ParseJsonBody->process()
#69 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#70 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\HandleErrors->process()
#71 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle()
#72 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\InjectActorReference->process()
#73 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(77): Laminas\Stratigility\Next->handle()
#74 /home/account/domain/flarum/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process()
#75 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Middlewares\RequestHandler->process()
#76 /home/account/domain/flarum/vendor/middlewares/base-path-router/src/BasePathRouter.php(101): Laminas\Stratigility\Next->handle()
#77 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Middlewares\BasePathRouter->process()
#78 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(36): Laminas\Stratigility\Next->handle()
#79 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Laminas\Stratigility\Middleware\OriginalMessages->process()
#80 /home/account/domain/flarum/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle()
#81 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Middlewares\BasePath->process()
#82 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle()
#83 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ProcessIp->process()
#84 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(77): Laminas\Stratigility\Next->handle()
#85 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(66): Laminas\Stratigility\MiddlewarePipe->process()
#86 /home/account/domain/flarum/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(73): Laminas\Stratigility\MiddlewarePipe->handle()
#87 /home/account/domain/flarum/vendor/flarum/core/src/Http/Server.php(45): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#88 /home/account/domain/flarum/public/index.php(26): Flarum\Http\Server->listen()
#89 {main}
Next Illuminate\Database\QueryException: SQLSTATE[42000]: Syntax error or access violation: 1104 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay (SQL: select * from `posts` where `posts`.`id` in (12, 13, 14, 15, 16, 17, 18, 19, 21, 30, 33, 34, 35, 36, 37, 38, 41, 42, 44, 45) and `type` in (discussionTagged, recipientLeft, recipientsModified, madePublic, discussionStickied, discussionLocked, comment, discussionRenamed)) in /home/account/domain/flarum/vendor/illuminate/database/Connection.php:712
Stack trace:
#0 /home/account/domain/flarum/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback()
#1 /home/account/domain/flarum/vendor/illuminate/database/Connection.php(376): Illuminate\Database\Connection->run()
#2 /home/account/domain/flarum/vendor/illuminate/database/Query/Builder.php(2414): Illuminate\Database\Connection->select()
#3 /home/account/domain/flarum/vendor/illuminate/database/Query/Builder.php(2402): Illuminate\Database\Query\Builder->runSelect()
#4 /home/account/domain/flarum/vendor/illuminate/database/Query/Builder.php(2936): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#5 /home/account/domain/flarum/vendor/illuminate/database/Query/Builder.php(2403): Illuminate\Database\Query\Builder->onceWithColumns()
#6 /home/account/domain/flarum/vendor/staudenmeir/eloquent-eager-limit/src/Builder.php(40): Illuminate\Database\Query\Builder->get()
#7 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Builder.php(625): Staudenmeir\EloquentEagerLimit\Builder->get()
#8 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Builder.php(609): Illuminate\Database\Eloquent\Builder->getModels()
#9 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Relations/Relation.php(195): Illuminate\Database\Eloquent\Builder->get()
#10 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Relations/Relation.php(160): Illuminate\Database\Eloquent\Relations\Relation->get()
#11 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Builder.php(673): Illuminate\Database\Eloquent\Relations\Relation->getEager()
#12 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Builder.php(642): Illuminate\Database\Eloquent\Builder->eagerLoadRelation()
#13 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Collection.php(60): Illuminate\Database\Eloquent\Builder->eagerLoadRelations()
#14 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Collection.php(231): Illuminate\Database\Eloquent\Collection->load()
#15 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Collection.php(206): Illuminate\Database\Eloquent\Collection->loadMissingRelation()
#16 /home/account/domain/flarum/vendor/flarum/core/src/Api/Controller/AbstractSerializeController.php(250): Illuminate\Database\Eloquent\Collection->loadMissing()
#17 /home/account/domain/flarum/vendor/flarum/core/src/Api/Controller/ListDiscussionsController.php(128): Flarum\Api\Controller\AbstractSerializeController->loadRelations()
#18 /home/account/domain/flarum/vendor/flarum/core/src/Api/Controller/AbstractSerializeController.php(116): Flarum\Api\Controller\ListDiscussionsController->data()
#19 /home/account/domain/flarum/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\AbstractSerializeController->handle()
#20 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#21 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ExecuteRoute->process()
#22 /home/account/domain/flarum/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#23 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Api\Middleware\ThrottleApi->process()
#24 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(69): Laminas\Stratigility\Next->handle()
#25 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ResolveRoute->process()
#26 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#27 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\SetLocale->process()
#28 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#29 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\HandleErrors->process()
#30 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(77): Laminas\Stratigility\Next->handle()
#31 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(66): Laminas\Stratigility\MiddlewarePipe->process()
#32 /home/account/domain/flarum/vendor/flarum/core/src/Api/Client.php(141): Laminas\Stratigility\MiddlewarePipe->handle()
#33 /home/account/domain/flarum/vendor/flarum/core/src/Api/Client.php(91): Flarum\Api\Client->send()
#34 /home/account/domain/flarum/vendor/flarum/core/src/Forum/Content/Index.php(108): Flarum\Api\Client->get()
#35 /home/account/domain/flarum/vendor/flarum/core/src/Forum/Content/Index.php(85): Flarum\Forum\Content\Index->getApiDocument()
#36 /home/account/domain/flarum/vendor/flarum/core/src/Frontend/Frontend.php(62): Flarum\Forum\Content\Index->__invoke()
#37 /home/account/domain/flarum/vendor/flarum/core/src/Frontend/Frontend.php(54): Flarum\Frontend\Frontend->populate()
#38 /home/account/domain/flarum/vendor/flarum/core/src/Frontend/Controller.php(32): Flarum\Frontend\Frontend->document()
#39 /home/account/domain/flarum/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Frontend\Controller->handle()
#40 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#41 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ExecuteRoute->process()
#42 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ContentTypeOptionsHeader.php(21): Laminas\Stratigility\Next->handle()
#43 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ContentTypeOptionsHeader->process()
#44 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ReferrerPolicyHeader.php(30): Laminas\Stratigility\Next->handle()
#45 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ReferrerPolicyHeader->process()
#46 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/FlarumPromotionHeader.php(30): Laminas\Stratigility\Next->handle()
#47 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\FlarumPromotionHeader->process()
#48 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ShareErrorsFromSession.php(57): Laminas\Stratigility\Next->handle()
#49 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ShareErrorsFromSession->process()
#50 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(36): Laminas\Stratigility\Next->handle()
#51 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\CheckCsrfToken->process()
#52 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(69): Laminas\Stratigility\Next->handle()
#53 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ResolveRoute->process()
#54 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#55 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\SetLocale->process()
#56 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle()
#57 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\AuthenticateWithSession->process()
#58 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle()
#59 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\RememberFromCookie->process()
#60 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#61 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\StartSession->process()
#62 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/CollectGarbage.php(46): Laminas\Stratigility\Next->handle()
#63 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\CollectGarbage->process()
#64 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle()
#65 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ParseJsonBody->process()
#66 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#67 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\HandleErrors->process()
#68 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle()
#69 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\InjectActorReference->process()
#70 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(77): Laminas\Stratigility\Next->handle()
#71 /home/account/domain/flarum/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process()
#72 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Middlewares\RequestHandler->process()
#73 /home/account/domain/flarum/vendor/middlewares/base-path-router/src/BasePathRouter.php(101): Laminas\Stratigility\Next->handle()
#74 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Middlewares\BasePathRouter->process()
#75 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(36): Laminas\Stratigility\Next->handle()
#76 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Laminas\Stratigility\Middleware\OriginalMessages->process()
#77 /home/account/domain/flarum/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle()
#78 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Middlewares\BasePath->process()
#79 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle()
#80 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ProcessIp->process()
#81 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(77): Laminas\Stratigility\Next->handle()
#82 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(66): Laminas\Stratigility\MiddlewarePipe->process()
#83 /home/account/domain/flarum/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(73): Laminas\Stratigility\MiddlewarePipe->handle()
#84 /home/account/domain/flarum/vendor/flarum/core/src/Http/Server.php(45): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#85 /home/account/domain/flarum/public/index.php(26): Flarum\Http\Server->listen()
#86 {main}
***
when I turn on the debug mode, the logs are updated with this:
[2024-08-12 03:07:07] flarum.ERROR: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1104 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay in /home/account/domain/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117
Stack trace:
#0 /home/account/domain/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(117): PDOStatement->execute()
#1 /home/account/domain/flarum/vendor/illuminate/database/Connection.php(373): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /home/account/domain/flarum/vendor/illuminate/database/Connection.php(705): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /home/account/domain/flarum/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback()
#4 /home/account/domain/flarum/vendor/illuminate/database/Connection.php(376): Illuminate\Database\Connection->run()
#5 /home/account/domain/flarum/vendor/illuminate/database/Query/Builder.php(2414): Illuminate\Database\Connection->select()
#6 /home/account/domain/flarum/vendor/illuminate/database/Query/Builder.php(2402): Illuminate\Database\Query\Builder->runSelect()
#7 /home/account/domain/flarum/vendor/illuminate/database/Query/Builder.php(2936): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#8 /home/account/domain/flarum/vendor/illuminate/database/Query/Builder.php(2403): Illuminate\Database\Query\Builder->onceWithColumns()
#9 /home/account/domain/flarum/vendor/staudenmeir/eloquent-eager-limit/src/Builder.php(40): Illuminate\Database\Query\Builder->get()
#10 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Builder.php(625): Staudenmeir\EloquentEagerLimit\Builder->get()
#11 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Builder.php(609): Illuminate\Database\Eloquent\Builder->getModels()
#12 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Relations/Relation.php(195): Illuminate\Database\Eloquent\Builder->get()
#13 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Relations/Relation.php(160): Illuminate\Database\Eloquent\Relations\Relation->get()
#14 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Builder.php(673): Illuminate\Database\Eloquent\Relations\Relation->getEager()
#15 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Builder.php(642): Illuminate\Database\Eloquent\Builder->eagerLoadRelation()
#16 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Collection.php(60): Illuminate\Database\Eloquent\Builder->eagerLoadRelations()
#17 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Collection.php(231): Illuminate\Database\Eloquent\Collection->load()
#18 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Collection.php(206): Illuminate\Database\Eloquent\Collection->loadMissingRelation()
#19 /home/account/domain/flarum/vendor/flarum/core/src/Api/Controller/AbstractSerializeController.php(250): Illuminate\Database\Eloquent\Collection->loadMissing()
#20 /home/account/domain/flarum/vendor/flarum/core/src/Api/Controller/ListDiscussionsController.php(128): Flarum\Api\Controller\AbstractSerializeController->loadRelations()
#21 /home/account/domain/flarum/vendor/flarum/core/src/Api/Controller/AbstractSerializeController.php(116): Flarum\Api\Controller\ListDiscussionsController->data()
#22 /home/account/domain/flarum/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\AbstractSerializeController->handle()
#23 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#24 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ExecuteRoute->process()
#25 /home/account/domain/flarum/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#26 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Api\Middleware\ThrottleApi->process()
#27 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(69): Laminas\Stratigility\Next->handle()
#28 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ResolveRoute->process()
#29 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#30 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\SetLocale->process()
#31 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#32 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\HandleErrors->process()
#33 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(77): Laminas\Stratigility\Next->handle()
#34 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(66): Laminas\Stratigility\MiddlewarePipe->process()
#35 /home/account/domain/flarum/vendor/flarum/core/src/Api/Client.php(141): Laminas\Stratigility\MiddlewarePipe->handle()
#36 /home/account/domain/flarum/vendor/flarum/core/src/Api/Client.php(91): Flarum\Api\Client->send()
#37 /home/account/domain/flarum/vendor/flarum/core/src/Forum/Content/Index.php(108): Flarum\Api\Client->get()
#38 /home/account/domain/flarum/vendor/flarum/core/src/Forum/Content/Index.php(85): Flarum\Forum\Content\Index->getApiDocument()
#39 /home/account/domain/flarum/vendor/flarum/core/src/Frontend/Frontend.php(62): Flarum\Forum\Content\Index->__invoke()
#40 /home/account/domain/flarum/vendor/flarum/core/src/Frontend/Frontend.php(54): Flarum\Frontend\Frontend->populate()
#41 /home/account/domain/flarum/vendor/flarum/core/src/Frontend/Controller.php(32): Flarum\Frontend\Frontend->document()
#42 /home/account/domain/flarum/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Frontend\Controller->handle()
#43 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#44 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ExecuteRoute->process()
#45 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ContentTypeOptionsHeader.php(21): Laminas\Stratigility\Next->handle()
#46 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ContentTypeOptionsHeader->process()
#47 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ReferrerPolicyHeader.php(30): Laminas\Stratigility\Next->handle()
#48 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ReferrerPolicyHeader->process()
#49 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/FlarumPromotionHeader.php(30): Laminas\Stratigility\Next->handle()
#50 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\FlarumPromotionHeader->process()
#51 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ShareErrorsFromSession.php(57): Laminas\Stratigility\Next->handle()
#52 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ShareErrorsFromSession->process()
#53 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(36): Laminas\Stratigility\Next->handle()
#54 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\CheckCsrfToken->process()
#55 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(69): Laminas\Stratigility\Next->handle()
#56 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ResolveRoute->process()
#57 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#58 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\SetLocale->process()
#59 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle()
#60 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\AuthenticateWithSession->process()
#61 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle()
#62 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\RememberFromCookie->process()
#63 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#64 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\StartSession->process()
#65 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/CollectGarbage.php(46): Laminas\Stratigility\Next->handle()
#66 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\CollectGarbage->process()
#67 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle()
#68 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ParseJsonBody->process()
#69 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#70 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\HandleErrors->process()
#71 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle()
#72 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\InjectActorReference->process()
#73 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(77): Laminas\Stratigility\Next->handle()
#74 /home/account/domain/flarum/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process()
#75 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Middlewares\RequestHandler->process()
#76 /home/account/domain/flarum/vendor/middlewares/base-path-router/src/BasePathRouter.php(101): Laminas\Stratigility\Next->handle()
#77 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Middlewares\BasePathRouter->process()
#78 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(36): Laminas\Stratigility\Next->handle()
#79 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Laminas\Stratigility\Middleware\OriginalMessages->process()
#80 /home/account/domain/flarum/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle()
#81 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Middlewares\BasePath->process()
#82 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle()
#83 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ProcessIp->process()
#84 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(77): Laminas\Stratigility\Next->handle()
#85 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(66): Laminas\Stratigility\MiddlewarePipe->process()
#86 /home/account/domain/flarum/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(73): Laminas\Stratigility\MiddlewarePipe->handle()
#87 /home/account/domain/flarum/vendor/flarum/core/src/Http/Server.php(45): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#88 /home/account/domain/flarum/public/index.php(26): Flarum\Http\Server->listen()
#89 {main}
Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42000]: Syntax error or access violation: 1104 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay in /home/account/domain/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /home/account/domain/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(119): Doctrine\DBAL\Driver\PDO\Exception::new()
#1 /home/account/domain/flarum/vendor/illuminate/database/Connection.php(373): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /home/account/domain/flarum/vendor/illuminate/database/Connection.php(705): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /home/account/domain/flarum/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback()
#4 /home/account/domain/flarum/vendor/illuminate/database/Connection.php(376): Illuminate\Database\Connection->run()
#5 /home/account/domain/flarum/vendor/illuminate/database/Query/Builder.php(2414): Illuminate\Database\Connection->select()
#6 /home/account/domain/flarum/vendor/illuminate/database/Query/Builder.php(2402): Illuminate\Database\Query\Builder->runSelect()
#7 /home/account/domain/flarum/vendor/illuminate/database/Query/Builder.php(2936): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#8 /home/account/domain/flarum/vendor/illuminate/database/Query/Builder.php(2403): Illuminate\Database\Query\Builder->onceWithColumns()
#9 /home/account/domain/flarum/vendor/staudenmeir/eloquent-eager-limit/src/Builder.php(40): Illuminate\Database\Query\Builder->get()
#10 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Builder.php(625): Staudenmeir\EloquentEagerLimit\Builder->get()
#11 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Builder.php(609): Illuminate\Database\Eloquent\Builder->getModels()
#12 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Relations/Relation.php(195): Illuminate\Database\Eloquent\Builder->get()
#13 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Relations/Relation.php(160): Illuminate\Database\Eloquent\Relations\Relation->get()
#14 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Builder.php(673): Illuminate\Database\Eloquent\Relations\Relation->getEager()
#15 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Builder.php(642): Illuminate\Database\Eloquent\Builder->eagerLoadRelation()
#16 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Collection.php(60): Illuminate\Database\Eloquent\Builder->eagerLoadRelations()
#17 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Collection.php(231): Illuminate\Database\Eloquent\Collection->load()
#18 /home/account/domain/flarum/vendor/illuminate/database/Eloquent/Collection.php(206): Illuminate\Database\Eloquent\Collection->loadMissingRelation()
#19 /home/account/domain/flarum/vendor/flarum/core/src/Api/Controller/AbstractSerializeController.php(250): Illuminate\Database\Eloquent\Collection->loadMissing()
#20 /home/account/domain/flarum/vendor/flarum/core/src/Api/Controller/ListDiscussionsController.php(128): Flarum\Api\Controller\AbstractSerializeController->loadRelations()
#21 /home/account/domain/flarum/vendor/flarum/core/src/Api/Controller/AbstractSerializeController.php(116): Flarum\Api\Controller\ListDiscussionsController->data()
#22 /home/account/domain/flarum/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\AbstractSerializeController->handle()
#23 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#24 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ExecuteRoute->process()
#25 /home/account/domain/flarum/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#26 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Api\Middleware\ThrottleApi->process()
#27 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(69): Laminas\Stratigility\Next->handle()
#28 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ResolveRoute->process()
#29 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#30 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\SetLocale->process()
#31 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#32 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\HandleErrors->process()
#33 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(77): Laminas\Stratigility\Next->handle()
#34 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(66): Laminas\Stratigility\MiddlewarePipe->process()
#35 /home/account/domain/flarum/vendor/flarum/core/src/Api/Client.php(141): Laminas\Stratigility\MiddlewarePipe->handle()
#36 /home/account/domain/flarum/vendor/flarum/core/src/Api/Client.php(91): Flarum\Api\Client->send()
#37 /home/account/domain/flarum/vendor/flarum/core/src/Forum/Content/Index.php(108): Flarum\Api\Client->get()
#38 /home/account/domain/flarum/vendor/flarum/core/src/Forum/Content/Index.php(85): Flarum\Forum\Content\Index->getApiDocument()
#39 /home/account/domain/flarum/vendor/flarum/core/src/Frontend/Frontend.php(62): Flarum\Forum\Content\Index->__invoke()
#40 /home/account/domain/flarum/vendor/flarum/core/src/Frontend/Frontend.php(54): Flarum\Frontend\Frontend->populate()
#41 /home/account/domain/flarum/vendor/flarum/core/src/Frontend/Controller.php(32): Flarum\Frontend\Frontend->document()
#42 /home/account/domain/flarum/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Frontend\Controller->handle()
#43 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#44 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ExecuteRoute->process()
#45 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ContentTypeOptionsHeader.php(21): Laminas\Stratigility\Next->handle()
#46 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ContentTypeOptionsHeader->process()
#47 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ReferrerPolicyHeader.php(30): Laminas\Stratigility\Next->handle()
#48 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ReferrerPolicyHeader->process()
#49 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/FlarumPromotionHeader.php(30): Laminas\Stratigility\Next->handle()
#50 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\FlarumPromotionHeader->process()
#51 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ShareErrorsFromSession.php(57): Laminas\Stratigility\Next->handle()
#52 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ShareErrorsFromSession->process()
#53 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(36): Laminas\Stratigility\Next->handle()
#54 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\CheckCsrfToken->process()
#55 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(69): Laminas\Stratigility\Next->handle()
#56 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ResolveRoute->process()
#57 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#58 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\SetLocale->process()
#59 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle()
#60 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\AuthenticateWithSession->process()
#61 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle()
#62 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\RememberFromCookie->process()
#63 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#64 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\StartSession->process()
#65 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/CollectGarbage.php(46): Laminas\Stratigility\Next->handle()
#66 /home/account/domain/flarum/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\CollectGarbage->process()
#67 /home/account/domain/flarum/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28):
