mattermost / focalboard

Focalboard is an open source, self-hosted alternative to Trello, Notion, and Asana.
https://www.focalboard.com
Other
20.65k stars 1.81k forks source link

Bug: After mattermost migration from MySQL to Postgresql boards are behaving strangely #5019

Open moonaala opened 1 week ago

moonaala commented 1 week ago

Steps to reproduce the behavior

  1. I migrated mattermost to postgreSQL from MySQL.

  2. I followed all the steps mentioned on this page: https://docs.mattermost.com/deploy/postgres-migration.html

  3. After mattermost migration from MySQL to Postgresql boards are behaving strangely

  4. On a team, i get the boards on my desktop app and on other team i am getting error of You are about to join a private board. But the same board which worked on my desktop app is showing joining private board message on web version.

  5. For the one which works on my desktop app here is the url https://mattermost-server/plugins/focalboard/api/v2/teams/w8orwn8u7bg4x8da9gqosuomna/users

  6. On web, i am getting {"error":"User IDs are empty","errorCode":400} error

  7. Other errors: That is something like this

URL: https://mattermost-server/plugins/focalboard/api/v2/boards/b8dy7huuhtpdftx385htrmn4agh/blocks?all=true

Response: {"error":"{boards} not found","errorCode":404}

Expected behavior

All the boards should work on both web and desktop and all the users must be able to see the same output.

If applicable, add screenshots or a screen recording to elaborate on the problem.

Edition and Platform