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

57 views
Skip to first unread message

Josué Charles

unread,
Oct 21, 2025, 4:40:28 PMOct 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 PMOct 21
to Er Mo, Bill Crews, Elizabeth Dixon, mementodatabase

Taeke

unread,
Oct 22, 2025, 5:03:20 AMOct 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 PMOct 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

Josué Charles

unread,
Oct 27, 2025, 6:45:24 PMOct 27
to Er Mo, mementodatabase
Hello Er Mo,
I'm using a pro version (a payed one).

_____________________________________
Josué CHARLES,
Ingénieur-Agronome (agro-économiste),
(+509) 44 37 6288/32 14 8820,
charlesj...@gmail.com,
charlesj...@hotmail.com

--
You received this message because you are subscribed to the Google Groups "mementodatabase" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mementodataba...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/mementodatabase/3a819537-eb62-4674-9bfc-7375fc5a19ddn%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages