WIP Extension Realtime chat with Pusher
Xelson One of the reasons is it looks and works better on mobile. So it doesn't even have to be another page, it could just be full-screen?
The other reason is it leaves more room for running ads (to help cover forum expenses).
And then I'd also say it helps me focus on the chat by letting it take up the whole screen.
Xelson Maybe you can add a button next to the minimize and maximize buttons: Chat in a separate window.
After clicking this button, the chat panel will open in a new tab, for example (please note the lower left corner of the video) ↓
- Edited
// Chat night mode
body.dark .chat .frame .wrapper .message-wrapper:nth-child(odd) {
background: #151515 !important;
}
body.dark .chat .frame .wrapper .message-wrapper {
background: #1a1a1a !important;
}
body.dark .chat .frame .wrapper .message-wrapper .message-block .UserMention {
color: #7c7c7c;
}
body.dark .chat .frame .wrapper .message-wrapper .message-block .toolbar .name {
color: #aaaaaa !important;
}
body.dark .chat {
color: #aaaaaa !important;
}
body.dark .chat .frame .input-wrapper #chat-input {
background: rgb(36, 36, 36) !important;
color: #7c7c7c !important;
}
body.dark .chat .frame .input-wrapper, body.dark .chat .frame {
background: rgb(21, 21, 21) !important;
}
// Chat day mode
.chat .frame .wrapper .message-wrapper .message-block .UserMention {
background: #ededed !important;
}
- Edited
Xelson On a newly built flarum site, I installed the dev-master version for the first time, I Turn On Realtime Chat extension, then the forum could not be successfully loaded, and the console reported an error. If I turn off this extension, the page can load successfully.
【Home Page】
【Discussion Page】
Littlegolden you forgot to enable Pusher
Xelson Can't believe I forgot this. . .
AnonAlpha follow https://forum.earthmcbe.space/api/extensions/xelson-chat and send screenshot
I could not install
[2020-02-24 20:07:39] production.ERROR: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'flarum.pushedx_messages' doesn't exist in D:\xampp\htdocs\flarum\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOStatement.php:121
Stack trace:
#0 D:\xampp\htdocs\flarum\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOStatement.php(121): PDOStatement->execute(NULL)
#1 D:\xampp\htdocs\flarum\vendor\illuminate\database\Connection.php(458): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 D:\xampp\htdocs\flarum\vendor\illuminate\database\Connection.php(657): Illuminate\Database\Connection->Illuminate\Database\{closure}('ALTER TABLE `pu...', Array)
#3 D:\xampp\htdocs\flarum\vendor\illuminate\database\Connection.php(624): Illuminate\Database\Connection->runQueryCallback('ALTER TABLE `pu...', Array, Object(Closure))
#4 D:\xampp\htdocs\flarum\vendor\illuminate\database\Connection.php(459): Illuminate\Database\Connection->run('ALTER TABLE `pu...', Array, Object(Closure))
#5 D:\xampp\htdocs\flarum\vendor\xelson\flarum-ext-chat\migrations\2020_01_31_000000_change_timestamp_to_datetime.php(9): Illuminate\Database\Connection->statement('ALTER TABLE `pu...')
#6 [internal function]: Illuminate\Filesystem\Filesystem->{closure}(Object(Illuminate\Database\Schema\MySqlBuilder))
#7 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Database\Migrator.php(197): call_user_func(Object(Closure), Object(Illuminate\Database\Schema\MySqlBuilder))
#8 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Database\Migrator.php(128): Flarum\Database\Migrator->runClosureMigration(Array)
#9 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Database\Migrator.php(111): Flarum\Database\Migrator->runUp('D:\\xampp\\htdocs...', '2020_01_31_0000...', Object(Flarum\Extension\Extension))
#10 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Database\Migrator.php(85): Flarum\Database\Migrator->runMigrationList('D:\\xampp\\htdocs...', Array, Object(Flarum\Extension\Extension))
#11 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Extension\Extension.php(352): Flarum\Database\Migrator->run('D:\\xampp\\htdocs...', Object(Flarum\Extension\Extension))
#12 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Extension\ExtensionManager.php(234): Flarum\Extension\Extension->migrate(Object(Flarum\Database\Migrator), 'up')
#13 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Extension\ExtensionManager.php(127): Flarum\Extension\ExtensionManager->migrate(Object(Flarum\Extension\Extension))
#14 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Api\Controller\UpdateExtensionController.php(48): Flarum\Extension\ExtensionManager->enable('xelson-chat')
#15 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Http\RouteHandlerFactory.php(38): Flarum\Api\Controller\UpdateExtensionController->handle(Object(Zend\Diactoros\ServerRequest))
#16 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Http\Middleware\DispatchRoute.php(65): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}(Object(Zend\Diactoros\ServerRequest), Array)
#17 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Next.php(60): Flarum\Http\Middleware\DispatchRoute->process(Object(Zend\Diactoros\ServerRequest), Object(Closure))
#18 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Http\Middleware\SetLocale.php(50): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#19 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Next.php(60): Flarum\Http\Middleware\SetLocale->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#20 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Http\Middleware\CheckCsrfToken.php(31): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#21 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Next.php(60): Flarum\Http\Middleware\CheckCsrfToken->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#22 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Http\Middleware\AuthenticateWithHeader.php(55): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#23 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Next.php(60): Flarum\Http\Middleware\AuthenticateWithHeader->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#24 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Http\Middleware\AuthenticateWithSession.php(32): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#25 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Next.php(60): Flarum\Http\Middleware\AuthenticateWithSession->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#26 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Http\Middleware\RememberFromCookie.php(51): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#27 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Next.php(60): Flarum\Http\Middleware\RememberFromCookie->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#28 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Http\Middleware\StartSession.php(61): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#29 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Next.php(60): Flarum\Http\Middleware\StartSession->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#30 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Api\Middleware\FakeHttpMethods.php(29): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#31 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Next.php(60): Flarum\Api\Middleware\FakeHttpMethods->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#32 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Http\Middleware\ParseJsonBody.php(28): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#33 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Next.php(60): Flarum\Http\Middleware\ParseJsonBody->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#34 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Http\Middleware\HandleErrors.php(57): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#35 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Next.php(60): Flarum\Http\Middleware\HandleErrors->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#36 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\MiddlewarePipe.php(83): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#37 D:\xampp\htdocs\flarum\vendor\middlewares\request-handler\src\RequestHandler.php(84): Zend\Stratigility\MiddlewarePipe->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#38 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Next.php(60): Middlewares\RequestHandler->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#39 D:\xampp\htdocs\flarum\vendor\middlewares\base-path-router\src\BasePathRouter.php(97): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#40 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Next.php(60): Middlewares\BasePathRouter->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#41 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Middleware\OriginalMessages.php(41): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#42 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Next.php(60): Zend\Stratigility\Middleware\OriginalMessages->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#43 D:\xampp\htdocs\flarum\vendor\middlewares\base-path\src\BasePath.php(53): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#44 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Next.php(60): Middlewares\BasePath->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#45 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\MiddlewarePipe.php(83): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#46 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\MiddlewarePipe.php(72): Zend\Stratigility\MiddlewarePipe->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\EmptyPipelineHandler))
#47 D:\xampp\htdocs\flarum\vendor\zendframework\zend-httphandlerrunner\src\RequestHandlerRunner.php(95): Zend\Stratigility\MiddlewarePipe->handle(Object(Zend\Diactoros\ServerRequest))
#48 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Http\Server.php(44): Zend\HttpHandlerRunner\RequestHandlerRunner->run()
#49 D:\xampp\htdocs\flarum\index.php(22): Flarum\Http\Server->listen()
#50 {main}
Next Doctrine\DBAL\Driver\PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'flarum.pushedx_messages' doesn't exist in D:\xampp\htdocs\flarum\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOStatement.php:123
Stack trace:
#0 D:\xampp\htdocs\flarum\vendor\illuminate\database\Connection.php(458): Doctrine\DBAL\Driver\PDOStatement->execute()
#1 D:\xampp\htdocs\flarum\vendor\illuminate\database\Connection.php(657): Illuminate\Database\Connection->Illuminate\Database\{closure}('ALTER TABLE `pu...', Array)
#2 D:\xampp\htdocs\flarum\vendor\illuminate\database\Connection.php(624): Illuminate\Database\Connection->runQueryCallback('ALTER TABLE `pu...', Array, Object(Closure))
#3 D:\xampp\htdocs\flarum\vendor\illuminate\database\Connection.php(459): Illuminate\Database\Connection->run('ALTER TABLE `pu...', Array, Object(Closure))
#4 D:\xampp\htdocs\flarum\vendor\xelson\flarum-ext-chat\migrations\2020_01_31_000000_change_timestamp_to_datetime.php(9): Illuminate\Database\Connection->statement('ALTER TABLE `pu...')
#5 [internal function]: Illuminate\Filesystem\Filesystem->{closure}(Object(Illuminate\Database\Schema\MySqlBuilder))
#6 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Database\Migrator.php(197): call_user_func(Object(Closure), Object(Illuminate\Database\Schema\MySqlBuilder))
#7 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Database\Migrator.php(128): Flarum\Database\Migrator->runClosureMigration(Array)
#8 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Database\Migrator.php(111): Flarum\Database\Migrator->runUp('D:\\xampp\\htdocs...', '2020_01_31_0000...', Object(Flarum\Extension\Extension))
#9 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Database\Migrator.php(85): Flarum\Database\Migrator->runMigrationList('D:\\xampp\\htdocs...', Array, Object(Flarum\Extension\Extension))
#10 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Extension\Extension.php(352): Flarum\Database\Migrator->run('D:\\xampp\\htdocs...', Object(Flarum\Extension\Extension))
#11 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Extension\ExtensionManager.php(234): Flarum\Extension\Extension->migrate(Object(Flarum\Database\Migrator), 'up')
#12 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Extension\ExtensionManager.php(127): Flarum\Extension\ExtensionManager->migrate(Object(Flarum\Extension\Extension))
#13 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Api\Controller\UpdateExtensionController.php(48): Flarum\Extension\ExtensionManager->enable('xelson-chat')
#14 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Http\RouteHandlerFactory.php(38): Flarum\Api\Controller\UpdateExtensionController->handle(Object(Zend\Diactoros\ServerRequest))
#15 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Http\Middleware\DispatchRoute.php(65): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}(Object(Zend\Diactoros\ServerRequest), Array)
#16 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Next.php(60): Flarum\Http\Middleware\DispatchRoute->process(Object(Zend\Diactoros\ServerRequest), Object(Closure))
#17 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Http\Middleware\SetLocale.php(50): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#18 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Next.php(60): Flarum\Http\Middleware\SetLocale->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#19 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Http\Middleware\CheckCsrfToken.php(31): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#20 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Next.php(60): Flarum\Http\Middleware\CheckCsrfToken->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#21 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Http\Middleware\AuthenticateWithHeader.php(55): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#22 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Next.php(60): Flarum\Http\Middleware\AuthenticateWithHeader->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#23 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Http\Middleware\AuthenticateWithSession.php(32): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#24 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Next.php(60): Flarum\Http\Middleware\AuthenticateWithSession->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#25 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Http\Middleware\RememberFromCookie.php(51): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#26 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Next.php(60): Flarum\Http\Middleware\RememberFromCookie->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#27 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Http\Middleware\StartSession.php(61): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#28 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Next.php(60): Flarum\Http\Middleware\StartSession->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#29 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Api\Middleware\FakeHttpMethods.php(29): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#30 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Next.php(60): Flarum\Api\Middleware\FakeHttpMethods->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#31 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Http\Middleware\ParseJsonBody.php(28): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#32 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Next.php(60): Flarum\Http\Middleware\ParseJsonBody->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#33 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Http\Middleware\HandleErrors.php(57): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#34 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Next.php(60): Flarum\Http\Middleware\HandleErrors->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#35 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\MiddlewarePipe.php(83): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#36 D:\xampp\htdocs\flarum\vendor\middlewares\request-handler\src\RequestHandler.php(84): Zend\Stratigility\MiddlewarePipe->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#37 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Next.php(60): Middlewares\RequestHandler->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#38 D:\xampp\htdocs\flarum\vendor\middlewares\base-path-router\src\BasePathRouter.php(97): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#39 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Next.php(60): Middlewares\BasePathRouter->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#40 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Middleware\OriginalMessages.php(41): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#41 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Next.php(60): Zend\Stratigility\Middleware\OriginalMessages->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#42 D:\xampp\htdocs\flarum\vendor\middlewares\base-path\src\BasePath.php(53): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#43 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Next.php(60): Middlewares\BasePath->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#44 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\MiddlewarePipe.php(83): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#45 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\MiddlewarePipe.php(72): Zend\Stratigility\MiddlewarePipe->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\EmptyPipelineHandler))
#46 D:\xampp\htdocs\flarum\vendor\zendframework\zend-httphandlerrunner\src\RequestHandlerRunner.php(95): Zend\Stratigility\MiddlewarePipe->handle(Object(Zend\Diactoros\ServerRequest))
#47 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Http\Server.php(44): Zend\HttpHandlerRunner\RequestHandlerRunner->run()
#48 D:\xampp\htdocs\flarum\index.php(22): Flarum\Http\Server->listen()
#49 {main}
Next Illuminate\Database\QueryException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'flarum.pushedx_messages' doesn't exist (SQL: ALTER TABLE `pushedx_messages` MODIFY created_at DATETIME) in D:\xampp\htdocs\flarum\vendor\illuminate\database\Connection.php:664
Stack trace:
#0 D:\xampp\htdocs\flarum\vendor\illuminate\database\Connection.php(624): Illuminate\Database\Connection->runQueryCallback('ALTER TABLE `pu...', Array, Object(Closure))
#1 D:\xampp\htdocs\flarum\vendor\illuminate\database\Connection.php(459): Illuminate\Database\Connection->run('ALTER TABLE `pu...', Array, Object(Closure))
#2 D:\xampp\htdocs\flarum\vendor\xelson\flarum-ext-chat\migrations\2020_01_31_000000_change_timestamp_to_datetime.php(9): Illuminate\Database\Connection->statement('ALTER TABLE `pu...')
#3 [internal function]: Illuminate\Filesystem\Filesystem->{closure}(Object(Illuminate\Database\Schema\MySqlBuilder))
#4 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Database\Migrator.php(197): call_user_func(Object(Closure), Object(Illuminate\Database\Schema\MySqlBuilder))
#5 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Database\Migrator.php(128): Flarum\Database\Migrator->runClosureMigration(Array)
#6 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Database\Migrator.php(111): Flarum\Database\Migrator->runUp('D:\\xampp\\htdocs...', '2020_01_31_0000...', Object(Flarum\Extension\Extension))
#7 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Database\Migrator.php(85): Flarum\Database\Migrator->runMigrationList('D:\\xampp\\htdocs...', Array, Object(Flarum\Extension\Extension))
#8 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Extension\Extension.php(352): Flarum\Database\Migrator->run('D:\\xampp\\htdocs...', Object(Flarum\Extension\Extension))
#9 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Extension\ExtensionManager.php(234): Flarum\Extension\Extension->migrate(Object(Flarum\Database\Migrator), 'up')
#10 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Extension\ExtensionManager.php(127): Flarum\Extension\ExtensionManager->migrate(Object(Flarum\Extension\Extension))
#11 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Api\Controller\UpdateExtensionController.php(48): Flarum\Extension\ExtensionManager->enable('xelson-chat')
#12 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Http\RouteHandlerFactory.php(38): Flarum\Api\Controller\UpdateExtensionController->handle(Object(Zend\Diactoros\ServerRequest))
#13 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Http\Middleware\DispatchRoute.php(65): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}(Object(Zend\Diactoros\ServerRequest), Array)
#14 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Next.php(60): Flarum\Http\Middleware\DispatchRoute->process(Object(Zend\Diactoros\ServerRequest), Object(Closure))
#15 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Http\Middleware\SetLocale.php(50): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#16 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Next.php(60): Flarum\Http\Middleware\SetLocale->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#17 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Http\Middleware\CheckCsrfToken.php(31): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#18 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Next.php(60): Flarum\Http\Middleware\CheckCsrfToken->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#19 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Http\Middleware\AuthenticateWithHeader.php(55): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#20 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Next.php(60): Flarum\Http\Middleware\AuthenticateWithHeader->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#21 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Http\Middleware\AuthenticateWithSession.php(32): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#22 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Next.php(60): Flarum\Http\Middleware\AuthenticateWithSession->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#23 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Http\Middleware\RememberFromCookie.php(51): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#24 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Next.php(60): Flarum\Http\Middleware\RememberFromCookie->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#25 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Http\Middleware\StartSession.php(61): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#26 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Next.php(60): Flarum\Http\Middleware\StartSession->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#27 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Api\Middleware\FakeHttpMethods.php(29): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#28 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Next.php(60): Flarum\Api\Middleware\FakeHttpMethods->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#29 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Http\Middleware\ParseJsonBody.php(28): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#30 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Next.php(60): Flarum\Http\Middleware\ParseJsonBody->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#31 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Http\Middleware\HandleErrors.php(57): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#32 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Next.php(60): Flarum\Http\Middleware\HandleErrors->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#33 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\MiddlewarePipe.php(83): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#34 D:\xampp\htdocs\flarum\vendor\middlewares\request-handler\src\RequestHandler.php(84): Zend\Stratigility\MiddlewarePipe->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#35 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Next.php(60): Middlewares\RequestHandler->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#36 D:\xampp\htdocs\flarum\vendor\middlewares\base-path-router\src\BasePathRouter.php(97): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#37 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Next.php(60): Middlewares\BasePathRouter->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#38 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Middleware\OriginalMessages.php(41): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#39 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Next.php(60): Zend\Stratigility\Middleware\OriginalMessages->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#40 D:\xampp\htdocs\flarum\vendor\middlewares\base-path\src\BasePath.php(53): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#41 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\Next.php(60): Middlewares\BasePath->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#42 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\MiddlewarePipe.php(83): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#43 D:\xampp\htdocs\flarum\vendor\zendframework\zend-stratigility\src\MiddlewarePipe.php(72): Zend\Stratigility\MiddlewarePipe->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\EmptyPipelineHandler))
#44 D:\xampp\htdocs\flarum\vendor\zendframework\zend-httphandlerrunner\src\RequestHandlerRunner.php(95): Zend\Stratigility\MiddlewarePipe->handle(Object(Zend\Diactoros\ServerRequest))
#45 D:\xampp\htdocs\flarum\vendor\flarum\core\src\Http\Server.php(44): Zend\HttpHandlerRunner\RequestHandlerRunner->run()
#46 D:\xampp\htdocs\flarum\index.php(22): Flarum\Http\Server->listen()
#47 {main}
AnonAlpha i think you have the same issue with datlechin. It's very strange behavior for migrations.
You need to manually delete the migration cache from the database and start the migration from scratch (if the database is not created, as in the case of datlechin). Open your SQL client, connect to flarum database then select flarum database and execute query: DELETE FROM migrations WHERE extension = 'xelson-chat'
. After this run migration via terminal: php flarum migrate
. I hope this will help you.
I followed the instructions and still couldn't activate it