FriendsOfFlarum Byōbu, well integrated, advanced private discussions

x06174

PHP 7.3
MySQL 8.0

Next Illuminate\Database\QueryException: SQLSTATE[HY000]: General error: 1525 Incorrect TIMESTAMP value: 'null' (SQL: select `users`.*, `recipients`.`discussion_id` as `pivot_discussion_id`, `recipients`.`user_id` as `pivot_user_id`, `recipients`.`created_at` as `pivot_created_at`, `recipients`.`updated_at` as `pivot_updated_at` from `users` inner join `recipients` on `users`.`id` = `recipients`.`user_id` where `recipients`.`removed_at` != null and `recipients`.`discussion_id` in (1, 2)) in /home/storage_01/data_04/web_0004/domain/public_html/vendor/illuminate/database/Connection.php:664
Stack trace:
#0 /home/storage_01/data_04/web_0004/domain/public_html/vendor/illuminate/database/Connection.php(624): Illuminate\Database\Connection->runQueryCallback('select `users`....', Array, Object(Closure))
#1 /home/storage_01/data_04/web_0004/domain/public_html/vendor/illuminate/database/Connection.php(333): Illuminate\Database\Connection->run('select `users`....', Array, Object(Closure))
#2 /home/storage_01/data_04/web_0004/domain/public_html/vendor/illuminate/database/Query/Builder.php(2095): Illuminate\Database\Connection->select('select `users`....', Array, true)
#3 /home/storage_01/data_04/web_0004/domain/public_html/vendor/illuminate/database/Query/Builder.php(2083): Illuminate\Database\Query\Builder->runSelect()
#4 /home/storage_01/data_04/web_0004/domain/public_html/vendor/illuminate/database/Query/Builder.php(2569): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#5 /home/storage_01/data_04/web_0004/domain/public_html/vendor/illuminate/database/Query/Builder.php(2084): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure))
#6 /home/storage_01/data_04/web_0004/domain/public_html/vendor/illuminate/database/Eloquent/Builder.php(519): Illuminate\Database\Query\Builder->get(Array)
#7 /home/storage_01/data_04/web_0004/domain/public_html/vendor/illuminate/database/Eloquent/Relations/BelongsToMany.php(584): Illuminate\Database\Eloquent\Builder->getModels()
#8 /home/storage_01/data_04/web_0004/domain/public_html/vendor/illuminate/database/Eloquent/Relations/Relation.php(144): Illuminate\Database\Eloquent\Relations\BelongsToMany->get()
#9 /home/storage_01/data_04/web_0004/domain/public_html/vendor/illuminate/database/Eloquent/Builder.php(567): Illuminate\Database\Eloquent\Relations\Relation->getEager()
#10 /home/storage_01/data_04/web_0004/domain/public_html/vendor/illuminate/database/Eloquent/Builder.php(536): Illuminate\Database\Eloquent\Builder->eagerLoadRelation(Array, 'oldRecipientUse...', Object(Closure))
#11 /home/storage_01/data_04/web_0004/domain/public_html/vendor/illuminate/database/Eloquent/Collection.php(60): Illuminate\Database\Eloquent\Builder->eagerLoadRelations(Array)
#12 /home/storage_01/data_04/web_0004/domain/public_html/vendor/flarum/core/src/Api/Controller/ListDiscussionsController.php(99): Illuminate\Database\Eloquent\Collection->load(Array)
#13 /home/storage_01/data_04/web_0004/domain/public_html/vendor/flarum/core/src/Api/Controller/AbstractSerializeController.php(98): Flarum\Api\Controller\ListDiscussionsController->data(Object(Zend\Diactoros\ServerRequest), Object(Tobscure\JsonApi\Document))
#14 /home/storage_01/data_04/web_0004/domain/public_html/vendor/flarum/core/src/Api/Client.php(71): Flarum\Api\Controller\AbstractSerializeController->handle(Object(Zend\Diactoros\ServerRequest))
#15 /home/storage_01/data_04/web_0004/domain/public_html/vendor/flarum/core/src/Forum/Content/Index.php(91): Flarum\Api\Client->send(Object(Flarum\Api\Controller\ListDiscussionsController), Object(Flarum\User\User), Array)
#16 /home/storage_01/data_04/web_0004/domain/public_html/vendor/flarum/core/src/Forum/Content/Index.php(59): Flarum\Forum\Content\Index->getApiDocument(Object(Flarum\User\User), Array)
#17 /home/storage_01/data_04/web_0004/domain/public_html/vendor/flarum/core/src/Frontend/Frontend.php(65): Flarum\Forum\Content\Index->__invoke(Object(Flarum\Frontend\Document), Object(Zend\Diactoros\ServerRequest))
#18 /home/storage_01/data_04/web_0004/domain/public_html/vendor/flarum/core/src/Frontend/Frontend.php(57): Flarum\Frontend\Frontend->populate(Object(Flarum\Frontend\Document), Object(Zend\Diactoros\ServerRequest))
#19 /home/storage_01/data_04/web_0004/domain/public_html/vendor/flarum/core/src/Frontend/Controller.php(34): Flarum\Frontend\Frontend->document(Object(Zend\Diactoros\ServerRequest))
#20 /home/storage_01/data_04/web_0004/domain/public_html/vendor/flarum/core/src/Http/RouteHandlerFactory.php(40): Flarum\Frontend\Controller->handle(Object(Zend\Diactoros\ServerRequest))
#21 /home/storage_01/data_04/web_0004/domain/public_html/vendor/flarum/core/src/Http/Middleware/DispatchRoute.php(67): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}(Object(Zend\Diactoros\ServerRequest), Array)
#22 /home/storage_01/data_04/web_0004/domain/public_html/vendor/zendframework/zend-stratigility/src/Next.php(60): Flarum\Http\Middleware\DispatchRoute->process(Object(Zend\Diactoros\ServerRequest), Object(Closure))
#23 /home/storage_01/data_04/web_0004/domain/public_html/vendor/flarum/core/src/Http/Middleware/ShareErrorsFromSession.php(58): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#24 /home/storage_01/data_04/web_0004/domain/public_html/vendor/zendframework/zend-stratigility/src/Next.php(60): Flarum\Http\Middleware\ShareErrorsFromSession->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#25 /home/storage_01/data_04/web_0004/domain/public_html/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#26 /home/storage_01/data_04/web_0004/domain/public_html/vendor/zendframework/zend-stratigility/src/Next.php(60): Flarum\Http\Middleware\SetLocale->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#27 /home/storage_01/data_04/web_0004/domain/public_html/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(25): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#28 /home/storage_01/data_04/web_0004/domain/public_html/vendor/zendframework/zend-stratigility/src/Next.php(60): Flarum\Http\Middleware\CheckCsrfToken->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#29 /home/storage_01/data_04/web_0004/domain/public_html/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(34): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#30 /home/storage_01/data_04/web_0004/domain/public_html/vendor/zendframework/zend-stratigility/src/Next.php(60): Flarum\Http\Middleware\AuthenticateWithSession->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#31 /home/storage_01/data_04/web_0004/domain/public_html/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#32 /home/storage_01/data_04/web_0004/domain/public_html/vendor/zendframework/zend-stratigility/src/Next.php(60): Flarum\Http\Middleware\RememberFromCookie->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#33 /home/storage_01/data_04/web_0004/domain/public_html/vendor/flarum/core/src/Http/Middleware/StartSession.php(62): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#34 /home/storage_01/data_04/web_0004/domain/public_html/vendor/zendframework/zend-stratigility/src/Next.php(60): Flarum\Http\Middleware\StartSession->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#35 /home/storage_01/data_04/web_0004/domain/public_html/vendor/flarum/core/src/Http/Middleware/CollectGarbage.php(48): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#36 /home/storage_01/data_04/web_0004/domain/public_html/vendor/zendframework/zend-stratigility/src/Next.php(60): Flarum\Http\Middleware\CollectGarbage->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#37 /home/storage_01/data_04/web_0004/domain/public_html/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(29): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#38 /home/storage_01/data_04/web_0004/domain/public_html/vendor/zendframework/zend-stratigility/src/Next.php(60): Flarum\Http\Middleware\ParseJsonBody->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#39 /home/storage_01/data_04/web_0004/domain/public_html/vendor/flarum/core/src/Http/Middleware/HandleErrorsWithView.php(67): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#40 /home/storage_01/data_04/web_0004/domain/public_html/vendor/zendframework/zend-stratigility/src/Next.php(60): Flarum\Http\Middleware\HandleErrorsWithView->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#41 /home/storage_01/data_04/web_0004/domain/public_html/vendor/zendframework/zend-stratigility/src/MiddlewarePipe.php(83): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#42 /home/storage_01/data_04/web_0004/domain/public_html/vendor/middlewares/request-handler/src/RequestHandler.php(84): Zend\Stratigility\MiddlewarePipe->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#43 /home/storage_01/data_04/web_0004/domain/public_html/vendor/zendframework/zend-stratigility/src/Next.php(60): Middlewares\RequestHandler->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#44 /home/storage_01/data_04/web_0004/domain/public_html/vendor/middlewares/base-path-router/src/BasePathRouter.php(97): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#45 /home/storage_01/data_04/web_0004/domain/public_html/vendor/zendframework/zend-stratigility/src/Next.php(60): Middlewares\BasePathRouter->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#46 /home/storage_01/data_04/web_0004/domain/public_html/vendor/zendframework/zend-stratigility/src/Middleware/OriginalMessages.php(41): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#47 /home/storage_01/data_04/web_0004/domain/public_html/vendor/zendframework/zend-stratigility/src/Next.php(60): Zend\Stratigility\Middleware\OriginalMessages->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#48 /home/storage_01/data_04/web_0004/domain/public_html/vendor/middlewares/base-path/src/BasePath.php(53): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#49 /home/storage_01/data_04/web_0004/domain/public_html/vendor/zendframework/zend-stratigility/src/Next.php(60): Middlewares\BasePath->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\Next))
#50 /home/storage_01/data_04/web_0004/domain/public_html/vendor/zendframework/zend-stratigility/src/MiddlewarePipe.php(83): Zend\Stratigility\Next->handle(Object(Zend\Diactoros\ServerRequest))
#51 /home/storage_01/data_04/web_0004/domain/public_html/vendor/zendframework/zend-stratigility/src/MiddlewarePipe.php(72): Zend\Stratigility\MiddlewarePipe->process(Object(Zend\Diactoros\ServerRequest), Object(Zend\Stratigility\EmptyPipelineHandler))
#52 /home/storage_01/data_04/web_0004/domain/public_html/vendor/zendframework/zend-httphandlerrunner/src/RequestHandlerRunner.php(95): Zend\Stratigility\MiddlewarePipe->handle(Object(Zend\Diactoros\ServerRequest))
#53 /home/storage_01/data_04/web_0004/domain/public_html/vendor/flarum/core/src/Http/Server.php(46): Zend\HttpHandlerRunner\RequestHandlerRunner->run()
#54 /home/storage_01/data_04/web_0004/domain/public_html/public/index.php(22): Flarum\Http\Server->listen()
#55 {main}

