FriendsOfFlarum upload, the intelligent file attachment extension

lucasushi

I have tried this before. Although it is still not working, I think it might be a right direction to solve this issue.

If I use file or any words other than files, say file1, hello, asdasd: I have 400 errors, like I mention previously, and there is no flarum error log.

If I use files: I have 500 error
x = requests.post(f'{BBS_URL}/api/fof/upload', files={'files': ('new_icon.png', open(f'data/new_icon.png', 'rb'), 'image/png')}, headers=LOGIN_CREDENTIALS)
b'{"errors":[{"status":"500","code":"unknown"}]}'
and I have the error log in flarum for this 500 error:
[2023-10-03 01:16:46] flarum.ERROR: TypeError: FoF\Upload\Commands\UploadHandler::FoF\Upload\Commands\{closure}(): Argument #1 ($file) must be of type Psr\Http\Message\Uploa dedFileInterface, int given in /home/lucasushi/bbs/vendor/fof/upload/src/Commands/UploadHandler.php:98

Alternatively, we can write like the following, but they will give the same results:

400 error: x = requests.post(f'{BBS_URL}/api/fof/upload', files=[('some words other than files': ('new_icon.png', open(f'data/new_icon.png', 'rb'), 'image/png'))], headers=LOGIN_CREDENTIALS)
500 error: x = requests.post(f'{BBS_URL}/api/fof/upload', files=[('files': ('new_icon.png', open(f'data/new_icon.png', 'rb'), 'image/png'))], headers=LOGIN_CREDENTIALS)

Any thoughts?

lucasushi

clarkwinkelmann

You are right! That's brilliant! Thanks very much!

x = requests.post(f'{BBS_URL}/api/fof/upload', files={'files[]': ('new_icon.png', open(f'data/new_icon.png', 'rb'), 'image/png')}, headers=LOGIN_CREDENTIALS)
returns 200

clarkwinkelmann

lucasushi nice to hear it works!

I was going to ask what the 500 error was, because while it's not a really ideal for improper params to return 500 errors in the extension, it was definitely a sign you were on the right path since you were guaranteed to see only a 400 error until the extension at least found something in the correct param.

IanM

1.3.5

feat: Add experimental support for GDPR exports by @IanM in FriendsOfFlarum/upload349

HarMan

how can i use aws-s3 or s3 compatioble object storage?

luceos

HarMan read this wiki page: https://github.com/FriendsOfFlarum/upload/wiki/aws-s3

clarkwinkelmann

Version 1.4.0

Allow TextEditor to be used in non-Composer contexts by @clarkwinkelmann in FriendsOfFlarum/upload327

This update enables compatibility with https://discuss.flarum.org/d/31564-composer-page (requires Composer Page version 1.1+)

MikeLundahl

Hi there. Is it possible to have different limits for different user groups?

wolfman

@FriendsOfFlarum @SychO Version 1.4.5 has a bug. Call to a member function getKey() on null. The error is in Line 34 of the new file src/Extenders/LoadFilesRelationship.php. Version 1.4.4 war working for me.

[2023-11-12 15:44:13] flarum.ERROR: Error: Call to a member function getKey() on null in /var/www/example.com/flarum/vendor/illuminate/database/Eloquent/Collection.php:321
Stack trace:
#0 [internal function]: Illuminate\Database\Eloquent\Collection->Illuminate\Database\Eloquent\{closure}()
#1 /var/www/example.com/flarum/vendor/illuminate/database/Eloquent/Collection.php(322): array_map()
#2 /var/www/example.com/flarum/vendor/illuminate/database/Eloquent/Collection.php(81): Illuminate\Database\Eloquent\Collection->modelKeys()
#3 /var/www/example.com/flarum/vendor/flarum/core/src/Database/Eloquent/Collection.php(47): Illuminate\Database\Eloquent\Collection->loadAggregate()
#4 /var/www/example.com/flarum/vendor/flarum/core/src/Database/AbstractModel.php(252): Flarum\Database\Eloquent\Collection->Flarum\Database\Eloquent\{closure}()
#5 /var/www/example.com/flarum/vendor/flarum/core/src/Database/Eloquent/Collection.php(48): Flarum\Database\AbstractModel->withTableAlias()
#6 /var/www/example.com/flarum/vendor/illuminate/database/Eloquent/Collection.php(111): Flarum\Database\Eloquent\Collection->loadAggregate()
#7 /var/www/example.com/flarum/vendor/fof/upload/src/Extenders/LoadFilesRelationship.php(34): Illuminate\Database\Eloquent\Collection->loadCount()
#8 /var/www/example.com/flarum/vendor/flarum/core/src/Api/Controller/AbstractSerializeController.php(121): FoF\Upload\Extenders\LoadFilesRelationship::countRelations()
#9 /var/www/example.com/flarum/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\AbstractSerializeController->handle()
#10 /var/www/example.com/flarum/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#11 /var/www/example.com/flarum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ExecuteRoute->process()
#12 /var/www/example.com/flarum/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#13 /var/www/example.com/flarum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Api\Middleware\ThrottleApi->process()
#14 /var/www/example.com/flarum/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(69): Laminas\Stratigility\Next->handle()
#15 /var/www/example.com/flarum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ResolveRoute->process()
#16 /var/www/example.com/flarum/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#17 /var/www/example.com/flarum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\SetLocale->process()
#18 /var/www/example.com/flarum/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#19 /var/www/example.com/flarum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\HandleErrors->process()
#20 /var/www/example.com/flarum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#21 /var/www/example.com/flarum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(64): Laminas\Stratigility\MiddlewarePipe->process()
#22 /var/www/example.com/flarum/vendor/flarum/core/src/Api/Client.php(141): Laminas\Stratigility\MiddlewarePipe->handle()
#23 /var/www/example.com/flarum/vendor/flarum/core/src/Api/Client.php(91): Flarum\Api\Client->send()
#24 /var/www/example.com/flarum/vendor/flarum/core/src/Forum/Content/Index.php(108): Flarum\Api\Client->get()
#25 /var/www/example.com/flarum/vendor/flarum/core/src/Forum/Content/Index.php(85): Flarum\Forum\Content\Index->getApiDocument()
#26 /var/www/example.com/flarum/vendor/flarum/core/src/Frontend/Frontend.php(62): Flarum\Forum\Content\Index->__invoke()
#27 /var/www/example.com/flarum/vendor/flarum/core/src/Frontend/Frontend.php(54): Flarum\Frontend\Frontend->populate()
#28 /var/www/example.com/flarum/vendor/flarum/core/src/Frontend/Controller.php(32): Flarum\Frontend\Frontend->document()
#29 /var/www/example.com/flarum/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Frontend\Controller->handle()
#30 /var/www/example.com/flarum/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#31 /var/www/example.com/flarum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ExecuteRoute->process()
#32 /var/www/example.com/flarum/vendor/fof/terms/src/Middlewares/RegisterMiddleware.php(59): Laminas\Stratigility\Next->handle()
#33 /var/www/example.com/flarum/vendor/laminas/laminas-stratigility/src/Next.php(49): FoF\Terms\Middlewares\RegisterMiddleware->process()
#34 /var/www/example.com/flarum/vendor/flarum/core/src/Http/Middleware/ContentTypeOptionsHeader.php(21): Laminas\Stratigility\Next->handle()
#35 /var/www/example.com/flarum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ContentTypeOptionsHeader->process()
#36 /var/www/example.com/flarum/vendor/flarum/core/src/Http/Middleware/ReferrerPolicyHeader.php(30): Laminas\Stratigility\Next->handle()
#37 /var/www/example.com/flarum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ReferrerPolicyHeader->process()
#38 /var/www/example.com/flarum/vendor/flarum/core/src/Http/Middleware/FlarumPromotionHeader.php(30): Laminas\Stratigility\Next->handle()
#39 /var/www/example.com/flarum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\FlarumPromotionHeader->process()
#40 /var/www/example.com/flarum/vendor/flarum/core/src/Http/Middleware/ShareErrorsFromSession.php(57): Laminas\Stratigility\Next->handle()
#41 /var/www/example.com/flarum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ShareErrorsFromSession->process()
#42 /var/www/example.com/flarum/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(36): Laminas\Stratigility\Next->handle()
#43 /var/www/example.com/flarum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\CheckCsrfToken->process()
#44 /var/www/example.com/flarum/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(69): Laminas\Stratigility\Next->handle()
#45 /var/www/example.com/flarum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ResolveRoute->process()
#46 /var/www/example.com/flarum/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#47 /var/www/example.com/flarum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\SetLocale->process()
#48 /var/www/example.com/flarum/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle()
#49 /var/www/example.com/flarum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\AuthenticateWithSession->process()
#50 /var/www/example.com/flarum/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle()
#51 /var/www/example.com/flarum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\RememberFromCookie->process()
#52 /var/www/example.com/flarum/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#53 /var/www/example.com/flarum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\StartSession->process()
#54 /var/www/example.com/flarum/vendor/flarum/core/src/Http/Middleware/CollectGarbage.php(46): Laminas\Stratigility\Next->handle()
#55 /var/www/example.com/flarum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\CollectGarbage->process()
#56 /var/www/example.com/flarum/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle()
#57 /var/www/example.com/flarum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ParseJsonBody->process()
#58 /var/www/example.com/flarum/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#59 /var/www/example.com/flarum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\HandleErrors->process()
#60 /var/www/example.com/flarum/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle()
#61 /var/www/example.com/flarum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\InjectActorReference->process()
#62 /var/www/example.com/flarum/vendor/fof/merge-discussions/src/Middleware/Redirection.php(28): Laminas\Stratigility\Next->handle()
#63 /var/www/example.com/flarum/vendor/laminas/laminas-stratigility/src/Next.php(49): FoF\MergeDiscussions\Middleware\Redirection->process()
#64 /var/www/example.com/flarum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#65 /var/www/example.com/flarum/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process()
#66 /var/www/example.com/flarum/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\RequestHandler->process()
#67 /var/www/example.com/flarum/vendor/middlewares/base-path-router/src/BasePathRouter.php(101): Laminas\Stratigility\Next->handle()
#68 /var/www/example.com/flarum/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\BasePathRouter->process()
#69 /var/www/example.com/flarum/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(36): Laminas\Stratigility\Next->handle()
#70 /var/www/example.com/flarum/vendor/laminas/laminas-stratigility/src/Next.php(49): Laminas\Stratigility\Middleware\OriginalMessages->process()
#71 /var/www/example.com/flarum/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle()
#72 /var/www/example.com/flarum/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\BasePath->process()
#73 /var/www/example.com/flarum/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle()
#74 /var/www/example.com/flarum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ProcessIp->process()
#75 /var/www/example.com/flarum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#76 /var/www/example.com/flarum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(64): Laminas\Stratigility\MiddlewarePipe->process()
#77 /var/www/example.com/flarum/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(73): Laminas\Stratigility\MiddlewarePipe->handle()
#78 /var/www/example.com/flarum/vendor/flarum/core/src/Http/Server.php(45): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#79 /var/www/example.com/flarum/public/index.php(26): Flarum\Http\Server->listen()

