Skip to content

Unexpected token #2187

@pshem

Description

@pshem

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 build log 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

My issue looks similar to #80 and #917, except the problematic token appears to be a space, or the entire expression.

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions