Description
Type: Bug
I have installed the sqlite in my laptop and the sqlite extension by alexcvzz in vs code as well. I can code sqlite in the vscode terminal but when I want go to my command plate>SQLite: Open Database and when I click on the database I get the error attached below. The same thing happens when I want to connect to a database I created myself in the terminal or if I say for exmaple: .read schema.sql. I have tried multiple troubleshooting ways unistalled and reinstalled the vscode again but nothing seems to fix this problem. Can you please help me find the solution for this error?
Error:
Failed to open database 'c:\Users\heela\Desktop\PythonProjects\views.db': Parse error near line 4: no such column: "table" - should this be a string literal in single-quotes? aster WHERE (type="table" OR type="view") error here ---^
VS Code version: Code 1.96.3 (91fbddd, 2025-01-09T18:14:09.060Z)
OS version: Windows_NT x64 10.0.26100
Modes:
System Info
| Item | Value |
|---|---|
| CPUs | Intel(R) Core(TM) Ultra 7 155U (14 x 2688) |
| GPU Status | 2d_canvas: enabled canvas_oop_rasterization: enabled_on direct_rendering_display_compositor: disabled_off_ok gpu_compositing: enabled multiple_raster_threads: enabled_on opengl: enabled_on rasterization: enabled raw_draw: disabled_off_ok skia_graphite: disabled_off video_decode: enabled video_encode: enabled vulkan: disabled_off webgl: enabled webgl2: enabled webgpu: enabled webnn: disabled_off |
| Load (avg) | undefined |
| Memory (System) | 31.45GB (21.37GB free) |
| Process Argv | --crash-reporter-id e2a2bb71-4829-4ef4-a61d-d93d91694a14 |
| Screen Reader | no |
| VM | 0% |
Extensions (8)
| Extension | Author (truncated) | Version |
|---|---|---|
| vscode-sqlite | ale | 0.14.1 |
| debugpy | ms- | 2024.14.0 |
| python | ms- | 2024.22.2 |
| vscode-pylance | ms- | 2024.12.1 |
| cmake-tools | ms- | 1.19.52 |
| cpptools | ms- | 1.22.11 |
| cpptools-extension-pack | ms- | 1.3.0 |
| cmake | twx | 0.0.17 |
(1 theme extensions excluded)
A/B Experiments
vsliv368cf:30146710
vspor879:30202332
vspor708:30202333
vspor363:30204092
vscod805cf:30301675
binariesv615:30325510
vsaa593cf:30376535
py29gd2263:31024239
c4g48928:30535728
azure-dev_surveyone:30548225
2i9eh265:30646982
962ge761:30959799
pythonnoceb:30805159
pythonmypyd1:30879173
h48ei257:31000450
pythontbext0:30879054
cppperfnew:31000557
dsvsc020:30976470
pythonait:31006305
dsvsc021:30996838
dvdeprecation:31068756
dwnewjupytercf:31046870
newcmakeconfigv2:31071590
nativerepl2:31139839
pythonrstrctxt:31112756
nativeloc1:31192215
cf971741:31144450
iacca1:31171482
notype1:31157159
5fd0e150:31155592
dwcopilot:31170013
stablechunks:31184530
6074i472:31201624
dwoutputs:31217127