triple-t / simpleprovider Goto Github PK

Caused by: android.database.sqlite.SQLiteException: no such table: journeys (code 1): , while compiling: SELECT * FROM journeys

public class JourneyProvider extends AbstractProvider {

    private static final int SCHEMA_VERSION = 1;

    protected String getAuthority() {
        return getContext().getString(R.string.authority);
    }

    @Table
    public class Journey {

        @Column(Column.FieldType.INTEGER)
        public static final String KEY_ID = "_id";

        @Column(Column.FieldType.TEXT)
        public static final String KEY_TITLE = "title";

    }

    @Override
    protected int getSchemaVersion() {
        return SCHEMA_VERSION;
    }
}

public static DatabaseProvider sDatabaseProvider;

    public static DatabaseProvider getInstance(Context context) {
        if (sDatabaseProvider == null) {
            synchronized (DatabaseProvider.class) {
                if (sDatabaseProvider == null) {
                    sDatabaseProvider = new DatabaseProvider();
                }
            }
        }
        return sDatabaseProvider;
    }

// For enabling and disabling the WAL by increasing the database version so I can get the logs.

@Override
 protected void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
   // to enable VAL setting 
   // db.enableWriteAheadLogging();
   // to disable VAL setting
     db.disableWriteAheadLogging();
   // And for testing val setting I have verified using 
  // to check WAL settings. 
   boolean isWriteAheadLoggingEnabled = db.isWriteAheadLoggingEnabled();
 }

07-29 12:16:19.070  12680-12720/? E/AndroidRuntime﹕ FATAL EXCEPTION: AsyncTask #1
    java.lang.RuntimeException: An error occured while executing doInBackground()
            at android.os.AsyncTask$3.done(AsyncTask.java:299)
            at java.util.concurrent.FutureTask.finishCompletion(FutureTask.java:352)
            at java.util.concurrent.FutureTask.setException(FutureTask.java:219)
            at java.util.concurrent.FutureTask.run(FutureTask.java:239)
            at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1080)
            at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:573)
            at java.lang.Thread.run(Thread.java:841)
     Caused by: android.database.sqlite.SQLiteException: no such table: posts (code 1): , while compiling: SELECT * FROM posts
            at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
            at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:1118)
            at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:691)
            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)
            at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:44)
            at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1436)
            at android.database.sqlite.SQLiteDatabase.queryWithFactory(SQLiteDatabase.java:1283)
            at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1154)
            at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1360)
            at de.triplet.simpleprovider.e.a(Unknown Source)
            at de.triplet.simpleprovider.e.a(Unknown Source)
            at de.triplet.simpleprovider.a.query(Unknown Source)
            at android.content.ContentProvider.query(ContentProvider.java:744)
            at android.content.ContentProvider$Transport.query(ContentProvider.java:199)
            at android.content.ContentResolver.query(ContentResolver.java:417)
            at android.content.CursorLoader.loadInBackground(CursorLoader.java:65)
            at android.content.CursorLoader.loadInBackground(CursorLoader.java:43)
            at android.content.AsyncTaskLoader.onLoadInBackground(AsyncTaskLoader.java:303)
            at android.content.AsyncTaskLoader$LoadTask.doInBackground(AsyncTaskLoader.java:68)
            at android.content.AsyncTaskLoader$LoadTask.doInBackground(AsyncTaskLoader.java:56)
            at android.os.AsyncTask$2.call(AsyncTask.java:287)
            at java.util.concurrent.FutureTask.run(FutureTask.java:234)
            at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1080)
            at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:573)
            at java.lang.Thread.run(Thread.java:841)

@Column(Column.FieldType.BLOB)
        public static final String IMAGE = "image"; //objectId