Flarum Info:

Flarum core: 1.8.3
PHP version: 8.1.2-1ubuntu2.14
MySQL version: 8.0.35-0ubuntu0.22.04.1
Loaded extensions: Core, date, libxml, openssl, pcre, zlib, filter, hash, json, pcntl, Reflection, SPL, session, standard, sodium, mysqlnd, PDO, xml,                                   bz2, calendar, ctype, curl, dom, mbstring, FFI, fileinfo, ftp, gd, gettext, iconv, imagick, intl, exif, mysqli, pdo_mysql, Phar, posix, readline, shmo                                  p, SimpleXML, sockets, sysvmsg, sysvsem, sysvshm, tokenizer, xmlreader, xmlwriter, xsl, zip, Zend OPcache
+--------------------------------------+------------+------------------------------------------+
| Flarum Extensions                    |            |                                          |
+--------------------------------------+------------+------------------------------------------+
| ID                                   | Version    | Commit                                   |
+--------------------------------------+------------+------------------------------------------+
| flarum-flags                         | v1.8.0     |                                          |
| flarum-bbcode                        | v1.8.0     |                                          |
| flarum-suspend                       | v1.8.1     |                                          |
| flarum-approval                      | v1.8.0     |                                          |
| flarum-tags                          | v1.8.0     |                                          |
| fof-formatting                       | 1.0.3      |                                          |
| wolfgang-demeter-bbcode-5star-rating | dev-main   | 57722d46957880ba45cce5a1e628ef51bb9237ab |
| wolfgang-demeter-amazon-product-api  | dev-main   | 103a697272450f99fe2fb223aaec2c668e72730b |
| fof-user-bio                         | 1.3.0      |                                          |
| fof-upload                           | 1.4.5      |                                          |
| fof-terms                            | 1.3.0      |                                          |
| fof-split                            | 1.1.1      |                                          |
| fof-socialprofile                    | 1.1.6      |                                          |
| fof-recaptcha                        | 1.3.0      |                                          |
| fof-pages                            | 1.0.8      |                                          |
| fof-merge-discussions                | 1.4.1      |                                          |
| fof-links                            | 1.2.0      |                                          |
| fof-byobu                            | 1.3.4      |                                          |
| fof-amazon-affiliation               | 1.1.0      |                                          |
| flarum-subscriptions                 | v1.8.0     |                                          |
| flarum-sticky                        | v1.8.0     |                                          |
| flarum-statistics                    | v1.8.0     |                                          |
| flarum-nicknames                     | v1.8.0     |                                          |
| flarum-mentions                      | v1.8.2     |                                          |
| flarum-markdown                      | v1.8.0     |                                          |
| flarum-lock                          | v1.8.0     |                                          |
| flarum-likes                         | v1.8.0     |                                          |
| flarum-lang-german                   | dev-master |                                          |
| flarum-lang-english                  | v1.8.0     |                                          |
| datlechin-birthdays                  | v2.0.1     |                                          |
| askvortsov-auto-moderator            | v0.1.3     |                                          |
| antoinefr-bbcode-fa                  | v1.0.0     |                                          |
+--------------------------------------+------------+------------------------------------------+
Base URL: https://dev.example.com
Installation path: /var/www/example.com/flarum
Queue driver: sync
Session driver: file
Mail driver: smtp
Debug mode: ON

SychO

wolfman do you know when the error happens?

wolfman

SychO Yes. While loading the index-Page / of Flarum which is configured to show all discussions.

It seems to work howerver while loading specific discussions (/d/...), tags (/t/...) or user (/u/...) pages. While navigating to all discussions (/) from one of these pages a red error box with "something went wrong" appears and it shows the same 500-error.

