Trouble accessing the Ionic SQLite database: Unable to open

Question

Trouble accessing the Ionic SQLite database: Unable to open

I encountered some errors while attempting to connect my ionic app to a database. I am currently running the app on an android device using Google Chrome DevTools to troubleshoot the issue.

Check out the createDatabase() function and the specific error that was generated.

createDatabase() {
    this.plt.ready().then(() => {
      if (this.plt.is('cordova')) {
        this.sqlite = new SQLite();
        this.sqlite.create({
          name: 'ocp_database_fuits.db',
          location: 'default'
        }).then((db: SQLiteObject) => {
          this.database = db;
          this.createTables();
        }).catch(e => {
          console.log(e);
        });
      }
    });
  }

OPEN database: ocp_database_fuits.db

SQLitePlugin.js:197 OPEN database: ocp_database_fuits.db

FAILED, aborting any pending transactions main.js:686 Error: Could not open database
  at newSQLError (SQLitePlugin.js:26)
  at SQLitePlugin.js:199
  at Object.callbackFromNative (cordova.js:290)
  at <anonymous>:1:9

javascript typescript sqlite ionic-framework

Answer 1

Answer №1

Have you tried removing and then reinstalling the plugin? I tested your code and it seems to be working fine for me.

Uninstall

ionic cordova plugin rm cordova-sqlite-storage
npm uninstall @ionic-native/sqlite

Install

ionic cordova plugin add cordova-sqlite-storage
npm install @ionic-native/sqlite

Answer 2

Have you tried removing and then reinstalling the plugin? I tested your code and it seems to be working fine for me.

Uninstall

ionic cordova plugin rm cordova-sqlite-storage
npm uninstall @ionic-native/sqlite

Install

ionic cordova plugin add cordova-sqlite-storage
npm install @ionic-native/sqlite

Answer 3

Answer №2

To address the issue you're facing, please carefully follow these steps:

npm update
npm run build
ionic cordova plugin rm cordova-plugin-sqlite-2

Next, make the following adjustments in your database file:

createDatabase(): void {
this.plt.ready().then(() => {
  if (this.plt.is('cordova')) {
    this.sqlite = new SQLite();
    this.sqlite.create({
      name: 'ocp_database_fuits.db',
      location: 'default'
    }).then((db: SQLiteObject) => {
      this.database = db;
      this.createUserTable(this.database);
      this.createPathTable(this.database);
    }).catch(e => {
      console.log(e);
    });
  }
});
}

Additionally, ensure to execute the following:

createUserTable(db): void {
    // const d: SQLiteObject;
    db.executeSql('CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY AUTOINCREMENT, username TEXT, pass TEXT)', [])
    .then(() => {
      console.log('table users created');
    }).catch(e => {
      console.log('error in createUserTable function');
      console.log(e);
    });
  }

createPathTable(db): void {
    db.executeSql('CREATE TABLE IF NOT EXISTS paths (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, type TEXT, points TEXT', [])
    .then(() => {
      console.log('table paths created');
    }).catch(e => {
      console.log('error in createPathTable function');
      console.log(e);
    });
  }

Answer 4

To address the issue you're facing, please carefully follow these steps:

npm update
npm run build
ionic cordova plugin rm cordova-plugin-sqlite-2

Next, make the following adjustments in your database file:

createDatabase(): void {
this.plt.ready().then(() => {
  if (this.plt.is('cordova')) {
    this.sqlite = new SQLite();
    this.sqlite.create({
      name: 'ocp_database_fuits.db',
      location: 'default'
    }).then((db: SQLiteObject) => {
      this.database = db;
      this.createUserTable(this.database);
      this.createPathTable(this.database);
    }).catch(e => {
      console.log(e);
    });
  }
});
}

Additionally, ensure to execute the following:

createUserTable(db): void {
    // const d: SQLiteObject;
    db.executeSql('CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY AUTOINCREMENT, username TEXT, pass TEXT)', [])
    .then(() => {
      console.log('table users created');
    }).catch(e => {
      console.log('error in createUserTable function');
      console.log(e);
    });
  }

createPathTable(db): void {
    db.executeSql('CREATE TABLE IF NOT EXISTS paths (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, type TEXT, points TEXT', [])
    .then(() => {
      console.log('table paths created');
    }).catch(e => {
      console.log('error in createPathTable function');
      console.log(e);
    });
  }

Trouble accessing the Ionic SQLite database: Unable to open

Answer №1

Answer №2

Similar questions

Enumerate all interdependencies among 2 directories or libraries in an Angular application

The source 'http://localhost:3000' is not authorized to access the Twitter API

Exploring the TypeScript Type System: Challenges with Arrays Generated and Constant Assertions

Is it possible for a JavaScript environment to restore function normally after modifying the [[Prototype]] of an object?

Strategies for avoiding asynchronous behavior in AJAX with JQuery

Converting a JavaScript array to a PHP array using POST request

JavaScript will continue to run uninterrupted even after refreshing the webpage

Obtain personalized results for implementing in Convase JS from a PHP server

What is the best way to ensure the search box remains fixed in the top navigation bar while maintaining a fluid and responsive design?

Utilizing the power of Datatables through AJAX calls with HTML Forms

How can I display the output from Geocoder in a text box using the ArcGIS JavaScript API?

angular5: The ngFor directive will only function properly after the second button click

Creating a Vue component that leverages the computed property from a mixin

Angular 13: A guide on pulling data from an Excel spreadsheet

Which option offers superior performance: using attributes through HTML or jQuery?

Adding a JavaScript variable into a Django template tag

Trouble accessing setState within an axios call in ReactJs

What is the purpose of adding "/dist" to the library import statement?

Collaborating and monitoring data between controllers

Add an unidentified element into a sealed directive's scope