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.
FriendsOfFlarum Byōbu, well integrated, advanced private discussions
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.
0.4.3
- Add setting to restrict new PDs into a designated tag
- When new setting is active, tags are removed from DiscussionList and HeroItems
- Tag selection is removed from PrivateDiscussionComposer, when setting is active
Updating
composer require fof/byobu
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?
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.
- Edited
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.
HD3D I see~ The issue you said is do important.
Nice update with ability to set automatic (private messages) tag.
I have few questions:
- 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? in permissions I can restrict by tag Inbox users from creating discussion and ability to create private discussions in this tag. But if user try to create Private discussion with default tag - "You do not have permission to do that."
- If I open user card page. And via Contols button send Private Message - its ok and default tag for PM loads successfully. But if 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. Same behavior (not loading a default tag ) if I'm trying to send message via User Directory. Sometimes it loads sometimes not...
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 ...
[deleted]
- Edited
{
"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}"
}
]
}
May be he is an Turkish guy. We dont have patient
[deleted]
luceos my intention is not to get a quick solution, but to make the post appear in the latest state.
- Edited
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.