SychO

wolfman can you please try with 1.4.6?

wolfman

SychO can you please try with 1.4.6?

Yepp, thad does the trick! works for me with 1.4.6. Thanks for the quick fix! 😀

wolfman

SychO Maybe i spoke to soon! Just updated my PROD-Forum and it is dead slow now!
Flarum encountered a boot error. Details have been logged to the Flarum log file.

Contents of the Log File:

Next Illuminate\Database\QueryException: SQLSTATE[HY000] [2002] No such file or directory (SQL: (select `discussions`.* from `discussions` where (`discussions`.`id` not in (select `discussion_id` from `discussion_tag` where `tag_id` not in (select `tags`.`id` from `tags` where (`tags`.`id` in (select `perm_tags`.`id` from `tags` as `perm_tags` where (`perm_tags`.`is_restricted` = 1 and `perm_tags`.`id` in (30)) or `perm_tags`.`is_restricted` = 0) and (`tags`.`parent_id` in (select `perm_tags`.`id` from `tags` as `perm_tags` where (`perm_tags`.`is_restricted` = 1 and `perm_tags`.`id` in (30)) or `perm_tags`.`is_restricted` = 0) or `tags`.`parent_id` is null))))) and (`discussions`.`is_private` = 0 or (((`discussions`.`is_approved` = 0 and (`discussions`.`user_id` = 0 or ((`discussions`.`id` not in (select `discussion_id` from `discussion_tag` where `tag_id` not in (select `tags`.`id` from `tags` where (`tags`.`id` in (select `perm_tags`.`id` from `tags` as `perm_tags` where (`perm_tags`.`is_restricted` = 1 and 0 = 1)) and (`tags`.`parent_id` in (select `perm_tags`.`id` from `tags` as `perm_tags` where (`perm_tags`.`is_restricted` = 1 and 0 = 1)) or `tags`.`parent_id` is null))))) and exists (select * from `tags` inner join `discussion_tag` on `tags`.`id` = `discussion_tag`.`tag_id` where `discussions`.`id` = `discussion_tag`.`discussion_id`))))))) and (`discussions`.`hidden_at` is null or `discussions`.`user_id` = 0 or ((`discussions`.`id` not in (select `discussion_id` from `discussion_tag` where `tag_id` not in (select `tags`.`id` from `tags` where (`tags`.`id` in (select `perm_tags`.`id` from `tags` as `perm_tags` where (`perm_tags`.`is_restricted` = 1 and 0 = 1)) and (`tags`.`parent_id` in (select `perm_tags`.`id` from `tags` as `perm_tags` where (`perm_tags`.`is_restricted` = 1 and 0 = 1)) or `tags`.`parent_id` is null))))) and exists (select * from `tags` inner join `discussion_tag` on `tags`.`id` = `discussion_tag`.`tag_id` where `discussions`.`id` = `discussion_tag`.`discussion_id`))) and (`discussions`.`comment_count` > 0 or `discussions`.`user_id` = 0 or ((`discussions`.`id` not in (select `discussion_id` from `discussion_tag` where `tag_id` not in (select `tags`.`id` from `tags` where (`tags`.`id` in (select `perm_tags`.`id` from `tags` as `perm_tags` where (`perm_tags`.`is_restricted` = 1 and 0 = 1)) and (`tags`.`parent_id` in (select `perm_tags`.`id` from `tags` as `perm_tags` where (`perm_tags`.`is_restricted` = 1 and 0 = 1)) or `tags`.`parent_id` is null))))) and exists (select * from `tags` inner join `discussion_tag` on `tags`.`id` = `discussion_tag`.`tag_id` where `discussions`.`id` = `discussion_tag`.`discussion_id`))) and `discussions`.`id` not in (select `discussion_id` from `discussion_tag` where 0 = 1) and not exists (select 1 from `discussion_user` where `discussions`.`id` = `discussion_id` and `user_id` = 0 and `subscription` = ignore) order by `last_posted_at` desc limit 21) union (select `discussions`.* from `discussions` where (`discussions`.`id` not in (select `discussion_id` from `discussion_tag` where `tag_id` not in (select `tags`.`id` from `tags` where (`tags`.`id` in (select `perm_tags`.`id` from `tags` as `perm_tags` where (`perm_tags`.`is_restricted` = 1 and `perm_tags`.`id` in (30)) or `perm_tags`.`is_restricted` = 0) and (`tags`.`parent_id` in (select `perm_tags`.`id` from `tags` as `perm_tags` where (`perm_tags`.`is_restricted` = 1 and `perm_tags`.`id` in (30)) or `perm_tags`.`is_restricted` = 0) or `tags`.`parent_id` is null))))) and (`discussions`.`is_private` = 0 or (((`discussions`.`is_approved` = 0 and (`discussions`.`user_id` = 0 or ((`discussions`.`id` not in (select `discussion_id` from `discussion_tag` where `tag_id` not in (select `tags`.`id` from `tags` where (`tags`.`id` in (select `perm_tags`.`id` from `tags` as `perm_tags` where (`perm_tags`.`is_restricted` = 1 and 0 = 1)) and (`tags`.`parent_id` in (select `perm_tags`.`id` from `tags` as `perm_tags` where (`perm_tags`.`is_restricted` = 1 and 0 = 1)) or `tags`.`parent_id` is null))))) and exists (select * from `tags` inner join `discussion_tag` on `tags`.`id` = `discussion_tag`.`tag_id` where `discussions`.`id` = `discussion_tag`.`discussion_id`))))))) and (`discussions`.`hidden_at` is null or `discussions`.`user_id` = 0 or ((`discussions`.`id` not in (select `discussion_id` from `discussion_tag` where `tag_id` not in (select `tags`.`id` from `tags` where (`tags`.`id` in (select `perm_tags`.`id` from `tags` as `perm_tags` where (`perm_tags`.`is_restricted` = 1 and 0 = 1)) and (`tags`.`parent_id` in (select `perm_tags`.`id` from `tags` as `perm_tags` where (`perm_tags`.`is_restricted` = 1 and 0 = 1)) or `tags`.`parent_id` is null))))) and exists (select * from `tags` inner join `discussion_tag` on `tags`.`id` = `discussion_tag`.`tag_id` where `discussions`.`id` = `discussion_tag`.`discussion_id`))) and (`discussions`.`comment_count` > 0 or `discussions`.`user_id` = 0 or ((`discussions`.`id` not in (select `discussion_id` from `discussion_tag` where `tag_id` not in (select `tags`.`id` from `tags` where (`tags`.`id` in (select `perm_tags`.`id` from `tags` as `perm_tags` where (`perm_tags`.`is_restricted` = 1 and 0 = 1)) and (`tags`.`parent_id` in (select `perm_tags`.`id` from `tags` as `perm_tags` where (`perm_tags`.`is_restricted` = 1 and 0 = 1)) or `tags`.`parent_id` is null))))) and exists (select * from `tags` inner join `discussion_tag` on `tags`.`id` = `discussion_tag`.`tag_id` where `discussions`.`id` = `discussion_tag`.`discussion_id`))) and `discussions`.`id` not in (select `discussion_id` from `discussion_tag` where 0 = 1) and not exists (select 1 from `discussion_user` where `discussions`.`id` = `discussion_id` and `user_id` = 0 and `subscription` = ignore) and `is_sticky` = 1 limit 21) order by is_sticky and not exists (select 1 from `discussion_user` as `sticky` where `sticky`.`discussion_id` = `id` and `sticky`.`user_id` = 0 and `sticky`.`last_read_post_number` >= `last_post_number`) and last_posted_at > 0 desc, `last_posted_at` desc limit 21) in /var/www/example.com/forum/vendor/illuminate/database/Connection.php:712
Stack trace:
#0 /var/www/example.com/forum/vendor/illuminate/database/Connection.php(784): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/example.com/forum/vendor/illuminate/database/Connection.php(764): Illuminate\Database\Connection->tryAgainIfCausedByLostConnection()
#2 /var/www/example.com/forum/vendor/illuminate/database/Connection.php(675): Illuminate\Database\Connection->handleQueryException()
#3 /var/www/example.com/forum/vendor/illuminate/database/Connection.php(376): Illuminate\Database\Connection->run()
#4 /var/www/example.com/forum/vendor/illuminate/database/Query/Builder.php(2414): Illuminate\Database\Connection->select()
#5 /var/www/example.com/forum/vendor/illuminate/database/Query/Builder.php(2402): Illuminate\Database\Query\Builder->runSelect()
#6 /var/www/example.com/forum/vendor/illuminate/database/Query/Builder.php(2936): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#7 /var/www/example.com/forum/vendor/illuminate/database/Query/Builder.php(2403): Illuminate\Database\Query\Builder->onceWithColumns()
#8 /var/www/example.com/forum/vendor/illuminate/database/Eloquent/Builder.php(625): Illuminate\Database\Query\Builder->get()
#9 /var/www/example.com/forum/vendor/illuminate/database/Eloquent/Builder.php(609): Illuminate\Database\Eloquent\Builder->getModels()
#10 /var/www/example.com/forum/vendor/flarum/core/src/Filter/AbstractFilterer.php(79): Illuminate\Database\Eloquent\Builder->get()
#11 /var/www/example.com/forum/vendor/flarum/core/src/Api/Controller/ListDiscussionsController.php(102): Flarum\Filter\AbstractFilterer->filter()
#12 /var/www/example.com/forum/vendor/flarum/core/src/Api/Controller/AbstractSerializeController.php(116): Flarum\Api\Controller\ListDiscussionsController->data()
#13 /var/www/example.com/forum/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\AbstractSerializeController->handle()
#14 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#15 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ExecuteRoute->process()
#16 /var/www/example.com/forum/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#17 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Api\Middleware\ThrottleApi->process()
#18 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(69): Laminas\Stratigility\Next->handle()
#19 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ResolveRoute->process()
#20 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#21 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\SetLocale->process()
#22 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#23 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\HandleErrors->process()
#24 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#25 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(64): Laminas\Stratigility\MiddlewarePipe->process()
#26 /var/www/example.com/forum/vendor/flarum/core/src/Api/Client.php(141): Laminas\Stratigility\MiddlewarePipe->handle()
#27 /var/www/example.com/forum/vendor/flarum/core/src/Api/Client.php(91): Flarum\Api\Client->send()
#28 /var/www/example.com/forum/vendor/flarum/core/src/Forum/Content/Index.php(108): Flarum\Api\Client->get()
#29 /var/www/example.com/forum/vendor/flarum/core/src/Forum/Content/Index.php(85): Flarum\Forum\Content\Index->getApiDocument()
#30 /var/www/example.com/forum/vendor/flarum/core/src/Frontend/Frontend.php(62): Flarum\Forum\Content\Index->__invoke()
#31 /var/www/example.com/forum/vendor/flarum/core/src/Frontend/Frontend.php(54): Flarum\Frontend\Frontend->populate()
#32 /var/www/example.com/forum/vendor/flarum/core/src/Frontend/Controller.php(32): Flarum\Frontend\Frontend->document()
#33 /var/www/example.com/forum/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Frontend\Controller->handle()
#34 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#35 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ExecuteRoute->process()
#36 /var/www/example.com/forum/vendor/fof/terms/src/Middlewares/RegisterMiddleware.php(59): Laminas\Stratigility\Next->handle()
#37 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): FoF\Terms\Middlewares\RegisterMiddleware->process()
#38 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/ContentTypeOptionsHeader.php(21): Laminas\Stratigility\Next->handle()
#39 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ContentTypeOptionsHeader->process()
#40 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/ReferrerPolicyHeader.php(30): Laminas\Stratigility\Next->handle()
#41 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ReferrerPolicyHeader->process()
#42 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/FlarumPromotionHeader.php(30): Laminas\Stratigility\Next->handle()
#43 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\FlarumPromotionHeader->process()
#44 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/ShareErrorsFromSession.php(57): Laminas\Stratigility\Next->handle()
#45 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ShareErrorsFromSession->process()
#46 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(36): Laminas\Stratigility\Next->handle()
#47 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\CheckCsrfToken->process()
#48 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(69): Laminas\Stratigility\Next->handle()
#49 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ResolveRoute->process()
#50 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#51 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\SetLocale->process()
#52 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle()
#53 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\AuthenticateWithSession->process()
#54 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle()
#55 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\RememberFromCookie->process()
#56 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#57 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\StartSession->process()
#58 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/CollectGarbage.php(46): Laminas\Stratigility\Next->handle()
#59 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\CollectGarbage->process()
#60 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle()
#61 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ParseJsonBody->process()
#62 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#63 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\HandleErrors->process()
#64 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle()
#65 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\InjectActorReference->process()
#66 /var/www/example.com/forum/vendor/fof/merge-discussions/src/Middleware/Redirection.php(28): Laminas\Stratigility\Next->handle()
#67 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): FoF\MergeDiscussions\Middleware\Redirection->process()
#68 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#69 /var/www/example.com/forum/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process()
#70 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\RequestHandler->process()
#71 /var/www/example.com/forum/vendor/middlewares/base-path-router/src/BasePathRouter.php(101): Laminas\Stratigility\Next->handle()
#72 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\BasePathRouter->process()
#73 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(36): Laminas\Stratigility\Next->handle()
#74 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Laminas\Stratigility\Middleware\OriginalMessages->process()
#75 /var/www/example.com/forum/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle()
#76 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\BasePath->process()
#77 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle()
#78 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ProcessIp->process()
#79 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#80 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(64): Laminas\Stratigility\MiddlewarePipe->process()
#81 /var/www/example.com/forum/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(73): Laminas\Stratigility\MiddlewarePipe->handle()
#82 /var/www/example.com/forum/vendor/flarum/core/src/Http/Server.php(45): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#83 /var/www/example.com/forum/public/index.php(26): Flarum\Http\Server->listen()
#84 {main}
[2023-11-12 16:55:54] flarum.ERROR: PDOException: SQLSTATE[HY000] [2002] No such file or directory in /var/www/example.com/forum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:40
Stack trace:
#0 /var/www/example.com/forum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(40): PDO->__construct()
#1 /var/www/example.com/forum/vendor/illuminate/database/Connectors/Connector.php(67): Doctrine\DBAL\Driver\PDOConnection->__construct()
#2 /var/www/example.com/forum/vendor/illuminate/database/Connectors/Connector.php(46): Illuminate\Database\Connectors\Connector->createPdoConnection()
#3 /var/www/example.com/forum/vendor/illuminate/database/Connectors/MySqlConnector.php(24): Illuminate\Database\Connectors\Connector->createConnection()
#4 /var/www/example.com/forum/vendor/illuminate/database/Connectors/ConnectionFactory.php(184): Illuminate\Database\Connectors\MySqlConnector->connect()
#5 [internal function]: Illuminate\Database\Connectors\ConnectionFactory->Illuminate\Database\Connectors\{closure}()
#6 /var/www/example.com/forum/vendor/illuminate/database/Connection.php(1064): call_user_func()
#7 /var/www/example.com/forum/vendor/illuminate/database/Connection.php(1100): Illuminate\Database\Connection->getPdo()
#8 /var/www/example.com/forum/vendor/illuminate/database/Connection.php(442): Illuminate\Database\Connection->getReadPdo()
#9 /var/www/example.com/forum/vendor/illuminate/database/Connection.php(368): Illuminate\Database\Connection->getPdoForSelect()
#10 /var/www/example.com/forum/vendor/illuminate/database/Connection.php(705): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#11 /var/www/example.com/forum/vendor/illuminate/database/Connection.php(784): Illuminate\Database\Connection->runQueryCallback()
#12 /var/www/example.com/forum/vendor/illuminate/database/Connection.php(764): Illuminate\Database\Connection->tryAgainIfCausedByLostConnection()
#13 /var/www/example.com/forum/vendor/illuminate/database/Connection.php(675): Illuminate\Database\Connection->handleQueryException()
#14 /var/www/example.com/forum/vendor/illuminate/database/Connection.php(376): Illuminate\Database\Connection->run()
#15 /var/www/example.com/forum/vendor/illuminate/database/Query/Builder.php(2414): Illuminate\Database\Connection->select()
#16 /var/www/example.com/forum/vendor/illuminate/database/Query/Builder.php(2402): Illuminate\Database\Query\Builder->runSelect()
#17 /var/www/example.com/forum/vendor/illuminate/database/Query/Builder.php(2936): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#18 /var/www/example.com/forum/vendor/illuminate/database/Query/Builder.php(2403): Illuminate\Database\Query\Builder->onceWithColumns()
#19 /var/www/example.com/forum/vendor/illuminate/database/Eloquent/Builder.php(625): Illuminate\Database\Query\Builder->get()
#20 /var/www/example.com/forum/vendor/illuminate/database/Eloquent/Builder.php(609): Illuminate\Database\Eloquent\Builder->getModels()
#21 /var/www/example.com/forum/vendor/flarum/core/src/Filter/AbstractFilterer.php(79): Illuminate\Database\Eloquent\Builder->get()
#22 /var/www/example.com/forum/vendor/flarum/core/src/Api/Controller/ListDiscussionsController.php(102): Flarum\Filter\AbstractFilterer->filter()
#23 /var/www/example.com/forum/vendor/flarum/core/src/Api/Controller/AbstractSerializeController.php(116): Flarum\Api\Controller\ListDiscussionsController->data()
#24 /var/www/example.com/forum/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\AbstractSerializeController->handle()
#25 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#26 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ExecuteRoute->process()
#27 /var/www/example.com/forum/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#28 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Api\Middleware\ThrottleApi->process()
#29 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(69): Laminas\Stratigility\Next->handle()
#30 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ResolveRoute->process()
#31 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#32 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\SetLocale->process()
#33 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#34 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\HandleErrors->process()
#35 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#36 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(64): Laminas\Stratigility\MiddlewarePipe->process()
#37 /var/www/example.com/forum/vendor/flarum/core/src/Api/Client.php(141): Laminas\Stratigility\MiddlewarePipe->handle()
#38 /var/www/example.com/forum/vendor/flarum/core/src/Api/Client.php(91): Flarum\Api\Client->send()
#39 /var/www/example.com/forum/vendor/flarum/core/src/Forum/Content/Index.php(108): Flarum\Api\Client->get()
#40 /var/www/example.com/forum/vendor/flarum/core/src/Forum/Content/Index.php(85): Flarum\Forum\Content\Index->getApiDocument()
#41 /var/www/example.com/forum/vendor/flarum/core/src/Frontend/Frontend.php(62): Flarum\Forum\Content\Index->__invoke()
#42 /var/www/example.com/forum/vendor/flarum/core/src/Frontend/Frontend.php(54): Flarum\Frontend\Frontend->populate()
#43 /var/www/example.com/forum/vendor/flarum/core/src/Frontend/Controller.php(32): Flarum\Frontend\Frontend->document()
#44 /var/www/example.com/forum/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Frontend\Controller->handle()
#45 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#46 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ExecuteRoute->process()
#47 /var/www/example.com/forum/vendor/fof/terms/src/Middlewares/RegisterMiddleware.php(59): Laminas\Stratigility\Next->handle()
#48 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): FoF\Terms\Middlewares\RegisterMiddleware->process()
#49 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/ContentTypeOptionsHeader.php(21): Laminas\Stratigility\Next->handle()
#50 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ContentTypeOptionsHeader->process()
#51 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/ReferrerPolicyHeader.php(30): Laminas\Stratigility\Next->handle()
#52 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ReferrerPolicyHeader->process()
#53 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/FlarumPromotionHeader.php(30): Laminas\Stratigility\Next->handle()
#54 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\FlarumPromotionHeader->process()
#55 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/ShareErrorsFromSession.php(57): Laminas\Stratigility\Next->handle()
#56 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ShareErrorsFromSession->process()
#57 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(36): Laminas\Stratigility\Next->handle()
#58 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\CheckCsrfToken->process()
#59 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(69): Laminas\Stratigility\Next->handle()
#60 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ResolveRoute->process()
#61 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#62 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\SetLocale->process()
#63 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle()
#64 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\AuthenticateWithSession->process()
#65 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle()
#66 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\RememberFromCookie->process()
#67 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#68 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\StartSession->process()
#69 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/CollectGarbage.php(46): Laminas\Stratigility\Next->handle()
#70 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\CollectGarbage->process()
#71 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle()
#72 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ParseJsonBody->process()
#73 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#74 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\HandleErrors->process()
#75 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle()
#76 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\InjectActorReference->process()
#77 /var/www/example.com/forum/vendor/fof/merge-discussions/src/Middleware/Redirection.php(28): Laminas\Stratigility\Next->handle()
#78 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): FoF\MergeDiscussions\Middleware\Redirection->process()
#79 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#80 /var/www/example.com/forum/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process()
#81 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\RequestHandler->process()
#82 /var/www/example.com/forum/vendor/middlewares/base-path-router/src/BasePathRouter.php(101): Laminas\Stratigility\Next->handle()
#83 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\BasePathRouter->process()
#84 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(36): Laminas\Stratigility\Next->handle()
#85 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Laminas\Stratigility\Middleware\OriginalMessages->process()
#86 /var/www/example.com/forum/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle()
#87 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\BasePath->process()
#88 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle()
#89 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ProcessIp->process()
#90 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#91 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(64): Laminas\Stratigility\MiddlewarePipe->process()
#92 /var/www/example.com/forum/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(73): Laminas\Stratigility\MiddlewarePipe->handle()
#93 /var/www/example.com/forum/vendor/flarum/core/src/Http/Server.php(45): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#94 /var/www/example.com/forum/public/index.php(26): Flarum\Http\Server->listen()
#95 {main}

Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[HY000] [2002] No such file or directory in /var/www/example.com/forum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /var/www/example.com/forum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(44): Doctrine\DBAL\Driver\PDO\Exception::new()
#1 /var/www/example.com/forum/vendor/illuminate/database/Connectors/Connector.php(67): Doctrine\DBAL\Driver\PDOConnection->__construct()
#2 /var/www/example.com/forum/vendor/illuminate/database/Connectors/Connector.php(46): Illuminate\Database\Connectors\Connector->createPdoConnection()
#3 /var/www/example.com/forum/vendor/illuminate/database/Connectors/MySqlConnector.php(24): Illuminate\Database\Connectors\Connector->createConnection()
#4 /var/www/example.com/forum/vendor/illuminate/database/Connectors/ConnectionFactory.php(184): Illuminate\Database\Connectors\MySqlConnector->connect()
#5 [internal function]: Illuminate\Database\Connectors\ConnectionFactory->Illuminate\Database\Connectors\{closure}()
#6 /var/www/example.com/forum/vendor/illuminate/database/Connection.php(1064): call_user_func()
#7 /var/www/example.com/forum/vendor/illuminate/database/Connection.php(1100): Illuminate\Database\Connection->getPdo()
#8 /var/www/example.com/forum/vendor/illuminate/database/Connection.php(442): Illuminate\Database\Connection->getReadPdo()
#9 /var/www/example.com/forum/vendor/illuminate/database/Connection.php(368): Illuminate\Database\Connection->getPdoForSelect()
#10 /var/www/example.com/forum/vendor/illuminate/database/Connection.php(705): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#11 /var/www/example.com/forum/vendor/illuminate/database/Connection.php(784): Illuminate\Database\Connection->runQueryCallback()
#12 /var/www/example.com/forum/vendor/illuminate/database/Connection.php(764): Illuminate\Database\Connection->tryAgainIfCausedByLostConnection()
#13 /var/www/example.com/forum/vendor/illuminate/database/Connection.php(675): Illuminate\Database\Connection->handleQueryException()
#14 /var/www/example.com/forum/vendor/illuminate/database/Connection.php(376): Illuminate\Database\Connection->run()
#15 /var/www/example.com/forum/vendor/illuminate/database/Query/Builder.php(2414): Illuminate\Database\Connection->select()
#16 /var/www/example.com/forum/vendor/illuminate/database/Query/Builder.php(2402): Illuminate\Database\Query\Builder->runSelect()
#17 /var/www/example.com/forum/vendor/illuminate/database/Query/Builder.php(2936): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#18 /var/www/example.com/forum/vendor/illuminate/database/Query/Builder.php(2403): Illuminate\Database\Query\Builder->onceWithColumns()
#19 /var/www/example.com/forum/vendor/illuminate/database/Eloquent/Builder.php(625): Illuminate\Database\Query\Builder->get()
#20 /var/www/example.com/forum/vendor/illuminate/database/Eloquent/Builder.php(609): Illuminate\Database\Eloquent\Builder->getModels()
#21 /var/www/example.com/forum/vendor/flarum/core/src/Filter/AbstractFilterer.php(79): Illuminate\Database\Eloquent\Builder->get()
#22 /var/www/example.com/forum/vendor/flarum/core/src/Api/Controller/ListDiscussionsController.php(102): Flarum\Filter\AbstractFilterer->filter()
#23 /var/www/example.com/forum/vendor/flarum/core/src/Api/Controller/AbstractSerializeController.php(116): Flarum\Api\Controller\ListDiscussionsController->data()
#24 /var/www/example.com/forum/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\AbstractSerializeController->handle()
#25 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#26 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ExecuteRoute->process()
#27 /var/www/example.com/forum/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#28 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Api\Middleware\ThrottleApi->process()
#29 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(69): Laminas\Stratigility\Next->handle()
#30 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ResolveRoute->process()
#31 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#32 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\SetLocale->process()
#33 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#34 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\HandleErrors->process()
#35 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#36 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(64): Laminas\Stratigility\MiddlewarePipe->process()
#37 /var/www/example.com/forum/vendor/flarum/core/src/Api/Client.php(141): Laminas\Stratigility\MiddlewarePipe->handle()
#38 /var/www/example.com/forum/vendor/flarum/core/src/Api/Client.php(91): Flarum\Api\Client->send()
#39 /var/www/example.com/forum/vendor/flarum/core/src/Forum/Content/Index.php(108): Flarum\Api\Client->get()
#40 /var/www/example.com/forum/vendor/flarum/core/src/Forum/Content/Index.php(85): Flarum\Forum\Content\Index->getApiDocument()
#41 /var/www/example.com/forum/vendor/flarum/core/src/Frontend/Frontend.php(62): Flarum\Forum\Content\Index->__invoke()
#42 /var/www/example.com/forum/vendor/flarum/core/src/Frontend/Frontend.php(54): Flarum\Frontend\Frontend->populate()
#43 /var/www/example.com/forum/vendor/flarum/core/src/Frontend/Controller.php(32): Flarum\Frontend\Frontend->document()
#44 /var/www/example.com/forum/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Frontend\Controller->handle()
#45 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#46 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ExecuteRoute->process()
#47 /var/www/example.com/forum/vendor/fof/terms/src/Middlewares/RegisterMiddleware.php(59): Laminas\Stratigility\Next->handle()
#48 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): FoF\Terms\Middlewares\RegisterMiddleware->process()
#49 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/ContentTypeOptionsHeader.php(21): Laminas\Stratigility\Next->handle()
#50 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ContentTypeOptionsHeader->process()
#51 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/ReferrerPolicyHeader.php(30): Laminas\Stratigility\Next->handle()
#52 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ReferrerPolicyHeader->process()
#53 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/FlarumPromotionHeader.php(30): Laminas\Stratigility\Next->handle()
#54 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\FlarumPromotionHeader->process()
#55 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/ShareErrorsFromSession.php(57): Laminas\Stratigility\Next->handle()
#56 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ShareErrorsFromSession->process()
#57 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(36): Laminas\Stratigility\Next->handle()
#58 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\CheckCsrfToken->process()
#59 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(69): Laminas\Stratigility\Next->handle()
#60 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ResolveRoute->process()
#61 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#62 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\SetLocale->process()
#63 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle()
#64 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\AuthenticateWithSession->process()
#65 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle()
#66 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\RememberFromCookie->process()
#67 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#68 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\StartSession->process()
#69 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/CollectGarbage.php(46): Laminas\Stratigility\Next->handle()
#70 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\CollectGarbage->process()
#71 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle()
#72 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ParseJsonBody->process()
#73 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#74 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\HandleErrors->process()
#75 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle()
#76 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\InjectActorReference->process()
#77 /var/www/example.com/forum/vendor/fof/merge-discussions/src/Middleware/Redirection.php(28): Laminas\Stratigility\Next->handle()
#78 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): FoF\MergeDiscussions\Middleware\Redirection->process()
#79 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#80 /var/www/example.com/forum/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process()
#81 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\RequestHandler->process()
#82 /var/www/example.com/forum/vendor/middlewares/base-path-router/src/BasePathRouter.php(101): Laminas\Stratigility\Next->handle()
#83 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\BasePathRouter->process()
#84 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(36): Laminas\Stratigility\Next->handle()
#85 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Laminas\Stratigility\Middleware\OriginalMessages->process()
#86 /var/www/example.com/forum/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle()
#87 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\BasePath->process()
#88 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle()
#89 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ProcessIp->process()
#90 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#91 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(64): Laminas\Stratigility\MiddlewarePipe->process()
#92 /var/www/example.com/forum/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(73): Laminas\Stratigility\MiddlewarePipe->handle()
#93 /var/www/example.com/forum/vendor/flarum/core/src/Http/Server.php(45): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#94 /var/www/example.com/forum/public/index.php(26): Flarum\Http\Server->listen()
#95 {main}

