FriendsOfFlarum Webhooks

ctml

Does anyone know what conditions can lead to this bug?
FriendsOfFlarum/webhooks37

I am trying to figure out if there is a way I can workaround the issue by avoiding doing whatever causes it.

datitisev

1.0.1

Fix not all tags being available in dropdown
Improve error handling & reporting of both request & event issues
- Events should now be reported to e.g. Sentry
- Errors in the Flarum log file will now have a tiny bit more information

I've not been able to reproduce the Closure bug (FriendsOfFlarum/webhooks37) locally yet. 🤔

DursunCan

datitisev FriendsOfFlarum/webhooks38
Can you look at the error in the link?

ctml

DursunCan did you ever create this column manually (like I did a long time ago), or did you run the migrate after extension updated?

datitisev
ctml

You could rename the column temporarily, tag_id_temp, run the migrate, enable extension, if all good then remove the newly created tag_id column and then rename the old one back to tag_id.

czayorijinal

How we can solve this problem?

ctml
Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'czayonli_banasor.fl_webhooks' doesn't exist in /home/czayonli/banasor.web.tr/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18

datitisev

czayorijinal The first migration should create the table... maybe try running php flarum migrate? 🤔

czayorijinal

datitisev i am using shared hosting so i have no chance to run this code

datitisev

czayorijinal Are you able to access the DB? If so, check if there are any rows in the migrations table (fl_migrations in your case) where extension column equals fof-webhooks... if not, then try disabling & enabling the extension 🤔 might have to do so by editing enabled_extensions row in settings table if you can't access the admin page without error...

ctml

czayorijinal no shell access with that provider? I don't know if it would be allowed by the provider, but maybe a bash script under a cronjob to execute this periodically, or even a one time php script to execute it when you hit it from browser (remove php script after).

czayorijinal

datitisev

Are you saying that I should add fof-webhooks here?

datitisev

ctml The command runs when enabling & disabling extensions, so it's not completely necessary to have access for that, but it would help in debugging the issue. Access to the DB is more necessary to resolve it.

ctml

datitisev ah gotcha, I didn't realize that was the case. Silly me, I've always been running them after installing extensions! Lol

datitisev

czayorijinal If you're getting the error, that means the extension is currently enabled, right? In that case, fof-webhooks should already be in there. I mentioned it because to perform migrations you will have to re-enable an extension, and with the error you're getting I assume that's not currently possible from the website.

But first you should check the migrations table for rows that have the extension column equal to fof-webhooks.

czayorijinal

fl_migrations : 2020_12_24_create_webhooks_table
fof-webhooks

This table was deleted because of my fault or for some other reason, what should I do to get it back?

datitisev

czayorijinal If that's the only row for fof-webhooks in migrations, delete the row. Then, remove fof-webhooks from extensions_enabled, and enable it from the forum admin side as you normally would.

czayorijinal

datitisev

DEBUG:
POST https://<domain>/api/extensions/fof-webhooks

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'czayonli_banasor.fl_webhooks' doesn't exist in

czayorijinal

datitisev

should i delete these 3 lines?

czayorijinal

datitisev
I did what you said, this time it gave such an error
PDOException: SQLSTATE[HY000]: General error: 1824 Failed to open the referenced table 'fl_tags' in

datitisev

czayorijinal There should be more to this error message, I think.

czayorijinal

datitisev

