[Bug]: Playlists stopped working

[YonderGod]

Guidelines

• I have encountered this bug in the latest release of FreeTube.
• I have encountered this bug in the official downloads of FreeTube.
• I have searched the issue tracker for open and closed issues that are similar to the bug report I want to file, without success.
• I have searched the documentation for information that matches the description of the bug I want to file, without success.
• This issue contains only one bug.

Describe the bug

All previous playlists are gone and cannot create a new one. It was working normally an hour ago.
Same thing happens whether I'm clicking the + button on a video or on the Playlist tab.
The message "Playlist _____ has been created successfully" appears, but the playlist isn't listed and I can't add a video to it.

Expected Behavior

Create playlist button should create a playlist.
Return old playlists to the list if possible.

Issue Labels

feature stopped working

FreeTube Version

v0.21.3 Beta

Operating System Version

Windows 10 Pro V22H2

Installation Method

.exe

Primary API used

Local API

Last Known Working FreeTube Version (If Any)

No response

Additional Information

I am not sure if this is related, but it seems to have started happening at the same time. When I close FreeTube and re-open it I get this error. I have to go to task manager and end the process before I can open FreeTube again.

Screenshots:

Nightly Build

• I have encountered this bug in the latest nightly build.

[YonderGod]

My issue is sort-of resolved but I'll just leave this info here in case the devs want to troubleshoot it.
I reinstalled windows for an unrelated reason, and then installed FreeTube and playlists were working correctly. So I guess it was some sort of glitch with my installation.
I wanted at least my subscriptions back so I copied over the whole FreeTube folder in appdata. The original issue came back like I suspected would happen. So I exported my subscriptions, history, and playlists, then went back to the known-working appdata folder, and then imported them. My old playlists "Favorites" and "Watch later" were back (except they are empty) plus I got ONE of the playlists called "test" that I was trying to create when I was having the issue.
So in the end, it's not a big deal to me but if you guys want the appdata folder or more info to try to figure out what caused it, let me know.

[efb4f5ff-1298-471a-8973-3d47447115dc]

Hi @YonderGod would it be possible for you to provide the files?

[YonderGod]

Hi @YonderGod would it be possible for you to provide the files?

I can, but I'm not sure if there's any personal info other than subscriptions and watch history? You want me to upload the whole \AppData\Roaming\FreeTube folder?

[efb4f5ff-1298-471a-8973-3d47447115dc]

The .db files are enough.

[YonderGod]

The .db files are enough.

Ok, I'm not sure if they will be enough since I was able to export and then import on my new install, but you can check it.
db.zip

[Valnir17]

Reporting the same issue on Linux mint.

[Valnir17]

playlists.db.zip

My playlists.db for if it can help

[Valnir17]

Any news?

[YonderGod]

Any news?

If you just want it to work for now; export your info, uninstall Freetube, delete the appdata folder (or move it if you want to keep it to help with troubleshooting), reinstall.

[Valnir17]

Thanks!

[efb4f5ff-1298-471a-8973-3d47447115dc]

Hi @YonderGod and @Valnir17, I have attempted to uncorrupt your files:

• Valnir17_playlists.zip
• YonderGod_playlists.zip

Corruption of your databases can happen when FT didnt have enough time to write the data to the databases for example when you shutdown your machine but FT is still running. I recommend to always close FT properly to prevent data loss.

More on this topic in #4762