Next Illuminate\Database\QueryException: SQLSTATE[HY000] [2002] No such file or directory (SQL: (select `discussions`.* from `discussions` where (`discussions`.`id` not in (select `discussion_id` from `discussion_tag` where `tag_id` not in (select `tags`.`id` from `tags` where (`tags`.`id` in (select `perm_tags`.`id` from `tags` as `perm_tags`) and (`tags`.`parent_id` in (select `perm_tags`.`id` from `tags` as `perm_tags`) or `tags`.`parent_id` is null))))) and (`discussions`.`is_private` = 0 or (((`discussions`.`is_approved` = 0) or (`discussions`.`id` in (select distinct `recipients`.`discussion_id` from `recipients` where `recipients`.`removed_at` is null and (`recipients`.`user_id` = 177 or `recipients`.`group_id` in (1))) or (`discussions`.`id` in (select `recipients`.`discussion_id` from `recipients` where `recipients`.`removed_at` is null) and `discussions`.`id` in (select distinct `posts`.`discussion_id` from `posts` where `posts`.`id` in (select distinct `flags`.`post_id` from `flags`))))))) and `discussions`.`id` not in (select `discussion_id` from `discussion_tag` where 0 = 1) and not exists (select 1 from `discussion_user` where `discussions`.`id` = `discussion_id` and `user_id` = 177 and `subscription` = ignore) order by `last_posted_at` desc limit 21) union (select `discussions`.* from `discussions` where (`discussions`.`id` not in (select `discussion_id` from `discussion_tag` where `tag_id` not in (select `tags`.`id` from `tags` where (`tags`.`id` in (select `perm_tags`.`id` from `tags` as `perm_tags`) and (`tags`.`parent_id` in (select `perm_tags`.`id` from `tags` as `perm_tags`) or `tags`.`parent_id` is null))))) and (`discussions`.`is_private` = 0 or (((`discussions`.`is_approved` = 0) or (`discussions`.`id` in (select distinct `recipients`.`discussion_id` from `recipients` where `recipients`.`removed_at` is null and (`recipients`.`user_id` = 177 or `recipients`.`group_id` in (1))) or (`discussions`.`id` in (select `recipients`.`discussion_id` from `recipients` where `recipients`.`removed_at` is null) and `discussions`.`id` in (select distinct `posts`.`discussion_id` from `posts` where `posts`.`id` in (select distinct `flags`.`post_id` from `flags`))))))) and `discussions`.`id` not in (select `discussion_id` from `discussion_tag` where 0 = 1) and not exists (select 1 from `discussion_user` where `discussions`.`id` = `discussion_id` and `user_id` = 177 and `subscription` = ignore) and `is_sticky` = 1 limit 21) order by is_sticky and not exists (select 1 from `discussion_user` as `sticky` where `sticky`.`discussion_id` = `id` and `sticky`.`user_id` = 177 and `sticky`.`last_read_post_number` >= `last_post_number`) and last_posted_at > 2022-01-22 09:51:37 desc, `last_posted_at` desc limit 21) in /var/www/example.com/forum/vendor/illuminate/database/Connection.php:712
Stack trace:
#0 /var/www/example.com/forum/vendor/illuminate/database/Connection.php(784): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/example.com/forum/vendor/illuminate/database/Connection.php(764): Illuminate\Database\Connection->tryAgainIfCausedByLostConnection()
#2 /var/www/example.com/forum/vendor/illuminate/database/Connection.php(675): Illuminate\Database\Connection->handleQueryException()
#3 /var/www/example.com/forum/vendor/illuminate/database/Connection.php(376): Illuminate\Database\Connection->run()
#4 /var/www/example.com/forum/vendor/illuminate/database/Query/Builder.php(2414): Illuminate\Database\Connection->select()
#5 /var/www/example.com/forum/vendor/illuminate/database/Query/Builder.php(2402): Illuminate\Database\Query\Builder->runSelect()
#6 /var/www/example.com/forum/vendor/illuminate/database/Query/Builder.php(2936): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#7 /var/www/example.com/forum/vendor/illuminate/database/Query/Builder.php(2403): Illuminate\Database\Query\Builder->onceWithColumns()
#8 /var/www/example.com/forum/vendor/illuminate/database/Eloquent/Builder.php(625): Illuminate\Database\Query\Builder->get()
#9 /var/www/example.com/forum/vendor/illuminate/database/Eloquent/Builder.php(609): Illuminate\Database\Eloquent\Builder->getModels()
#10 /var/www/example.com/forum/vendor/flarum/core/src/Filter/AbstractFilterer.php(79): Illuminate\Database\Eloquent\Builder->get()
#11 /var/www/example.com/forum/vendor/flarum/core/src/Api/Controller/ListDiscussionsController.php(102): Flarum\Filter\AbstractFilterer->filter()
#12 /var/www/example.com/forum/vendor/flarum/core/src/Api/Controller/AbstractSerializeController.php(116): Flarum\Api\Controller\ListDiscussionsController->data()
#13 /var/www/example.com/forum/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\AbstractSerializeController->handle()
#14 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#15 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ExecuteRoute->process()
#16 /var/www/example.com/forum/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#17 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Api\Middleware\ThrottleApi->process()
#18 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(69): Laminas\Stratigility\Next->handle()
#19 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ResolveRoute->process()
#20 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#21 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\SetLocale->process()
#22 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#23 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\HandleErrors->process()
#24 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#25 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(64): Laminas\Stratigility\MiddlewarePipe->process()
#26 /var/www/example.com/forum/vendor/flarum/core/src/Api/Client.php(141): Laminas\Stratigility\MiddlewarePipe->handle()
#27 /var/www/example.com/forum/vendor/flarum/core/src/Api/Client.php(91): Flarum\Api\Client->send()
#28 /var/www/example.com/forum/vendor/flarum/core/src/Forum/Content/Index.php(108): Flarum\Api\Client->get()
#29 /var/www/example.com/forum/vendor/flarum/core/src/Forum/Content/Index.php(85): Flarum\Forum\Content\Index->getApiDocument()
#30 /var/www/example.com/forum/vendor/flarum/core/src/Frontend/Frontend.php(62): Flarum\Forum\Content\Index->__invoke()
#31 /var/www/example.com/forum/vendor/flarum/core/src/Frontend/Frontend.php(54): Flarum\Frontend\Frontend->populate()
#32 /var/www/example.com/forum/vendor/flarum/core/src/Frontend/Controller.php(32): Flarum\Frontend\Frontend->document()
#33 /var/www/example.com/forum/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Frontend\Controller->handle()
#34 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#35 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ExecuteRoute->process()
#36 /var/www/example.com/forum/vendor/fof/terms/src/Middlewares/RegisterMiddleware.php(59): Laminas\Stratigility\Next->handle()
#37 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): FoF\Terms\Middlewares\RegisterMiddleware->process()
#38 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/ContentTypeOptionsHeader.php(21): Laminas\Stratigility\Next->handle()
#39 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ContentTypeOptionsHeader->process()
#40 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/ReferrerPolicyHeader.php(30): Laminas\Stratigility\Next->handle()
#41 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ReferrerPolicyHeader->process()
#42 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/FlarumPromotionHeader.php(30): Laminas\Stratigility\Next->handle()
#43 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\FlarumPromotionHeader->process()
#44 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/ShareErrorsFromSession.php(57): Laminas\Stratigility\Next->handle()
#45 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ShareErrorsFromSession->process()
#46 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(36): Laminas\Stratigility\Next->handle()
#47 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\CheckCsrfToken->process()
#48 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(69): Laminas\Stratigility\Next->handle()
#49 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ResolveRoute->process()
#50 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#51 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\SetLocale->process()
#52 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle()
#53 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\AuthenticateWithSession->process()
#54 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle()
#55 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\RememberFromCookie->process()
#56 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#57 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\StartSession->process()
#58 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/CollectGarbage.php(46): Laminas\Stratigility\Next->handle()
#59 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\CollectGarbage->process()
#60 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle()
#61 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ParseJsonBody->process()
#62 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#63 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\HandleErrors->process()
#64 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle()
#65 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\InjectActorReference->process()
#66 /var/www/example.com/forum/vendor/fof/merge-discussions/src/Middleware/Redirection.php(28): Laminas\Stratigility\Next->handle()
#67 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): FoF\MergeDiscussions\Middleware\Redirection->process()
#68 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#69 /var/www/example.com/forum/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process()
#70 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\RequestHandler->process()
#71 /var/www/example.com/forum/vendor/middlewares/base-path-router/src/BasePathRouter.php(101): Laminas\Stratigility\Next->handle()
#72 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\BasePathRouter->process()
#73 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(36): Laminas\Stratigility\Next->handle()
#74 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Laminas\Stratigility\Middleware\OriginalMessages->process()
#75 /var/www/example.com/forum/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle()
#76 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\BasePath->process()
#77 /var/www/example.com/forum/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle()
#78 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ProcessIp->process()
#79 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#80 /var/www/example.com/forum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(64): Laminas\Stratigility\MiddlewarePipe->process()
#81 /var/www/example.com/forum/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(73): Laminas\Stratigility\MiddlewarePipe->handle()
#82 /var/www/example.com/forum/vendor/flarum/core/src/Http/Server.php(45): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#83 /var/www/example.com/forum/public/index.php(26): Flarum\Http\Server->listen()
#84 {main}

