Missing notes & notebooks

Hello there,
I have the problem that several notebooks went missing.

I noticed it as I wanted to add a note via the webclipper and couldn’t find the notebook I was aiming for.

It seems that the notes don’t seem to be gone for good. If I e.g. search for a word contained in one of the missing notes in the Joplin folder on Nextcloud I get a “xxx.md” file displayed. If i open it in a texteditor like sublime I can see that this is one of the missing notes.

Is there a way to get the notes back into joplin?


I don’t think that debugging will help, but it pushed me in the direction of reading the log.txt. and it seems that 10 days ago my total amount of folders was reduced by 8 caused by an update of the FTS table ?

2020-08-16 08:32:18: "Total folders: 57"
2020-08-16 08:32:18: "Total notes: 214"
2020-08-16 08:32:18: "Total resources: 233"
2020-08-16 08:32:19: "DecryptionWorker: cannot start because no master key is currently loaded."
2020-08-16 08:38:23: "RevisionService::maintenance: Starting..."
2020-08-16 08:38:23: "RevisionService::maintenance: Service is enabled"
2020-08-16 08:38:23: "RevisionService::collectRevisions: Created revisions for 0 notes"
2020-08-16 08:38:23: "RevisionService::maintenance: Done in 126ms"
2020-08-16 08:41:16: "SearchEngine: Updating FTS table..."
2020-08-16 08:41:16: "SearchEngine: Updated FTS table in 57ms. Inserted: 1. Deleted: 1"
2020-08-16 08:41:29: "SearchEngine: Updating FTS table..."
2020-08-16 08:41:30: "SearchEngine: Updated FTS table in 180ms. Inserted: 0. Deleted: 23"
2020-08-16 08:41:50: "Preparing scheduled sync"
2020-08-16 08:41:50: "Starting scheduled sync"
2020-08-16 08:44:19: "SearchEngine: Updating FTS table..."
2020-08-16 08:44:19: "SearchEngine: Updated FTS table in 11ms. Inserted: 0. Deleted: 0"
2020-08-16 08:44:47: "SearchEngine: Updating FTS table..."
2020-08-16 08:44:47: "SearchEngine: Updated FTS table in 47ms. Inserted: 1. Deleted: 0"
2020-08-16 08:44:58: "SearchEngine: Updating FTS table..."
2020-08-16 08:44:58: "SearchEngine: Updated FTS table in 60ms. Inserted: 1. Deleted: 0"
2020-08-16 08:45:21: "SearchEngine: Updating FTS table..."
2020-08-16 08:45:22: "SearchEngine: Updated FTS table in 75ms. Inserted: 1. Deleted: 0"
2020-08-16 08:45:49: "SearchEngine: Updating FTS table..."
2020-08-16 08:45:49: "SearchEngine: Updated FTS table in 59ms. Inserted: 1. Deleted: 0"
2020-08-16 08:46:10: "SearchEngine: Updating FTS table..."
2020-08-16 08:46:10: "SearchEngine: Updated FTS table in 5ms. Inserted: 0. Deleted: 0"
2020-08-16 08:46:27: "SearchEngine: Updating FTS table..."
2020-08-16 08:46:27: "SearchEngine: Updated FTS table in 3ms. Inserted: 0. Deleted: 0"
2020-08-16 08:48:23: "RevisionService::maintenance: Starting..."
2020-08-16 08:48:23: "RevisionService::maintenance: Service is enabled"
2020-08-16 08:48:24: "RevisionService::collectRevisions: Created revisions for 26 notes"
2020-08-16 08:48:24: "RevisionService::maintenance: Done in 1267ms"
2020-08-16 08:54:24: "TaskQueue.stop: syncDownload: waiting for tasks to complete: 0"
2020-08-16 08:54:24: "TaskQueue.stop: syncDownload: Done, waited for 0"
2020-08-16 08:54:24: "Operations completed: "
2020-08-16 08:54:24: "updateRemote: 1"
2020-08-16 08:54:24: "deleteRemote: 30"
2020-08-16 08:54:24: "Total folders: 49"
2020-08-16 08:54:24: "Total notes: 190"
2020-08-16 08:54:24: "Total resources: 233"

