FriendsOfFlarum Gamification

Communitybuilder

fatihaysel Gamification version 0.2.6 isn't compatible to Beta 14 yet :/. 2 solutions:

Wait for updates of Gamification 0.2.7 compatible to Beta 14
Go back to Beta 13 :/

fatihaysel

i am using beta 13

clarkwinkelmann

fatihaysel what do you mean? As explained in the README, this extension is meant to REPLACE likes. Using both together is unsupported.

Do you mean the conversion from existing likes to upvotes is not working?

Pika

please forgive me, I wonder is there a plan to update this extension to be compatible with Beta14 recently?
@datitisev

cmwetherell

I am excited for this to be updated for Beta 14 💕

[deleted]

Someone using the reddit style layout here? If so, when you have upvoted discussions, does the "Trending" filter work for you?

xwiz

I'm interested in contributing. What can I do to help with Beta14 compatibility?

datity

@clarkwinkelmann @datitisev @@Kyrne @luceos
We Want Beta14 Compatibility.
This Extension Is A Fantastic Job!
Please Update As Soon As You Can,
And There Will Be Some Support From Us.
Thank You!

MartinJD

it is a cracking extenshion.

Pika

seems to this extension would be abandoned? @clarkwinkelmann @datitisev for all fof extensions be updated but this one.

clarkwinkelmann

It's not abandoned. We just haven't managed to update all extensions yet. It will come 😉

Pika

clarkwinkelmann Thank you for your glory job and wish you have a good day! Cant Wait!!!

HD3D

@clarkwinkelmann
I updated from 0.1.9 to 0.2.8 but while migrate it was stuck and I click the right button on the putty screen.
After that I tried to run the migrate command again but got mysql error.
Now I can't enable this extension on admin panel as it is giving me "500 Internal Server Error"
Help me fix it please:

POST https://www.domain.com/api/extensions/fof-gamification

