Questions tagged [sqliteexception]
10 questions
3
votes
0 answers
Android Room database SqliteException not clear
I am getting this error in my Google play console.
android.database.sqlite.SQLiteException:
at android.database.sqlite.SQLiteConnection.nativeExecuteForCursorWindow (Native Method)
at android.database.sqlite.SQLiteConnection.executeForCursorWindow…

Vasudev
- 1,936
- 19
- 17
2
votes
0 answers
no such table while inserting data in SQLDelight
All of a sudden my sample project is unable to insert data to table. it complains table not created. my sample GitHub(https://github.com/sreexamus/KMMSQLDelightPOC) removed the SQM file in the sample and tried. Not sure which plugin got updated on…

SreekanthI
- 393
- 3
- 13
2
votes
3 answers
android.database.sqlite.SQLiteException: no such column: bucket_display_name
I was trying to get buckets having audio files using MediaStore. This is working fine on Android 10 API 29 but not working previous Android versions. I've attached a screenshot of working example on Android 10 API 29.
Caused by:…

AtifSayings
- 756
- 14
- 23
0
votes
1 answer
fetchone vs fetchone[0] in python sqlite3
I have a function like the below to get data from SQLite3 table.
def remedysql(crop, disease):
try:
conn = sqlite3.connect('plant_protection.db')
mycur = conn.cursor()
sql=f'select remedy from pp_remedy WHERE…

rsklearner
- 17
- 3
0
votes
1 answer
Android: android.database.sqlite.SQLiteException on rawQuery
Unable to detect cause of application crash. Variables StartDate and lastTimeCalculateValues are long.
Cursor c = MyApplicationExtendsClass.database.rawQuery("SELECT * FROM " + MyApplicationExtendsClass.locationTableName + " WHERE [Date] >= '" + new…

Neo
- 11
- 1
0
votes
0 answers
No column found when attempting to compile, code 1 SQLITE_ERROR[1]
I keep getting the error no column in various forms for example below but I cannot see any error in my code like comma or ' in the wrong place etc, does anyone know whats wrong here, probably something obvious. I have attached a portion of my…

RevansArden
- 75
- 8
0
votes
2 answers
Why is getBlob() retrieving Integer data from my Blob column in my database?
I am trying to display the data from my SQLite database to the recycler views. The data I am trying to display is an image & text. For the images in my database, I converted the image resources into bitmaps then into bytes & stored the bytes in my…

Zahid Habib
- 21
- 7
0
votes
0 answers
android.database.sqlite.SQLiteException in some devices
The application was working well, but became closed on some devices and this code for the application
my code is:
public List- getListProduct() {
item product = null;
List
- productList = new ArrayList<>();
…
-1
votes
2 answers
How to resolve "no such column: date_addedDESC" error?
My audio player on phone is showing "SQLite exception" and crashed. It needs external storage permission but I don't have a memory card. How to resolve this error?
Exception:
android.database.sqlite.SQLiteException: no such column: date_addedDESC…

Ahmed Abubaker
- 99
- 1
- 8
-2
votes
5 answers
java.lang.RuntimeException: Unable to start activity ComponentInfo: Sqlite exception" error
while I am trying to execute my app, it is crashing and I am getting this "java.lang.RuntimeException: Unable to start activity ComponentInfo: Sqlite exception" error.
please help me find my mistake. here is the snapshot of my code:
@Override
public…