Why do I get "Error: Could not open database"?

Question

I'm using the Android emulator so I put users.db in 'android/app/src/main/assets/users.db'. I already ran npx react-native link to make the link. I'm using a React Native version above 6.0 with auto-link.

I'm getting "Error: Could not open database":

import React, {Component} from 'react'
import {View, Text, Alert} from 'react-native'
import SQLite from 'react-native-sqlite-storage'

export default class App extends Component {

  constructor(props) {
    super(props)
    SQLite.openDatabase({name:'users', createFromLocation:1}, this.connected, this.failed)
  }

  connected= () =>{
    Alert.alert('Connected with success !')
  }

  failed= (e) =>{
    Alert.alert('Something went wrong !', `${e}`)
  }

  render(){
    return(
      <View>
        <Text>Testing SQLite</Text>
      </View>
    )
  }
}

VMMOORTHY · Accepted Answer · 2023-03-31 09:09:43Z

5

I removed this from the react-native.config.js and it worked

    "react-native-sqlite-storage": {
  platforms: {
    android: {
      sourceDir:
        "../node_modules/react-native-sqlite-storage/platforms/android-native",
      packageImportPath: "import io.liteglue.SQLitePluginPackage;",
      packageInstance: "new SQLitePluginPackage()"
    }
  }
}

Ref : Github

answered Mar 31, 2023 at 9:09

VMMOORTHY

1651 gold badge2 silver badges7 bronze badges

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

4 Comments

Azizi Musa Over a year ago

after hours of debugging. This is the solution for me. Previously unable to insert data when using android emulator or ios simulator. Only works on real device. But after removing script like above. Everything works.

Erick Crus Over a year ago

this solution saved my job!

VMMOORTHY Over a year ago

but do you know I am searching for a job?. Haha this is the world's reality

VMMOORTHY Over a year ago

feel free to follow me on LinkedIn(linkedin.com/in/vmmoorthy) and twitter(twitter.com/vmmoorthi25)

user4157124 · Accepted Answer · 2023-06-26 11:52:19Z

5

When changing the attribute createFromLocation to number 2 the system creates its own database which comes empty, so you need to create the tables. Unfortunately I didn't manage to use my old database.

edited Jun 26, 2023 at 11:52

user4157124

3,00021 gold badges33 silver badges48 bronze badges

answered Aug 19, 2020 at 18:37

Denis Ximenes

3794 silver badges12 bronze badges

Comments

michael · Accepted Answer · 2020-12-15 02:18:25Z

2

You need to put your db into assets/www folder to make it works.

edited Dec 15, 2020 at 2:18

michael

4,1733 gold badges15 silver badges31 bronze badges

answered Dec 14, 2020 at 15:52

Амартүвшин Батаа

214 bronze badges

Comments

Ger · Accepted Answer · 2021-05-10 13:31:09Z

2

The pre-populated database was read only after I completely uninstalled the app from the device and re-installed it from scratch with npx react-native run-android.

It was not enough to simply reload the app while it was already on the device.

answered May 10, 2021 at 13:31

Ger

9581 gold badge12 silver badges24 bronze badges

Comments

user4157124 · Accepted Answer · 2023-06-26 11:53:00Z

0

The full file path for the database should be "\android\app\src\main\assets\www".

edited Jun 26, 2023 at 11:53

user4157124

3,00021 gold badges33 silver badges48 bronze badges

answered Jun 26, 2023 at 9:32

mikest31

1

Collectives™ on Stack Overflow

Why do I get "Error: Could not open database"?

5 Answers 5

4 Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

4 Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related