Struggling to run ionic 3 on windows (UWP) after adding SQLite

Hello, I’m trying to use SQLite in my ionic app, and it’s working for ios and android, but with windows UWP I’m hitting issue’s.

After running ‘ionic cordova prepare windows’ and then ‘ionic cordova run windows’ I see the following output in the console.

SQLite3.UWP.vcxproj → C:\Users\Matty\source\repos\IonicPlaypen\MyAppV3\plugins\cordova-sqlite-storage\src\windows\SQLite3-Win-RT\SQLite3\SQLite3.UWP\debug\SQLite3.UWP\SQLite3.UWP.dll
C:\Program Files (x86)\Microsoft Visual Studio\2017\Enterprise\MSBuild\15.0\Microsoft.Common.targets\ImportBefore\Microsoft.Cpp.VCLibs120Universal.targets(103,5): warning MSB3842: Project “CordovaApp.Windows10” depends upon SDK “Microsoft Universal CRT Debug Runtime v10.0.17763.0” which supports apps targeting “UAP 10.0”. To verify whether “Microsoft Universal CRT Debug Runtime v10.0.17763.0” is compatible with “UAP
10.0.17763.0”, contact the SDK author or see http://go.microsoft.com/fwlink/?LinkID=309181. [C:\Users\Matty\source\repos\IonicPlaypen\MyAppV3\platforms\windows\CordovaApp.Windows10.jsproj]
C:\Program Files (x86)\Microsoft Visual Studio\2017\Enterprise\MSBuild\15.0\Microsoft.Common.targets\ImportBefore\Microsoft.Cpp.VCLibs120Universal.targets(103,5): error MSB3779: The processor architecture of the project being built “Any CPU” is not supported by the referenced SDK “Microsoft.UniversalCRT.Debug, Version=10.0.17763.0”. Please consider changing the targeted processor architecture of your project (in Visual Studio this can be done through the Configuration Manager) to one of the architectures supported by the SDK: “x86, x64, ARM, ARM64”. [C:\Users\Matty\source\repos\IonicPlaypen\MyAppV3\platforms\windows\CordovaApp.Windows10.jsproj]
No valid MSBuild was detected for the selected target: Error: C:\Program Files (x86)\Microsoft Visual Studio\2017\Enterprise\MSBuild\15.0\Bin\msbuild.exe: Command failed with exit code 1

I’ve tried loading the generated windows project in visual studio 2017. If I build from there, I see this error:

Severity Code Description Project File Line Suppression State
Error MSB3030 Could not copy the file “C:\Users\Matty\source\repos\IonicPlaypen\MyAppV3\platforms\windows\Debug\SQLite3.UWP\SQLite3.winmd” because it was not found. CordovaApp.Windows10 C:\Program Files (x86)\Microsoft Visual Studio\2017\Enterprise\MSBuild\15.0\Bin\Microsoft.Common.CurrentVersion.targets 4358

I can see a seperate ‘SQLite3.UWP’ project that’s referenced, so I thought I’d try and build that on it’s own, I just see in the output:

1>------ Build started: Project: SQLite3.UWP, Configuration: Debug Win32 ------
1>Object reference not set to an instance of an object.
========== Build: 0 succeeded, 1 failed, 0 up-to-date, 0 skipped ==========

Pretty stuck on this one now, pretty much a blocker on us being able to use Ionic. Anyone got any idea’s?

Maybe --archs=x64 is missing (or arm)
I use : ionic cordova build windows – --release --archs=x64
Sorry if i’m wrong, i’m newbie french user.

I know it’s been a while… Did anyone manage to resolve this?

Just in case anyone stumbles across this…

I managed to get around this by uninstalling Visual Studio, Visual Studio Installer, Visual Studio Code, all instances of Visual C++, .NET Core, and manually deleting all instances of ‘Microsoft Visual Studio’ or ‘Visual Studio’ or ‘vs’ or ‘NuGet’ in AppData/Local, AppData/Roaming, and Program Files etc… then a restart and a fresh install of Visual Studio Community 2017… which is tricky to find now. I’m pretty sure VS2019 doesn’t work with cordova-windows at the time of writing this.

I’m not sure if it was all necessary, but you can understand the pain. I tried everything.

Works now, waaaaaay