search

zadam / trilium

Build your personal knowledge base with Trilium Notes
GNU Affero General Public License v3.0
26.98k stars 1.89k forks source link

(Bug report) Month Note Always Showing Up #3822

Open verveq opened 1 year ago

verveq commented 1 year ago

Trilium Version

0.59.3

What operating system are you using?

Windows

What is your setup?

Local (no sync)

Operating System Version

Windows 7

Description

Hi! I have updated from Trilium 0.47.7 straight to the latest (currently 0.59.3) version. While it seems that Trilium has successfully migrated the db I have however encountered several issues after the update: Clicking on any Month note of the Journal would make it “persistent” : now selecting any other Month or Year note, or any other notes that have subnotes, would display only the Month note that was clicked first, and not the actual content. TBR

ways to make it force-update itself: F5, Trilium relaunch, or if/when the list of contents is big enough to have several pages: clicking page (2) would break the spell and it would display what should be displayed.

Error logs

Console:

frontend_script_api.js:125 api.addButtonToToolbar() has been deprecated since v0.58 and may be removed in the future. Use  Menu -> Configure Launchbar to create/update launchers instead.
addButtonToToolbar @ frontend_script_api.js:125
DevTools failed to load source map: Could not load content for http://127.0.0.1:37840/assets/v0.59.3/libraries/bootstrap/js/bootstrap.bundle.min.js.map: HTTP error: status code 404, net::ERR_HTTP_RESPONSE_CODE_FAILURE
DevTools failed to load source map: Could not load content for http://127.0.0.1:37840/assets/v0.59.3/libraries/fancytree/jquery.fancytree-all-deps.min.js.map: HTTP error: status code 404, net::ERR_HTTP_RESPONSE_CODE_FAILURE
DevTools failed to load source map: Could not load content for http://127.0.0.1:37840/assets/v0.59.3/libraries/split.min.js.map: HTTP error: status code 404, net::ERR_HTTP_RESPONSE_CODE_FAILURE
DevTools failed to load source map: Could not load content for http://127.0.0.1:37840/libraries/ckeditor/ckeditor.js.map: HTTP error: status code 404, net::ERR_HTTP_RESPONSE_CODE_FAILURE
DevTools failed to load source map: Could not load content for http://127.0.0.1:37840/assets/v0.59.3/libraries/bootstrap/css/bootstrap.min.css.map: HTTP error: status code 404, net::ERR_HTTP_RESPONSE_CODE_FAILURE

There are also this entries in the Log that seem to regularly appear, not sure if it has to do with anything:

_:40:09.526 Keyboard action showNoteInfo found in database, but not in action definition.
_:40:09.527 Keyboard action showLinkMap found in database, but not in action definition.
_:40:09.527 Keyboard action focusOnAttributes found in database, but not in action definition.
_:40:09.527 Keyboard action toggleZenMode found in database, but not in action definition.
_:40:09.527 200 GET /api/keyboard-actions with 12175 bytes took 1ms
_:40:09.556 Slow 200 GET /api/script/widgets with 2908 bytes took 28ms
_:40:09.558 200 POST /api/tree/load with 14023 bytes took 0ms
_:40:09.609 200 GET /api/keyboard-shortcuts-for-notes with 2 bytes took 1ms
_:40:09.639 200 POST /api/tree/load with 15371 bytes took 1ms
_:40:09.640 200 POST /api/tree/load with 24435 bytes took 1ms
_:40:09.657 200 POST /api/tree/load with 30743 bytes took 1ms
_:40:10.252 200 GET /api/notes/PPcWuSYCdi4N with 442 bytes took 0ms
_:40:10.253 200 GET /api/note-map/PPcWuSYCdi4N/backlink-count with 11 bytes took 0ms
_:40:11.686 Slow 200 GET /api/script/startup with 1343 bytes took 35ms
_:40:11.688 200 POST /api/tree/load with 15541 bytes took 1ms
_:40:11.730 Slow 200 PUT /api/special-notes/api-script-launcher with 323 bytes took 40ms
_:40:11.916 Table counts: notes: 34533, note_revisions: 18030, branches: 34569, attributes: 96417, etapi_tokens: 0
_:40:11.956 Slow query took 39ms: SELECT noteId as entityId FROM notes LEFT JOIN entity_changes ON entity_changes.entityName = 'notes' AND entity_changes.entityId = noteId WHERE entity_changes.id IS NULL
_:40:11.978 Slow query took 22ms: SELECT id, entityId FROM entity_changes LEFT JOIN notes ON entityId = noteId WHERE entity_changes.isErased = 0 AND entity_changes.entityName = 'notes' AND noteId IS NULL
_:40:12.008 Slow query took 26ms: SELECT noteId as entityId FROM note_contents LEFT JOIN entity_changes ON entity_changes.entityName = 'note_contents' AND entity_changes.entityId = noteId WHERE entity_changes.id IS NULL
_:40:12.030 Slow query took 21ms: SELECT id, entityId FROM entity_changes LEFT JOIN note_contents ON entityId = noteId WHERE entity_changes.isErased = 0 AND entity_changes.entityName = 'note_contents' AND noteId IS NULL
_:40:12.113 Slow query took 26ms: SELECT branchId as entityId FROM branches LEFT JOIN entity_changes ON entity_changes.entityName = 'branches' AND entity_changes.entityId = branchId WHERE entity_changes.id IS NULL
_:40:12.148 Slow query took 35ms: SELECT id, entityId FROM entity_changes LEFT JOIN branches ON entityId = branchId WHERE entity_changes.isErased = 0 AND entity_changes.entityName = 'branches' AND branchId IS NULL
_:40:12.233 Slow query took 70ms: SELECT attributeId as entityId FROM attributes LEFT JOIN entity_changes ON entity_changes.entityName = 'attributes' AND entity_changes.entityId = attributeId WHERE entity_changes.id IS NULL
_:40:12.295 Slow query took 62ms: SELECT id, entityId FROM entity_changes LEFT JOIN attributes ON entityId = attributeId WHERE entity_changes.isErased = 0 AND entity_changes.entityName = 'attributes' AND attributeId IS NULL
_:40:12.332 Slow query took 24ms: SELECT branchId, branches.noteId FROM branches LEFT JOIN notes USING (noteId) WHERE branches.isDeleted = 0 AND notes.noteId IS NULL
_:40:12.405 Slow query took 57ms: SELECT attributeId, attributes.noteId FROM attributes LEFT JOIN notes USING (noteId) WHERE attributes.isDeleted = 0 AND notes.noteId IS NULL
_:40:12.434 Slow query took 29ms: SELECT attributeId, attributes.value AS noteId FROM attributes LEFT JOIN notes ON notes.noteId = attributes.value WHERE attributes.isDeleted = 0 AND attributes.type = 'relation' AND notes.noteId IS NULL
_:40:12.466 Slow query took 31ms: SELECT branchId, noteId FROM branches JOIN notes USING (noteId) WHERE notes.isDeleted = 1 AND branches.isDeleted = 0
_:40:12.534 Slow query took 49ms: SELECT DISTINCT notes.noteId FROM notes LEFT JOIN branches ON notes.noteId = branches.noteId AND branches.isDeleted = 0 WHERE notes.isDeleted = 0 AND branches.branchId IS NULL
_:40:12.558 Slow query took 24ms: SELECT noteId, parentNoteId FROM branches WHERE branches.isDeleted = 0 GROUP BY branches.parentNoteId, branches.noteId HAVING COUNT(1) > 1
_:40:12.589 Slow query took 21ms: SELECT notes.noteId, notes.isProtected, notes.type, notes.mime FROM notes LEFT JOIN note_contents USING (noteId) WHERE note_contents.noteId IS NULL
_:40:12.701 Slow query took 59ms: SELECT noteId, parentNoteId FROM branches WHERE isDeleted = 0
_:40:12.781 All consistency checks passed with no errors detected (took 882ms)
zadam commented 1 year ago

Hmm, that is strange. Unfortunately I can't reproduce this :-(