Android 8 이하 이미지 저장소 탐색 중 오류 발생 대응방법이 있을까요?

[cho960422]

안드로이드 9이하에서 이미지 저장소를 찾는 쿼리에서 문제가 생긴 것 같습니다. 아래와 같은 내용은 대처가 가능할까요?

Caused by android.database.sqlite.SQLiteException: no such column: duration (code 1): , while compiling: SELECT _id, _data, bucket_display_name, date_added, duration FROM images ORDER BY date_added DESC
#################################################################
Error Code : 1 (SQLITE_ERROR)
Caused By : SQL(query) error or missing database.
(no such column: duration (code 1): , while compiling: SELECT _id, _data, bucket_display_name, date_added, duration FROM images ORDER BY date_added DESC)
#################################################################
at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:179)
at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:135)
at android.content.ContentProviderProxy.query(ContentProviderNative.java:418)
at android.content.ContentResolver.query(ContentResolver.java:760)
at android.content.ContentResolver.query(ContentResolver.java:710)
at android.content.ContentResolver.query(ContentResolver.java:668)
at gun0912.tedimagepicker.util.GalleryUtil$Companion.getAllMediaList(GalleryUtil.kt:84)
at gun0912.tedimagepicker.util.GalleryUtil$Companion.getMedia$lambda-6(GalleryUtil.kt:30)
at gun0912.tedimagepicker.util.GalleryUtil$Companion.$r8$lambda$MEh2T-ij7_phM_p2hSXHbj5lEI4()
at gun0912.tedimagepicker.util.GalleryUtil$Companion$$ExternalSyntheticLambda0.subscribe(:4)
at io.reactivex.internal.operators.single.SingleCreate.subscribeActual(SingleCreate.java:39)
at io.reactivex.Single.subscribe(Single.java:3666)
at io.reactivex.internal.operators.single.SingleSubscribeOn$SubscribeOnObserver.run(SingleSubscribeOn.java:89)
at io.reactivex.Scheduler$DisposeTask.run(Scheduler.java:578)
at io.reactivex.internal.schedulers.ScheduledRunnable.run(ScheduledRunnable.java:66)
at io.reactivex.internal.schedulers.ScheduledRunnable.call(ScheduledRunnable.java:57)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:301)
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)