theportablegeek

Is it possible to make a Byobu private conversation public? I cant seem to remove all the recipient tags...

luceos

theportablegeek it should be.

alanrezende

When I try to create a private post, or set a public post to private, I get Oops! Something went wrong. Please reload the page and try again. and then the post disapears. :

luceos

alanrezende can you check the flarum log file under storage/logs?

alanrezende

Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (deebrasil_forum.tbz_recipients, CONSTRAINTtbz_recipients_user_id_foreignFOREIGN KEY (user_id) REFERENCEStbz_users(id) ON DELETE CASCADE) in /home/deebrasil/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117

alanrezende

@luceos Looks like the tbz_recipients user_id could not be null, so we always need a user ID, when I try to set it only to Admins group the error was show, the discussions.is_private was changed to true and when no entries could be created in recipients table, the post could not be seen by nobody.

Directly in database:

I changed is_private back to false
Changed the recipients.user_id to nullable
It all works now

mrnemesys

alanrezende Hi, can you tell the name of the table please. Don't find it 😢

mrnemesys

mrnemesys found it ^^ tbz_ is your prefix ^^ thanks

alanrezende

mrnemesys Exactly!

youngseebi

Hello,

Is it possible to change the error message non-accepted users receive?

When I send a locked link to a user who’s not logged in, the receive an error rather than telling them to login to access the page.

