Board are gone after upgrading to v. 7.4.4, but db remains

[candidexmedia]

Hello! I upgraded to v. 7.4.4, but Focalboard is not finding my boards... They seem to have disapeared.

That said, my database file is still there.

How can I retrieve my boards?

[wuwinson]

@candidexmedia Can you provide more details to help us investigate? Thanks!

• Edition: Personal Desktop / Personal Server / Mattermost Boards (plugin)
• Version: [Which version did you upgrade from?]
• Browser and OS: [e.g. Chrome on Mac, Edge on Windows]
• Logs: Screenshots of server logs if available

[wuwinson]

@wiggin77 Can you help look into this bug? Thanks! @sbishel

[candidexmedia]

Edition: Personal Desktop Version: I'm not sure which version I upgraded from, to be honest... It was likely a release from the summer of this year Browser and OS: Windows (downloaded from GitHub, not the MS Store) Logs: Not sure where to find that

[candidexmedia]

Hi, I've updated to 7.5.1 and still cannot access my boards. Please advise on the next steps, or ways I can convert the db to another format. I was using Focalboard to keep track of various projects, and I cannot proceed without my boards.

[wuwinson]

@candidexmedia It looks like the latest Windows version from Github is potentially pulling from a db in a different location.

See https://github.com/mattermost/focalboard/discussions/2169 for details.

I suspect your original db might be located in: My Documents\Focalboard

But the latest version of boards is actually storing the db in: C:\Users\USERID\AppData\Local\Packages\MattermostInc.Focalboard_g26br8h4erjr8\LocalState, where MattermostInc.Focalboard_g26br8h4erjr8

Can you try to locate focalboard.db from the My Documents folder and copy it over to the 2nd path? Please backup the focalboard.db files from both locations before doing so. Let us know if that worked. Thanks! cc @wiggin77

[candidexmedia]

@wuwinson Thanks for guidance. I did indeed have the standalone stored in Documents\Focalboard

Unfortunately, I didn't find a Mattermost folder under C:\Users\USERID\AppData\Local\Packages\. In fact, when I create a new board in focalboard and close the app, the board is no longer there when I reopen the app. I'm not sure what's going on

[candidexmedia]

Also: I don't typically use the Microsoft Store version of the app, because it's still running the March 2022 version of Focalboard (v. 0.15.0). I prefer the standalone .exe

[wiggin77]

Unfortunately, I didn't find a Mattermost folder under C:\Users\USERID\AppData\Local\Packages\. In fact, when I create a new board in focalboard and close the app, the board is no longer there when I reopen the app.

@candidexmedia what directory is your focalboard.db getting created in?

[candidexmedia]

In the past, the database would be created in My Documents\Focalboard (the program itself was stored in My Documents\Focalboard\focalboard-win).

But now, no database is created at all. I've even tried saving the standalone Focalboard program in another random folder, and I get the same issue.

It looks like C:\Users\USERID\AppData\Local\Packages\ is only applicable for the Microsoft store version (which is outdated).

[wiggin77]

But now, no database is created at all.

@candidexmedia if no database file is truly created then the config is telling it to create an in-memory database, which is not the default that ships with our releases. Can you provide your config file?

[candidexmedia]

I've tested it on a separate device, and realized that I had to delete the following folder so that the standalone app could generate a new db: My Documents\Focalboard

That said, this doesn't resolve the issue I have with not being able to access my previous existing database (with all my boards). I opened the new database and previous database in SQLiteStudio, and noticed that the number of tables and structures is different:

The top focalboard.db is the old one, and the one at the bottom is the latest one. I can open the latest one in the newest Focalboard standalone app for Windows, but opening the top one either freezes the app, or shows a blank app (as though there was no database) and doesn't save any changes once you close and reopen.

I feel like we're getting closer to the solution, but I just need to be able to open my old database in the new version.

@candidexmedia if no database file is truly created then the config is telling it to create an in-memory database, which is not the default that ships with our releases. Can you provide your config file?

{
    "serverRoot": "http://localhost:8088",
    "port": 8088,
    "dbtype": "sqlite3",
    "dbconfig": "./focalboard.db",
    "useSSL": false,
    "webpath": "./pack",
    "filespath": "./files",
    "telemetry": true,
    "localOnly": true
}

[wiggin77]

@candidexmedia can you query the contents of schema_migrations?

[candidexmedia]

@candidexmedia can you query the contents of schema_migrations?

@wiggin77 Here it is:

1 init 2 system_settings_table 3 blocks_rootid 4 auth_table 5 blocks_modifiedby 6 sharing_table 7 workspaces_table 8 teams 9 blocks_history 10 blocks_created_by 11 match_collation 12 match_column_collation 13 millisecond_timestamps 14 add_not_null_constraint 15 blocks_history_no_nulls 16 subscriptions_table 17 add_file_info 18 add_teams_and_boards 19 populate_categories 20 populate_category_blocks 21 create_boards_members_history 22 create_default_board_role 23 persist_category_collapsed_state 24 mark_existsing_categories_collapsed 25 indexes_update 26 create_preferences_table 27 migrate_user_props_to_preferences 28 remove_template_channel_link 29 add_category_type_field

[wiggin77]

Thanks @candidexmedia. Are you sure you've not at any point run a version later than 7.4.4? There is a data migration in the list above that does not appear until 7.5

Sorry - re-reading the thread I see you upgraded to 7.5.1

[wiggin77]

Is your experience the same as https://github.com/mattermost/focalboard/issues/4293 ?

[candidexmedia]

Is your experience the same as #4293 ?

I am not. I'm not using Docker, but the Windows standalone, so there is no URL that can be retrieved.

[candidexmedia]

I've installed the latest version in the same directory, and it won't even open... I still can't properly access my tasks.

[wiggin77]

@candidexmedia have you been able to resolve this?

[candidexmedia]

@wiggin77 I haven't, unfortunately. My boards are still completely gone.

[candidexmedia]

Hi @wiggin77 : the issue has not been resolved. I haven't been able to access my boards for the past 8 months, regardless of the version.

Why was this issue closed?

[wiggin77]

Apologies. It was closed unintentionally. Can you let me know what the current state is? When you try to open your old database with the latest version, what happens? Can you send logs with any error messages?

[candidexmedia]

When you try to open your old database with the latest version, what happens?

The software doesn't open at all if the old db is there. It will only open if there's a blank database file. Should I send the db file over to you? It may be easier to debug that way.

How do I find logs and error messages?

[wiggin77]

@candidexmedia if you send me the DB I will debug the issue. You can drop it here, or if you prefer, you can DM me at https://community.mattermost.com (doug.lauder)

[candidexmedia]

Ok, I've sent you a DM.