Forum Discussion
winget SQL error
Hi, The winget command fails with SQL error [ Spoiler ] Is there a way to solve this issue ? (Windows 11 22523, Winget v1.2.3411-preview)
plo3000 I was recently having the same issue. Seems like it has to do with the cache for apps installed from the MS Store being corrupted. I was able to resolve it by deleting %LOCALAPPDATA%\Packages\Microsoft.DesktopAppInstaller_8wekyb3d8bbwe\LocalState\StoreEdgeFD\installed.db
If that doesn't fix it, you can better diagnose the issue by taking a look at the logs in %LOCALAPPDATA%\Packages\Microsoft.DesktopAppInstaller_8wekyb3d8bbwe\LocalState\DiagOutputDir\
Here are my relevant logs for reference:
Spoiler
2022-02-24 15:58:00.760 [REPO] Opening SQLite Index for ReadWrite at 'C:\Users\teomi\AppData\Local\Packages\Microsoft.DesktopAppInstaller_8wekyb3d8bbwe\LocalState\StoreEdgeFD\installed.db'
2022-02-24 15:58:00.760 [SQL ] Opening SQLite connection: 'C:\Users\teomi\AppData\Local\Packages\Microsoft.DesktopAppInstaller_8wekyb3d8bbwe\LocalState\StoreEdgeFD\installed.db' [2, 0]
2022-02-24 15:58:00.761 [FAIL] D:\a\_work\1\s\external\pkg\src\AppInstallerRepositoryCore\SQLiteWrapper.cpp(173)\WindowsPackageManager.dll!00007FF841A8121A: (caller: 00007FF841A821B6) Exception(1) tid(2b64) 87AF0001 SQL error or missing database
Msg:[SQL logic error]
2022-02-24 15:58:00.761 [CLI ] Caught wil::ResultException: D:\a\_work\1\s\external\pkg\src\AppInstallerRepositoryCore\SQLiteWrapper.cpp(173)\WindowsPackageManager.dll!00007FF841A8121A: (caller: 00007FF841A821B6) Exception(1) tid(2b64) 87AF0001 SQL error or missing database
Msg:[SQL logic error]
Worked like a charm, thanks!