fof/upload 500 server error

AbusingBruno

Hello,

I can't use fof/upload on my website. When I try to upload an image, I get this error (with debug on):

POST https://forum.gameloop.it/api/fof/upload

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'uuid' in 'where clause' in /var/www/html/forum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:79
Stack trace:
#0 /var/www/html/forum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(79): PDO->prepare()
#1 /var/www/html/forum/vendor/illuminate/database/Connection.php(345): Doctrine\DBAL\Driver\PDOConnection->prepare()
#2 /var/www/html/forum/vendor/illuminate/database/Connection.php(678): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /var/www/html/forum/vendor/illuminate/database/Connection.php(645): Illuminate\Database\Connection->runQueryCallback()
#4 /var/www/html/forum/vendor/illuminate/database/Connection.php(353): Illuminate\Database\Connection->run()
#5 /var/www/html/forum/vendor/illuminate/database/Query/Builder.php(2351): Illuminate\Database\Connection->select()
#6 /var/www/html/forum/vendor/illuminate/database/Query/Builder.php(2339): Illuminate\Database\Query\Builder->runSelect()
#7 /var/www/html/forum/vendor/illuminate/database/Query/Builder.php(2905): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#8 /var/www/html/forum/vendor/illuminate/database/Query/Builder.php(2340): Illuminate\Database\Query\Builder->onceWithColumns()
#9 /var/www/html/forum/vendor/illuminate/database/Eloquent/Builder.php(604): Illuminate\Database\Query\Builder->get()
#10 /var/www/html/forum/vendor/illuminate/database/Eloquent/Builder.php(588): Illuminate\Database\Eloquent\Builder->getModels()
#11 /var/www/html/forum/vendor/illuminate/database/Concerns/BuildsQueries.php(254): Illuminate\Database\Eloquent\Builder->get()
#12 /var/www/html/forum/vendor/fof/upload/src/Repositories/FileRepository.php(72): Illuminate\Database\Eloquent\Builder->first()
#13 /var/www/html/forum/vendor/fof/upload/src/Repositories/FileRepository.php(88): FoF\Upload\Repositories\FileRepository->findByUuid()
#14 /var/www/html/forum/vendor/fof/upload/src/Commands/UploadHandler.php(125): FoF\Upload\Repositories\FileRepository->createFileFromUpload()
#15 [internal function]: FoF\Upload\Commands\UploadHandler->FoF\Upload\Commands\{closure}()
#16 /var/www/html/forum/vendor/illuminate/collections/Collection.php(642): array_map()
#17 /var/www/html/forum/vendor/fof/upload/src/Commands/UploadHandler.php(169): Illuminate\Support\Collection->map()
#18 /var/www/html/forum/vendor/illuminate/bus/Dispatcher.php(122): FoF\Upload\Commands\UploadHandler->handle()
#19 /var/www/html/forum/vendor/illuminate/pipeline/Pipeline.php(128): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}()
#20 /var/www/html/forum/vendor/illuminate/pipeline/Pipeline.php(103): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#21 /var/www/html/forum/vendor/illuminate/bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()
#22 /var/www/html/forum/vendor/illuminate/bus/Dispatcher.php(78): Illuminate\Bus\Dispatcher->dispatchNow()
#23 /var/www/html/forum/vendor/fof/upload/src/Api/Controllers/UploadController.php(52): Illuminate\Bus\Dispatcher->dispatch()
#24 /var/www/html/forum/vendor/flarum/core/src/Api/Controller/AbstractSerializeController.php(110): FoF\Upload\Api\Controllers\UploadController->data()
#25 /var/www/html/forum/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\AbstractSerializeController->handle()
#26 /var/www/html/forum/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#27 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ExecuteRoute->process()
#28 /var/www/html/forum/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#29 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Api\Middleware\ThrottleApi->process()
#30 /var/www/html/forum/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(44): Laminas\Stratigility\Next->handle()
#31 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\CheckCsrfToken->process()
#32 /var/www/html/forum/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(67): Laminas\Stratigility\Next->handle()
#33 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ResolveRoute->process()
#34 /var/www/html/forum/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#35 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\SetLocale->process()
#36 /var/www/html/forum/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(56): Laminas\Stratigility\Next->handle()
#37 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\AuthenticateWithHeader->process()
#38 /var/www/html/forum/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle()
#39 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\AuthenticateWithSession->process()
#40 /var/www/html/forum/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle()
#41 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\RememberFromCookie->process()
#42 /var/www/html/forum/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#43 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\StartSession->process()
#44 /var/www/html/forum/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\Stratigility\Next->handle()
#45 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Api\Middleware\FakeHttpMethods->process()
#46 /var/www/html/forum/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle()
#47 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ParseJsonBody->process()
#48 /var/www/html/forum/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#49 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\HandleErrors->process()
#50 /var/www/html/forum/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle()
#51 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\InjectActorReference->process()
#52 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\Stratigility\Next->handle()
#53 /var/www/html/forum/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process()
#54 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\RequestHandler->process()
#55 /var/www/html/forum/vendor/middlewares/base-path-router/src/BasePathRouter.php(101): Laminas\Stratigility\Next->handle()
#56 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\BasePathRouter->process()
#57 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(42): Laminas\Stratigility\Next->handle()
#58 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/Next.php(61): Laminas\Stratigility\Middleware\OriginalMessages->process()
#59 /var/www/html/forum/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle()
#60 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\BasePath->process()
#61 /var/www/html/forum/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle()
#62 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ProcessIp->process()
#63 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\Stratigility\Next->handle()
#64 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(73): Laminas\Stratigility\MiddlewarePipe->process()
#65 /var/www/html/forum/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(96): Laminas\Stratigility\MiddlewarePipe->handle()
#66 /var/www/html/forum/vendor/flarum/core/src/Http/Server.php(44): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#67 /var/www/html/forum/public/index.php(26): Flarum\Http\Server->listen()
#68 {main}

and if I click on the "My media" button...

GET https://forum.gameloop.it/api/fof/uploads

Error: Call to a member function preview() on array in /var/www/html/forum/vendor/fof/upload/src/Helpers/Util.php:153
Stack trace:
#0 /var/www/html/forum/vendor/fof/upload/src/Api/Serializers/FileSerializer.php(46): FoF\Upload\Helpers\Util->getBbcodeForFile()
#1 /var/www/html/forum/vendor/flarum/core/src/Api/Serializer/AbstractSerializer.php(88): FoF\Upload\Api\Serializers\FileSerializer->getDefaultAttributes()
#2 /var/www/html/forum/vendor/tobscure/json-api/src/Resource.php(169): Flarum\Api\Serializer\AbstractSerializer->getAttributes()
#3 /var/www/html/forum/vendor/tobscure/json-api/src/Resource.php(75): Tobscure\JsonApi\Resource->getAttributes()
#4 /var/www/html/forum/vendor/tobscure/json-api/src/Collection.php(123): Tobscure\JsonApi\Resource->toArray()
#5 [internal function]: Tobscure\JsonApi\Collection->Tobscure\JsonApi\{closure}()
#6 /var/www/html/forum/vendor/tobscure/json-api/src/Collection.php(124): array_map()
#7 /var/www/html/forum/vendor/tobscure/json-api/src/Document.php(181): Tobscure\JsonApi\Collection->toArray()
#8 /var/www/html/forum/vendor/tobscure/json-api/src/Document.php(224): Tobscure\JsonApi\Document->toArray()
#9 /var/www/html/forum/vendor/flarum/core/src/Api/JsonApiResponse.php(27): Tobscure\JsonApi\Document->jsonSerialize()
#10 /var/www/html/forum/vendor/flarum/core/src/Api/Controller/AbstractSerializeController.php(129): Flarum\Api\JsonApiResponse->__construct()
#11 /var/www/html/forum/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\AbstractSerializeController->handle()
#12 /var/www/html/forum/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#13 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ExecuteRoute->process()
#14 /var/www/html/forum/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#15 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Api\Middleware\ThrottleApi->process()
#16 /var/www/html/forum/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(36): Laminas\Stratigility\Next->handle()
#17 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\CheckCsrfToken->process()
#18 /var/www/html/forum/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(67): Laminas\Stratigility\Next->handle()
#19 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ResolveRoute->process()
#20 /var/www/html/forum/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#21 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\SetLocale->process()
#22 /var/www/html/forum/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(56): Laminas\Stratigility\Next->handle()
#23 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\AuthenticateWithHeader->process()
#24 /var/www/html/forum/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle()
#25 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\AuthenticateWithSession->process()
#26 /var/www/html/forum/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle()
#27 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\RememberFromCookie->process()
#28 /var/www/html/forum/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#29 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\StartSession->process()
#30 /var/www/html/forum/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\Stratigility\Next->handle()
#31 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Api\Middleware\FakeHttpMethods->process()
#32 /var/www/html/forum/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle()
#33 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ParseJsonBody->process()
#34 /var/www/html/forum/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#35 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\HandleErrors->process()
#36 /var/www/html/forum/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle()
#37 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\InjectActorReference->process()
#38 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\Stratigility\Next->handle()
#39 /var/www/html/forum/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process()
#40 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\RequestHandler->process()
#41 /var/www/html/forum/vendor/middlewares/base-path-router/src/BasePathRouter.php(101): Laminas\Stratigility\Next->handle()
#42 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\BasePathRouter->process()
#43 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(42): Laminas\Stratigility\Next->handle()
#44 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/Next.php(61): Laminas\Stratigility\Middleware\OriginalMessages->process()
#45 /var/www/html/forum/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle()
#46 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\BasePath->process()
#47 /var/www/html/forum/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle()
#48 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ProcessIp->process()
#49 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\Stratigility\Next->handle()
#50 /var/www/html/forum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(73): Laminas\Stratigility\MiddlewarePipe->process()
#51 /var/www/html/forum/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(96): Laminas\Stratigility\MiddlewarePipe->handle()
#52 /var/www/html/forum/vendor/flarum/core/src/Http/Server.php(44): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#53 /var/www/html/forum/public/index.php(26): Flarum\Http\Server->listen()
#54 {main}

