Android P – ‘SQLite: No Such Table Error’ after copying database from assets

by

Was having a similar issue, and solved this adding this to my SQLiteOpenHelper

    @Override
    public void onOpen(SQLiteDatabase db) {
        super.onOpen(db);
        db.disableWriteAheadLogging();
    }

Apparently Android P sets the PRAGMA Log thing different. Still no idea if will have side effects, but seems to be working!

More Related Contents:

  1. How to add multiple edit text and spinner data into SQLite database?
  2. Hindi font not displying correctly in android [closed]
  3. Share SQLite database between 2 android apps?
  4. Location of sqlite database on the device
  5. Android: upgrading DB version and adding new table
  6. How to ignore accent in SQLite query (Android)
  7. Deleting Row in SQLite in Android
  8. Best place to close database connection
  9. Store Android SQLite
  10. How to split comma-separated value in SQLite?
  11. Why do I get a “sqlite3: not found” error on a rooted Nexus One when I try to open a database using the adb shell?
  12. Android sqlite how to check if a record exists
  13. Android Persistence room: “Cannot figure out how to read this field from a cursor”
  14. SQLite Exception no such column when trying to select
  15. android java.lang.IllegalStateException: Couldn’t read row 0, col 0 from CursorWindow
  16. Download Manger not working in Android Pie 9.0 NetworkSecurityConfig: No Network Security Config specified, using platform default
  17. How can I insert image in a sqlite database
  18. Android Cursor with ORMLite to use in CursorAdapter
  19. Is it possible to apply primary key on the text fields in android database
  20. What is The use of moveToFirst () in SQLite Cursors
  21. How to store sqlite database directly on sdcard
  22. sqlite example program in android [closed]
  23. How to check database on not rooted android device
  24. SQLite android column not found
  25. SQlite – Android – Foreign key syntax
  26. Inserting values to SQLite table in Android
  27. Queries with prepared statements in Android?
  28. SQLiteOpenHelper onUpgrade() Confusion Android
  29. Using COLLATE in Android SQLite – Locales is ignored in LIKE statement
  30. SQLite Foreign Key

Leave a Comment