{
  "errors": [
    {
      "status": "500",
      "code": "unknown",
      "detail": "PDOException: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'value' in /home/admin/web/domain.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:127\nStack trace:\n#0 /home/admin/web/domain.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(127): PDOStatement->execute(NULL)\n#1 /home/admin/web/domain.com/public_html/vendor/illuminate/database/Connection.php(458): Doctrine\\DBAL\\Driver\\PDOStatement->execute()\n#2 /home/admin/web/domain.com/public_html/vendor/illuminate/database/Connection.php(657): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('alter table `po...', Array)\n#3 /home/admin/web/domain.com/public_html/vendor/illuminate/database/Connection.php(624): Illuminate\\Database\\Connection->runQueryCallback('alter table `po...', Array, Object(Closure))\n#4 /home/admin/web/domain.com/public_html/vendor/illuminate/database/Connection.php(459): Illuminate\\Database\\Connection->run('alter table `po...', Array, Object(Closure))\n#5 /home/admin/web/domain.com/public_html/vendor/illuminate/database/Schema/Blueprint.php(97): Illuminate\\Database\\Connection->statement('alter table `po...')\n#6 /home/admin/web/domain.com/public_html/vendor/illuminate/database/Schema/Builder.php(264): Illuminate\\Database\\Schema\\Blueprint->build(Object(Illuminate\\Database\\MySqlConnection), Object(Illuminate\\Database\\Schema\\Grammars\\MySqlGrammar))\n#7 /home/admin/web/domain.com/public_html/vendor/illuminate/database/Schema/Builder.php(149): Illuminate\\Database\\Schema\\Builder->build(Object(Illuminate\\Database\\Schema\\Blueprint))\n#8 /home/admin/web/domain.com/public_html/vendor/fof/gamification/migrations/2020_07_09_000000_change_post_votes_type_column.php(20): Illuminate\\Database\\Schema\\Builder->table('post_votes', Object(Closure))\n#9 [internal function]: Illuminate\\Filesystem\\Filesystem->{closure}(Object(Illuminate\\Database\\Schema\\MySqlBuilder))\n#10 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Database/Migrator.php(197): call_user_func(Object(Closure), Object(Illuminate\\Database\\Schema\\MySqlBuilder))\n#11 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Database/Migrator.php(128): Flarum\\Database\\Migrator->runClosureMigration(Array)\n#12 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Database/Migrator.php(111): Flarum\\Database\\Migrator->runUp('/home/admin/web...', '2020_07_09_0000...', Object(Flarum\\Extension\\Extension))\n#13 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Database/Migrator.php(85): Flarum\\Database\\Migrator->runMigrationList('/home/admin/web...', Array, Object(Flarum\\Extension\\Extension))\n#14 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Extension/Extension.php(352): Flarum\\Database\\Migrator->run('/home/admin/web...', Object(Flarum\\Extension\\Extension))\n#15 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Extension/ExtensionManager.php(246): Flarum\\Extension\\Extension->migrate(Object(Flarum\\Database\\Migrator), 'up')\n#16 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Extension/ExtensionManager.php(139): Flarum\\Extension\\ExtensionManager->migrate(Object(Flarum\\Extension\\Extension))\n#17 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Api/Controller/UpdateExtensionController.php(48): Flarum\\Extension\\ExtensionManager->enable('fof-gamificatio...')\n#18 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Http/RouteHandlerFactory.php(38): Flarum\\Api\\Controller\\UpdateExtensionController->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#19 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Http/Middleware/DispatchRoute.php(65): Flarum\\Http\\RouteHandlerFactory->Flarum\\Http\\{closure}(Object(Laminas\\Diactoros\\ServerRequest), Array)\n#20 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\DispatchRoute->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Closure))\n#21 /home/admin/web/domain.com/public_html/vendor/kilowhat/flarum-ext-audit-free/src/Middlewares/SetLoggerActor.php(28): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#22 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Kilowhat\\Audit\\Middlewares\\SetLoggerActor->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#23 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Http/Middleware/SetLocale.php(50): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#24 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\SetLocale->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#25 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(45): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#26 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\CheckCsrfToken->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#27 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(55): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#28 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\AuthenticateWithHeader->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#29 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(32): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#30 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\AuthenticateWithSession->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#31 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(51): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#32 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\RememberFromCookie->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#33 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#34 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\StartSession->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#35 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#36 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Api\\Middleware\\FakeHttpMethods->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#37 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#38 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\ParseJsonBody->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#39 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#40 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\HandleErrors->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#41 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#42 /home/admin/web/domain.com/public_html/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\\Stratigility\\MiddlewarePipe->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#43 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\\RequestHandler->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#44 /home/admin/web/domain.com/public_html/vendor/middlewares/base-path-router/src/BasePathRouter.php(97): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#45 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\\BasePathRouter->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#46 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(42): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#47 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Laminas\\Stratigility\\Middleware\\OriginalMessages->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#48 /home/admin/web/domain.com/public_html/vendor/middlewares/base-path/src/BasePath.php(53): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#49 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\\BasePath->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#50 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#51 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(73): Laminas\\Stratigility\\MiddlewarePipe->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\EmptyPipelineHandler))\n#52 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(96): Laminas\\Stratigility\\MiddlewarePipe->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#53 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Http/Server.php(42): Laminas\\HttpHandlerRunner\\RequestHandlerRunner->run()\n#54 /home/admin/web/domain.com/public_html/index.php(22): Flarum\\Http\\Server->listen()\n#55 {main}\n\nNext Doctrine\\DBAL\\Driver\\PDOException: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'value' in /home/admin/web/domain.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:129\nStack trace:\n#0 /home/admin/web/domain.com/public_html/vendor/illuminate/database/Connection.php(458): Doctrine\\DBAL\\Driver\\PDOStatement->execute()\n#1 /home/admin/web/domain.com/public_html/vendor/illuminate/database/Connection.php(657): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('alter table `po...', Array)\n#2 /home/admin/web/domain.com/public_html/vendor/illuminate/database/Connection.php(624): Illuminate\\Database\\Connection->runQueryCallback('alter table `po...', Array, Object(Closure))\n#3 /home/admin/web/domain.com/public_html/vendor/illuminate/database/Connection.php(459): Illuminate\\Database\\Connection->run('alter table `po...', Array, Object(Closure))\n#4 /home/admin/web/domain.com/public_html/vendor/illuminate/database/Schema/Blueprint.php(97): Illuminate\\Database\\Connection->statement('alter table `po...')\n#5 /home/admin/web/domain.com/public_html/vendor/illuminate/database/Schema/Builder.php(264): Illuminate\\Database\\Schema\\Blueprint->build(Object(Illuminate\\Database\\MySqlConnection), Object(Illuminate\\Database\\Schema\\Grammars\\MySqlGrammar))\n#6 /home/admin/web/domain.com/public_html/vendor/illuminate/database/Schema/Builder.php(149): Illuminate\\Database\\Schema\\Builder->build(Object(Illuminate\\Database\\Schema\\Blueprint))\n#7 /home/admin/web/domain.com/public_html/vendor/fof/gamification/migrations/2020_07_09_000000_change_post_votes_type_column.php(20): Illuminate\\Database\\Schema\\Builder->table('post_votes', Object(Closure))\n#8 [internal function]: Illuminate\\Filesystem\\Filesystem->{closure}(Object(Illuminate\\Database\\Schema\\MySqlBuilder))\n#9 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Database/Migrator.php(197): call_user_func(Object(Closure), Object(Illuminate\\Database\\Schema\\MySqlBuilder))\n#10 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Database/Migrator.php(128): Flarum\\Database\\Migrator->runClosureMigration(Array)\n#11 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Database/Migrator.php(111): Flarum\\Database\\Migrator->runUp('/home/admin/web...', '2020_07_09_0000...', Object(Flarum\\Extension\\Extension))\n#12 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Database/Migrator.php(85): Flarum\\Database\\Migrator->runMigrationList('/home/admin/web...', Array, Object(Flarum\\Extension\\Extension))\n#13 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Extension/Extension.php(352): Flarum\\Database\\Migrator->run('/home/admin/web...', Object(Flarum\\Extension\\Extension))\n#14 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Extension/ExtensionManager.php(246): Flarum\\Extension\\Extension->migrate(Object(Flarum\\Database\\Migrator), 'up')\n#15 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Extension/ExtensionManager.php(139): Flarum\\Extension\\ExtensionManager->migrate(Object(Flarum\\Extension\\Extension))\n#16 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Api/Controller/UpdateExtensionController.php(48): Flarum\\Extension\\ExtensionManager->enable('fof-gamificatio...')\n#17 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Http/RouteHandlerFactory.php(38): Flarum\\Api\\Controller\\UpdateExtensionController->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#18 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Http/Middleware/DispatchRoute.php(65): Flarum\\Http\\RouteHandlerFactory->Flarum\\Http\\{closure}(Object(Laminas\\Diactoros\\ServerRequest), Array)\n#19 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\DispatchRoute->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Closure))\n#20 /home/admin/web/domain.com/public_html/vendor/kilowhat/flarum-ext-audit-free/src/Middlewares/SetLoggerActor.php(28): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#21 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Kilowhat\\Audit\\Middlewares\\SetLoggerActor->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#22 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Http/Middleware/SetLocale.php(50): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#23 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\SetLocale->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#24 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(45): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#25 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\CheckCsrfToken->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#26 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(55): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#27 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\AuthenticateWithHeader->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#28 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(32): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#29 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\AuthenticateWithSession->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#30 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(51): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#31 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\RememberFromCookie->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#32 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#33 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\StartSession->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#34 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#35 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Api\\Middleware\\FakeHttpMethods->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#36 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#37 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\ParseJsonBody->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#38 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#39 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\HandleErrors->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#40 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#41 /home/admin/web/domain.com/public_html/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\\Stratigility\\MiddlewarePipe->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#42 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\\RequestHandler->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#43 /home/admin/web/domain.com/public_html/vendor/middlewares/base-path-router/src/BasePathRouter.php(97): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#44 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\\BasePathRouter->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#45 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(42): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#46 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Laminas\\Stratigility\\Middleware\\OriginalMessages->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#47 /home/admin/web/domain.com/public_html/vendor/middlewares/base-path/src/BasePath.php(53): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#48 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\\BasePath->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#49 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#50 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(73): Laminas\\Stratigility\\MiddlewarePipe->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\EmptyPipelineHandler))\n#51 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(96): Laminas\\Stratigility\\MiddlewarePipe->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#52 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Http/Server.php(42): Laminas\\HttpHandlerRunner\\RequestHandlerRunner->run()\n#53 /home/admin/web/domain.com/public_html/index.php(22): Flarum\\Http\\Server->listen()\n#54 {main}\n\nNext Illuminate\\Database\\QueryException: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'value' (SQL: alter table `post_votes` add `value` int not null default '0') in /home/admin/web/domain.com/public_html/vendor/illuminate/database/Connection.php:664\nStack trace:\n#0 /home/admin/web/domain.com/public_html/vendor/illuminate/database/Connection.php(624): Illuminate\\Database\\Connection->runQueryCallback('alter table `po...', Array, Object(Closure))\n#1 /home/admin/web/domain.com/public_html/vendor/illuminate/database/Connection.php(459): Illuminate\\Database\\Connection->run('alter table `po...', Array, Object(Closure))\n#2 /home/admin/web/domain.com/public_html/vendor/illuminate/database/Schema/Blueprint.php(97): Illuminate\\Database\\Connection->statement('alter table `po...')\n#3 /home/admin/web/domain.com/public_html/vendor/illuminate/database/Schema/Builder.php(264): Illuminate\\Database\\Schema\\Blueprint->build(Object(Illuminate\\Database\\MySqlConnection), Object(Illuminate\\Database\\Schema\\Grammars\\MySqlGrammar))\n#4 /home/admin/web/domain.com/public_html/vendor/illuminate/database/Schema/Builder.php(149): Illuminate\\Database\\Schema\\Builder->build(Object(Illuminate\\Database\\Schema\\Blueprint))\n#5 /home/admin/web/domain.com/public_html/vendor/fof/gamification/migrations/2020_07_09_000000_change_post_votes_type_column.php(20): Illuminate\\Database\\Schema\\Builder->table('post_votes', Object(Closure))\n#6 [internal function]: Illuminate\\Filesystem\\Filesystem->{closure}(Object(Illuminate\\Database\\Schema\\MySqlBuilder))\n#7 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Database/Migrator.php(197): call_user_func(Object(Closure), Object(Illuminate\\Database\\Schema\\MySqlBuilder))\n#8 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Database/Migrator.php(128): Flarum\\Database\\Migrator->runClosureMigration(Array)\n#9 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Database/Migrator.php(111): Flarum\\Database\\Migrator->runUp('/home/admin/web...', '2020_07_09_0000...', Object(Flarum\\Extension\\Extension))\n#10 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Database/Migrator.php(85): Flarum\\Database\\Migrator->runMigrationList('/home/admin/web...', Array, Object(Flarum\\Extension\\Extension))\n#11 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Extension/Extension.php(352): Flarum\\Database\\Migrator->run('/home/admin/web...', Object(Flarum\\Extension\\Extension))\n#12 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Extension/ExtensionManager.php(246): Flarum\\Extension\\Extension->migrate(Object(Flarum\\Database\\Migrator), 'up')\n#13 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Extension/ExtensionManager.php(139): Flarum\\Extension\\ExtensionManager->migrate(Object(Flarum\\Extension\\Extension))\n#14 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Api/Controller/UpdateExtensionController.php(48): Flarum\\Extension\\ExtensionManager->enable('fof-gamificatio...')\n#15 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Http/RouteHandlerFactory.php(38): Flarum\\Api\\Controller\\UpdateExtensionController->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#16 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Http/Middleware/DispatchRoute.php(65): Flarum\\Http\\RouteHandlerFactory->Flarum\\Http\\{closure}(Object(Laminas\\Diactoros\\ServerRequest), Array)\n#17 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\DispatchRoute->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Closure))\n#18 /home/admin/web/domain.com/public_html/vendor/kilowhat/flarum-ext-audit-free/src/Middlewares/SetLoggerActor.php(28): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#19 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Kilowhat\\Audit\\Middlewares\\SetLoggerActor->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#20 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Http/Middleware/SetLocale.php(50): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#21 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\SetLocale->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#22 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(45): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#23 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\CheckCsrfToken->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#24 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(55): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#25 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\AuthenticateWithHeader->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#26 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(32): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#27 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\AuthenticateWithSession->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#28 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(51): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#29 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\RememberFromCookie->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#30 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#31 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\StartSession->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#32 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#33 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Api\\Middleware\\FakeHttpMethods->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#34 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#35 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\ParseJsonBody->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#36 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#37 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\HandleErrors->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#38 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#39 /home/admin/web/domain.com/public_html/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\\Stratigility\\MiddlewarePipe->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#40 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\\RequestHandler->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#41 /home/admin/web/domain.com/public_html/vendor/middlewares/base-path-router/src/BasePathRouter.php(97): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#42 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\\BasePathRouter->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#43 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(42): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#44 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Laminas\\Stratigility\\Middleware\\OriginalMessages->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#45 /home/admin/web/domain.com/public_html/vendor/middlewares/base-path/src/BasePath.php(53): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#46 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\\BasePath->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#47 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#48 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(73): Laminas\\Stratigility\\MiddlewarePipe->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\EmptyPipelineHandler))\n#49 /home/admin/web/domain.com/public_html/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(96): Laminas\\Stratigility\\MiddlewarePipe->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#50 /home/admin/web/domain.com/public_html/vendor/flarum/core/src/Http/Server.php(42): Laminas\\HttpHandlerRunner\\RequestHandlerRunner->run()\n#51 /home/admin/web/domain.com/public_html/index.php(22): Flarum\\Http\\Server->listen()\n#52 {main}"
    }
  ]
}