Same for me whhen using Joplin with nextcloud WebDav. Note turns up in Nextcloud folder but cannot be found in Joplin. Importing the note into Joplin results in the sourcecode (XML?) beeing displayed in Joplin.
Same for Joplin on Win10 and Android.

  • Were files in the folder modified manually or with other programs?
  • Have you deleted the note (Than this is from the note history)
  • Is the type_:1 in the file?

There are several options for restoring the note:

  1. Ctrl+Shift+P, then restoreNoteRevision NOTE_ID
  2. Copy the content from the file
  3. You can create a empty folder and place the file in it and then try to import it via 'RAW - Joplin export Directory'
1 Like

Thanks for your help!
For your questions:

  1. At least I did not change anything intentionally.
  2. Did not delete
  3. type_: 13

On restoring the note I get the following

  1. does not work, I get an error 'No revision for note "7777fe5981b14ee2b8921a3f993ae66c"'
  2. would require some manual formatting as the content is not really human readable
  3. results in error message:

[Window Title]
Joplin

[Content]
Error: SQLITE_CONSTRAINT: UNIQUE constraint failed: revisions.id: INSERT INTO revisions (id, parent_id, item_type, item_id, item_updated_time, title_diff, body_diff, metadata_diff, encryption_cipher_text, encryption_applied, updated_time, created_time) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?): 7777fe5981b14ee2b8921a3f993ae66c,,1,d193a2f2d701467fb91ac1f3b4b30e61,1624101522937,@@ -0,0 +1,6 @@
+L-Boxx
,@@ -0,0 +1,193 @@
+Bosch L-Boxx 102 Gr.1 (17,77%E2%82%AC)%0A%0ABosch L-Boxx 136 Gr.2%C2%A0 (22,90%E2%82%AC)%0A%0A1. Winkelschleifer%0A2. Schleifpapier%0A%0ABosch L-Boxx 238 Gr.3%0A%0A1. Bandschleifer (mit selbst gemachter Ein%0A%0ABosch L-Boxx 374 Gr.4
,{"new":{"id":"d193a2f2d701467fb91ac1f3b4b30e61","parent_id":"7a04059cdcb64c12a14181a2dafd3eec","latitude":"0.00000000","longitude":"0.00000000","altitude":"0.0000","author":"","source_url":"","is_todo":0,"todo_due":0,"todo_completed":0,"source":"joplin","source_application":"net.cozic.joplin-mobile","application_data":"","order":1623018342868,"markup_language":1,"is_shared":0},"deleted":[]},,0,1624101541652,1624101541652

[OK]

This is how the file looks.

id: 7777fe5981b14ee2b8921a3f993ae66c
parent_id: 
item_type: 1
item_id: d193a2f2d701467fb91ac1f3b4b30e61
item_updated_time: 1624101522937
title_diff: "@@ -0,0 +1,6 @@\n+L-Boxx\n"
body_diff: "@@ -0,0 +1,193 @@\n+Bosch L-Boxx 102 Gr.1 (17,77%E2%82%AC)%0A%0ABosch L-Boxx 136 Gr.2%C2%A0 (22,90%E2%82%AC)%0A%0A1.  Winkelschleifer%0A2.  Schleifpapier%0A%0ABosch L-Boxx 238 Gr.3%0A%0A1.  Bandschleifer (mit selbst gemachter Ein%0A%0ABosch L-Boxx 374 Gr.4\n"
metadata_diff: {"new":{"id":"d193a2f2d701467fb91ac1f3b4b30e61","parent_id":"7a04059cdcb64c12a14181a2dafd3eec","latitude":"0.00000000","longitude":"0.00000000","altitude":"0.0000","author":"","source_url":"","is_todo":0,"todo_due":0,"todo_completed":0,"source":"joplin","source_application":"net.cozic.joplin-mobile","application_data":"","order":1623018342868,"markup_language":1,"is_shared":0},"deleted":[]}
encryption_cipher_text: 
encryption_applied: 0
updated_time: 2021-06-19T11:19:01.652Z
created_time: 2021-06-19T11:19:01.652Z
type_: 13

This is a revision (only difference from a note), not a note and can't be imported.

The note id is: d193a2f2d701467fb91ac1f3b4b30e61, so you can try restoreNoteRevision d193a2f2d701467fb91ac1f3b4b30e61

1 Like

Nice! That did the trick! Thank you so much!