Thanks.

Ralkage

0.3.4

Private discussions user page fixes
- Hid private discussions user page link from guests.
- Fixed private discussions page breaking when user is loaded async.

Updating

composer update fof/byobu
php flarum migrate

Thank you @clarkwinkelmann for your bug fixes 😘

Lolu

luceos The counter still counts messages from the extension.

SpacellaGaming

Keep getting the "reload" error and reloading doesn't help.

Log file: https://anonfile.com/66D2xd51n3/flarum-2019-09-10_log

imbyter

FriendsOfFlarum I met a problem. It is OK when I create a post with a user , but a problem when i add a group to the provate post:

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (dbtest.recipients, CONSTRAINTrecipients_user_id_foreignFOREIGN KEY (user_id) REFERENCESusers(id) ON DELETE CASCADE) in /var/www/html/dbtest/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117↵Stack trace:↵#0 /var/www/html/dbtest/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(117): PDOStatement->execute(NULL)↵#1 /var/www/html/dbtest/vendor/illuminate/database/Connection.php(458): Doctrine\DBAL\Drive

Please help! 😿

luceos

imbyter is it possible that one of the recipient users was deleted?

imbyter

luceos no, i can add any user as recipient to see my post, but can't add any group name to see my post. Group can't,

Thoran

luceos i have the same error when i want to add topic with participants