HD3D

HD3D @datitisev help please

clarkwinkelmann

HD3D I'm not sure whether there's an issue with Gamification itself or not, but to solve this you will need to manually add/remove columns to the database, or add the migration to the migrations table to tell Flarum it has already run so it can skip it.

You can see what each migration does here https://github.com/FriendsOfFlarum/gamification/tree/master/migrations Gamification has a lot of them. I think your error happens in https://github.com/FriendsOfFlarum/gamification/blob/3b9619ef779e38391c23ed97018136c07fcf6176/migrations/2020_07_09_000000_change_post_votes_type_column.php . If you already have that column, you can manually add an entry for 2020_07_09_000000_change_post_votes_type_column - fof-gamification in the migrations table.

Seeing that migration has a big loop in it, I suspect you tried to run it once on a large amount of data and it must have failed mid-way. To avoid this in the future, always try to run php flarum migrate from the command line instead of disabling and re-enabling extensions, and make sure the command line has unlimited execution time and enough memory.

If the script indeed failed during that migration, you most likely have a partially migrated database from simple votes to value-based votes. You would know if that's the case if you still have the type column on post_votes which is supposed to be deleted at the end of the migration. You might want to restore from backup and attempt the migration again to make sure your database integrity is good.

HD3D

clarkwinkelmann Yes I do have type column on post_votes

