Whisper - Encryption-less Private Messaging

Bbsonet · Jul 22, 2021

Confirm problem above.
Plus would be nice to be able to delete conversations in two ways:

any user can delete his own window chat
cleaning DB by admin....like deleting post older than XX days. DB isnt endless ><

xasharma · Jul 22, 2021

thimiraonline

Same ... sometimes it shows up to 15-20

Kyrne · Jul 22, 2021

xasharma

thimiraonline

0.1.1

Fix for negative unread messages.

Aaksh · Jul 22, 2021

Bro you're amazing! Installing this right now...

thimiraonline · Jul 22, 2021

Kyrne Is this working with Pusher? I installed Websocket and I have to refresh home screen to load new and updated discussions. It's not updating in real-time. Are there any special settings that I have made to websocket?

Kyrne · Jul 22, 2021

thimiraonline unfortunately it's not as easy as just installing websocket. Please follow the install guide here: https://github.com/KyrneDev/websocket#websocket-by-kyrne

xasharma · Jul 22, 2021

Kyrne

The extension is not turning on

Is there any problem with database?

Kyrne · Jul 22, 2021

xasharma enable debug mode and try again

xasharma · Jul 22, 2021

Kyrne

Kyrne · Jul 22, 2021

xasharma did you use shout previously?

Kyrne If you have previously used Shout, you will need to drop the conversations messages and conversation_user tables. As well as remove the unread_messages field on the users table.

xasharma · Jul 22, 2021

Kyrne

NO, I was trying it on localhost before using it (whisper) on my main site .... Every time It is showing 15 messages unread (only for 1 user) ... So I thought I should clear the data by uninstalling it, After that it stopped working and then i removed it and reinstalled then also same error.

Ralkage · Jul 22, 2021

xasharma most likely due to https://github.com/KyrneDev/whisper/blob/master/migrations/2020_03_27_170413_create_conversations_table.php#L27; the conversations table is prefixed in the down method but not in the up method so it didn't drop the conversations table when you uninstalled the extension.

xasharma · Jul 22, 2021

Kyrne

Debug file - https://hastebin.com/eborefayox.typescript

thimiraonline · Jul 22, 2021

Kyrne I'm running on a Bitnami stack. Do you have any idea about the configuration?

Ppkernstock · Jul 22, 2021

Kyrne Current Limitations

Only supports Websockets.

Are you referring to your own WebSockets implementation/extension, or just any sort of websocket extension implementation? (Like the one from blomstra). I think the first, but can you quickly confirm? Thanks!

Kyrne · Jul 22, 2021

Ralkage thanks man!

0.1.2

fix down migration

pkernstock

I don't have access to a copy of the real-time extension so I can't tell for sure. In my post I am referring to my extension.

Ppkernstock · Jul 22, 2021

Kyrne I don't have access to a copy of the real-time extension so I can't tell for sure. In my post I am referring to my extension.

Between the lines it sounds like Whisper uses some generic APIs under-the-hood, so that realtime could work here too. If so, I'm happy to test it out on the weekend or so and report back accordingly.

mekici · Jul 23, 2021

Kyrne

If you have previously used Shout, you will need to drop the conversations messages and conversation_user tables. As well as remove the unread_messages field on the users table.

As said, I removed the conversations, messages, conversation_user tables. I removed the unread_messages column in the Users table. I can't activate the plugin in the admin panel. The error logs are as follows.

When trying to activate the extension, I see that it rewrites the same tables to the database. However, the extension is not active.

