SQLite not working on Ionic 2

Question

Cannot use SQLite plugin in my Angular 2/Ionic 2 project.

The way SQLite is instantiated accordint to the Ionic 2 documentation is not working.

Sublime give me an error message:

Supplied parameters do not match nay signature of the call target.

It means that the constructor shoud receive parameters. But what parameters?

Ionic 2 SQLite plugin documentation: http://ionicframework.com/docs/v2/native/sqlite/

import { SQLite } from 'ionic-native';

let db = new SQLite();
db.openDatabse({
  name: 'data.db',
  location: 'default' // the location field is required
}).then(() => {
  db.executeSql('create table danceMoves(name VARCHAR(32))', {}).then(() => {

  }, (err) => {
    console.error('Unable to execute sql', err);
  })
}, (err) => {
  console.error('Unable to open database', err);
});

It also says Property 'openDatabse' does not exist on type 'SQLite'

You've spelled Database in openDatabase wrong. Maybe that was your problem. — Akshar Patel
– Akshar Patel, Commented Aug 23, 2016 at 11:17
No. This was a problem of documentation. I corrected it and still got errors. The real solution is desbribed bellow. Probably I was usin an outdated version of Ionic 2. — Natanael
– Natanael, Commented Aug 23, 2016 at 14:28

Natanael · Accepted Answer · 2016-07-15 19:49:11Z

1

Solved by recreating the project from scratch and coping old app folder, configs and reinstalling npm modules and ionic native plugins.

answered Jul 15, 2016 at 19:49

Natanael

1,3565 gold badges19 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sameeksha Kumari · Accepted Answer · 2017-04-19 11:51:14Z

1

May be try to import SQLite object using

import { SQLite, SQLiteObject } from '@ionic-native/sqlite';

Note : Dont forget to install ionic-native/sqlite

npm install --save @ionic-native/sqlite

answered Apr 19, 2017 at 11:51

Sameeksha Kumari

1,2743 gold badges18 silver badges23 bronze badges

Comments

Saravanan Sachi · Accepted Answer · 2018-04-11 13:25:58Z

0

I resolved this issue by following steps.

Add and install plugin

ionic cordova plugin add cordova-sqlite-storage

npm install --save @ionic-native/sqlite

Now create a database.

let db = new SQLite();
            db.openDatabase({
                name: "data.db",
                location: "default"
            }).then(() => {
});

If you getting an error like: "openDatabse does not exist on type 'SQLite". Just delete node_module folder and reinstall node_module.

It will work.

edited Apr 11, 2018 at 13:25

Saravanan Sachi

2,6425 gold badges36 silver badges44 bronze badges

answered Dec 3, 2017 at 6:13

Manish

13.6k1 gold badge14 silver badges9 bronze badges

Comments

Pétalomine · Accepted Answer · 2017-04-14 11:09:49Z

-1

It's db.openDatabase, not Databse

But I think that now it's .create and not .openDatabase.

When you say .then(() => {db.executeSql ... try to add .then((db: SQLiteObject) and for the next then : {}).then(() => {}, (err) => { add data between the ( )

answered Apr 14, 2017 at 11:09

Pétalomine

12 bronze badges

Collectives™ on Stack Overflow

SQLite not working on Ionic 2

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related