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.

[bmaier]

Same error on MacBook. Have to switch to a different plugin https://marketplace.visualstudio.com/items?itemName=yy0931.vscode-sqlite3-editor

[altaufique]

Solutions: https://www.reddit.com/r/vscode/comments/1duh76t/problem_opening_the_database_with_sqlite_in/?rdt=49355

[charlesAOC]

solution: https://github.com/AlexCovizzi/vscode-sqlite/issues/235#issue-1626088707

[aaalvinnn]

just setting vscode here. I fill in with my absolute path of sqlite3 and it worked

[erojas150604]

just setting vscode here. I fill in with my absolute path of sqlite3 and it worked

this guy know things, this solution took me away a lot of headaches

[abdull6771]

Same error on MacBook. Have to switch to a different plugin https://marketplace.visualstudio.com/items?itemName=yy0931.vscode-sqlite3-editor

thank you this help me