OppiaMobile Community

SQLiteException: no such table: userprefs

Hi
I have been noticing this error in the in the log files, after installation of the app initially. I think it disappears after that. Looks like its coming from the DbHelper class.

2020-07-24 11:03:06.416 19130-19163/? E/SQLiteLog: (1) no such table: userprefs
2020-07-24 11:03:06.417 19130-19163/? D/SQLiteDBG: func: nativePrepareStatement, confirmed: 2
2020-07-24 11:03:06.417 19130-19163/? D/SQLiteDBG: handleSQLiteError, path: /data/user/0/ug.go.health.mobile.covid19/databases/mobilelearning.db, handle: 0x7f0628f800, errCode: 1, msg: no such table: userprefs
2020-07-24 11:03:06.420 19130-19163/? D/DBMigration: SQLiteException
android.database.sqlite.SQLiteException: no such table: userprefs (code 1): , while compiling: SELECT * FROM userprefs
at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:893)
at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:504)
at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
at android.database.sqlite.SQLiteProgram.(SQLiteProgram.java:58)
at android.database.sqlite.SQLiteQuery.(SQLiteQuery.java:37)
at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:68)
at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1404)
at android.database.sqlite.SQLiteDatabase.queryWithFactory(SQLiteDatabase.java:1251)
at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1122)
at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1290)
at org.digitalcampus.oppia.database.DbHelper.getAllUserPreferences(DbHelper.java:2344)
at org.digitalcampus.oppia.database.DBMigration.copyUserPreferencesData(DBMigration.java:80)
at org.digitalcampus.oppia.database.DBMigration.runMigrationsByVersion(DBMigration.java:64)
at org.digitalcampus.oppia.database.DBMigration.checkMigrationStatus(DBMigration.java:53)
at org.digitalcampus.oppia.task.UpgradeManagerTask.doInBackground(UpgradeManagerTask.java:152)
at org.digitalcampus.oppia.task.UpgradeManagerTask.doInBackground(UpgradeManagerTask.java:60)
at android.os.AsyncTask$2.call(AsyncTask.java:333)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at android.os.AsyncTask$SerialExecutor$1.run(AsyncTask.java:245)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1162)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:636)
at java.lang.Thread.run(Thread.java:764)

Thanks Hakim… just to check… does this cause any problem when actually installing or running the app?

No, it does not cause any problem. I was investigating something else, and I noticed that error in the Log files every-time i installed the app.