Next Illuminate\Database\QueryException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (hexah_forum.recipients, CONSTRAINT recipients_user_id_foreign FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE CASCADE) (SQL: insert into recipients (created_at, discussion_id, group_id, updated_at) values (2019-10-31 22:30:59, 4, 5, 2019-10-31 22:30:59)) in vendor/illuminate/database/Connection.php:664

nitaaikumar

Thanks so much for the hard work being put in this extension.

I wanted to use it only for the members to ask private queries to mods or admins and not for member to member private communication. Since they can't ask personal questions in the public discussions. Like a support ticket system somewhat. Can there be a setting addded which will allow a member to start a private discussion with only an admin or mod? Or it is already there? Thank you so much in advance.

taciturasa

I can't seem to add groups to a byobu discussion. When I do, it errors out. Can't access the console, as I am on FreeFlarum.

luceos

Thoran I think I know what is happening. Was a user deleted that was currently a recipient of the discussion?

ikseek

Thoran
Did you find what triggers that error?
I'm seeing the same issue immediately after install.
Here is the reproducer docker-compose.yml:

version: "3"

services:
  flarum:
    image: mondedie/docker-flarum:0.1.0-beta.11.1-stable
    container_name: flarum
    ports:
      - "80:8888"
    environment:
      - DEBUG=true
      - FORUM_URL=http://localhost
      - DB_HOST=mysql
      - DB_NAME=flarum
      - DB_USER=flarum
      - DB_PASS=db_passw0rd
      - DB_PREF=flarum_
      - DB_PORT=3306
      - FLARUM_ADMIN_USER=admin
      - FLARUM_ADMIN_PASS=passw0rd
      - FLARUM_ADMIN_MAIL=admin@mail.com
      - FLARUM_TITLE=my flarum

    volumes:
      - /data/flarum/assets:/flarum/app/public/assets
      - /data/flarum/extensions:/flarum/app/extensions
      - /data/flarum/nginx:/etc/nginx/conf.d
    depends_on:
      - mysql

  mysql:
    image: mysql:5.7
    container_name: mysql
    environment:
      - MYSQL_ROOT_PASSWORD=db_passw0rd
      - MYSQL_DATABASE=flarum
      - MYSQL_USER=flarum
      - MYSQL_PASSWORD=db_passw0rd
    volumes:
      - /data/flarum/mysql/db:/var/lib/mysql

Having it in current dir run and login with admin/passw0rd

% docker-compose up -d mysql 
# Wait until it initializes
% docker-compose up -d flarum  
docker exec -ti flarum extension require fof/byobu

Posting a message to "Mods" group shows that error.

« Previous Page Next Page »