Can't open database: unable to open database file FROM ANDROID DEVICE

[lcatoni72]

E 0:00:03.110   bool godot::SQLite::open_db(): GDSQLite **Error: Can't open database: unable to open database file**
  <Sorgente C++>./src/gdsqlite.cpp:126 @ bool godot::SQLite::open_db()()
  <Analisi dello stack>Main.gd:27 @ run()
                Main.gd:21 @ _ready()

E 0:00:03.110   bool godot::SQLite::query_with_bindings(godot::String, godot::Array):  --> SQL error: unable to open database file
  <Sorgente C++>./src/gdsqlite.cpp:192 @ bool godot::SQLite::query_with_bindings(godot::String, godot::Array)()
  <Analisi dello stack>Main.gd:27 @ run()
                Main.gd:21 @ _ready()

Hi, I'm having this issue executing code on my phisical android device form godot v 3.4.4.4 No issues playing on windows from Godot environment, all it works perfectly Can someone help me ? Thanks.

extends Node2D

const SQLite = preload ("res://addons/godot-sqlite/bin/gdsqlite.gdns")
var db
var db_name = "res://databases/thedb"
#var db_name = "user://thedb"

var STT

# Called when the node enters the scene tree for the first time.
func _ready():
    OS.request_permission("RECORD_AUDIO")
    if Engine.has_singleton("SpeechToText"):
        STT = Engine.get_singleton("SpeechToText")
        STT.setLanguage("en")
        STT.connect("error",self,"_on_error")
        STT.connect("listening_completed",self,"_on_listening_completed")       
    db = SQLite.new()
    db.path = db_name
    run()
    pass # Replace with function body.

func run():
    db.open_db()
    db.query("select * from sentence order by random() limit 1;")

[2shady4u]

Hi @lcatoni72!

You can't create nor edit databases in the res://-folder on Android. This is restriction of Android and not something fixable by this plugin, as discussed here: https://github.com/2shady4u/godot-sqlite#4-my-androidioshtml5-application-cannot-access-the-database

Your options are:

• When your application starts, copy the database file to the user://-folder and change the database path to the path of the copied version. See the implementation of this exact thing in the demo-project: https://github.com/2shady4u/godot-sqlite/blob/f1eea6edea38f62d00df77929380f17f9fd0166e/demo/database.gd#L52
• Package your read-only database into your .PCK-file by adding the database to the export filter and access the database in read_only mode as discussed here: https://github.com/2shady4u/godot-sqlite#how-to-export

Note that in the second option, you won't be able to write anything to the database as the database will be packaged into your application's .PCK-file which is read-only by design.

[lcatoni72]

Great, I used first solution with copy_data_to_user() function !! It works, thanks !!!

[2shady4u]

Closing this as the issue is resolved!