SychO

wolfman that doesn't seem like upload causing it, it seems like the mysql service is not running at all there for some reason.

wolfman

wolfman SychO Maybe i spoke to soon! Just updated my PROD-Forum and it is dead slow now!
Flarum encountered a boot error. Details have been logged to the Flarum log file.

SychO I just upgraded Flarum Core to 1.8.5 and FoF Upload to 1.5.4 and i had the same issue again. After the update a lot of different SQLs failed (Doctrine & PDO) and soon after everthiny was fine again. I upgraded Flarum and it's plugins a couple of times since we last spoke about this issue. This only happens when updating FoF Upload.

Flarum core: 1.8.5
PHP version: 8.1.2-1ubuntu2.14
MySQL version: 8.0.35-0ubuntu0.22.04.1
Loaded extensions: Core, date, libxml, openssl, pcre, zlib, filter, hash, json, pcntl, Reflection, SPL, session, standard, sodium, mysqlnd, PDO, xml, bz2, calendar, ctype, curl, dom, mbstring, FFI, fileinfo, ftp, gd, gettext, iconv, imagick, intl, exif, mysqli, pdo_mysql, Phar, posix, readline, shmop, SimpleXML, sockets, sysvmsg, sysvsem, sysvshm, tokenizer, xmlreader, xmlwriter, xsl, zip, Zend OPcache
+--------------------------------------+------------+--------+
| Flarum Extensions                    |            |        |
+--------------------------------------+------------+--------+
| ID                                   | Version    | Commit |
+--------------------------------------+------------+--------+
| flarum-flags                         | v1.8.0     |        |
| flarum-bbcode                        | v1.8.0     |        |
| flarum-suspend                       | v1.8.1     |        |
| flarum-approval                      | v1.8.1     |        |
| flarum-tags                          | v1.8.0     |        |
| fof-formatting                       | 1.0.3      |        |
| wolfgang-demeter-bbcode-5star-rating | v0.1.8     |        |
| wolfgang-demeter-amazon-product-api  | v0.1.7     |        |
| fof-user-bio                         | 1.3.1      |        |
| fof-upload                           | 1.5.4      |        |
| fof-terms                            | 1.3.0      |        |
| fof-split                            | 1.1.1      |        |
| fof-socialprofile                    | 1.1.6      |        |
| fof-recaptcha                        | 1.3.1      |        |
| fof-pages                            | 1.0.8      |        |
| fof-merge-discussions                | 1.4.1      |        |
| fof-links                            | 1.2.1      |        |
| fof-byobu                            | 1.3.5      |        |
| fof-amazon-affiliation               | 1.1.0      |        |
| flarum-subscriptions                 | v1.8.0     |        |
| flarum-sticky                        | v1.8.0     |        |
| flarum-statistics                    | v1.8.0     |        |
| flarum-nicknames                     | v1.8.0     |        |
| flarum-mentions                      | v1.8.3     |        |
| flarum-markdown                      | v1.8.0     |        |
| flarum-lock                          | v1.8.0     |        |
| flarum-likes                         | v1.8.0     |        |
| flarum-lang-german                   | dev-master |        |
| flarum-lang-english                  | v1.8.0     |        |
| datlechin-birthdays                  | v2.0.1     |        |
| askvortsov-auto-moderator            | v0.1.3     |        |
| antoinefr-bbcode-fa                  | v1.0.0     |        |
+--------------------------------------+------------+--------+
Base URL: https://forum.dvdnarr.com
Installation path: /var/www/dvdnarr.com/forum
Queue driver: sync
Session driver: file
Mail driver: mail
Debug mode: off

