nagasathish
Lurker
Hi All,
Background:
I am a beginner developer and i developed a developed small App which reads from the pre-initialised sqlite db in assets folder and display data from it. It was developed in 2018 and no updates pushed since then. Somehow, I lost the backup of sqllite file .
ISSUE:
In order to retrieve the database file i followed some below adb commands to download the sqllite file from the data folder. (I am suspecting, i messed something after logging in here).
TILL BEFORE THE MINUTE I DID THIS, MY APP IS WORKING ON MY PHONE.
Somehow i downloaded my '.sqlite' file but it has just only schema. Since then i am not able to PROPERLY install my App on to my phone from Playstore (not debug and 2yrs old).
App is getting crashed with below stack trace and sometimes unable to find your database in 'data/data folder'.
My Findings:
1. After Fresh Installation, in App Info neither my permissions (Storage) are enabled nor prompting me to allow.
2. This was working fine before the minute till i did some unknown adb steps from forums.
3. I did tried Full factory reset twice to remove if any preferences but no luck. Giving SQLlite exception (database not found or unable to query select * table).
4. I tried in some other phones i have, it is getting installed fine there, I am seeing issue only in my phone.
Any suggestions or further help will be greatly appreciated.
Background:
I am a beginner developer and i developed a developed small App which reads from the pre-initialised sqlite db in assets folder and display data from it. It was developed in 2018 and no updates pushed since then. Somehow, I lost the backup of sqllite file .
ISSUE:
In order to retrieve the database file i followed some below adb commands to download the sqllite file from the data folder. (I am suspecting, i messed something after logging in here).
TILL BEFORE THE MINUTE I DID THIS, MY APP IS WORKING ON MY PHONE.
Code:
cd /Users/user/Library/Android/sdk/platform-tools
$ adb shell
$ OnePlus: run-as your.package.name
$ OnePlus: cd databases
etc... dont rememberSomehow i downloaded my '.sqlite' file but it has just only schema. Since then i am not able to PROPERLY install my App on to my phone from Playstore (not debug and 2yrs old).
App is getting crashed with below stack trace and sometimes unable to find your database in 'data/data folder'.
Code:
Process: com.mypackage, PID: 23778
java.lang.RuntimeException: Unable to start activity ComponentInfo{com.mypackage/com.mypackage.MainActivity}: android.database.sqlite.SQLiteException: no such table: station (code 1 SQLITE_ERROR): , while compiling: SELECT * FROM station
at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:3037)My Findings:
1. After Fresh Installation, in App Info neither my permissions (Storage) are enabled nor prompting me to allow.
2. This was working fine before the minute till i did some unknown adb steps from forums.
3. I did tried Full factory reset twice to remove if any preferences but no luck. Giving SQLlite exception (database not found or unable to query select * table).
4. I tried in some other phones i have, it is getting installed fine there, I am seeing issue only in my phone.
Any suggestions or further help will be greatly appreciated.