Cannot open a database

[OMGerCoder]

Every time I try to open a database I get an error with the following message. [12:21:29 PM][vscode-sqlite][ERROR] Failed to open database '[REDACTED]\test.db': Parse error near line 4: no such column: table aster WHERE (type="table" OR type="view")
error here ---^

[grahamblandford]

Also having this issue. Using the latest Windows binary for SQLLite3.

[PorcoRosso85]

+1

[nicholasjamesrattigan]

Having the same issue as well.

[5:15:07 PM][vscode-sqlite][ERROR] Failed to open database 'c:\SQLite\Databases\sample_db.db': Parse error near line 4: no such column: table aster WHERE (type="table" OR type="view")
error here ---^

[rgugs]

The extension worked before I downloaded SQLite and added a Path environmental variable, and now it doesn't work. Getting the same issue as posted here.

[philtreffer]

+1

[Kh4N1]

+1

[Teja0309]

Having the same issue as well.

[5:15:07 PM][vscode-sqlite][ERROR] Failed to open database 'c:\SQLite\Databases\sample_db.db': Parse error near line 4: no such column: table aster WHERE (type="table" OR type="view") error here ---^

How to resolve this issue?

[fjuren]

I had SQLite installed and ran into this error. Removing the path environment variable fixed the issue for me, but this doesn't seems like a temp fix.

[Kirill777-web]

Same issue ! Parse error near line 4: no such column: table aster WHERE (type="table" OR type="view")

[GBognar]

+1

Neither when using latest SQLite 3 distro binary (3.45..3-1) on Arch Linux, nor when using latest precompiled binary (sqlite-tools-linux-x64-3450300.zip) downloaded from sqlite.org

[aimixsaka]

Related pr is https://github.com/AlexCovizzi/vscode-sqlite/pull/241 Can be resolved temporarily by setting explicitly sqlite executable path to the bundled one. (set "sqlite.sqlite3": "bundled sqlite3 binary path" in settings.json (bin path is /usr/bin/sqlite3 on mac)

[MZshnik]

Related pr is #241 Can be resolved temporarily by setting explicitly sqlite executable path to the bundled one. (set "sqlite.sqlite3": "bundled sqlite3 binary path" in settings.json (bin path is /usr/bin/sqlite3 on mac)

Helps me

[eeskildsen]

Related pr is #241 Can be resolved temporarily by setting explicitly sqlite executable path to the bundled one. (set "sqlite.sqlite3": "bundled sqlite3 binary path" in settings.json (bin path is /usr/bin/sqlite3 on mac)

For those on Windows, the path is:

%userprofile%\.vscode\extensions\alexcvzz.vscode-sqlite-<version>\bin\sqlite-v<version>-<architecture>.exe

Copy it to the clipboard in PowerShell:

gci "$env:userprofile\.vscode\extensions\alexcvzz.vscode-sqlite-*\bin\sqlite*.exe" | % FullName | scb

Edit: Autocompletion wasn't working either. I switched to the SQLTools extension, which has SQLite support.

[sandrock]

Same issue on :

• Manjaro, Code OSS 1.89.1
• PopOS 22.04, VS Code 1.90.2 flatpak

Setting the full path to the sqlite3 did not work.

[vinooganesh]

Same issue here as well

[donpark]

Seeing this error on macOS as well. SQLite database files that opens fine with 'SQLite Viewer' extension fails to open with this extension.