BUG: no such column: when opening sqlite database

[charlesdaniels]

Describe the bug

When opening some, but not all sqlite databases, I see an error message no such column:. These databases are known to work in Python's sqlite3 module and with sqlitebrowser.

To Reproduce

1. Add the database as a connection
2. Click on it

Expected behavior

The database opens correctly without error.

Screenshots

N/A

Version Information (please complete the following information):

• OS: ArchLinux
• App Version: 4.2.5
• Install source: tested with dbgate-bin AUR package, as well as the AppImage and got the same result
• Type - Web/Application
• Database engine: sqlite

Additional context

See attached the console output. After letting it sit for a few seconds, it dumps a bunch of JSON to the console as well.

dbgate.log

This issue seems to only trigger for databases that have views in them, so it may be related to how dbgate handles views in sqlite.

[janproch]

Thank you for bug report.

Unfortunately, I was unable to find a reason. I have no problem to open SQLite files with views in DbGate, when I was analysing log attached, it seems, that SQLite file you use is not supported by used driver.

It is possible to send me some SQLite file, which caused this error? It will be the simplest way, how to solve this. If not, I could add more detailed logging for this situation

And sorry for late response, I have some vacations in this season