Comments (2)
I don't know if this is related.
When trying to vote, this happens:
POST https://forum.kekloud.com/api/posts/20
{
"errors": [
{
"status": "500",
"code": "unknown",
"detail": "PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'flarum_flarum_post_votes.value' in 'field list' in /flarum/app/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:64\nStack trace:\n#0 /flarum/app/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(64): PDO->prepare('select sum(`fla...', Array)\n#1 /flarum/app/vendor/illuminate/database/Connection.php(326): Doctrine\\DBAL\\Driver\\PDOConnection->prepare('select sum(`fla...')\n#2 /flarum/app/vendor/illuminate/database/Connection.php(657): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('select sum(`fla...', Array)\n#3 /flarum/app/vendor/illuminate/database/Connection.php(624): Illuminate\\Database\\Connection->runQueryCallback('select sum(`fla...', Array, Object(Closure))\n#4 /flarum/app/vendor/illuminate/database/Connection.php(333): Illuminate\\Database\\Connection->run('select sum(`fla...', Array, Object(Closure))\n#5 /flarum/app/vendor/illuminate/database/Query/Builder.php(2095): Illuminate\\Database\\Connection->select('select sum(`fla...', Array, true)\n#6 /flarum/app/vendor/illuminate/database/Query/Builder.php(2083): Illuminate\\Database\\Query\\Builder->runSelect()\n#7 /flarum/app/vendor/illuminate/database/Query/Builder.php(2569): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()\n#8 /flarum/app/vendor/illuminate/database/Query/Builder.php(2084): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure))\n#9 /flarum/app/vendor/illuminate/database/Query/Builder.php(2496): Illuminate\\Database\\Query\\Builder->get(Array)\n#10 /flarum/app/vendor/illuminate/database/Query/Builder.php(2457): Illuminate\\Database\\Query\\Builder->aggregate('sum', Array)\n#11 /flarum/app/vendor/illuminate/database/Eloquent/Builder.php(1338): Illuminate\\Database\\Query\\Builder->sum('flarum_post_vot...')\n#12 /flarum/app/vendor/fof/gamification/src/Vote.php(62): Illuminate\\Database\\Eloquent\\Builder->__call('sum', Array)\n#13 /flarum/app/vendor/fof/gamification/src/Vote.php(71): FoF\\Gamification\\Vote::calculate(Object(Illuminate\\Database\\Eloquent\\Builder), true)\n#14 /flarum/app/vendor/fof/gamification/src/Listeners/SaveVotesToDatabase.php(150): FoF\\Gamification\\Vote::updateUserVotes(Object(Flarum\\User\\User))\n#15 /flarum/app/vendor/fof/gamification/src/Listeners/SaveVotesToDatabase.php(135): FoF\\Gamification\\Listeners\\SaveVotesToDatabase->updatePoints(Object(Flarum\\User\\User), Object(Flarum\\Post\\CommentPost))\n#16 /flarum/app/vendor/fof/gamification/src/Listeners/SaveVotesToDatabase.php(95): FoF\\Gamification\\Listeners\\SaveVotesToDatabase->vote(Object(Flarum\\Post\\CommentPost), true, false, Object(Flarum\\User\\User), Object(Flarum\\User\\User))\n#17 [internal function]: FoF\\Gamification\\Listeners\\SaveVotesToDatabase->handle(Object(Flarum\\Post\\Event\\Saving))\n#18 /flarum/app/vendor/illuminate/events/Dispatcher.php(379): call_user_func_array(Array, Array)\n#19 /flarum/app/vendor/illuminate/events/Dispatcher.php(209): Illuminate\\Events\\Dispatcher->Illuminate\\Events\\{closure}('Flarum\\\\Post\\\\Eve...', Array)\n#20 /flarum/app/vendor/flarum/core/src/Post/Command/EditPostHandler.php(81): Illuminate\\Events\\Dispatcher->dispatch('Flarum\\\\Post\\\\Eve...')\n#21 /flarum/app/vendor/illuminate/bus/Dispatcher.php(90): Flarum\\Post\\Command\\EditPostHandler->handle(Object(Flarum\\Post\\Command\\EditPost))\n#22 /flarum/app/vendor/illuminate/pipeline/Pipeline.php(128): Illuminate\\Bus\\Dispatcher->Illuminate\\Bus\\{closure}(Object(Flarum\\Post\\Command\\EditPost))\n#23 /flarum/app/vendor/illuminate/pipeline/Pipeline.php(104): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Flarum\\Post\\Command\\EditPost))\n#24 /flarum/app/vendor/illuminate/bus/Dispatcher.php(98): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))\n#25 /flarum/app/vendor/illuminate/bus/Dispatcher.php(76): Illuminate\\Bus\\Dispatcher->dispatchNow(Object(Flarum\\Post\\Command\\EditPost))\n#26 /flarum/app/vendor/flarum/core/src/Api/Controller/UpdatePostController.php(57): Illuminate\\Bus\\Dispatcher->dispatch(Object(Flarum\\Post\\Command\\EditPost))\n#27 /flarum/app/vendor/flarum/core/src/Api/Controller/AbstractSerializeController.php(96): Flarum\\Api\\Controller\\UpdatePostController->data(Object(Laminas\\Diactoros\\ServerRequest), Object(Tobscure\\JsonApi\\Document))\n#28 /flarum/app/vendor/flarum/core/src/Http/RouteHandlerFactory.php(38): Flarum\\Api\\Controller\\AbstractSerializeController->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#29 /flarum/app/vendor/flarum/core/src/Http/Middleware/DispatchRoute.php(65): Flarum\\Http\\RouteHandlerFactory->Flarum\\Http\\{closure}(Object(Laminas\\Diactoros\\ServerRequest), Array)\n#30 /flarum/app/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\DispatchRoute->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Closure))\n#31 /flarum/app/vendor/flarum/core/src/Http/Middleware/SetLocale.php(50): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#32 /flarum/app/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\SetLocale->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#33 /flarum/app/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(45): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#34 /flarum/app/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\CheckCsrfToken->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#35 /flarum/app/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(55): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#36 /flarum/app/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\AuthenticateWithHeader->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#37 /flarum/app/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(32): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#38 /flarum/app/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\AuthenticateWithSession->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#39 /flarum/app/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(51): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#40 /flarum/app/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\RememberFromCookie->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#41 /flarum/app/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#42 /flarum/app/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\StartSession->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#43 /flarum/app/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#44 /flarum/app/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Api\\Middleware\\FakeHttpMethods->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#45 /flarum/app/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#46 /flarum/app/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\ParseJsonBody->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#47 /flarum/app/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#48 /flarum/app/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\HandleErrors->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#49 /flarum/app/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#50 /flarum/app/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\\Stratigility\\MiddlewarePipe->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#51 /flarum/app/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\\RequestHandler->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#52 /flarum/app/vendor/middlewares/base-path-router/src/BasePathRouter.php(97): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#53 /flarum/app/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\\BasePathRouter->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#54 /flarum/app/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(42): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#55 /flarum/app/vendor/laminas/laminas-stratigility/src/Next.php(61): Laminas\\Stratigility\\Middleware\\OriginalMessages->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#56 /flarum/app/vendor/middlewares/base-path/src/BasePath.php(53): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#57 /flarum/app/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\\BasePath->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#58 /flarum/app/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#59 /flarum/app/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(73): Laminas\\Stratigility\\MiddlewarePipe->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\EmptyPipelineHandler))\n#60 /flarum/app/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(96): Laminas\\Stratigility\\MiddlewarePipe->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#61 /flarum/app/vendor/flarum/core/src/Http/Server.php(42): Laminas\\HttpHandlerRunner\\RequestHandlerRunner->run()\n#62 /flarum/app/public/index.php(26): Flarum\\Http\\Server->listen()\n#63 {main}\n\nNext Doctrine\\DBAL\\Driver\\PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'flarum_flarum_post_votes.value' in 'field list' in /flarum/app/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:66\nStack trace:\n#0 /flarum/app/vendor/illuminate/database/Connection.php(326): Doctrine\\DBAL\\Driver\\PDOConnection->prepare('select sum(`fla...')\n#1 /flarum/app/vendor/illuminate/database/Connection.php(657): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('select sum(`fla...', Array)\n#2 /flarum/app/vendor/illuminate/database/Connection.php(624): Illuminate\\Database\\Connection->runQueryCallback('select sum(`fla...', Array, Object(Closure))\n#3 /flarum/app/vendor/illuminate/database/Connection.php(333): Illuminate\\Database\\Connection->run('select sum(`fla...', Array, Object(Closure))\n#4 /flarum/app/vendor/illuminate/database/Query/Builder.php(2095): Illuminate\\Database\\Connection->select('select sum(`fla...', Array, true)\n#5 /flarum/app/vendor/illuminate/database/Query/Builder.php(2083): Illuminate\\Database\\Query\\Builder->runSelect()\n#6 /flarum/app/vendor/illuminate/database/Query/Builder.php(2569): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()\n#7 /flarum/app/vendor/illuminate/database/Query/Builder.php(2084): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure))\n#8 /flarum/app/vendor/illuminate/database/Query/Builder.php(2496): Illuminate\\Database\\Query\\Builder->get(Array)\n#9 /flarum/app/vendor/illuminate/database/Query/Builder.php(2457): Illuminate\\Database\\Query\\Builder->aggregate('sum', Array)\n#10 /flarum/app/vendor/illuminate/database/Eloquent/Builder.php(1338): Illuminate\\Database\\Query\\Builder->sum('flarum_post_vot...')\n#11 /flarum/app/vendor/fof/gamification/src/Vote.php(62): Illuminate\\Database\\Eloquent\\Builder->__call('sum', Array)\n#12 /flarum/app/vendor/fof/gamification/src/Vote.php(71): FoF\\Gamification\\Vote::calculate(Object(Illuminate\\Database\\Eloquent\\Builder), true)\n#13 /flarum/app/vendor/fof/gamification/src/Listeners/SaveVotesToDatabase.php(150): FoF\\Gamification\\Vote::updateUserVotes(Object(Flarum\\User\\User))\n#14 /flarum/app/vendor/fof/gamification/src/Listeners/SaveVotesToDatabase.php(135): FoF\\Gamification\\Listeners\\SaveVotesToDatabase->updatePoints(Object(Flarum\\User\\User), Object(Flarum\\Post\\CommentPost))\n#15 /flarum/app/vendor/fof/gamification/src/Listeners/SaveVotesToDatabase.php(95): FoF\\Gamification\\Listeners\\SaveVotesToDatabase->vote(Object(Flarum\\Post\\CommentPost), true, false, Object(Flarum\\User\\User), Object(Flarum\\User\\User))\n#16 [internal function]: FoF\\Gamification\\Listeners\\SaveVotesToDatabase->handle(Object(Flarum\\Post\\Event\\Saving))\n#17 /flarum/app/vendor/illuminate/events/Dispatcher.php(379): call_user_func_array(Array, Array)\n#18 /flarum/app/vendor/illuminate/events/Dispatcher.php(209): Illuminate\\Events\\Dispatcher->Illuminate\\Events\\{closure}('Flarum\\\\Post\\\\Eve...', Array)\n#19 /flarum/app/vendor/flarum/core/src/Post/Command/EditPostHandler.php(81): Illuminate\\Events\\Dispatcher->dispatch('Flarum\\\\Post\\\\Eve...')\n#20 /flarum/app/vendor/illuminate/bus/Dispatcher.php(90): Flarum\\Post\\Command\\EditPostHandler->handle(Object(Flarum\\Post\\Command\\EditPost))\n#21 /flarum/app/vendor/illuminate/pipeline/Pipeline.php(128): Illuminate\\Bus\\Dispatcher->Illuminate\\Bus\\{closure}(Object(Flarum\\Post\\Command\\EditPost))\n#22 /flarum/app/vendor/illuminate/pipeline/Pipeline.php(104): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Flarum\\Post\\Command\\EditPost))\n#23 /flarum/app/vendor/illuminate/bus/Dispatcher.php(98): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))\n#24 /flarum/app/vendor/illuminate/bus/Dispatcher.php(76): Illuminate\\Bus\\Dispatcher->dispatchNow(Object(Flarum\\Post\\Command\\EditPost))\n#25 /flarum/app/vendor/flarum/core/src/Api/Controller/UpdatePostController.php(57): Illuminate\\Bus\\Dispatcher->dispatch(Object(Flarum\\Post\\Command\\EditPost))\n#26 /flarum/app/vendor/flarum/core/src/Api/Controller/AbstractSerializeController.php(96): Flarum\\Api\\Controller\\UpdatePostController->data(Object(Laminas\\Diactoros\\ServerRequest), Object(Tobscure\\JsonApi\\Document))\n#27 /flarum/app/vendor/flarum/core/src/Http/RouteHandlerFactory.php(38): Flarum\\Api\\Controller\\AbstractSerializeController->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#28 /flarum/app/vendor/flarum/core/src/Http/Middleware/DispatchRoute.php(65): Flarum\\Http\\RouteHandlerFactory->Flarum\\Http\\{closure}(Object(Laminas\\Diactoros\\ServerRequest), Array)\n#29 /flarum/app/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\DispatchRoute->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Closure))\n#30 /flarum/app/vendor/flarum/core/src/Http/Middleware/SetLocale.php(50): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#31 /flarum/app/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\SetLocale->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#32 /flarum/app/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(45): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#33 /flarum/app/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\CheckCsrfToken->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#34 /flarum/app/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(55): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#35 /flarum/app/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\AuthenticateWithHeader->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#36 /flarum/app/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(32): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#37 /flarum/app/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\AuthenticateWithSession->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#38 /flarum/app/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(51): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#39 /flarum/app/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\RememberFromCookie->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#40 /flarum/app/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#41 /flarum/app/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\StartSession->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#42 /flarum/app/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#43 /flarum/app/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Api\\Middleware\\FakeHttpMethods->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#44 /flarum/app/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#45 /flarum/app/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\ParseJsonBody->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#46 /flarum/app/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#47 /flarum/app/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\HandleErrors->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#48 /flarum/app/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#49 /flarum/app/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\\Stratigility\\MiddlewarePipe->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#50 /flarum/app/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\\RequestHandler->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#51 /flarum/app/vendor/middlewares/base-path-router/src/BasePathRouter.php(97): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#52 /flarum/app/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\\BasePathRouter->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#53 /flarum/app/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(42): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#54 /flarum/app/vendor/laminas/laminas-stratigility/src/Next.php(61): Laminas\\Stratigility\\Middleware\\OriginalMessages->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#55 /flarum/app/vendor/middlewares/base-path/src/BasePath.php(53): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#56 /flarum/app/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\\BasePath->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#57 /flarum/app/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#58 /flarum/app/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(73): Laminas\\Stratigility\\MiddlewarePipe->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\EmptyPipelineHandler))\n#59 /flarum/app/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(96): Laminas\\Stratigility\\MiddlewarePipe->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#60 /flarum/app/vendor/flarum/core/src/Http/Server.php(42): Laminas\\HttpHandlerRunner\\RequestHandlerRunner->run()\n#61 /flarum/app/public/index.php(26): Flarum\\Http\\Server->listen()\n#62 {main}\n\nNext Illuminate\\Database\\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'flarum_flarum_post_votes.value' in 'field list' (SQL: select sum(`flarum_flarum_post_votes`.`value`) as aggregate from `flarum_post_votes` inner join `flarum_posts` on `flarum_posts`.`id` = `flarum_post_votes`.`post_id` where `flarum_posts`.`user_id` = 1) in /flarum/app/vendor/illuminate/database/Connection.php:664\nStack trace:\n#0 /flarum/app/vendor/illuminate/database/Connection.php(624): Illuminate\\Database\\Connection->runQueryCallback('select sum(`fla...', Array, Object(Closure))\n#1 /flarum/app/vendor/illuminate/database/Connection.php(333): Illuminate\\Database\\Connection->run('select sum(`fla...', Array, Object(Closure))\n#2 /flarum/app/vendor/illuminate/database/Query/Builder.php(2095): Illuminate\\Database\\Connection->select('select sum(`fla...', Array, true)\n#3 /flarum/app/vendor/illuminate/database/Query/Builder.php(2083): Illuminate\\Database\\Query\\Builder->runSelect()\n#4 /flarum/app/vendor/illuminate/database/Query/Builder.php(2569): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()\n#5 /flarum/app/vendor/illuminate/database/Query/Builder.php(2084): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure))\n#6 /flarum/app/vendor/illuminate/database/Query/Builder.php(2496): Illuminate\\Database\\Query\\Builder->get(Array)\n#7 /flarum/app/vendor/illuminate/database/Query/Builder.php(2457): Illuminate\\Database\\Query\\Builder->aggregate('sum', Array)\n#8 /flarum/app/vendor/illuminate/database/Eloquent/Builder.php(1338): Illuminate\\Database\\Query\\Builder->sum('flarum_post_vot...')\n#9 /flarum/app/vendor/fof/gamification/src/Vote.php(62): Illuminate\\Database\\Eloquent\\Builder->__call('sum', Array)\n#10 /flarum/app/vendor/fof/gamification/src/Vote.php(71): FoF\\Gamification\\Vote::calculate(Object(Illuminate\\Database\\Eloquent\\Builder), true)\n#11 /flarum/app/vendor/fof/gamification/src/Listeners/SaveVotesToDatabase.php(150): FoF\\Gamification\\Vote::updateUserVotes(Object(Flarum\\User\\User))\n#12 /flarum/app/vendor/fof/gamification/src/Listeners/SaveVotesToDatabase.php(135): FoF\\Gamification\\Listeners\\SaveVotesToDatabase->updatePoints(Object(Flarum\\User\\User), Object(Flarum\\Post\\CommentPost))\n#13 /flarum/app/vendor/fof/gamification/src/Listeners/SaveVotesToDatabase.php(95): FoF\\Gamification\\Listeners\\SaveVotesToDatabase->vote(Object(Flarum\\Post\\CommentPost), true, false, Object(Flarum\\User\\User), Object(Flarum\\User\\User))\n#14 [internal function]: FoF\\Gamification\\Listeners\\SaveVotesToDatabase->handle(Object(Flarum\\Post\\Event\\Saving))\n#15 /flarum/app/vendor/illuminate/events/Dispatcher.php(379): call_user_func_array(Array, Array)\n#16 /flarum/app/vendor/illuminate/events/Dispatcher.php(209): Illuminate\\Events\\Dispatcher->Illuminate\\Events\\{closure}('Flarum\\\\Post\\\\Eve...', Array)\n#17 /flarum/app/vendor/flarum/core/src/Post/Command/EditPostHandler.php(81): Illuminate\\Events\\Dispatcher->dispatch('Flarum\\\\Post\\\\Eve...')\n#18 /flarum/app/vendor/illuminate/bus/Dispatcher.php(90): Flarum\\Post\\Command\\EditPostHandler->handle(Object(Flarum\\Post\\Command\\EditPost))\n#19 /flarum/app/vendor/illuminate/pipeline/Pipeline.php(128): Illuminate\\Bus\\Dispatcher->Illuminate\\Bus\\{closure}(Object(Flarum\\Post\\Command\\EditPost))\n#20 /flarum/app/vendor/illuminate/pipeline/Pipeline.php(104): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Flarum\\Post\\Command\\EditPost))\n#21 /flarum/app/vendor/illuminate/bus/Dispatcher.php(98): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))\n#22 /flarum/app/vendor/illuminate/bus/Dispatcher.php(76): Illuminate\\Bus\\Dispatcher->dispatchNow(Object(Flarum\\Post\\Command\\EditPost))\n#23 /flarum/app/vendor/flarum/core/src/Api/Controller/UpdatePostController.php(57): Illuminate\\Bus\\Dispatcher->dispatch(Object(Flarum\\Post\\Command\\EditPost))\n#24 /flarum/app/vendor/flarum/core/src/Api/Controller/AbstractSerializeController.php(96): Flarum\\Api\\Controller\\UpdatePostController->data(Object(Laminas\\Diactoros\\ServerRequest), Object(Tobscure\\JsonApi\\Document))\n#25 /flarum/app/vendor/flarum/core/src/Http/RouteHandlerFactory.php(38): Flarum\\Api\\Controller\\AbstractSerializeController->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#26 /flarum/app/vendor/flarum/core/src/Http/Middleware/DispatchRoute.php(65): Flarum\\Http\\RouteHandlerFactory->Flarum\\Http\\{closure}(Object(Laminas\\Diactoros\\ServerRequest), Array)\n#27 /flarum/app/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\DispatchRoute->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Closure))\n#28 /flarum/app/vendor/flarum/core/src/Http/Middleware/SetLocale.php(50): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#29 /flarum/app/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\SetLocale->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#30 /flarum/app/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(45): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#31 /flarum/app/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\CheckCsrfToken->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#32 /flarum/app/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(55): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#33 /flarum/app/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\AuthenticateWithHeader->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#34 /flarum/app/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(32): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#35 /flarum/app/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\AuthenticateWithSession->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#36 /flarum/app/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(51): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#37 /flarum/app/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\RememberFromCookie->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#38 /flarum/app/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#39 /flarum/app/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\StartSession->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#40 /flarum/app/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#41 /flarum/app/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Api\\Middleware\\FakeHttpMethods->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#42 /flarum/app/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#43 /flarum/app/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\ParseJsonBody->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#44 /flarum/app/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#45 /flarum/app/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\HandleErrors->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#46 /flarum/app/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#47 /flarum/app/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\\Stratigility\\MiddlewarePipe->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#48 /flarum/app/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\\RequestHandler->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#49 /flarum/app/vendor/middlewares/base-path-router/src/BasePathRouter.php(97): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#50 /flarum/app/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\\BasePathRouter->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#51 /flarum/app/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(42): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#52 /flarum/app/vendor/laminas/laminas-stratigility/src/Next.php(61): Laminas\\Stratigility\\Middleware\\OriginalMessages->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#53 /flarum/app/vendor/middlewares/base-path/src/BasePath.php(53): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#54 /flarum/app/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\\BasePath->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#55 /flarum/app/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#56 /flarum/app/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(73): Laminas\\Stratigility\\MiddlewarePipe->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\EmptyPipelineHandler))\n#57 /flarum/app/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(96): Laminas\\Stratigility\\MiddlewarePipe->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#58 /flarum/app/vendor/flarum/core/src/Http/Server.php(42): Laminas\\HttpHandlerRunner\\RequestHandlerRunner->run()\n#59 /flarum/app/public/index.php(26): Flarum\\Http\\Server->listen()\n#60 {main}"
}
]
}
I get a very similar error when trying to post new discussions or answer to an existing discussion (the former doesn't even happen, while the latter happens if you refresh).
from gamification.
I think I see the issue. When I moved from upvotes/downvotes to a value system (-1 & +1), some old code that made sure a prefix was used stopped being necessary and now breaks things.
I think the culprit is @
Lines 58 to 60 in 3b9619e
I'll investigate.
from gamification.
Related Issues (20)
- Error when permanently deleting a post HOT 2
- Tag-based voting / permission bug? HOT 3
- Bug on flarum toggles HOT 5
- Bug on /vendor/fof/gamification/src/Gamification.php::calculateHotness ? HOT 1
- Sorting by "Trending" does not stick on page refresh HOT 2
- Only my settings data not being rendered HOT 9
- Unable to enable the module HOT 2
- Enabling pluggin causes Flarum to Crash
- Option to show RankingPage-nav/IndexPage-nav in vertical (Flarum default style)
- Crashes flarum once u active plugin HOT 9
- Missing items when activating Gamification HOT 3
- Use the icon chosen in the settings for the icon inside the notifications
- The "See ranking page" permissions have stopped working (1.3.2)
- When I try to cancel an upvote or downvote, it returns a 404. HOT 1
- Unable to vote from the discussion list with the alternative layout HOT 1
- Delete posts have upvote button if gamification isn't enabled for tag
- CSS and Cache issues HOT 1
- No foreign key between post_votes and users table HOT 4
- Settings for notifications about downvote/upvote are visible even if user does not have permissions to get such notifications
- Fatal error when activating the extension HOT 3
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from gamification.