App crash on production, but not on debug mode

[penciaz]

Hi there, I've been using Simple SQLite on my project since Unity 2017.
Now I'm using Unity 2021.3.10f1, with a new fresh app. The app work perfectly on my computer, whe i run the app on my phone it work too (Debug mode).

I recently publish the game to playstotre, I had a lot of  crash request. When I download the app install it on my phone, I noticed right before calling Sqllite the app crash. When Open my Logcat on unity I found this error:


2022/10/13 15:39:41.512 18736 18753 Error Unity DllNotFoundException: Unable to load DLL 'sqlite3'. Tried the load the following dynamic libraries: Unable to load dynamic library 'sqlite3' because of 'Failed to open the requested dynamic library (0x06000000) dlerror() = dlopen failed: library "sqlite3" not found


I need your help please to submit an update.

[echo17]

I'm not sure which platform you are building for, but please be sure to select the correct one in the Unity menu Tools > SimpleSQL > Options. If it is Android, you will need to select that platform for it to extract the appropriate sqlite runtime library.

Please see these FAQs for more information:

link
link
link

[penciaz]

Hi, I follow all the step bellow , Nothing work. I still can't Send the update. Yes the game is for android. Like I said it's works on debug mode, but when I build the app for google play store, After Installing it the app send this error:

31625 Error SQLiteConnection Unable to find class org/sqlite/database/sqlite/SQLiteCustomFunction

[echo17]

Without seeing your build settings, it'd be hard to troubleshoot. Sounds like it might be a conflict with your target build architecture and the format of the sqlite library included with SimpleSQL. Here's a thread discussing this: link

Make sure your build settings are targeting both ARM7 and ARM64 architectures. I believe Google now requires you to use the IL2CPP scripting backend. I would try experimenting with the different build settings in the configuration. The support team at Unity would be able to explain all their functionality since it is part of their editor, so you could reach out to them for an explanation.



I know that in some cases the stripping level of the build settings can cause issues with .NET. Make sure you have the stripping set to minimal. Again, the Unity support team would be able to explain these settings the best.



If these steps fail, you might try downloading a different Android sqlite library from here: link. Place it in your Unity project's "Plugins/Android" folder

[penciaz]

HI, Still can't fix my issue, despite looking for help every where. I just buy a new macbookpro and move the project to it. Still the same issue, I thought it was on my windows laptop.

Why no one can't understand my issue. Please note, The app work well on debug, but if I Sign the apk or aab package to upload it to plays store, the app crash with the folling error
"2023/01/17 03:02:15.568 8170 8210 Error SQLiteConnection Unable to find class org/sqlite/database/sqlite/SQLiteCustomFunction" 
when getting to the Sqlite library. When I remove the package (simple sqlite) everything work perfectly and submitted to playstore.

[penciaz]

I share my option and build setting with you for more detail

imgur.com/a/ye99lQX

[echo17]

This error is coming from the sqlite library, not SimpleSQL. SimpleSQL is just a wrapper for SQLite, so there is something wrong with the apk, Unity build settings, or Android studio. Here is a web search showing the error and that it is related to the sqlite library specifically: link

I'm not able to reproduce this. Have you tried using .NET 4.x instead of 2.0? Have you tried a different minimum API level or target API level? Have you tried to use a different apk from the sqlite.org website (link)? Have you verified that the sqlite apk is in the project inside Android Studio? What stripping level do you have it set to (should be low with no engine code stripping)?

[penciaz]

When I download the new Sqlite library from sqlite.or I got error, dell library not found, when building for android. I downloaded the 3400100.aar one.

Error Unity DllNotFoundException: Unable to load DLL 'sqlite3'. Tried the load the following dynamic libraries: Unable to load dynamic library 'sqlite3' because of 'Failed to open the requested dynamic library (0x06000000) dlerror() = dlopen failed: library "sqlite3" not found

[echo17]

Have you tried using .NET 4.x instead of 2.0? Have you tried a different minimum API level or target API level? Have you verified that the sqlite apk is in the project inside Android Studio? What stripping level do you have it set to (should be low with no engine code stripping)?