askvortsov
As I explored so far, after upgraded anything to the latest version ( flarum 1.7.2 / iOS 16.4( which is the latest version that officially supports push notifications of an web-app/ pwa 3.1.4), only Someone mentions a group I'm a member of in a post
can successfully trigger a push notification on my apple device now. Since there is something can be successfully pushed, I don't think the push notification is not working.
Someone mentions a group I'm a member of in a post
was implemented in flarum since 1.7 as I remember, so maybe there are something subtle changed for this mention feature?(only guess, I know nothing about the code)
I turned on the debug mode of pwa, I don't know if there are anything related to the issue on the log:
#17 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/bus/Dispatcher.php(128): Illuminate\Container\Container->call()
#18 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/pipeline/Pipeline.php(128): Illuminate\Bus\Dispatcher->Illuminate\Bus{closure}()
#19 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/clarkwinkelmann/flarum-ext-anonymous-posting/src/FakeUserRelation/FakeUserHydratorPipe.php(17): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}()
#20 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/pipeline/Pipeline.php(167): ClarkWinkelmann\AnonymousPosting\FakeUserRelation\FakeUserHydratorPipe->handle()
#21 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/pipeline/Pipeline.php(103): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}()
#22 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()
#23 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/queue/CallQueuedHandler.php(120): Illuminate\Bus\Dispatcher->dispatchNow()
#24 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/pipeline/Pipeline.php(128): Illuminate\Queue\CallQueuedHandler->Illuminate\Queue{closure}()
#25 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/pipeline/Pipeline.php(103): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}()
#26 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/queue/CallQueuedHandler.php(122): Illuminate\Pipeline\Pipeline->then()
#27 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/queue/CallQueuedHandler.php(70): Illuminate\Queue\CallQueuedHandler->dispatchThroughMiddleware()
#28 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/queue/Jobs/Job.php(98): Illuminate\Queue\CallQueuedHandler->call()
#29 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/queue/Worker.php(428): Illuminate\Queue\Jobs\Job->fire()
#30 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/queue/Worker.php(378): Illuminate\Queue\Worker->process()
#31 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/queue/Worker.php(172): Illuminate\Queue\Worker->runJob()
#32 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/queue/Console/WorkCommand.php(117): Illuminate\Queue\Worker->daemon()
#33 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/queue/Console/WorkCommand.php(101): Illuminate\Queue\Console\WorkCommand->runWorker()
#34 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/container/BoundMethod.php(36): Illuminate\Queue\Console\WorkCommand->handle()
#35 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/container/Util.php(40): Illuminate\Container\BoundMethod::Illuminate\Container{closure}()
#36 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#37 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#38 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/container/Container.php(653): Illuminate\Container\BoundMethod::call()
#39 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/console/Command.php(136): Illuminate\Container\Container->call()
#40 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/symfony/console/Command/Command.php(298): Illuminate\Console\Command->execute()
#41 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/console/Command.php(121): Symfony\Component\Console\Command\Command->run()
#42 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/symfony/console/Application.php(1058): Illuminate\Console\Command->run()
#43 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#44 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#45 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/flarum/core/src/Console/Server.php(42): Symfony\Component\Console\Application->run()
#46 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/flarum(24): Flarum\Console\Server->listen()
#47 {main}
Next Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'last_used' in 'field list' (SQL: update push_subscriptions
set last_used
= 2023-04-14 14:39:02 where id
= 34731) in /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/database/Connection.php:712
Stack trace:
#0 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback()
#1 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/database/Connection.php(533): Illuminate\Database\Connection->run()
#2 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/database/Connection.php(466): Illuminate\Database\Connection->affectingStatement()
#3 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/database/Query/Builder.php(3063): Illuminate\Database\Connection->update()
#4 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/database/Eloquent/Builder.php(921): Illuminate\Database\Query\Builder->update()
#5 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/database/Eloquent/Model.php(1072): Illuminate\Database\Eloquent\Builder->update()
#6 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/database/Eloquent/Model.php(987): Illuminate\Database\Eloquent\Model->performUpdate()
#7 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/askvortsov/flarum-pwa/src/PushSender.php(139): Illuminate\Database\Eloquent\Model->save()
#8 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/askvortsov/flarum-pwa/src/Job/SendPushNotificationsJob.php(39): Askvortsov\FlarumPWA\PushSender->notify()
#9 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/container/BoundMethod.php(36): Askvortsov\FlarumPWA\Job\SendPushNotificationsJob->handle()
#10 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/container/Util.php(40): Illuminate\Container\BoundMethod::Illuminate\Container{closure}()
#11 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#12 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#13 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/container/Container.php(653): Illuminate\Container\BoundMethod::call()
#14 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/bus/Dispatcher.php(128): Illuminate\Container\Container->call()
#15 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/pipeline/Pipeline.php(128): Illuminate\Bus\Dispatcher->Illuminate\Bus{closure}()
#16 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/clarkwinkelmann/flarum-ext-anonymous-posting/src/FakeUserRelation/FakeUserHydratorPipe.php(17): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}()
#17 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/pipeline/Pipeline.php(167): ClarkWinkelmann\AnonymousPosting\FakeUserRelation\FakeUserHydratorPipe->handle()
#18 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/pipeline/Pipeline.php(103): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}()
#19 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()
#20 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/queue/CallQueuedHandler.php(120): Illuminate\Bus\Dispatcher->dispatchNow()
#21 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/pipeline/Pipeline.php(128): Illuminate\Queue\CallQueuedHandler->Illuminate\Queue{closure}()
#22 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/pipeline/Pipeline.php(103): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}()
#23 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/queue/CallQueuedHandler.php(122): Illuminate\Pipeline\Pipeline->then()
#24 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/queue/CallQueuedHandler.php(70): Illuminate\Queue\CallQueuedHandler->dispatchThroughMiddleware()
#25 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/queue/Jobs/Job.php(98): Illuminate\Queue\CallQueuedHandler->call()
#26 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/queue/Worker.php(428): Illuminate\Queue\Jobs\Job->fire()
#27 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/queue/Worker.php(378): Illuminate\Queue\Worker->process()
#28 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/queue/Worker.php(172): Illuminate\Queue\Worker->runJob()
#29 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/queue/Console/WorkCommand.php(117): Illuminate\Queue\Worker->daemon()
#30 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/queue/Console/WorkCommand.php(101): Illuminate\Queue\Console\WorkCommand->runWorker()
#31 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/container/BoundMethod.php(36): Illuminate\Queue\Console\WorkCommand->handle()
#32 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/container/Util.php(40): Illuminate\Container\BoundMethod::Illuminate\Container{closure}()
#33 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#34 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#35 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/container/Container.php(653): Illuminate\Container\BoundMethod::call()
#36 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/console/Command.php(136): Illuminate\Container\Container->call()
#37 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/symfony/console/Command/Command.php(298): Illuminate\Console\Command->execute()
#38 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/console/Command.php(121): Symfony\Component\Console\Command\Command->run()
#39 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/symfony/console/Application.php(1058): Illuminate\Console\Command->run()
#40 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#41 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#42 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/flarum/core/src/Console/Server.php(42): Symfony\Component\Console\Application->run()
#43 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/flarum(24): Flarum\Console\Server->listen()
#44 {main}
[2023-04-14 14:39:02] flarum.ERROR: Illuminate\Queue\MaxAttemptsExceededException: Askvortsov\FlarumPWA\Job\SendPushNotificationsJob has been attempted too many times or run too long. The job may have previously timed out. in /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/queue/Worker.php:750
Stack trace:
#0 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/queue/Worker.php(504): Illuminate\Queue\Worker->maxAttemptsExceededException()
#1 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/queue/Worker.php(418): Illuminate\Queue\Worker->markJobAsFailedIfAlreadyExceedsMaxAttempts()
#2 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/queue/Worker.php(378): Illuminate\Queue\Worker->process()
#3 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/queue/Worker.php(172): Illuminate\Queue\Worker->runJob()
#4 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/queue/Console/WorkCommand.php(117): Illuminate\Queue\Worker->daemon()
#5 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/queue/Console/WorkCommand.php(101): Illuminate\Queue\Console\WorkCommand->runWorker()
#6 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/container/BoundMethod.php(36): Illuminate\Queue\Console\WorkCommand->handle()
#7 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/container/Util.php(40): Illuminate\Container\BoundMethod::Illuminate\Container{closure}()
#8 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#9 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#10 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/container/Container.php(653): Illuminate\Container\BoundMethod::call()
#11 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/console/Command.php(136): Illuminate\Container\Container->call()
#12 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/symfony/console/Command/Command.php(298): Illuminate\Console\Command->execute()
#13 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/console/Command.php(121): Symfony\Component\Console\Command\Command->run()
#14 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/symfony/console/Application.php(1058): Illuminate\Console\Command->run()
#15 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#16 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#17 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/flarum/core/src/Console/Server.php(42): Symfony\Component\Console\Application->run()
#18 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/flarum(24): Flarum\Console\Server->listen()
#19 {main}
[2023-04-14 14:39:02] flarum.ERROR: Illuminate\Queue\MaxAttemptsExceededException: Askvortsov\FlarumPWA\Job\SendPushNotificationsJob has been attempted too many times or run too long. The job may have previously timed out. in /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/queue/Worker.php:750
Stack trace:
#0 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/queue/Worker.php(504): Illuminate\Queue\Worker->maxAttemptsExceededException()
#1 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/queue/Worker.php(418): Illuminate\Queue\Worker->markJobAsFailedIfAlreadyExceedsMaxAttempts()
#2 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/queue/Worker.php(378): Illuminate\Queue\Worker->process()
#3 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/queue/Worker.php(172): Illuminate\Queue\Worker->runJob()
#4 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/queue/Console/WorkCommand.php(117): Illuminate\Queue\Worker->daemon()
#5 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/queue/Console/WorkCommand.php(101): Illuminate\Queue\Console\WorkCommand->runWorker()
#6 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/container/BoundMethod.php(36): Illuminate\Queue\Console\WorkCommand->handle()
#7 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/container/Util.php(40): Illuminate\Container\BoundMethod::Illuminate\Container{closure}()
#8 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#9 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#10 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/container/Container.php(653): Illuminate\Container\BoundMethod::call()
#11 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/console/Command.php(136): Illuminate\Container\Container->call()
#12 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/symfony/console/Command/Command.php(298): Illuminate\Console\Command->execute()
#13 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/illuminate/console/Command.php(121): Symfony\Component\Console\Command\Command->run()
#14 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/symfony/console/Application.php(1058): Illuminate\Console\Command->run()
#15 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#16 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#17 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/vendor/flarum/core/src/Console/Server.php(42): Symfony\Component\Console\Application->run()
#18 /www/wwwroot/www.xn--fmrv2rkpbv8uymm.com/flarum(24): Flarum\Console\Server->listen()
#19 {main}
!<
And as I noticed, every time that actually triggers the push notification is a Failed procession in worker.log