SQLiteException: no such table only on Motorola Plus?

We have a user who runs our application on Motorola PLUS, and when we try to read from the SQL server, he receives the following exception.

We have already tried to completely remove the application and the database and reinstall it.

We also tried to query the database using simple rawquery, but did not succeed.

Any suggestion is welcome!

java.lang.RuntimeException: An error occured while executing doInBackground() at android.support.v4.brdone(SourceFile:137) at java.util.concurrent.FutureTask$Sync.innerSetException(FutureTask.java:274) at java.util.concurrent.FutureTask.setException(FutureTask.java:125) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:308) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1088) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:581) at java.lang.Thread.run(Thread.java:1019) Caused by: android.database.sqlite.SQLiteException: no such table: records: , while compiling: SELECT _id, name, isbackground FROM records ORDER BY _id ASC at android.database.sqlite.SQLiteCompiledSql.native_compile(Native Method) at android.database.sqlite.SQLiteCompiledSql.compile(SQLiteCompiledSql.java:92) at android.database.sqlite.SQLiteCompiledSql.<init>(SQLiteCompiledSql.java:65) at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:83) at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:49) at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:42) at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1365) at android.database.sqlite.SQLiteQueryBuilder.query(SQLiteQueryBuilder.java:330) at android.database.sqlite.SQLiteQueryBuilder.query(SQLiteQueryBuilder.java:280) at com.voicepro.db.RecordsContentProvider.query(SourceFile:289) at android.content.ContentProvider$Transport.query(ContentProvider.java:187) at android.content.ContentResolver.query(ContentResolver.java:266) at android.support.v4.bfloadInBackground(SourceFile:49) at android.support.v4.bfloadInBackground(SourceFile:35) at android.support.v4.baonLoadInBackground(SourceFile:240) at android.support.v4.bbdoInBackground(SourceFile:51) at android.support.v4.bbdoInBackground(SourceFile:40) at android.support.v4.bqcall(SourceFile:123) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:306) ... 4 more android.database.sqlite.SQLiteException: no such table: records: , while compiling: SELECT _id, name, isbackground FROM records ORDER BY _id ASC at android.database.sqlite.SQLiteCompiledSql.native_compile(Native Method) at android.database.sqlite.SQLiteCompiledSql.compile(SQLiteCompiledSql.java:92) at android.database.sqlite.SQLiteCompiledSql.<init>(SQLiteCompiledSql.java:65) at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:83) at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:49) at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:42) at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1365) at android.database.sqlite.SQLiteQueryBuilder.query(SQLiteQueryBuilder.java:330) at android.database.sqlite.SQLiteQueryBuilder.query(SQLiteQueryBuilder.java:280) at com.voicepro.db.RecordsContentProvider.query(SourceFile:289) at android.content.ContentProvider$Transport.query(ContentProvider.java:187) at android.content.ContentResolver.query(ContentResolver.java:266) at android.support.v4.bfloadInBackground(SourceFile:49) at android.support.v4.bfloadInBackground(SourceFile:35) at android.support.v4.baonLoadInBackground(SourceFile:240) at android.support.v4.bbdoInBackground(SourceFile:51) at android.support.v4.bbdoInBackground(SourceFile:40) at android.support.v4.bqcall(SourceFile:123) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:306) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1088) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:581) at java.lang.Thread.run(Thread.java:1019) 
0
source share
1 answer

I had the same problem. I think this does not happen on all devices, as you said, but the problem is not in the sqlite version, the problem is probably that in some place in your code you deleted the table (in my case, I deleted the cache for the web -client). Go to your code and retrain it.

see: Strange SQLiteException not on all devices

+1
source

All Articles