Any ideas?

Thanks in advance!

IanM

AbusingBruno this would indicate one (or more) of the migrations has not run.

Run the following command from the root of your Flarum installation folder:

php flarum migrate

AbusingBruno

thanks for the reply, I've done it multiple times but no results. maybe I can "force" a migration?

Migrating Flarum... Nothing to migrate. Migrating extension: flarum-markdown Nothing to migrate. Migrating extension: flarum-flags Nothing to migrate. Migrating extension: fof-drafts Nothing to migrate. Migrating extension: flarum-suspend Nothing to migrate. Migrating extension: flarum-sticky Nothing to migrate. Migrating extension: flarum-lock Nothing to migrate. Migrating extension: fof-socialprofile Nothing to migrate. Migrating extension: fof-links Nothing to migrate. Migrating extension: flarum-emoji Nothing to migrate. Migrating extension: flarum-approval Nothing to migrate. Migrating extension: flarum-likes Nothing to migrate. Migrating extension: flarum-mentions Nothing to migrate. Migrating extension: flarum-subscriptions Nothing to migrate. Migrating extension: flarum-tags Nothing to migrate. Migrating extension: fof-pages Nothing to migrate. Migrating extension: fof-upload Nothing to migrate. DONE.

IanM

AbusingBruno Can you post the output of php flarum info please?

AbusingBruno

here is it:

AbusingBruno

ok so I fixed it by doing

php flarum migrate:reset --extension=fof-upload

and then

php flarum migrate

it was a migration issue indeed! thank you!

IanM

AbusingBruno great, sorry for the late reply, but glad you've sorted it 🙂