Windows version does not work with PhoneGap Build

[brodycj]

When I tried building a Windows version of my test app at https://github.com/brodybits/Cordova-sql-test-app-evcore-free-pgb with PhoneGap Build it would not work with this plugin. Using the echoTest function would not work. However displaying a dialog using cordova-plugin-dialogs does work with Windows on PhoneGap Build.

[brodycj]

I tried PhoneGap Build with another version of my test app at https://github.com/brodybits/Cordova-sql-test-app-legacy-pgb that uses cordova-sqlite-legacy and it is able to pass the echoTest and selfTest stages. I think that PhoneGap Build will still use the wp8 target by default.

I tried following http://phonegap.com/blog/2016/04/25/windows-10-and-phonegap-cli-6_1-now-on-build/ to test the test app with Windows 10 mobile, and the PhoneGap Build web interface tells me that they have to investigate the build error. I will update this once I hear back from them.

[brodycj]

Raised phonegap/build#530. It doesn't even seem to work with a dialog test app.

[brodycj]

Related question at https://forums.adobe.com/message/8864670 - still not answered!

[brodycj]

Current status:

• PhoneGap build does not work for Windows appx phonegap/build#530 is now solved: I am able to build and run a dialog test app from PhoneGap Build on my Windows 10 mobile device. I do have to specify the CPU architecture type. Test dialog project working with PhoneGap Build on Windows 10 mobile: https://github.com/brodybits/Cordova-PGB-dialog-test-Windows10-arm
• If I build a test project that uses this plugin along with cordova-plugin-dialogs on PhoneGap Build for ARM and run it on my Windows 10 mobile device, it starts up and then crashes. Same if I comment out the code that attempts to open and access a sqlite database. Test project: https://github.com/brodybits/Cordova-sqlite-evcore-free-PGB-W10-arm-test
• If I build a test project that uses this plugin with cordova-plugin-dialogs on PGB for x86 and run it on my Windows 10 workstation (laptop) it also starts up then crashes (with the code to open and access a sqlite database commented out). Test project: https://github.com/brodybits/Cordova-sqlite-evcore-free-PGB-W10-x86-test

I think the next step is to investigate why an app built by PhoneGap Build with this plugin crashes on Windows. Another idea may be to build the SQLite3 C++ libs manually.

[brodycj]

I discovered that for some reason PhoneGap Build does not build the SQLite3 component. Here is some log for the build of https://github.com/brodybits/Cordova-sqlite-evcore-free-PGB-W10-arm-test:

Build Date: 2016-10-27 18:20:18 +0000
--------------------------------------------------------------------------------
PLUGIN OUTPUT
--------------------------------------------------------------------------------
Fetching plugin "cordova-plugin-dialogs@~1.3.0" via npm
Installing "cordova-plugin-dialogs" at "1.3.0" for windows
Fetching plugin "cordova-sqlite-evcore-extbuild-free@~0.8.2" via npm
Installing "cordova-sqlite-evcore-extbuild-free" at "0.8.2" for windows
Building project: C:\cygwin\tmp\gimlet\2327652\project\CordovaApp.Windows10.jsproj
    Configuration : debug
    Platform      : arm
C:\Program Files (x86)\MSBuild\14.0\bin\Microsoft.Common.CurrentVersion.targets(1610,5): warning : The referenced project '..\..\cordova\plugins\cordova-sqlite-evcore-extbuild-free\src\windows\SQLite3-Win-RT\SQLite3\SQLite3.UWP\SQLite3.UWP.vcxproj' does not exist. [C:\cygwin\tmp\gimlet\2327652\project\CordovaApp.Windows10.jsproj]
C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v14.0\AppxPackage\Microsoft.AppXPackage.Targets(4330,5): warning MSB3202: The project file "..\..\cordova\plugins\cordova-sqlite-evcore-extbuild-free\src\windows\SQLite3-Win-RT\SQLite3\SQLite3.UWP\SQLite3.UWP.vcxproj" was not found. [C:\cygwin\tmp\gimlet\2327652\project\CordovaApp.Windows10.jsproj]
  CordovaApp.Windows10 -> C:\cygwin\tmp\gimlet\2327652\project\AppPackages\CordovaApp.Windows10_0.0.1.0_arm_debug_Test\CordovaApp.Windows10_0.0.1.0_arm_debug.appx

I get similar log for the x86 build as well.

For some reason PhoneGap Build does not see and include SQLite3.UWP.vcxproj from the plugins directory tree. I will also try this on the legacy version and then raise a new issue on https://github.com/phonegap/build.