{"action":"created","issue":{"url":"https://api.github.com/repos/jgilfelt/android-sqlite-asset-helper/issues/93","repository_url":"https://api.github.com/repos/jgilfelt/android-sqlite-asset-helper","labels_url":"https://api.github.com/repos/jgilfelt/android-sqlite-asset-helper/issues/93/labels{/name}","comments_url":"https://api.github.com/repos/jgilfelt/android-sqlite-asset-helper/issues/93/comments","events_url":"https://api.github.com/repos/jgilfelt/android-sqlite-asset-helper/issues/93/events","html_url":"https://github.com/jgilfelt/android-sqlite-asset-helper/issues/93","id":142707024,"number":93,"title":"no such table error when trying to open db using sqlite-asset-helper","user":{"login":"sunladyjoy","id":1957700,"avatar_url":"https://avatars.githubusercontent.com/u/1957700?v=3","gravatar_id":"","url":"https://api.github.com/users/sunladyjoy","html_url":"https://github.com/sunladyjoy","followers_url":"https://api.github.com/users/sunladyjoy/followers","following_url":"https://api.github.com/users/sunladyjoy/following{/other_user}","gists_url":"https://api.github.com/users/sunladyjoy/gists{/gist_id}","starred_url":"https://api.github.com/users/sunladyjoy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sunladyjoy/subscriptions","organizations_url":"https://api.github.com/users/sunladyjoy/orgs","repos_url":"https://api.github.com/users/sunladyjoy/repos","events_url":"https://api.github.com/users/sunladyjoy/events{/privacy}","received_events_url":"https://api.github.com/users/sunladyjoy/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2016-03-22T16:41:40Z","updated_at":"2016-03-23T13:34:57Z","closed_at":null,"body":"I've added the gradle dependency for SQLiteAssetHelper and I [researched](http://stackoverflow.com/questions/32939748/sqliteassethelper-no-such-table-error) and re-copied my database into the databases folder (within the assets folder) yet I'm still getting this error:\r\n\r\n[sqliteassethelpererror.pdf](https://github.com/jgilfelt/android-sqlite-asset-helper/files/184514/sqliteassethelpererror.pdf)\r\n\r\n\r\n\r\n\r\n\r\n\r\n[DisplayResult.zip](https://github.com/jgilfelt/android-sqlite-asset-helper/files/184516/DisplayResult.zip)\r\n[MainActivity.zip](https://github.com/jgilfelt/android-sqlite-asset-helper/files/184517/MainActivity.zip)\r\n[MySQLiteHelper.zip](https://github.com/jgilfelt/android-sqlite-asset-helper/files/184518/MySQLiteHelper.zip)\r\n[PromiseListAdapter.zip](https://github.com/jgilfelt/android-sqlite-asset-helper/files/184519/PromiseListAdapter.zip)\r\n[Promises.zip](https://github.com/jgilfelt/android-sqlite-asset-helper/files/184529/Promises.zip)\r\n[verses.zip](https://github.com/jgilfelt/android-sqlite-asset-helper/files/184532/verses.zip)\r\n[activity_main.zip](https://github.com/jgilfelt/android-sqlite-asset-helper/files/184534/activity_main.zip)\r\n[lv_items.zip](https://github.com/jgilfelt/android-sqlite-asset-helper/files/184533/lv_items.zip)\r\n[categories.zip](https://github.com/jgilfelt/android-sqlite-asset-helper/files/184535/categories.zip)\r\n\r\nI'm still relatively new to Android Studio.  \r\n\r\nThank you.\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/jgilfelt/android-sqlite-asset-helper/issues/comments/200345343","html_url":"https://github.com/jgilfelt/android-sqlite-asset-helper/issues/93#issuecomment-200345343","issue_url":"https://api.github.com/repos/jgilfelt/android-sqlite-asset-helper/issues/93","id":200345343,"user":{"login":"Kisty","id":3243752,"avatar_url":"https://avatars.githubusercontent.com/u/3243752?v=3","gravatar_id":"","url":"https://api.github.com/users/Kisty","html_url":"https://github.com/Kisty","followers_url":"https://api.github.com/users/Kisty/followers","following_url":"https://api.github.com/users/Kisty/following{/other_user}","gists_url":"https://api.github.com/users/Kisty/gists{/gist_id}","starred_url":"https://api.github.com/users/Kisty/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Kisty/subscriptions","organizations_url":"https://api.github.com/users/Kisty/orgs","repos_url":"https://api.github.com/users/Kisty/repos","events_url":"https://api.github.com/users/Kisty/events{/privacy}","received_events_url":"https://api.github.com/users/Kisty/received_events","type":"User","site_admin":false},"created_at":"2016-03-23T13:34:57Z","updated_at":"2016-03-23T13:34:57Z","body":"@sunladyjoy Looks fine to me. Can you post your asset folder and can you tell us the path of it by right clicking on the folder and selecting _Copy path_. Maybe the database is in the wrong place. How do you make your database? Is it a SQLite database? Nice idea, btw! :)\r\n\r\nThis is the stack trace from the PDF:\r\n\r\n`03-22 12:23:44.130 3791-3791/? E/SQLiteAssetHelper: Couldn't open cybdatabase.db for writing (will try read-only):\r\ncom.readystatesoftware.sqliteasset.SQLiteAssetHelper$SQLiteAssetException: Missing databases/cybdatabase.db file (or .zip, .gz archive) in assets, or target folder not writable\r\nat android.content.res.AssetManager.openAsset(Native Method)\r\nat android.content.res.AssetManager.open(AssetManager.java:313)\r\nat android.content.res.AssetManager.open(AssetManager.java:287)\r\nat com.readystatesoftware.sqliteasset.SQLiteAssetHelper.copyDatabaseFromAssets(SQLiteAssetHelper.java:436)\r\nat com.readystatesoftware.sqliteasset.SQLiteAssetHelper.createOrOpenDatabase(SQLiteAssetHelper.java:400)\r\nat com.readystatesoftware.sqliteasset.SQLiteAssetHelper.getWritableDatabase(SQLiteAssetHelper.java:176)\r\nat com.readystatesoftware.sqliteasset.SQLiteAssetHelper.getReadableDatabase(SQLiteAssetHelper.java:254)\r\nat com.blogspot.joyouslybeingjoy.cybpromises.MySQLiteHelper.getPromiseVerses(MySQLiteHelper.java:23)\r\nat com.blogspot.joyouslybeingjoy.cybpromises.DisplayResult.onCreate(DisplayResult.java:31)\r\nat android.app.Activity.performCreate(Activity.java:6237)\r\nat android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1107)\r\nat android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2369)\r\nat android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2476)\r\nat android.app.ActivityThread.-wrap11(ActivityThread.java)\r\nat android.app.ActivityThread$H.handleMessage(ActivityThread.java:1344)\r\nat android.os.Handler.dispatchMessage(Handler.java:102)\r\nat android.os.Looper.loop(Looper.java:148)\r\nat android.app.ActivityThread.main(ActivityThread.java:5417)\r\nat java.lang.reflect.Method.invoke(Native Method)\r\nat com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:726)\r\nat com.android.internal.os.ZygoteInit.main(ZygoteInit.java:616)\r\n03-22 12:23:44.130 3791-3791/? E/SQLiteLog: (14) cannot open file at line 31278 of [2ef4f3a5b1]\r\n03-22 12:23:44.133 3791-3791/? E/SQLiteLog: (14) os_unix.c:31278: (2) open(/data/user/0/com.blogspot.joyouslybeingjoy.cybpromises/databases/cybdatabase.db) -\r\n03-22 12:23:44.134 3791-3791/? E/SQLiteDatabase: Failed to open database '/data/user/0/com.blogspot.joyouslybeingjoy.cybpromises/databases/cybdatabase.db'.\r\nandroid.database.sqlite.SQLiteCantOpenDatabaseException: unknown error (code 14): Could not open database\r\nat android.database.sqlite.SQLiteConnection.nativeOpen(Native Method)\r\nat android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:207)\r\nat android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:191)\r\nat android.database.sqlite.SQLiteConnectionPool.openConnectionLocked(SQLiteConnectionPool.java:463)\r\nat android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:185)\r\nat android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:177)\r\nat android.database.sqlite.SQLiteDatabase.openInner(SQLiteDatabase.java:806)\r\nat android.database.sqlite.SQLiteDatabase.open(SQLiteDatabase.java:791)\r\nat android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:694)\r\nat android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:669)\r\nat com.readystatesoftware.sqliteasset.SQLiteAssetHelper.getReadableDatabase(SQLiteAssetHelper.java:264)\r\nat com.blogspot.joyouslybeingjoy.cybpromises.MySQLiteHelper.getPromiseVerses(MySQLiteHelper.java:23)\r\nat\r\ncom.blogspot.joyouslybeingjoy.cybpromises.DisplayResult.onCreate(DisplayResult.java:31)\r\nat android.app.Activity.performCreate(Activity.java:6237)\r\nat android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1107)\r\nat android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2369)\r\nat android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2476)\r\nat android.app.ActivityThread.-wrap11(ActivityThread.java)\r\nat android.app.ActivityThread$H.handleMessage(ActivityThread.java:1344)\r\nat android.os.Handler.dispatchMessage(Handler.java:102)\r\nat android.os.Looper.loop(Looper.java:148)\r\nat android.app.ActivityThread.main(ActivityThread.java:5417)\r\nat java.lang.reflect.Method.invoke(Native Method)\r\nat com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:726)\r\nat com.android.internal.os.ZygoteInit.main(ZygoteInit.java:616)\r\n03-22 12:23:44.135 3791-3791/? D/AndroidRuntime: Shutting down VM\r\n03-22 12:23:44.135 3791-3791/? E/AndroidRuntime: FATAL EXCEPTION: main\r\nProcess: com.blogspot.joyouslybeingjoy.cybpromises, PID: 3791\r\njava.lang.RuntimeException: Unable to start activity\r\nComponentInfo{com.blogspot.joyouslybeingjoy.cybpromises/com.blogspot.joyouslybeingjoy.cybpromises.DisplayResult}\r\n: android.database.sqlite.SQLiteCantOpenDatabaseException: unknown error (code 14): Could not open database\r\nat android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2416)\r\nat android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2476)\r\nat android.app.ActivityThread.-wrap11(ActivityThread.java)\r\nat android.app.ActivityThread$H.handleMessage(ActivityThread.java:1344)\r\nat android.os.Handler.dispatchMessage(Handler.java:102)\r\nat android.os.Looper.loop(Looper.java:148)\r\nat android.app.ActivityThread.main(ActivityThread.java:5417)\r\nat java.lang.reflect.Method.invoke(Native Method)\r\nat com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:726)\r\nat com.android.internal.os.ZygoteInit.main(ZygoteInit.java:616)\r\nCaused by: android.database.sqlite.SQLiteCantOpenDatabaseException: unknown error\r\n(code 14): Could not open database\r\nat android.database.sqlite.SQLiteConnection.nativeOpen(Native Method)\r\nat android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:207)\r\nat android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:191)\r\nat\r\nandroid.database.sqlite.SQLiteConnectionPool.openConnectionLocked(SQLiteConnectionPool.java:463)\r\nat android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:185)\r\nat android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:177)\r\nat android.database.sqlite.SQLiteDatabase.openInner(SQLiteDatabase.java:806)\r\nat android.database.sqlite.SQLiteDatabase.open(SQLiteDatabase.java:791)\r\nat android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:694)\r\nat android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:669)\r\nat\r\ncom.readystatesoftware.sqliteasset.SQLiteAssetHelper.getReadableDatabase(SQLiteAssetHelper.java:264)\r\nat\r\ncom.blogspot.joyouslybeingjoy.cybpromises.MySQLiteHelper.getPromiseVerses(MySQLiteHelper.java:23)\r\nat\r\ncom.blogspot.joyouslybeingjoy.cybpromises.DisplayResult.onCreate(DisplayResult.java:31)\r\nat android.app.Activity.performCreate(Activity.java:6237)\r\nat android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1107)\r\nat android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2369)\r\nat android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2476)\r\nat android.app.ActivityThread.-wrap11(ActivityThread.java)\r\nat android.app.ActivityThread$H.handleMessage(ActivityThread.java:1344)\r\nat android.os.Handler.dispatchMessage(Handler.java:102)\r\nat android.os.Looper.loop(Looper.java:148)\r\nat android.app.ActivityThread.main(ActivityThread.java:5417)\r\nat java.lang.reflect.Method.invoke(Native Method)\r\nat com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:726)\r\nat com.android.internal.os.ZygoteInit.main(ZygoteInit.java:616)\r\n03-22 12:23:44.169 1630-3602/? W/ActivityManager: Force finishing activity com.blogspot.joyouslybeingjoy.cybpromises/.DisplayResult\r\n03-22 12:23:44.191 1630-3602/? W/ActivityManager: Force finishing activity com.blogspot.joyouslybeingjoy.cybpromises/.MainActivity`"}}