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…
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…
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…
-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…