Error: Plugin "Cordova sqlite storage plugin" failed to install.

[Rodrigo_M_1]

Hi there,

I'm trying to use the that comes already with Intel XDK in the Plugin Management located in the "Featured Plugins" --> "SQLite Native Storage" Version 0.7.11.

The thing is I'm able to add the plugin without problem, but wen I try to compile for iOS I got a error message.

I was able to add the plugin locally after download, but I would like to report this error!

Follow the error:

The build failed. An error occurred while building the application. Verify your build assets are correct and try again.
Build Log:
Building a Cordova 4.1.2 application.
The application name is "Texboxes"
The package name is "com.rmartins.DataGrid"
Will use the provisioning profile for "adhoc"
Error: Plugin "Cordova sqlite storage plugin" failed to install.
Plugin "org.apache.cordova.device" (0.2.13) installed.
Plugin "org.apache.cordova.splashscreen" (0.3.5) installed.

[Amrita_C_Intel]

Hello,

I recreated the scenario and I was able to build successfully. If you can provide the .zip file of your project I can try building.

[Rodrigo_M_1]

Amrita C. (Intel) wrote:

Hello,

I recreated the scenario and I was able to build successfully. If you can provide the .zip file of your project I can try building.

Hi Amrita, I sent to you a message with a sample code attached!

Thanks!

[Amrita_C_Intel]

Hello,

I have replied you.

[Kevin_L_3]

I'm reporting the same issue on iOS builds, as of this morning, I'm getting the same error message. Error: Plugin "Cordova sqlite storage plugin" failed to install (version 0.7.14). Android Crosswalk build was successful. Have been using CLI Version 5.1.1 all along as well.

[Rodrigo_M_1]

I just tested my application, and I got the problem with SQLite version: 0.7.14 on Cordova CLI Version 5.1.1

I have changed the Cordova CLI to 4.1.2 and I was able to compile.

So the problem is a compatibility with cordova CLI 5.1.1!

The build failed.

An error occurred while building the application. Verify your build assets are correct and try again.

Build Log:

• Building a Cordova 5.1.1 application.
• The application name is "MFSiOsMobile"
• The package name is "com.rmartins.DataGrid"
• Will use the provisioning profile for "adhoc"
• Error: Plugin "Device" failed to install.
• Error: Plugin "Network Information" failed to install.
• Error: Plugin "Notification" failed to install.
• Error: Plugin "Cordova sqlite storage plugin" failed to install.
• Plugin "cordova-plugin-splashscreen" (2.1.0) installed.
• Plugin "intel.xdk.device" (2.0.1) installed.
• Plugin "intel.xdk.contacts" (1.2.3) installed.

[Kevin_L_3]

As an update: I was able to build with 0.7.15-pre Ok on iOS, CLI 5.1.1.

[Rodrigo_M_1]

Kevin L. wrote:

As an update: I was able to build with 0.7.15-pre Ok on iOS, CLI 5.1.1.

Where did you get the 0.7.15 version ? I have tried to remove and add the SQLite plugin, but the last version is 0.7.14!

[PaulF_IntelCorp]

Rodrigo -- the plugin versions shown in the featured list are those that were available at the time the list was assembled. If you want to use a version of a plugin that is not shown in the featured list you can do so by simply adding the plugin using the third-party plugin dialog, rather than the featured list dialog.

Follow the documentation link for more details about that plugin:

[Rodrigo_M_1]

Hi Paul, thanks for your reply! I Already know that, and I have checked the documentation already that the 0.7.14 is the latest of 8 releases.

By the way I note that the link to the gitHub repository some files has been changed 14 days ago...

I just don't understand why the SQLite 0.7.14 just start having this problem on  cordova CLI 5.1.1 between yesterday and today...

Actually I was working yesterday without problem!

I'll use the third-Party for now until get it fixed!

Thanks guys!

Best Regards!

[Michael_O_2]

Dear Rodrigo.

Remove the plugin and use this:

var db = openDatabase('mydb', '1.0', 'Test DB', 2 * 1024 * 1024);
db.transaction(function (tx) {  
   tx.executeSql('CREATE TABLE IF NOT EXISTS LOGS (id unique, log)');
});

The in-built HTML5 Web SQL functionality can suffice for sqlite plugin.

Another advantage if using this is the reduction in your file size.