Ionic 4 with Sqlite - Cannot read property 'then' of undefined TypeError: Cannot read property 'then' of undefined

Question

My database is not getting created. When I see my console, it shows the following error:

Uncaught (in promise): TypeError: Cannot read property 'then' of undefined TypeError: Cannot read property 'then' of undefined at new HomePage (home.page.ts:31)

I have installed npm install @ionic-native/sqlite@beta --save

Below is my home.page.ts code:

import { Component } from '@angular/core';
import { NavController } from '@ionic/angular';
import { SQLite, SQLiteObject } from '@ionic-native/sqlite/ngx';

@Component({
  selector: 'app-home',
  templateUrl: 'home.page.html',
  styleUrls: ['home.page.scss'],
})
export class HomePage {
constructor(public navCtrl: NavController,private sqlite: SQLite){
  this.sqlite.create({
    name: 'ionicdb.db',
    location: 'default'
  })
  .then((db: SQLiteObject) => {
    db.executeSql('CREATE TABLE IF NOT EXISTS expense2(rowid INTEGER PRIMARY KEY, date TEXT, type TEXT, description TEXT, amount INT)', [])
    .then(() => console.log('Executed SQL'))
    .catch(e => console.log(e, 'err'));
  })
  .catch(e => console.log(e)); 
}
}

I have done as per the documentation but dont know why this error is still there.

My project's ionic info -v for your reference:

ionic (Ionic CLI)             : 4.8.0 (C:\Users\jessica\AppData\Roaming\npm\node_modules\ionic)
   Ionic Framework               : @ionic/angular 4.0.0-rc.1
   @angular-devkit/build-angular : 0.11.4
   @angular-devkit/schematics    : 7.1.4
   @angular/cli                  : 7.1.4
   @ionic/angular-toolkit        : 1.2.2

Cordova:

   cordova (Cordova CLI) : 8.1.2 ([email protected])
   Cordova Platforms     : none
   Cordova Plugins       : no whitelisted plugins (2 plugins total)

System:

 (C:\Program Files (x86)\Android\android-sdk)
   NodeJS            : v10.15.0 (C:\Program Files\nodejs\node.exe)
   npm               : 6.0.1
   OS                : Windows 8.1

Have you added SQLite plugin in your APP? refer this:ionicframework.com/docs/native/sqlite — H_H
– H_H, Commented Jan 20, 2019 at 8:56
I am talking about native SQLite plugin: ionic cordova plugin add cordova-sqlite-storage — H_H
– H_H, Commented Jan 20, 2019 at 9:46
I have added this, is it ok or i need to add some other? - ionic cordova plugin add cordova-sqlite-storage — user2828442
– user2828442, Commented Jan 20, 2019 at 9:51
If you added these 2 then make sure you are calling it after platform.ready event and running the APP in emulator or physical device. — H_H
– H_H, Commented Jan 20, 2019 at 9:59

Scott · Accepted Answer · 2019-02-05 23:39:28Z

1

I ran into this same issue. sqlite isn't available in browser naturally. So, if you just install the plugin, and do ionic serve, it's not going to work. Run these commands:

ionic cordova platform add browser

and then

ionic cordova run browser

I had to run the 2nd command twice. With the first command, it didn't build for me. After this, it worked.

answered Feb 5, 2019 at 23:39

Scott

8278 silver badges20 bronze badges

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

1 Comment

Uday Nayak Over a year ago

this command give error like: Using cordova-fetch for cordova-browser@^6.0.0 Platform browser already added. [ERROR] An error occurred while running subprocess cordova. cordova platform add browser exited with exit code 1.

Collectives™ on Stack Overflow

Ionic 4 with Sqlite - Cannot read property 'then' of undefined TypeError: Cannot read property 'then' of undefined

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related