​Blank page in a local notebook workspace after rebooting my PC about affine HOT 7 OPEN

Guess we've both learned our lessons. 😭 Thank you so much either way, though. At least now I can scrape out some stuff I forgot, even if I can't perfectly restore it. Better than trying to force my poor goldfish brain to remember what the hell I wrote, at least. Hope you have a great day, and may we both remember to back our notes up!

from affine.

Issue Status: 🆕 *Untriaged

*🆕 Untriaged

The team has not yet reviewed the issue. We usually do it within one business day.
Docs: https://github.com/toeverything/AFFiNE/blob/canary/docs/issue-triaging.md

^{_{This is an automatic reply by the bot.}}

from affine.

Ok, so I found the original storage.db file (600mb) in a C:\Users\user\AppData\Roaming\AFFiNE\workspaces
So my notes are not gone 100%, just a scuffed format, thats a good news
But it still can't be imporded back in affine, saying its a "wrong file for a database",
even when this .db improted from outside of the C:\Users\user\AppData\Roaming folder.

Is the format the issue? Or the size of it? Or smth else

from affine.

So I checked the db file and found that the last notes are damaged, but the previous versions of notes inside of the .db are fine.
The problem occurred during the process of saving/updating the database file.
When Affine tried to save the file, I had 0 MB left on my disk storage,
which resulted in a corrupted note and a blank page scuffed format.
I hope this information is helpful to you

Do the backups, free up space so you have more than 0mb available, have a nice day :)

from affine.

Hi, I'm having the same problem. I'm a bit new to Affine and databases and whatnot, so I'm not really sure what to do. I've found the db file, but how did you roll back to a previous version of the notes? I tried checking the properties of the file, but it showed that there were no previous versions available. I've had these notes for a few days now and updated them a few times, so there should be a previous update of them in there, but I don't know how to check or how to go back to it to restore them.

from affine.

Hi, I'm having the same problem. I'm a bit new to Affine and databases and whatnot, so I'm not really sure what to do. I've found the db file, but how did you roll back to a previous version of the notes? I tried checking the properties of the file, but it showed that there were no previous versions available. I've had these notes for a few days now and updated them a few times, so there should be a previous update of them in there, but I don't know how to check or how to go back to it to restore them.

Hey, I didnt roll back the database, but instead opened the old scuffed .db file using both VSCode and Notepad++,
then used Ctrl+F in both editors in order to search for my notes based on what I had written before.

And to clean up the large chunks of data and extract just the text without the format,
I pasted it into Google Gemini 1.5 and asked it to extract the text without the formatting.
It works nicely cuz of the large ammount of context.
But in the end, had to recreate it all from scratch.

Yeah, it was a harsh lesson. Now, I'm backing it up regularly to restore it just in case. 😌

from affine.

the data is in binary format and if you own the data, we can help you recover it if still needed @kindadeadish

from affine.