Error when exporting to Android

[artiko99-b1]

Environment:

• OS: Windows
• Godot version: 4.0.3
• godot-sqlite version: 4.0

Issue description:
When I export to android I get the error "No suitable library found for GDExtension: res://addons/godot-sqlite/gdsqlite.gdextension. Possible feature flags for your platform: mobile, android, etc2, astc, arm64, arm64-v8a, template, debug, template_debug"
I can install the generated APK/AAB file on android but the Sqlite functions are ignored so the app on mobile does not work.

What I have found out:
I have looked in the gdsqlite.gdextension file and I have seen that it does not have the libraries it should use for android. It doesn't have the depencies either.
I have edited the file adding the missing entries and now the Android export works correctly.
Please correct the gdsqlite.gdextension file with the missing entries.

[2shady4u]

I will add the binaries to the gdsqlite.gdextension-file ASAP.
To speed up this process, would it be possible to show me the missing entries that you added?

[artiko99-b1]

These are the missing entries that I´ve added to gdsqlite.gdextension file:
In [libraries] section:
android.arm64 = "res://addons/godot-sqlite/bin/libgdsqlite.android.template_debug.arm64.so"
android.template_release.arm64 = "res://addons/godot-sqlite/bin/libgdsqlite.android.template_release.arm64.so"
android.x86_64 = "res://addons/godot-sqlite/bin/libgdsqlite.android.template_debug.x86_64.so"
android.template_release.x86_64 = "res://addons/godot-sqlite/bin/libgdsqlite.android.template_release.x86_64.so"

In [dependencies] section:
android.arm64 = {}
android.template_release.arm64 = {}
android.x86_64 = {}
android.template_release.x86_64 = {}

That's all.

[Labanazario]

@artiko99-b1 but you managed to make the database work after that? Like read/write to the db in Android, because in my case it wont work even if I do this gdextension modification. It exports but do not actually work when reading something from the db.

[artiko99-b1]

@Labanazario
My database is read-only. I don't have to copy it to the user:// folder.
Before the fix, I was getting the error mentioned in the first post, and the version exported to my Android device was unusable.
Now it works as expected.

[2shady4u]

@artiko99-b1
Adding these library entries to the gdsqlite.gdextension-file doesn't seem to be sufficient to make it work on Android on my end:

ERROR: No suitable library found for GDExtension: res://addons/godot-sqlite/gdsqlite.gdextension. Possible feature flags for your platform: mobile, android, etc2, astc, arm32, armeabi-v7a, arm64, arm64-v8a, template, debug, template_debug
   at: (./editor/plugins/gdextension_export_plugin.h:114)

The latest gdsqlite.gdextension-file can be found here.

[vtgreybeard]

Fwiw, I am getting the exact same error when exporting to Android:
No suitable library found for GDExtension: res://addons/godot-sqlite/gdsqlite.gdextension. Possible feature flags for your platform: mobile, android, etc2, astc, arm32, armeabi-v7a, arm64, arm64-v8a, template, debug, template_debug

I am using the stock/provided gdsqlite.gdextension file as well.

Also, it did previously export properly when I was using Godot v4.0.1 with an (unknown) previous version of this plugin.

[cyberpuffin-digital]

I hit this issue when exporting for Android as well (Godot 4.1.1, godot-sqlite 4.2). If I understand the issue correctly, it's because there is no binary for the 32 bit Android architectures (armeabi-v7a and x86). Once I removed those target architectures from my build, everything worked as expected. I can read and write databases in the user space on my builds.

[shanbady]

I have a cheap android that my app needs to run on (armeabi-v7a) - How can I get it running on there without running into the "Could not find type "SQLite" in the current scope." error

[jlucki]

I'm also getting this error when exporting to Android in release mode. Are there any working fixes for this?

[shanbady]

@jlucki I was able to get this working. what i did was:

1. clone down the repo
2. manually generate a build for android arm32

ANDROID_HOME=<path to android sdk> scons platform=android target=template_debug target_path=<cloned_repo>/demo/addons/godot-sqlite/bin/ target_name=libgdsqlite -j6 arch=arm32 enable_fts5=no

2. copy the generated libs in demo/addons/godot-sqlite/bin/ to /addons/godot-sqlite/bin/
3. edit /addons/godot-sqlite/godot-sqlite.gd to include the new libs for arm32. add the following to the [libraries] section:

android.debug.arm64 = "res://addons/godot-sqlite/bin/libgdsqlite.android.template_debug.arm64.so"
android.debug.arm32 = "res://addons/godot-sqlite/bin/libgdsqlite.android.template_debug.arm32.so"
android.release.arm32 = "res://addons/godot-sqlite/bin/libgdsqlite.android.template_release.arm32.so"
android.release.arm64 = "res://addons/godot-sqlite/bin/libgdsqlite.android.template_release.arm64.so"
android.debug.x86_64 = "res://addons/godot-sqlite/bin/libgdsqlite.android.template_debug.x86_64.so"
android.release.x86_64 = "res://addons/godot-sqlite/bin/libgdsqlite.android.template_release.x86_64.so"
android.debug.x86_32 = "res://addons/godot-sqlite/bin/libgdsqlite.android.template_debug.x86_32.so"
android.release.x86_32 = "res://addons/godot-sqlite/bin/libgdsqlite.android.template_release.x86_32.so"

open your godot project and try a build. it should work