vscodenpa
commented
1 year ago We closed this issue because it is a question about using VS Code rather than an issue or feature request. Please search for help on StackOverflow, where the community has already answered thousands of similar questions. You may find their guide on asking a new question helpful if your question has not already been asked. See also our issue reporting guidelines.
Happy Coding!
Type: Bug
I can open any DB, i get this error even on new db without any tables on it.
[2:23:46 PM][vscode-sqlite][ERROR] Failed to open database 'c:\Users\steve\Desktop\Test_project\project.db': Parse error near line 4: no such column: table aster WHERE (type="table" OR type="view")
error here ---^
VS Code version: Code 1.80.2 (2ccd690cbff1569e4a83d7c43d45101f817401dc, 2023-07-27T20:40:28.909Z) OS version: Windows_NT x64 10.0.22621 Modes:
System Info
|Item|Value| |---|---| |CPUs|AMD Ryzen 7 5700X 8-Core Processor (16 x 3400)| |GPU Status|2d_canvas: enabledcanvas_oop_rasterization: disabled_off
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
video_decode: enabled
video_encode: enabled
vulkan: disabled_off
webgl: enabled
webgl2: enabled
webgpu: enabled| |Load (avg)|undefined| |Memory (System)|15.92GB (3.19GB free)| |Process Argv|--crash-reporter-id a0057069-8edb-4a13-947e-029300e7b6fe| |Screen Reader|no| |VM|0%|
Extensions (23)
Extension|Author (truncated)|Version ---|---|--- vscode-sqlite|ale|0.14.1 ajax-query|Bal|0.6.0 vscode-intelephense-client|bme|1.9.5 phpserver|bra|3.0.2 xml|Dot|2.5.1 EditorConfig|Edi|0.16.4 auto-close-tag|for|0.5.14 auto-rename-tag|for|0.1.10 code-runner|for|0.12.0 node-module-intellisense|lei|1.5.0 vscode-apache|mrm|1.2.0 vscode-docker|ms-|1.26.0 data-workspace-vscode|ms-|0.5.0 mssql|ms-|1.20.0 sql-bindings-vscode|ms-|0.4.0 sql-database-projects-vscode|ms-|1.2.0 remote-containers|ms-|0.299.0 remote-wsl|ms-|0.80.2 sqltools|mtx|0.28.0 sqltools-driver-mysql|mtx|0.6.0 LiveServer|rit|5.7.9 code-spell-checker|str|2.20.5 php-debug|xde|1.33.0A/B Experiments
``` vsliv368:30146709 vsreu685:30147344 python383:30185418 vspor879:30202332 vspor708:30202333 vspor363:30204092 vslsvsres303:30308271 vserr242:30382549 pythontb:30283811 vsjup518:30340749 pythonptprofiler:30281270 vshan820:30294714 vstes263:30335439 vscorecescf:30445987 vscod805:30301674 binariesv615:30325510 bridge0708:30335490 bridge0723:30353136 vsaa593cf:30376535 pythonvs932:30410667 vsclangdf:30486550 c4g48928:30535728 dsvsc012:30540252 pynewext54:30695312 azure-dev_surveyonecf:30548226 2e4cg342:30602488 89544117:30613380 showlangstatbar:30737416 vsctsb:30748421 03d35959:30757346 pythonfmttext:30731395 pythoncmv:30756943 fixshowwlkth:30771522 hideindicator:30785051 pythongtdpath:30769146 i26e3531:30792625 pythonnosmt12:30797651 pythonnoceb:30797650 e537b577:30795824 dsvsc013:30795093 dsvsc014cf:30797590 ```