danielunited You can check this "How to Improve Chinese, Japanese, and Korean Search", MySQL should support most of languages in the world. Maybe this article can give you ideas.
Littlegolden Oh cool, thanks!
danielunited Good news, I just tested, the solution in the article I send you, can search not only Chinese, Korean, Japanese, but also All languages in the world!
danielunited Sorry, it seems that the function of searching user groups is not related to the keyword search function. 🤣
Littlegolden Right, I now changed the Forum language to Hebrew and it works okay.
composer require fof/byobu
ianm
I really like the recent additions. Keeping private discussions as simple as possible, that's my aim. People are used to the traditional ways of writing private messages, which used to be at one clear designated place and only there, so forcing a certain tag (e.g. Mailbox) is great.
I would like to go further and have the option to restrict private discussions to two recipients, the one who initiates a private discussion and the one who shall receive the message. The former is myself, the latter is selected by starting the private discussion via the user's profile page. This way we wouldn't even need a dialog to specify recipients. And instead of showing "2 Recipients" we could simply show the adressee's name, as we don't need to be informed about our own name (exception: if we are participating as a member of a group).
ianm Great update, solved lots of trouble but is there a way to hide that specific tag which is being used for private discussions (for example: I have it like "Private Inbox") Now the problem is, users are still able to go to Private Inbox tag and Create Discussion there which is a simple discussion but not a Private message.
HD3D But wasn't the positioning of byobu a private discussion tool from the beginning?
Littlegolden I'm trying to understand what you mean buddy, I created Private Inbox tag when I installed byobu, After Update 0.4.3 it solved the issue of choosing "Private Inbox" tag every time but what I mean is, Users can still go directly to the Private Inbox tag and create a normal discussion there, which I want to use only for Private Discussions not for normal discussions.
Well, I know I can use private discussions without a tag but for this I will have to remove settings of minimum 1 tag selection which I don't want.
Now what exactly is happening is, some users create new discussion in Private Inbox tag considering they're start a PD but it is actually exposed to everyone.
I hope that the function of private discussions will be maintained, but the function of private message can have another extension or be integrated in this extension. In short, private discussions and private message do not conflict, and both are needed.
HD3D I see~ The issue you said is do important.
Nice update with ability to set automatic (private messages) tag. I have few questions:
SilverPoplar I choose Private Discussions (by the way what the sense to see private discussion link in user page?) from Dropdown menu on the same page (user card) and press Button New Private Discussion it will not load default tag and username
This issue is fixed, and will be released in the next version of Byobu, most likely next week.
SilverPoplar If I set Inbox tag for my private message and set it is as default private discussion tag, how can i prevent users from creating not a private discussion with tag Inbox by a mistake?
This is not currently supported. Feel free to create an issue on github, or submit a PR 🙂
I wonder if it is possible to turn private discussions into ordinary public discussions? （except go to the database to change the value） I can't search the "All Users" user group in the user search box ...
{ "errors": [ { "status": "500", "code": "unknown", "detail": "PDOException: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'user_id' in where clause is ambiguous in /www/wwwroot/bbs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:61\nStack trace:\n#0 /www/wwwroot/bbs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(61): PDO->prepare('select `discuss...', Array)\n#1 /www/wwwroot/bbs/vendor/illuminate/database/Connection.php(326): Doctrine\\DBAL\\Driver\\PDOConnection->prepare('select `discuss...')\n#2 /www/wwwroot/bbs/vendor/illuminate/database/Connection.php(657): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('select `discuss...', Array)\n#3 /www/wwwroot/bbs/vendor/illuminate/database/Connection.php(624): Illuminate\\Database\\Connection->runQueryCallback('select `discuss...', Array, Object(Closure))\n#4 /www/wwwroot/bbs/vendor/illuminate/database/Connection.php(333): Illuminate\\Database\\Connection->run('select `discuss...', Array, Object(Closure))\n#5 /www/wwwroot/bbs/vendor/illuminate/database/Query/Builder.php(2095): Illuminate\\Database\\Connection->select('select `discuss...', Array, true)\n#6 /www/wwwroot/bbs/vendor/illuminate/database/Query/Builder.php(2083): Illuminate\\Database\\Query\\Builder->runSelect()\n#7 /www/wwwroot/bbs/vendor/illuminate/database/Query/Builder.php(2569): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()\n#8 /www/wwwroot/bbs/vendor/illuminate/database/Query/Builder.php(2084): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure))\n#9 /www/wwwroot/bbs/vendor/illuminate/database/Eloquent/Builder.php(519): Illuminate\\Database\\Query\\Builder->get(Array)\n#10 /www/wwwroot/bbs/vendor/illuminate/database/Eloquent/Builder.php(503): Illuminate\\Database\\Eloquent\\Builder->getModels(Array)\n#11 /www/wwwroot/bbs/vendor/flarum/core/src/Discussion/Search/DiscussionSearcher.php(79): Illuminate\\Database\\Eloquent\\Builder->get()\n#12 /www/wwwroot/bbs/vendor/flarum/core/src/Api/Controller/ListDiscussionsController.php(86): Flarum\\Discussion\\Search\\DiscussionSearcher->search(Object(Flarum\\Search\\SearchCriteria), 20, 0)\n#13 /www/wwwroot/bbs/vendor/flarum/core/src/Api/Controller/AbstractSerializeController.php(96): Flarum\\Api\\Controller\\ListDiscussionsController->data(Object(Laminas\\Diactoros\\ServerRequest), Object(Tobscure\\JsonApi\\Document))\n#14 /www/wwwroot/bbs/vendor/flarum/core/src/Http/RouteHandlerFactory.php(38): Flarum\\Api\\Controller\\AbstractSerializeController->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#15 /www/wwwroot/bbs/vendor/flarum/core/src/Http/Middleware/DispatchRoute.php(65): Flarum\\Http\\RouteHandlerFactory->Flarum\\Http\\{closure}(Object(Laminas\\Diactoros\\ServerRequest), Array)\n#16 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\DispatchRoute->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Closure))\n#17 /www/wwwroot/bbs/vendor/fof/pwned-passwords/src/Middleware/CheckPasswordReset.php(55): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#18 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): FoF\\PwnedPasswords\\Middleware\\CheckPasswordReset->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#19 /www/wwwroot/bbs/vendor/fof/pwned-passwords/src/Middleware/CheckLoginPassword.php(45): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#20 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): FoF\\PwnedPasswords\\Middleware\\CheckLoginPassword->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#21 /www/wwwroot/bbs/vendor/fof/pwned-passwords/src/Middleware/PreventPwnedPassword.php(42): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#22 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): FoF\\PwnedPasswords\\Middleware\\PreventPwnedPassword->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#23 /www/wwwroot/bbs/vendor/fof/terms/src/Middlewares/RegisterMiddleware.php(54): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#24 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): FoF\\Terms\\Middlewares\\RegisterMiddleware->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#25 /www/wwwroot/bbs/vendor/flarum/core/src/Http/Middleware/SetLocale.php(50): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#26 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\SetLocale->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#27 /www/wwwroot/bbs/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(23): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#28 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\CheckCsrfToken->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#29 /www/wwwroot/bbs/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(55): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#30 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\AuthenticateWithHeader->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#31 /www/wwwroot/bbs/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(32): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#32 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\AuthenticateWithSession->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#33 /www/wwwroot/bbs/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(51): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#34 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\RememberFromCookie->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#35 /www/wwwroot/bbs/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#36 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\StartSession->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#37 /www/wwwroot/bbs/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#38 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Api\\Middleware\\FakeHttpMethods->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#39 /www/wwwroot/bbs/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#40 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\ParseJsonBody->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#41 /www/wwwroot/bbs/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#42 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\HandleErrors->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#43 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#44 /www/wwwroot/bbs/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\\Stratigility\\MiddlewarePipe->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#45 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\\RequestHandler->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#46 /www/wwwroot/bbs/vendor/middlewares/base-path-router/src/BasePathRouter.php(97): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#47 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\\BasePathRouter->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#48 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(42): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#49 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): Laminas\\Stratigility\\Middleware\\OriginalMessages->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#50 /www/wwwroot/bbs/vendor/middlewares/base-path/src/BasePath.php(53): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#51 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\\BasePath->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#52 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#53 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(73): Laminas\\Stratigility\\MiddlewarePipe->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\EmptyPipelineHandler))\n#54 /www/wwwroot/bbs/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(96): Laminas\\Stratigility\\MiddlewarePipe->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#55 /www/wwwroot/bbs/vendor/flarum/core/src/Http/Server.php(42): Laminas\\HttpHandlerRunner\\RequestHandlerRunner->run()\n#56 /www/wwwroot/bbs/public/index.php(26): Flarum\\Http\\Server->listen()\n#57 {main}\n\nNext Doctrine\\DBAL\\Driver\\PDOException: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'user_id' in where clause is ambiguous in /www/wwwroot/bbs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:63\nStack trace:\n#0 /www/wwwroot/bbs/vendor/illuminate/database/Connection.php(326): Doctrine\\DBAL\\Driver\\PDOConnection->prepare('select `discuss...')\n#1 /www/wwwroot/bbs/vendor/illuminate/database/Connection.php(657): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('select `discuss...', Array)\n#2 /www/wwwroot/bbs/vendor/illuminate/database/Connection.php(624): Illuminate\\Database\\Connection->runQueryCallback('select `discuss...', Array, Object(Closure))\n#3 /www/wwwroot/bbs/vendor/illuminate/database/Connection.php(333): Illuminate\\Database\\Connection->run('select `discuss...', Array, Object(Closure))\n#4 /www/wwwroot/bbs/vendor/illuminate/database/Query/Builder.php(2095): Illuminate\\Database\\Connection->select('select `discuss...', Array, true)\n#5 /www/wwwroot/bbs/vendor/illuminate/database/Query/Builder.php(2083): Illuminate\\Database\\Query\\Builder->runSelect()\n#6 /www/wwwroot/bbs/vendor/illuminate/database/Query/Builder.php(2569): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()\n#7 /www/wwwroot/bbs/vendor/illuminate/database/Query/Builder.php(2084): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure))\n#8 /www/wwwroot/bbs/vendor/illuminate/database/Eloquent/Builder.php(519): Illuminate\\Database\\Query\\Builder->get(Array)\n#9 /www/wwwroot/bbs/vendor/illuminate/database/Eloquent/Builder.php(503): Illuminate\\Database\\Eloquent\\Builder->getModels(Array)\n#10 /www/wwwroot/bbs/vendor/flarum/core/src/Discussion/Search/DiscussionSearcher.php(79): Illuminate\\Database\\Eloquent\\Builder->get()\n#11 /www/wwwroot/bbs/vendor/flarum/core/src/Api/Controller/ListDiscussionsController.php(86): Flarum\\Discussion\\Search\\DiscussionSearcher->search(Object(Flarum\\Search\\SearchCriteria), 20, 0)\n#12 /www/wwwroot/bbs/vendor/flarum/core/src/Api/Controller/AbstractSerializeController.php(96): Flarum\\Api\\Controller\\ListDiscussionsController->data(Object(Laminas\\Diactoros\\ServerRequest), Object(Tobscure\\JsonApi\\Document))\n#13 /www/wwwroot/bbs/vendor/flarum/core/src/Http/RouteHandlerFactory.php(38): Flarum\\Api\\Controller\\AbstractSerializeController->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#14 /www/wwwroot/bbs/vendor/flarum/core/src/Http/Middleware/DispatchRoute.php(65): Flarum\\Http\\RouteHandlerFactory->Flarum\\Http\\{closure}(Object(Laminas\\Diactoros\\ServerRequest), Array)\n#15 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\DispatchRoute->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Closure))\n#16 /www/wwwroot/bbs/vendor/fof/pwned-passwords/src/Middleware/CheckPasswordReset.php(55): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#17 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): FoF\\PwnedPasswords\\Middleware\\CheckPasswordReset->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#18 /www/wwwroot/bbs/vendor/fof/pwned-passwords/src/Middleware/CheckLoginPassword.php(45): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#19 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): FoF\\PwnedPasswords\\Middleware\\CheckLoginPassword->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#20 /www/wwwroot/bbs/vendor/fof/pwned-passwords/src/Middleware/PreventPwnedPassword.php(42): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#21 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): FoF\\PwnedPasswords\\Middleware\\PreventPwnedPassword->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#22 /www/wwwroot/bbs/vendor/fof/terms/src/Middlewares/RegisterMiddleware.php(54): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#23 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): FoF\\Terms\\Middlewares\\RegisterMiddleware->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#24 /www/wwwroot/bbs/vendor/flarum/core/src/Http/Middleware/SetLocale.php(50): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#25 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\SetLocale->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#26 /www/wwwroot/bbs/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(23): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#27 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\CheckCsrfToken->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#28 /www/wwwroot/bbs/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(55): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#29 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\AuthenticateWithHeader->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#30 /www/wwwroot/bbs/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(32): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#31 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\AuthenticateWithSession->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#32 /www/wwwroot/bbs/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(51): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#33 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\RememberFromCookie->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#34 /www/wwwroot/bbs/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#35 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\StartSession->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#36 /www/wwwroot/bbs/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#37 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Api\\Middleware\\FakeHttpMethods->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#38 /www/wwwroot/bbs/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#39 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\ParseJsonBody->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#40 /www/wwwroot/bbs/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#41 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\HandleErrors->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#42 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#43 /www/wwwroot/bbs/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\\Stratigility\\MiddlewarePipe->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#44 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\\RequestHandler->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#45 /www/wwwroot/bbs/vendor/middlewares/base-path-router/src/BasePathRouter.php(97): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#46 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\\BasePathRouter->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#47 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(42): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#48 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): Laminas\\Stratigility\\Middleware\\OriginalMessages->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#49 /www/wwwroot/bbs/vendor/middlewares/base-path/src/BasePath.php(53): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#50 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\\BasePath->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#51 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#52 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(73): Laminas\\Stratigility\\MiddlewarePipe->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\EmptyPipelineHandler))\n#53 /www/wwwroot/bbs/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(96): Laminas\\Stratigility\\MiddlewarePipe->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#54 /www/wwwroot/bbs/vendor/flarum/core/src/Http/Server.php(42): Laminas\\HttpHandlerRunner\\RequestHandlerRunner->run()\n#55 /www/wwwroot/bbs/public/index.php(26): Flarum\\Http\\Server->listen()\n#56 {main}\n\nNext Illuminate\\Database\\QueryException: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'user_id' in where clause is ambiguous (SQL: select `discussions`.* from `discussions` inner join `recipients` on `discussions`.`id` = `recipients`.`discussion_id` where (not exists (select 1 from `discussion_tag` where 0 = 1 and `discussions`.`id` = `discussion_id`) or `user_id` = 1 and (`discussions`.`is_private` = 0 or (`discussions`.`is_approved` = 0 or `discussions`.`id` in (select `discussion_id` from `recipients` where `removed_at` is null and `user_id` = 1 or `group_id` in (1)) or `discussions`.`id` in (select `posts`.`discussion_id` from `flags` left join `posts` on `flags`.`post_id` = `posts`.`id`)))) and (`recipients`.`user_id` in (1) or `recipients`.`group_id` in (1)) and (exists (select 1 from `recipients` where `discussions`.`id` = discussion_id and `removed_at` is null and (`user_id` = 1 or `group_id` in (1)))) order by `last_posted_at` desc limit 21) in /www/wwwroot/bbs/vendor/illuminate/database/Connection.php:664\nStack trace:\n#0 /www/wwwroot/bbs/vendor/illuminate/database/Connection.php(624): Illuminate\\Database\\Connection->runQueryCallback('select `discuss...', Array, Object(Closure))\n#1 /www/wwwroot/bbs/vendor/illuminate/database/Connection.php(333): Illuminate\\Database\\Connection->run('select `discuss...', Array, Object(Closure))\n#2 /www/wwwroot/bbs/vendor/illuminate/database/Query/Builder.php(2095): Illuminate\\Database\\Connection->select('select `discuss...', Array, true)\n#3 /www/wwwroot/bbs/vendor/illuminate/database/Query/Builder.php(2083): Illuminate\\Database\\Query\\Builder->runSelect()\n#4 /www/wwwroot/bbs/vendor/illuminate/database/Query/Builder.php(2569): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()\n#5 /www/wwwroot/bbs/vendor/illuminate/database/Query/Builder.php(2084): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure))\n#6 /www/wwwroot/bbs/vendor/illuminate/database/Eloquent/Builder.php(519): Illuminate\\Database\\Query\\Builder->get(Array)\n#7 /www/wwwroot/bbs/vendor/illuminate/database/Eloquent/Builder.php(503): Illuminate\\Database\\Eloquent\\Builder->getModels(Array)\n#8 /www/wwwroot/bbs/vendor/flarum/core/src/Discussion/Search/DiscussionSearcher.php(79): Illuminate\\Database\\Eloquent\\Builder->get()\n#9 /www/wwwroot/bbs/vendor/flarum/core/src/Api/Controller/ListDiscussionsController.php(86): Flarum\\Discussion\\Search\\DiscussionSearcher->search(Object(Flarum\\Search\\SearchCriteria), 20, 0)\n#10 /www/wwwroot/bbs/vendor/flarum/core/src/Api/Controller/AbstractSerializeController.php(96): Flarum\\Api\\Controller\\ListDiscussionsController->data(Object(Laminas\\Diactoros\\ServerRequest), Object(Tobscure\\JsonApi\\Document))\n#11 /www/wwwroot/bbs/vendor/flarum/core/src/Http/RouteHandlerFactory.php(38): Flarum\\Api\\Controller\\AbstractSerializeController->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#12 /www/wwwroot/bbs/vendor/flarum/core/src/Http/Middleware/DispatchRoute.php(65): Flarum\\Http\\RouteHandlerFactory->Flarum\\Http\\{closure}(Object(Laminas\\Diactoros\\ServerRequest), Array)\n#13 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\DispatchRoute->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Closure))\n#14 /www/wwwroot/bbs/vendor/fof/pwned-passwords/src/Middleware/CheckPasswordReset.php(55): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#15 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): FoF\\PwnedPasswords\\Middleware\\CheckPasswordReset->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#16 /www/wwwroot/bbs/vendor/fof/pwned-passwords/src/Middleware/CheckLoginPassword.php(45): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#17 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): FoF\\PwnedPasswords\\Middleware\\CheckLoginPassword->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#18 /www/wwwroot/bbs/vendor/fof/pwned-passwords/src/Middleware/PreventPwnedPassword.php(42): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#19 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): FoF\\PwnedPasswords\\Middleware\\PreventPwnedPassword->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#20 /www/wwwroot/bbs/vendor/fof/terms/src/Middlewares/RegisterMiddleware.php(54): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#21 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): FoF\\Terms\\Middlewares\\RegisterMiddleware->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#22 /www/wwwroot/bbs/vendor/flarum/core/src/Http/Middleware/SetLocale.php(50): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#23 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\SetLocale->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#24 /www/wwwroot/bbs/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(23): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#25 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\CheckCsrfToken->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#26 /www/wwwroot/bbs/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(55): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#27 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\AuthenticateWithHeader->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#28 /www/wwwroot/bbs/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(32): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#29 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\AuthenticateWithSession->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#30 /www/wwwroot/bbs/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(51): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#31 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\RememberFromCookie->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#32 /www/wwwroot/bbs/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#33 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\StartSession->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#34 /www/wwwroot/bbs/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#35 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Api\\Middleware\\FakeHttpMethods->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#36 /www/wwwroot/bbs/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#37 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\ParseJsonBody->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#38 /www/wwwroot/bbs/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#39 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\\Http\\Middleware\\HandleErrors->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#40 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#41 /www/wwwroot/bbs/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\\Stratigility\\MiddlewarePipe->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#42 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\\RequestHandler->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#43 /www/wwwroot/bbs/vendor/middlewares/base-path-router/src/BasePathRouter.php(97): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#44 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\\BasePathRouter->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#45 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(42): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#46 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): Laminas\\Stratigility\\Middleware\\OriginalMessages->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#47 /www/wwwroot/bbs/vendor/middlewares/base-path/src/BasePath.php(53): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#48 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\\BasePath->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\Next))\n#49 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\\Stratigility\\Next->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#50 /www/wwwroot/bbs/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(73): Laminas\\Stratigility\\MiddlewarePipe->process(Object(Laminas\\Diactoros\\ServerRequest), Object(Laminas\\Stratigility\\EmptyPipelineHandler))\n#51 /www/wwwroot/bbs/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(96): Laminas\\Stratigility\\MiddlewarePipe->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#52 /www/wwwroot/bbs/vendor/flarum/core/src/Http/Server.php(42): Laminas\\HttpHandlerRunner\\RequestHandlerRunner->run()\n#53 /www/wwwroot/bbs/public/index.php(26): Flarum\\Http\\Server->listen()\n#54 {main}" } ] }
[deleted] please stop posting your issue everywhere, have some patience so that an active maintainer can help resolve the issue. We're in different timezones and with different responsibilities, so that makes getting an answer within 4 minutes a bit hard. Thanks for your understanding.
fakruzaruret Why I can't convert private discussion to public?
This feature is being actively worked on. FriendsOfFlarum/byobu#56 I hope to have this released in the next version.
[deleted] can you please share the output of php flarum info? I assume you've also checked that you're using the latest version of the extension?
php flarum info
luceos 😄😄
May be he is an Turkish guy. We dont have patient 🙂
luceos 😁 my intention is not to get a quick solution, but to make the post appear in the latest state.
Why I can't convert private discussion to public? I think this is important. This feature is default on many paltform, seystem. I can change state of article between private and public or with password in wordpress.
fakruzaruret What is the version of your system? No error will be reported when using it?