[2021-07-05 19:54:22] flarum.ERROR: PDOException: SQLSTATE[HY000]: General error: 1824 Failed to open the referenced table 'fl_tags' in /home/czayonli/banasor.web.tr/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:112
Stack trace:
#0 /home/czayonli/banasor.web.tr/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(112): PDOStatement->execute(NULL)
#1 /home/czayonli/banasor.web.tr/vendor/illuminate/database/Connection.php(485): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /home/czayonli/banasor.web.tr/vendor/illuminate/database/Connection.php(685): Illuminate\Database\Connection->Illuminate\Database\{closure}('alter table `fl...', Array)
#3 /home/czayonli/banasor.web.tr/vendor/illuminate/database/Connection.php(652): Illuminate\Database\Connection->runQueryCallback('alter table `fl...', Array, Object(Closure))
#4 /home/czayonli/banasor.web.tr/vendor/illuminate/database/Connection.php(486): Illuminate\Database\Connection->run('alter table `fl...', Array, Object(Closure))
#5 /home/czayonli/banasor.web.tr/vendor/illuminate/database/Schema/Blueprint.php(109): Illuminate\Database\Connection->statement('alter table `fl...')
#6 /home/czayonli/banasor.web.tr/vendor/illuminate/database/Schema/Builder.php(365): Illuminate\Database\Schema\Blueprint->build(Object(Illuminate\Database\MySqlConnection), Object(Illuminate\Database\Schema\Grammars\MySqlGrammar))
#7 /home/czayonli/banasor.web.tr/vendor/illuminate/database/Schema/Builder.php(212): Illuminate\Database\Schema\Builder->build(Object(Illuminate\Database\Schema\Blueprint))
#8 /home/czayonli/banasor.web.tr/vendor/fof/webhooks/migrations/2020_12_27_add_tag_column.php(24): Illuminate\Database\Schema\Builder->table('webhooks', Object(Closure))
#9 [internal function]: Illuminate\Filesystem\Filesystem::{closure}(Object(Illuminate\Database\Schema\MySqlBuilder))
#10 /home/czayonli/banasor.web.tr/vendor/flarum/core/src/Database/Migrator.php(202): call_user_func(Object(Closure), Object(Illuminate\Database\Schema\MySqlBuilder))
#11 /home/czayonli/banasor.web.tr/vendor/flarum/core/src/Database/Migrator.php(133): Flarum\Database\Migrator->runClosureMigration(Array)
#12 /home/czayonli/banasor.web.tr/vendor/flarum/core/src/Database/Migrator.php(116): Flarum\Database\Migrator->runUp('/home/czayonli/...', '2020_12_27_add_...', Object(Flarum\Extension\Extension))
#13 /home/czayonli/banasor.web.tr/vendor/flarum/core/src/Database/Migrator.php(90): Flarum\Database\Migrator->runMigrationList('/home/czayonli/...', Array, Object(Flarum\Extension\Extension))
#14 /home/czayonli/banasor.web.tr/vendor/flarum/core/src/Extension/Extension.php(482): Flarum\Database\Migrator->run('/home/czayonli/...', Object(Flarum\Extension\Extension))
#15 /home/czayonli/banasor.web.tr/vendor/flarum/core/src/Extension/ExtensionManager.php(311): Flarum\Extension\Extension->migrate(Object(Flarum\Database\Migrator), 'up')
#16 /home/czayonli/banasor.web.tr/vendor/flarum/core/src/Extension/ExtensionManager.php(182): Flarum\Extension\ExtensionManager->migrate(Object(Flarum\Extension\Extension))
#17 /home/czayonli/banasor.web.tr/vendor/flarum/core/src/Api/Controller/UpdateExtensionController.php(46): Flarum\Extension\ExtensionManager->enable('fof-webhooks')
#18 /home/czayonli/banasor.web.tr/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\UpdateExtensionController->handle(Object(Laminas\Diactoros\ServerRequest))
#19 /home/czayonli/banasor.web.tr/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}(Object(Laminas\Diactoros\ServerRequest), Array)
#20 /home/czayonli/banasor.web.tr/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ExecuteRoute->process(Object(Laminas\Diactoros\ServerRequest), Object(Closure))
#21 /home/czayonli/banasor.web.tr/vendor/malago/flarum-achievements/src/Middlewares/MiddlewarePosted.php(27): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#22 /home/czayonli/banasor.web.tr/vendor/laminas/laminas-stratigility/src/Next.php(61): Malago\Achievements\Middlewares\MiddlewarePosted->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#23 /home/czayonli/banasor.web.tr/vendor/nearata/flarum-ext-twofactor/src/Http/Middleware/AuthenticateWithTwoFactor.php(37): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#24 /home/czayonli/banasor.web.tr/vendor/laminas/laminas-stratigility/src/Next.php(61): Nearata\TwoFactor\Http\Middleware\AuthenticateWithTwoFactor->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#25 /home/czayonli/banasor.web.tr/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#26 /home/czayonli/banasor.web.tr/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Api\Middleware\ThrottleApi->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#27 /home/czayonli/banasor.web.tr/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(44): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#28 /home/czayonli/banasor.web.tr/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\CheckCsrfToken->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#29 /home/czayonli/banasor.web.tr/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(67): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#30 /home/czayonli/banasor.web.tr/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ResolveRoute->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#31 /home/czayonli/banasor.web.tr/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#32 /home/czayonli/banasor.web.tr/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\SetLocale->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#33 /home/czayonli/banasor.web.tr/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(56): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#34 /home/czayonli/banasor.web.tr/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\AuthenticateWithHeader->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#35 /home/czayonli/banasor.web.tr/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#36 /home/czayonli/banasor.web.tr/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\AuthenticateWithSession->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#37 /home/czayonli/banasor.web.tr/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#38 /home/czayonli/banasor.web.tr/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\RememberFromCookie->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#39 /home/czayonli/banasor.web.tr/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#40 /home/czayonli/banasor.web.tr/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\StartSession->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#41 /home/czayonli/banasor.web.tr/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#42 /home/czayonli/banasor.web.tr/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Api\Middleware\FakeHttpMethods->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#43 /home/czayonli/banasor.web.tr/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#44 /home/czayonli/banasor.web.tr/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ParseJsonBody->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#45 /home/czayonli/banasor.web.tr/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#46 /home/czayonli/banasor.web.tr/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\HandleErrors->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#47 /home/czayonli/banasor.web.tr/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#48 /home/czayonli/banasor.web.tr/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\InjectActorReference->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#49 /home/czayonli/banasor.web.tr/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#50 /home/czayonli/banasor.web.tr/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#51 /home/czayonli/banasor.web.tr/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\RequestHandler->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#52 /home/czayonli/banasor.web.tr/vendor/middlewares/base-path-router/src/BasePathRouter.php(101): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#53 /home/czayonli/banasor.web.tr/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\BasePathRouter->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#54 /home/czayonli/banasor.web.tr/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(42): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#55 /home/czayonli/banasor.web.tr/vendor/laminas/laminas-stratigility/src/Next.php(61): Laminas\Stratigility\Middleware\OriginalMessages->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#56 /home/czayonli/banasor.web.tr/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#57 /home/czayonli/banasor.web.tr/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\BasePath->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#58 /home/czayonli/banasor.web.tr/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#59 /home/czayonli/banasor.web.tr/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ProcessIp->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#60 /home/czayonli/banasor.web.tr/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#61 /home/czayonli/banasor.web.tr/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(73): Laminas\Stratigility\MiddlewarePipe->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\EmptyPipelineHandler))
#62 /home/czayonli/banasor.web.tr/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(96): Laminas\Stratigility\MiddlewarePipe->handle(Object(Laminas\Diactoros\ServerRequest))
#63 /home/czayonli/banasor.web.tr/vendor/flarum/core/src/Http/Server.php(44): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#64 /home/czayonli/banasor.web.tr/index.php(26): Flarum\Http\Server->listen()
#65 {main}

datitisev

czayorijinal Hm, do you not have flarum/tags installed/enabled? I guess the migrations don't check whether it is installed or not, so it doesn't really work to have tags as an optional dependency 🤔

« Previous Page Next Page »