wolfman

It seems to work fine again, after MySQL has initially filled it's Query-Caches! MySQL is/was running fine. Never had this after an update.

There are a mere 658 entries in the fof_upload_files table.

SychO

wolfman that is odd, the changes made in 1.4.5 are technically faster and less load on the database, but keep watch and let us know if anything of the sort happens again.

wolfman

SychO Will do. Thanks again for your support and quick help!

alexcool

Good day

Please tell me what free file storage can I connect?

I have successfully configured Imgbur, but I would like to configure sending files (zip, 7z for example) option too.

Thank you!

clarkwinkelmann

alexcool what kind of hosting are you using ?

If your hosting includes some disk space you can use the local adapter which should not incur additional costs.

Otherwise you would have to find a free service that supports the Amazon S3 protocol and use the S3 adapter which works with many S3-compatible services.

Last resort, you could create a custom adapter for a service of your choice.

alexcool

clarkwinkelmann Good day

I use public hosting of flarum

I created free Amazon S3 storage and configured extension FOFupload:

imgur.com/P3kjadC

But when i try to upload files, for example *.jpeg , I get an error:

imgur.com/AGiFM0v

Or:

imgur.com/zUkdaZ7

I need to configure upload of archive files, like zip, RAR, 7z

Please, help me to configure it right

« Previous Page Next Page »