Click here to Skip to main content
15,888,351 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi Android gurus

I generated an apk file from my android studio, when i tested it on different android devices below are the result
Android 9.0 crashes
Android 9.0 (Emulator): works perfectly
Android 8.0 works perfectly
Android 7.0 crashes
Android 6.0: works perfectly
Android 5.0: works perfectly
Android 4.0: works perfectly
Has anybody experience this kind of issue before? kindly suggest a solution or a workaround. I anticipate a favourable
response thanks in advance

What I have tried:

I have tried searching the internet for the solution but no concrete answer was given
Posted
Updated 30-Dec-19 18:46pm
Comments
Richard MacCutchan 31-Dec-19 4:05am    
Forget searching the internet and do some debugging to find out why it crashes.
Member 10627743 1-Jan-20 11:56am    
See the logcat details below
Kris Lantz 31-Dec-19 8:26am    
By "crashing", do you mean at apk install or during runtime? If you have access to real hardware, Android Studio supports live debugging on the device (you might already know.) I used that feature quite a lot for troubleshooting, instead of those... delightful emulators.
Member 10627743 1-Jan-20 11:56am    
Happy new year to everyone in the house

thanks for your swift response, during the process of debuging the app information below was shown in the logcat

Process: com.akinyemi.logicverse.giving, PID: 6189
java.lang.RuntimeException: Unable to start activity ComponentInfo{com.akinyemi.logicverse.giving./com.akinyemi.logicverse.giving.MainActivity}: android.database.sqlite.SQLiteException: no such table: places (code 1 SQLITE_ERROR): , while compiling: SELECT pl_web_id FROM places ORDER BY pl_web_id DESC LIMIT 1
at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2942)
at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:3089)
at android.app.servertransaction.LaunchActivityItem.execute(LaunchActivityItem.java:78)
at android.app.servertransaction.TransactionExecutor.executeCallbacks(TransactionExecutor.java:108)
at android.app.servertransaction.TransactionExecutor.execute(TransactionExecutor.java:68)
at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1816)
at android.os.Handler.dispatchMessage(Handler.java:106)
at android.os.Looper.loop(Looper.java:193)
at android.app.ActivityThread.main(ActivityThread.java:6852)
at java.lang.reflect.Method.invoke(Native Method)
at com.android.internal.os.RuntimeInit$MethodAndArgsCaller.run(RuntimeInit.java:504)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:858)
Caused by: android.database.sqlite.SQLiteException: no such table: places (code 1 SQLITE_ERROR): , while compiling: SELECT pl_web_id FROM places ORDER BY pl_web_id DESC LIMIT 1
at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:903)
at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:514)
at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:37)

Do you anyone have any idea or solution to the error, kindly help
Richard MacCutchan 1-Jan-20 12:06pm    
android.database.sqlite.SQLiteException: no such table: places
Your database is either missing or has not been initialised.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900