Replies: 1 comment 1 reply
-
|
You're misusing the The optional argument for |
Beta Was this translation helpful? Give feedback.
1 reply
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
Under Windows 11 (current build), the VACUUM query on a virtual fts5 database from within SQLiteStudio 3.4.17 and 3.4.20 as shown below fails, with the error message that is also shown. (The "/" or "" seem to make no difference.)
VACUUM "C:/DATA/databases/SQLiteData/db/intelligent_search.db";The error messages were:
[22:57:21] Error while executing SQL query on database 'intelligent_search': unknown database "C:\DATA\databases\SQLiteData\db\intelligent_search.db"
[22:58:16] Error while executing SQL query on database 'intelligent_search': unknown database "C:/DATA/databases/SQLiteData/db/intelligent_search.db"
The database is at the specified path, as verified by File Explorer and as correctly found from the comparable Python3 code.
I have no troubles using VACUUM with non-fts5 virtual SQLite databases.
Any helpful thoughts or strategies (other than to use Python...)?
Beta Was this translation helpful? Give feedback.
All reactions