-
-
Notifications
You must be signed in to change notification settings - Fork 2.3k
Closed
Description
Details for the issue
What did you do?
I opened a database. I'm including a dataless version of the database as it also triggers the warning messages and should hopefully aid in debugging.
backup.db.zip
What did you expect to see?
I didn't expect to see errors in the terminal
What did you see instead?
$ sqlitebrowser --read-only ~/z/source/backup.db
Sqlite parse error: line 1:47: unexpected token: thread_id(CREATE VIRTUAL TABLE sms_fts USING fts5(body, thread_id UNINDEXED, content=sms, content_rowid=_id))
Sqlite parse error: line 1:47: unexpected token: thread_id(CREATE VIRTUAL TABLE mms_fts USING fts5(body, thread_id UNINDEXED, content=mms, content_rowid=_id))I'm not sure whether the problematic token is fts5 or not. The 47th character is the t in fts5. Do you think loading the fts5 extension would help? I've tried to find out whether Ubuntu builds sqlitebrowser with fts5, but with no luck. Searching the for fts5 found nothing.
Useful extra information
The info below often helps, please fill it out if you're able to. :)
What operating system are you using?
- Windows: ( version: ___ )
- Linux: ( distro: Kubuntu 19.10 )
- macOS: ( version: ___ )
- Other: ___
What is your DB4S version?
- 3.11.2
- 3.11.1
- 3.10.1
- Other: ___
Did you also
- Try out the latest nightly version: https://github.com/sqlitebrowser/sqlitebrowser#nightly-builds
- Search for an existing similar issue: https://github.com/sqlitebrowser/sqlitebrowser/issues?utf8=%E2%9C%93&q=is%3Aissue%20
My issue looks similar to #80 and #917, except the problematic token appears to be a space, or the entire expression.