Bug? Intermittent "no such table" Error in Cross-Library SQL Scripts (Desktop)

35 views
Skip to first unread message

Josué Charles

unread,
Oct 21, 2025, 4:40:28 PM (5 days ago) Oct 21
to mementodatabase

Hello everyone,

Is anyone else using the new sql(query).asEntries() function on the Desktop app (3.6.0) to query a different library?

I'm finding that my script works perfectly for the first few executions, but then suddenly starts failing with this error: [SQLITE_ERROR] SQL error or missing database (no such table: LibraryName)

If I completely close and restart the Memento Desktop app, it works again... but only for a short time before the error returns.

It seems the app "forgets" that the other library exists after a while. Has anyone else seen this or found a permanent fix (other than restarting)?

Thanks!

Josué Charles

unread,
Oct 21, 2025, 6:20:17 PM (5 days ago) Oct 21
to Er Mo, Bill Crews, Elizabeth Dixon, mementodatabase

Taeke

unread,
Oct 22, 2025, 5:03:20 AM (4 days ago) Oct 22
to mementodatabase
I'm having exact the same issue. 
I will report this to the developer

Op dinsdag 21 oktober 2025 om 22:40:28 UTC+2 schreef charlesj...@gmail.com:

Er Mo

unread,
Oct 22, 2025, 1:02:22 PM (4 days ago) Oct 22
to mementodatabase
Hallo
Verwendet ihr eine Kostenlose Version oder eine mit Bezahlung . Ist vielleicht in der Kostenlosen Version auf ein paar Abfragen gesperrt.

Hello
Are you using a free version or a paid one? The free version might be blocked on a few queries.

Ernst
Reply all
Reply to author
Forward
0 new messages