Giter VIP home page Giter VIP logo

Comments (2)

Braintelligence avatar Braintelligence commented on July 26, 2024

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.

dsevillamartin avatar dsevillamartin commented on July 26, 2024

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 @

if ($advanced) {
$prefix = self::query()->getConnection()->getTablePrefix().(new self())->getTable().'.';
}
.

I'll investigate.

from gamification.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo 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.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.