I'm not good at database so I don't think I can perform above steps, but if I restore yesterday's backup of database, is it not gonna delete all posts and discussions from yesterday till now?

I don't want to lose posts at all, so what should I do? I mean if it is that hard to fix it then can I still run my forum normally without gamification with that error or is removing gamification and reinstalling it gonna fix the database itself?

Currently my forum is running fine without gamification extension enabled.

clarkwinkelmann

HD3D I think the easiest solution might be to remove the value column manually, enable the extension by adding the fof-gamification ID to the list of enabled extensions in the enabled_extensions key in the settings table (it's a JSON-encoded array), then run php flarum migrate.

Enabling the extension via the frontend would probably result in the same error happening again if it's due to the request timing out, so enabling it by editing the settings table then running the migration on the command line should succeed.

Obviously, it's best to make one more backup just before this procedure.

To prevent this kind of issue for happening again (assuming it was a request timeout that created the issue in the first place), you should always have all extensions enabled while you perform an update, so that you can run php flarum migrate. But I know there's a bit of a contradiction here with Flarum update steps since Flarum update recommends disabling extensions, but then this leads to migrations running on the web server instead of the command line and could time out migrations like these.

I hope my explanations are not too confusing 😅

HD3D

clarkwinkelmann 😕
It is more than confusing sir.

If you can guide me though the exact steps I need to follow but what you're telling me all just hints, that's where I have no idea how to follow because I don't have good knowledge in mysql.
All I have is phpmyadmin so it will be a lot easier if you can help me with the commands that need to run to fix gamification.

But if it is that hard, I better not mess up with the database, so is it safe to remove the gamification extension through ssh and reinstall or it or just remove it and run the forum without it?

clarkwinkelmann

HD3D you might want to use the help of a freelancer to cleanly update or remove the extension at this point.

Keeping the database like it is with the extension disabled is probably fine, and you can remove the extension with Composer. However you can't re-install the extension without first manually fixing the database.

Kyrne

0.3.1

Beta 14
Small change to hotness algorithm
Use native sort for trending

php flarum cache:clear

xwiz

Nice work Kyrne

@luuhai48 Check the update from @Kyrne to see if there's an improvement you can contribute.

Pika

fantastic job! Thanks for you guys' working! Kyrne @clarkwinkelmann

« Previous Page Next Page »