[2021-07-23 09:59:04] flarum.ERROR: PDOException: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'conversation_user' already exists in /var/www/flarumtr/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:112
Stack trace:
#0 /var/www/flarumtr/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(112): PDOStatement->execute()
#1 /var/www/flarumtr/vendor/illuminate/database/Connection.php(485): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /var/www/flarumtr/vendor/illuminate/database/Connection.php(685): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /var/www/flarumtr/vendor/illuminate/database/Connection.php(652): Illuminate\Database\Connection->runQueryCallback()
#4 /var/www/flarumtr/vendor/illuminate/database/Connection.php(486): Illuminate\Database\Connection->run()
#5 /var/www/flarumtr/vendor/illuminate/database/Schema/Blueprint.php(109): Illuminate\Database\Connection->statement()
#6 /var/www/flarumtr/vendor/illuminate/database/Schema/Builder.php(365): Illuminate\Database\Schema\Blueprint->build()
#7 /var/www/flarumtr/vendor/illuminate/database/Schema/Builder.php(228): Illuminate\Database\Schema\Builder->build()
#8 /var/www/flarumtr/vendor/kyrne/whisper/migrations/2020_05_28_164214_create_conversation_user_table.php(28): Illuminate\Database\Schema\Builder->create()
#9 [internal function]: Illuminate\Filesystem\Filesystem::{closure}()
#10 /var/www/flarumtr/vendor/flarum/core/src/Database/Migrator.php(202): call_user_func()
#11 /var/www/flarumtr/vendor/flarum/core/src/Database/Migrator.php(133): Flarum\Database\Migrator->runClosureMigration()
#12 /var/www/flarumtr/vendor/flarum/core/src/Database/Migrator.php(116): Flarum\Database\Migrator->runUp()
#13 /var/www/flarumtr/vendor/flarum/core/src/Database/Migrator.php(90): Flarum\Database\Migrator->runMigrationList()
#14 /var/www/flarumtr/vendor/flarum/core/src/Extension/Extension.php(482): Flarum\Database\Migrator->run()
#15 /var/www/flarumtr/vendor/flarum/core/src/Extension/ExtensionManager.php(311): Flarum\Extension\Extension->migrate()
#16 /var/www/flarumtr/vendor/flarum/core/src/Extension/ExtensionManager.php(182): Flarum\Extension\ExtensionManager->migrate()
#17 /var/www/flarumtr/vendor/flarum/core/src/Api/Controller/UpdateExtensionController.php(46): Flarum\Extension\ExtensionManager->enable()
#18 /var/www/flarumtr/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\UpdateExtensionController->handle()
#19 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#20 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\ExecuteRoute->process()
#21 /var/www/flarumtr/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#22 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Api\Middleware\ThrottleApi->process()
#23 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(44): Laminas\Stratigility\Next->handle()
#24 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\CheckCsrfToken->process()
#25 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(67): Laminas\Stratigility\Next->handle()
#26 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\ResolveRoute->process()
#27 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#28 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\SetLocale->process()
#29 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(56): Laminas\Stratigility\Next->handle()
#30 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\AuthenticateWithHeader->process()
#31 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle()
#32 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\AuthenticateWithSession->process()
#33 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle()
#34 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\RememberFromCookie->process()
#35 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#36 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\StartSession->process()
#37 /var/www/flarumtr/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\Stratigility\Next->handle()
#38 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Api\Middleware\FakeHttpMethods->process()
#39 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle()
#40 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\ParseJsonBody->process()
#41 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#42 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\HandleErrors->process()
#43 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle()
#44 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\InjectActorReference->process()
#45 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(76): Laminas\Stratigility\Next->handle()
#46 /var/www/flarumtr/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process()
#47 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Middlewares\RequestHandler->process()
#48 /var/www/flarumtr/vendor/middlewares/base-path-router/src/BasePathRouter.php(101): Laminas\Stratigility\Next->handle()
#49 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Middlewares\BasePathRouter->process()
#50 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(36): Laminas\Stratigility\Next->handle()
#51 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Laminas\Stratigility\Middleware\OriginalMessages->process()
#52 /var/www/flarumtr/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle()
#53 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Middlewares\BasePath->process()
#54 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle()
#55 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\ProcessIp->process()
#56 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(76): Laminas\Stratigility\Next->handle()
#57 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(65): Laminas\Stratigility\MiddlewarePipe->process()
#58 /var/www/flarumtr/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(96): Laminas\Stratigility\MiddlewarePipe->handle()
#59 /var/www/flarumtr/vendor/flarum/core/src/Http/Server.php(44): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#60 /var/www/flarumtr/public/index.php(26): Flarum\Http\Server->listen()
#61 {main}

Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'conversation_user' already exists in /var/www/flarumtr/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /var/www/flarumtr/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(114): Doctrine\DBAL\Driver\PDO\Exception::new()
#1 /var/www/flarumtr/vendor/illuminate/database/Connection.php(485): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /var/www/flarumtr/vendor/illuminate/database/Connection.php(685): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /var/www/flarumtr/vendor/illuminate/database/Connection.php(652): Illuminate\Database\Connection->runQueryCallback()
#4 /var/www/flarumtr/vendor/illuminate/database/Connection.php(486): Illuminate\Database\Connection->run()
#5 /var/www/flarumtr/vendor/illuminate/database/Schema/Blueprint.php(109): Illuminate\Database\Connection->statement()
#6 /var/www/flarumtr/vendor/illuminate/database/Schema/Builder.php(365): Illuminate\Database\Schema\Blueprint->build()
#7 /var/www/flarumtr/vendor/illuminate/database/Schema/Builder.php(228): Illuminate\Database\Schema\Builder->build()
#8 /var/www/flarumtr/vendor/kyrne/whisper/migrations/2020_05_28_164214_create_conversation_user_table.php(28): Illuminate\Database\Schema\Builder->create()
#9 [internal function]: Illuminate\Filesystem\Filesystem::{closure}()
#10 /var/www/flarumtr/vendor/flarum/core/src/Database/Migrator.php(202): call_user_func()
#11 /var/www/flarumtr/vendor/flarum/core/src/Database/Migrator.php(133): Flarum\Database\Migrator->runClosureMigration()
#12 /var/www/flarumtr/vendor/flarum/core/src/Database/Migrator.php(116): Flarum\Database\Migrator->runUp()
#13 /var/www/flarumtr/vendor/flarum/core/src/Database/Migrator.php(90): Flarum\Database\Migrator->runMigrationList()
#14 /var/www/flarumtr/vendor/flarum/core/src/Extension/Extension.php(482): Flarum\Database\Migrator->run()
#15 /var/www/flarumtr/vendor/flarum/core/src/Extension/ExtensionManager.php(311): Flarum\Extension\Extension->migrate()
#16 /var/www/flarumtr/vendor/flarum/core/src/Extension/ExtensionManager.php(182): Flarum\Extension\ExtensionManager->migrate()
#17 /var/www/flarumtr/vendor/flarum/core/src/Api/Controller/UpdateExtensionController.php(46): Flarum\Extension\ExtensionManager->enable()
#18 /var/www/flarumtr/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\UpdateExtensionController->handle()
#19 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#20 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\ExecuteRoute->process()
#21 /var/www/flarumtr/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#22 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Api\Middleware\ThrottleApi->process()
#23 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(44): Laminas\Stratigility\Next->handle()
#24 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\CheckCsrfToken->process()
#25 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(67): Laminas\Stratigility\Next->handle()
#26 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\ResolveRoute->process()
#27 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#28 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\SetLocale->process()
#29 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(56): Laminas\Stratigility\Next->handle()
#30 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\AuthenticateWithHeader->process()
#31 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle()
#32 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\AuthenticateWithSession->process()
#33 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle()
#34 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\RememberFromCookie->process()
#35 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#36 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\StartSession->process()
#37 /var/www/flarumtr/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\Stratigility\Next->handle()
#38 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Api\Middleware\FakeHttpMethods->process()
#39 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle()
#40 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\ParseJsonBody->process()
#41 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#42 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\HandleErrors->process()
#43 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle()
#44 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\InjectActorReference->process()
#45 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(76): Laminas\Stratigility\Next->handle()
#46 /var/www/flarumtr/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process()
#47 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Middlewares\RequestHandler->process()
#48 /var/www/flarumtr/vendor/middlewares/base-path-router/src/BasePathRouter.php(101): Laminas\Stratigility\Next->handle()
#49 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Middlewares\BasePathRouter->process()
#50 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(36): Laminas\Stratigility\Next->handle()
#51 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Laminas\Stratigility\Middleware\OriginalMessages->process()
#52 /var/www/flarumtr/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle()
#53 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Middlewares\BasePath->process()
#54 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle()
#55 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\ProcessIp->process()
#56 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(76): Laminas\Stratigility\Next->handle()
#57 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(65): Laminas\Stratigility\MiddlewarePipe->process()
#58 /var/www/flarumtr/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(96): Laminas\Stratigility\MiddlewarePipe->handle()
#59 /var/www/flarumtr/vendor/flarum/core/src/Http/Server.php(44): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#60 /var/www/flarumtr/public/index.php(26): Flarum\Http\Server->listen()
#61 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'conversation_user' already exists (SQL: create table `conversation_user` (`id` int unsigned not null auto_increment primary key, `conversation_id` int unsigned not null, `user_id` int unsigned not null, `last_read_message_number` int unsigned not null default '0', `last_read_at` datetime null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB) in /var/www/flarumtr/vendor/illuminate/database/Connection.php:692
Stack trace:
#0 /var/www/flarumtr/vendor/illuminate/database/Connection.php(652): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/flarumtr/vendor/illuminate/database/Connection.php(486): Illuminate\Database\Connection->run()
#2 /var/www/flarumtr/vendor/illuminate/database/Schema/Blueprint.php(109): Illuminate\Database\Connection->statement()
#3 /var/www/flarumtr/vendor/illuminate/database/Schema/Builder.php(365): Illuminate\Database\Schema\Blueprint->build()
#4 /var/www/flarumtr/vendor/illuminate/database/Schema/Builder.php(228): Illuminate\Database\Schema\Builder->build()
#5 /var/www/flarumtr/vendor/kyrne/whisper/migrations/2020_05_28_164214_create_conversation_user_table.php(28): Illuminate\Database\Schema\Builder->create()
#6 [internal function]: Illuminate\Filesystem\Filesystem::{closure}()
#7 /var/www/flarumtr/vendor/flarum/core/src/Database/Migrator.php(202): call_user_func()
#8 /var/www/flarumtr/vendor/flarum/core/src/Database/Migrator.php(133): Flarum\Database\Migrator->runClosureMigration()
#9 /var/www/flarumtr/vendor/flarum/core/src/Database/Migrator.php(116): Flarum\Database\Migrator->runUp()
#10 /var/www/flarumtr/vendor/flarum/core/src/Database/Migrator.php(90): Flarum\Database\Migrator->runMigrationList()
#11 /var/www/flarumtr/vendor/flarum/core/src/Extension/Extension.php(482): Flarum\Database\Migrator->run()
#12 /var/www/flarumtr/vendor/flarum/core/src/Extension/ExtensionManager.php(311): Flarum\Extension\Extension->migrate()
#13 /var/www/flarumtr/vendor/flarum/core/src/Extension/ExtensionManager.php(182): Flarum\Extension\ExtensionManager->migrate()
#14 /var/www/flarumtr/vendor/flarum/core/src/Api/Controller/UpdateExtensionController.php(46): Flarum\Extension\ExtensionManager->enable()
#15 /var/www/flarumtr/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\UpdateExtensionController->handle()
#16 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#17 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\ExecuteRoute->process()
#18 /var/www/flarumtr/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#19 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Api\Middleware\ThrottleApi->process()
#20 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(44): Laminas\Stratigility\Next->handle()
#21 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\CheckCsrfToken->process()
#22 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(67): Laminas\Stratigility\Next->handle()
#23 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\ResolveRoute->process()
#24 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#25 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\SetLocale->process()
#26 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(56): Laminas\Stratigility\Next->handle()
#27 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\AuthenticateWithHeader->process()
#28 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle()
#29 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\AuthenticateWithSession->process()
#30 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle()
#31 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\RememberFromCookie->process()
#32 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#33 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\StartSession->process()
#34 /var/www/flarumtr/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\Stratigility\Next->handle()
#35 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Api\Middleware\FakeHttpMethods->process()
#36 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle()
#37 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\ParseJsonBody->process()
#38 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#39 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\HandleErrors->process()
#40 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle()
#41 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\InjectActorReference->process()
#42 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(76): Laminas\Stratigility\Next->handle()
#43 /var/www/flarumtr/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process()
#44 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Middlewares\RequestHandler->process()
#45 /var/www/flarumtr/vendor/middlewares/base-path-router/src/BasePathRouter.php(101): Laminas\Stratigility\Next->handle()
#46 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Middlewares\BasePathRouter->process()
#47 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(36): Laminas\Stratigility\Next->handle()
#48 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Laminas\Stratigility\Middleware\OriginalMessages->process()
#49 /var/www/flarumtr/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle()
#50 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Middlewares\BasePath->process()
#51 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle()
#52 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\ProcessIp->process()
#53 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(76): Laminas\Stratigility\Next->handle()
#54 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(65): Laminas\Stratigility\MiddlewarePipe->process()
#55 /var/www/flarumtr/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(96): Laminas\Stratigility\MiddlewarePipe->handle()
#56 /var/www/flarumtr/vendor/flarum/core/src/Http/Server.php(44): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#57 /var/www/flarumtr/public/index.php(26): Flarum\Http\Server->listen()
#58 {main}  

[2021-07-23 09:59:10] flarum.ERROR: PDOException: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'unread_messages' in /var/www/flarumtr/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:112
Stack trace:
#0 /var/www/flarumtr/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(112): PDOStatement->execute()
#1 /var/www/flarumtr/vendor/illuminate/database/Connection.php(485): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /var/www/flarumtr/vendor/illuminate/database/Connection.php(685): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /var/www/flarumtr/vendor/illuminate/database/Connection.php(652): Illuminate\Database\Connection->runQueryCallback()
#4 /var/www/flarumtr/vendor/illuminate/database/Connection.php(486): Illuminate\Database\Connection->run()
#5 /var/www/flarumtr/vendor/illuminate/database/Schema/Blueprint.php(109): Illuminate\Database\Connection->statement()
#6 /var/www/flarumtr/vendor/illuminate/database/Schema/Builder.php(365): Illuminate\Database\Schema\Blueprint->build()
#7 /var/www/flarumtr/vendor/illuminate/database/Schema/Builder.php(212): Illuminate\Database\Schema\Builder->build()
#8 /var/www/flarumtr/vendor/kyrne/whisper/migrations/2020_05_20_152335_add_fields_to_users.php(20): Illuminate\Database\Schema\Builder->table()
#9 [internal function]: Illuminate\Filesystem\Filesystem::{closure}()
#10 /var/www/flarumtr/vendor/flarum/core/src/Database/Migrator.php(202): call_user_func()
#11 /var/www/flarumtr/vendor/flarum/core/src/Database/Migrator.php(133): Flarum\Database\Migrator->runClosureMigration()
#12 /var/www/flarumtr/vendor/flarum/core/src/Database/Migrator.php(116): Flarum\Database\Migrator->runUp()
#13 /var/www/flarumtr/vendor/flarum/core/src/Database/Migrator.php(90): Flarum\Database\Migrator->runMigrationList()
#14 /var/www/flarumtr/vendor/flarum/core/src/Extension/Extension.php(482): Flarum\Database\Migrator->run()
#15 /var/www/flarumtr/vendor/flarum/core/src/Extension/ExtensionManager.php(311): Flarum\Extension\Extension->migrate()
#16 /var/www/flarumtr/vendor/flarum/core/src/Extension/ExtensionManager.php(182): Flarum\Extension\ExtensionManager->migrate()
#17 /var/www/flarumtr/vendor/flarum/core/src/Api/Controller/UpdateExtensionController.php(46): Flarum\Extension\ExtensionManager->enable()
#18 /var/www/flarumtr/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\UpdateExtensionController->handle()
#19 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#20 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\ExecuteRoute->process()
#21 /var/www/flarumtr/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#22 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Api\Middleware\ThrottleApi->process()
#23 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(44): Laminas\Stratigility\Next->handle()
#24 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\CheckCsrfToken->process()
#25 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(67): Laminas\Stratigility\Next->handle()
#26 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\ResolveRoute->process()
#27 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#28 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\SetLocale->process()
#29 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(56): Laminas\Stratigility\Next->handle()
#30 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\AuthenticateWithHeader->process()
#31 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle()
#32 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\AuthenticateWithSession->process()
#33 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle()
#34 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\RememberFromCookie->process()
#35 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#36 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\StartSession->process()
#37 /var/www/flarumtr/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\Stratigility\Next->handle()
#38 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Api\Middleware\FakeHttpMethods->process()
#39 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle()
#40 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\ParseJsonBody->process()
#41 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#42 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\HandleErrors->process()
#43 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle()
#44 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\InjectActorReference->process()
#45 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(76): Laminas\Stratigility\Next->handle()
#46 /var/www/flarumtr/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process()
#47 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Middlewares\RequestHandler->process()
#48 /var/www/flarumtr/vendor/middlewares/base-path-router/src/BasePathRouter.php(101): Laminas\Stratigility\Next->handle()
#49 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Middlewares\BasePathRouter->process()
#50 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(36): Laminas\Stratigility\Next->handle()
#51 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Laminas\Stratigility\Middleware\OriginalMessages->process()
#52 /var/www/flarumtr/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle()
#53 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Middlewares\BasePath->process()
#54 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle()
#55 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\ProcessIp->process()
#56 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(76): Laminas\Stratigility\Next->handle()
#57 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(65): Laminas\Stratigility\MiddlewarePipe->process()
#58 /var/www/flarumtr/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(96): Laminas\Stratigility\MiddlewarePipe->handle()
#59 /var/www/flarumtr/vendor/flarum/core/src/Http/Server.php(44): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#60 /var/www/flarumtr/public/index.php(26): Flarum\Http\Server->listen()
#61 {main}

Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'unread_messages' in /var/www/flarumtr/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /var/www/flarumtr/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(114): Doctrine\DBAL\Driver\PDO\Exception::new()
#1 /var/www/flarumtr/vendor/illuminate/database/Connection.php(485): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /var/www/flarumtr/vendor/illuminate/database/Connection.php(685): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /var/www/flarumtr/vendor/illuminate/database/Connection.php(652): Illuminate\Database\Connection->runQueryCallback()
#4 /var/www/flarumtr/vendor/illuminate/database/Connection.php(486): Illuminate\Database\Connection->run()
#5 /var/www/flarumtr/vendor/illuminate/database/Schema/Blueprint.php(109): Illuminate\Database\Connection->statement()
#6 /var/www/flarumtr/vendor/illuminate/database/Schema/Builder.php(365): Illuminate\Database\Schema\Blueprint->build()
#7 /var/www/flarumtr/vendor/illuminate/database/Schema/Builder.php(212): Illuminate\Database\Schema\Builder->build()
#8 /var/www/flarumtr/vendor/kyrne/whisper/migrations/2020_05_20_152335_add_fields_to_users.php(20): Illuminate\Database\Schema\Builder->table()
#9 [internal function]: Illuminate\Filesystem\Filesystem::{closure}()
#10 /var/www/flarumtr/vendor/flarum/core/src/Database/Migrator.php(202): call_user_func()
#11 /var/www/flarumtr/vendor/flarum/core/src/Database/Migrator.php(133): Flarum\Database\Migrator->runClosureMigration()
#12 /var/www/flarumtr/vendor/flarum/core/src/Database/Migrator.php(116): Flarum\Database\Migrator->runUp()
#13 /var/www/flarumtr/vendor/flarum/core/src/Database/Migrator.php(90): Flarum\Database\Migrator->runMigrationList()
#14 /var/www/flarumtr/vendor/flarum/core/src/Extension/Extension.php(482): Flarum\Database\Migrator->run()
#15 /var/www/flarumtr/vendor/flarum/core/src/Extension/ExtensionManager.php(311): Flarum\Extension\Extension->migrate()
#16 /var/www/flarumtr/vendor/flarum/core/src/Extension/ExtensionManager.php(182): Flarum\Extension\ExtensionManager->migrate()
#17 /var/www/flarumtr/vendor/flarum/core/src/Api/Controller/UpdateExtensionController.php(46): Flarum\Extension\ExtensionManager->enable()
#18 /var/www/flarumtr/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\UpdateExtensionController->handle()
#19 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#20 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\ExecuteRoute->process()
#21 /var/www/flarumtr/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#22 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Api\Middleware\ThrottleApi->process()
#23 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(44): Laminas\Stratigility\Next->handle()
#24 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\CheckCsrfToken->process()
#25 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(67): Laminas\Stratigility\Next->handle()
#26 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\ResolveRoute->process()
#27 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#28 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\SetLocale->process()
#29 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(56): Laminas\Stratigility\Next->handle()
#30 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\AuthenticateWithHeader->process()
#31 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle()
#32 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\AuthenticateWithSession->process()
#33 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle()
#34 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\RememberFromCookie->process()
#35 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#36 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\StartSession->process()
#37 /var/www/flarumtr/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\Stratigility\Next->handle()
#38 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Api\Middleware\FakeHttpMethods->process()
#39 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle()
#40 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\ParseJsonBody->process()
#41 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#42 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\HandleErrors->process()
#43 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle()
#44 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\InjectActorReference->process()
#45 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(76): Laminas\Stratigility\Next->handle()
#46 /var/www/flarumtr/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process()
#47 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Middlewares\RequestHandler->process()
#48 /var/www/flarumtr/vendor/middlewares/base-path-router/src/BasePathRouter.php(101): Laminas\Stratigility\Next->handle()
#49 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Middlewares\BasePathRouter->process()
#50 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(36): Laminas\Stratigility\Next->handle()
#51 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Laminas\Stratigility\Middleware\OriginalMessages->process()
#52 /var/www/flarumtr/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle()
#53 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Middlewares\BasePath->process()
#54 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle()
#55 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\ProcessIp->process()
#56 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(76): Laminas\Stratigility\Next->handle()
#57 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(65): Laminas\Stratigility\MiddlewarePipe->process()
#58 /var/www/flarumtr/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(96): Laminas\Stratigility\MiddlewarePipe->handle()
#59 /var/www/flarumtr/vendor/flarum/core/src/Http/Server.php(44): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#60 /var/www/flarumtr/public/index.php(26): Flarum\Http\Server->listen()
#61 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'unread_messages' (SQL: alter table `users` add `unread_messages` int not null) in /var/www/flarumtr/vendor/illuminate/database/Connection.php:692
Stack trace:
#0 /var/www/flarumtr/vendor/illuminate/database/Connection.php(652): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/flarumtr/vendor/illuminate/database/Connection.php(486): Illuminate\Database\Connection->run()
#2 /var/www/flarumtr/vendor/illuminate/database/Schema/Blueprint.php(109): Illuminate\Database\Connection->statement()
#3 /var/www/flarumtr/vendor/illuminate/database/Schema/Builder.php(365): Illuminate\Database\Schema\Blueprint->build()
#4 /var/www/flarumtr/vendor/illuminate/database/Schema/Builder.php(212): Illuminate\Database\Schema\Builder->build()
#5 /var/www/flarumtr/vendor/kyrne/whisper/migrations/2020_05_20_152335_add_fields_to_users.php(20): Illuminate\Database\Schema\Builder->table()
#6 [internal function]: Illuminate\Filesystem\Filesystem::{closure}()
#7 /var/www/flarumtr/vendor/flarum/core/src/Database/Migrator.php(202): call_user_func()
#8 /var/www/flarumtr/vendor/flarum/core/src/Database/Migrator.php(133): Flarum\Database\Migrator->runClosureMigration()
#9 /var/www/flarumtr/vendor/flarum/core/src/Database/Migrator.php(116): Flarum\Database\Migrator->runUp()
#10 /var/www/flarumtr/vendor/flarum/core/src/Database/Migrator.php(90): Flarum\Database\Migrator->runMigrationList()
#11 /var/www/flarumtr/vendor/flarum/core/src/Extension/Extension.php(482): Flarum\Database\Migrator->run()
#12 /var/www/flarumtr/vendor/flarum/core/src/Extension/ExtensionManager.php(311): Flarum\Extension\Extension->migrate()
#13 /var/www/flarumtr/vendor/flarum/core/src/Extension/ExtensionManager.php(182): Flarum\Extension\ExtensionManager->migrate()
#14 /var/www/flarumtr/vendor/flarum/core/src/Api/Controller/UpdateExtensionController.php(46): Flarum\Extension\ExtensionManager->enable()
#15 /var/www/flarumtr/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\UpdateExtensionController->handle()
#16 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#17 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\ExecuteRoute->process()
#18 /var/www/flarumtr/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#19 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Api\Middleware\ThrottleApi->process()
#20 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(44): Laminas\Stratigility\Next->handle()
#21 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\CheckCsrfToken->process()
#22 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(67): Laminas\Stratigility\Next->handle()
#23 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\ResolveRoute->process()
#24 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#25 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\SetLocale->process()
#26 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(56): Laminas\Stratigility\Next->handle()
#27 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\AuthenticateWithHeader->process()
#28 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle()
#29 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\AuthenticateWithSession->process()
#30 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle()
#31 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\RememberFromCookie->process()
#32 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#33 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\StartSession->process()
#34 /var/www/flarumtr/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\Stratigility\Next->handle()
#35 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Api\Middleware\FakeHttpMethods->process()
#36 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle()
#37 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\ParseJsonBody->process()
#38 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#39 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\HandleErrors->process()
#40 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle()
#41 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\InjectActorReference->process()
#42 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(76): Laminas\Stratigility\Next->handle()
#43 /var/www/flarumtr/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process()
#44 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Middlewares\RequestHandler->process()
#45 /var/www/flarumtr/vendor/middlewares/base-path-router/src/BasePathRouter.php(101): Laminas\Stratigility\Next->handle()
#46 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Middlewares\BasePathRouter->process()
#47 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(36): Laminas\Stratigility\Next->handle()
#48 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Laminas\Stratigility\Middleware\OriginalMessages->process()
#49 /var/www/flarumtr/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle()
#50 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Middlewares\BasePath->process()
#51 /var/www/flarumtr/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle()
#52 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\ProcessIp->process()
#53 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(76): Laminas\Stratigility\Next->handle()
#54 /var/www/flarumtr/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(65): Laminas\Stratigility\MiddlewarePipe->process()
#55 /var/www/flarumtr/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(96): Laminas\Stratigility\MiddlewarePipe->handle()
#56 /var/www/flarumtr/vendor/flarum/core/src/Http/Server.php(44): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#57 /var/www/flarumtr/public/index.php(26): Flarum\Http\Server->listen()
#58 {main}  

```

Braden · Jul 24, 2021

Can someone create a msql command to drop the 3 tables, single command or all at once

Gatsu · Jul 24, 2021

Kyrne It is still present