升级到 Android 10,后调用Matisse崩溃 : Invalid column COUNT(*) AS count #659

JakePrim · 2019-09-04T06:08:43Z

Describe the bug
升级到 Android 10,后调用Matisse崩溃
Invalid column COUNT(*) AS count
To Reproduce
Caused by: java.lang.IllegalArgumentException: Invalid column COUNT(*) AS count at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:170) at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:140) at android.content.ContentProviderProxy.query(ContentProviderNative.java:423) at android.content.ContentResolver.query(ContentResolver.java:944) at android.content.ContentResolver.query(ContentResolver.java:880) at androidx.core.content.ContentResolverCompat.query(ContentResolverCompat.java:81) at androidx.loader.content.CursorLoader.loadInBackground(CursorLoader.java:63) at com.zhihu.matisse.internal.loader.AlbumLoader.loadInBackground(AlbumLoader.java:114) at com.zhihu.matisse.internal.loader.AlbumLoader.loadInBackground(AlbumLoader.java:33) at androidx.loader.content.AsyncTaskLoader.onLoadInBackground(AsyncTaskLoader.java:307) at androidx.loader.content.AsyncTaskLoader$LoadTask.doInBackground(AsyncTaskLoader.java:60) at androidx.loader.content.AsyncTaskLoader$LoadTask.doInBackground(AsyncTaskLoader.java:48) at androidx.loader.content.ModernAsyncTask$2.call(ModernAsyncTask.java:141) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641) at java.lang.Thread.run(Thread.java:919)
Expected behavior

Screenshots

Smartphone (please complete the following information):

Device: [e.g. Pixel 3 XL]
OS: [e.g. Android 29]
Version [29]

The text was updated successfully, but these errors were encountered:

REBOOTERS · 2019-09-04T10:25:06Z

还没有适配 Android 10 ，近期会支持一下。

vee-zhang · 2019-09-05T07:12:25Z

我也遇到了

yccheok · 2019-09-11T04:09:15Z

Just an additional note to all, if you intent to reproduce this problem in Android Q, which introduces scoped storage recently, you need to change Matisse library and Matisse sample's build.gradle, to both

compileSdkVersion 29 and targetSdkVersion 29

AlbumLoader.java
My initial testing is that, Android Q is having problem in

Using "COUNT(*) AS " + COLUMN_COUNT in PROJECTION
Using GROUP BY in SELECTION

An op seem to have solution on these limitations - #646 However, the code formatting make it difficult to copy and paste directly for testing purpose. I may need to spend some time, to digest the idea behind the code as I'm not familiar with CursorLoader.

yccheok · 2019-09-11T16:28:14Z

同志好！

我尝试修复 Android Q 的臭虫。因为我对 CursorLoader 并不了解。如果你能找出更好的方案，请修正。

谢谢同志们！

这是我建议的代码

2c8f6f8

MediaStore.MediaColumns.DATA 已经 deprecated 了。可，我不知道应该用什么代替品。请同志留意 - https://stackoverflow.com/questions/57893449/what-is-the-replacement-for-deprecated-mediastore-mediacolumns-data-in-android-q

yccheok · 2019-09-11T18:16:14Z

因为 MediaStore.MediaColumns.DATA 已经 deprecated ，我建议把 Album 的 mCoverPath 转换成 mCoverUri

4cccb27

我比较不确定的是，会不会在一些刁钻的状况，Uri.toString / Uri.parse 的相互转换会失败？

JocelynDavid · 2019-09-28T11:57:55Z

I got the same crash on version 0.5.3-beta2, any idea when a fix will be added to the library?

REBOOTERS · 2019-10-11T01:25:38Z

近期工作中的事情比较多，会抽空进行适配。

Jocerly · 2019-10-14T05:52:06Z

可以暂时按照 issues 646 来改

#646, closes #603, closes #602, closes #667

kilo-swodh · 2019-11-11T01:14:10Z

希望尽快适配Android 10

REBOOTERS · 2019-11-11T09:49:35Z

希望尽快适配Android 10

https://github.com/zhihu/Matisse/releases/tag/v0.5.3-beta3 已经适配了呀。

kilo-swodh · 2019-11-12T06:59:34Z

希望尽快适配Android 10

https://github.com/zhihu/Matisse/releases/tag/v0.5.3-beta3 已经适配了呀。

抱歉,已发现是我这边没适配好Android 10的外部存储限制

wlong800 · 2019-11-14T02:47:31Z

api 'com.zhihu.android:matisse:0.5.3-beta3'
为啥编译不过

ERROR: Unable to resolve dependency for ':PhotoSdk@debug/compileClasspath': Could not download matisse.aar (com.zhihu.android:matisse:0.5.3-beta3)
Show Details
Affected Modules: PhotoSdk

ERROR: Unable to resolve dependency for ':PhotoSdk@debugAndroidTest/compileClasspath': Could not download matisse.aar (com.zhihu.android:matisse:0.5.3-beta3)
Show Details
Affected Modules: PhotoSdk

ERROR: Unable to resolve dependency for ':PhotoSdk@debugUnitTest/compileClasspath': Could not download matisse.aar (com.zhihu.android:matisse:0.5.3-beta3)
Show Details
Affected Modules: PhotoSdk

ERROR: Unable to resolve dependency for ':PhotoSdk@release/compileClasspath': Could not download matisse.aar (com.zhihu.android:matisse:0.5.3-beta3)
Show Details
Affected Modules: PhotoSdk

ERROR: Unable to resolve dependency for ':PhotoSdk@releaseUnitTest/compileClasspath': Could not download matisse.aar (com.zhihu.android:matisse:0.5.3-beta3)
Show Details
Affected Modules: PhotoSdk

ERROR: Unable to resolve dependency for ':App@debug/compileClasspath': Could not download matisse.aar (com.zhihu.android:matisse:0.5.3-beta3)
Show Details
Affected Modules: App

ERROR: Unable to resolve dependency for ':App@debugAndroidTest/compileClasspath': Could not download matisse.aar (com.zhihu.android:matisse:0.5.3-beta3)
Show Details
Affected Modules: App

ERROR: Unable to resolve dependency for ':App@debugUnitTest/compileClasspath': Could not download matisse.aar (com.zhihu.android:matisse:0.5.3-beta3)
Show Details
Affected Modules: App

ERROR: Unable to resolve dependency for ':App@release/compileClasspath': Could not download matisse.aar (com.zhihu.android:matisse:0.5.3-beta3)
Show Details
Affected Modules: App

ERROR: Unable to resolve dependency for ':App@releaseUnitTest/compileClasspath': Could not download matisse.aar (com.zhihu.android:matisse:0.5.3-beta3)
Show Details
Affected Modules: App

wlong800 · 2019-11-14T02:48:16Z

@JakePrim kilo-swodh

… closes zhihu#659, closes zhihu#646, closes zhihu#603, closes zhihu#602, closes zhihu#667

serreau · 2020-03-26T19:37:31Z

Same problem with Android 10 (pixel 4)

2020-03-26 20:32:13.820 1815-2067/[my project name] E/AndroidRuntime: FATAL EXCEPTION: ModernAsyncTask #1
Process: [my project name] , PID: 1815
java.lang.RuntimeException: An error occurred while executing doInBackground()
at androidx.loader.content.ModernAsyncTask$3.done(ModernAsyncTask.java:164)
at java.util.concurrent.FutureTask.finishCompletion(FutureTask.java:383)
at java.util.concurrent.FutureTask.setException(FutureTask.java:252)
at java.util.concurrent.FutureTask.run(FutureTask.java:271)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641)
at java.lang.Thread.run(Thread.java:919)
Caused by: java.lang.IllegalArgumentException: Invalid column COUNT(*) AS count
at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:170)
at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:140)
at android.content.ContentProviderProxy.query(ContentProviderNative.java:423)
at android.content.ContentResolver.query(ContentResolver.java:944)
at android.content.ContentResolver.query(ContentResolver.java:880)
at androidx.core.content.ContentResolverCompat.query(ContentResolverCompat.java:81)
at androidx.loader.content.CursorLoader.loadInBackground(CursorLoader.java:63)
at com.zhihu.matisse.internal.loader.AlbumLoader.loadInBackground(AlbumLoader.java:97)
at com.zhihu.matisse.internal.loader.AlbumLoader.loadInBackground(AlbumLoader.java:33)
at androidx.loader.content.AsyncTaskLoader.onLoadInBackground(AsyncTaskLoader.java:307)
at androidx.loader.content.AsyncTaskLoader$LoadTask.doInBackground(AsyncTaskLoader.java:60)
at androidx.loader.content.AsyncTaskLoader$LoadTask.doInBackground(AsyncTaskLoader.java:48)
at androidx.loader.content.ModernAsyncTask$2.call(ModernAsyncTask.java:141)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641)
at java.lang.Thread.run(Thread.java:919)

baizhu0414 · 2021-05-06T11:43:16Z

我遇到了类似的问题：（已经调整编译环境到buildVersion29）
2021-05-06 19:33:13.231 5150-5239/com.example.testmatisse E/AndroidRuntime: FATAL EXCEPTION: ModernAsyncTask #1
Process: com.example.testmatisse, PID: 5150
java.lang.RuntimeException: An error occurred while executing doInBackground()
at androidx.loader.content.ModernAsyncTask$3.done(ModernAsyncTask.java:164)
at java.util.concurrent.FutureTask.finishCompletion(FutureTask.java:383)
at java.util.concurrent.FutureTask.setException(FutureTask.java:252)
at java.util.concurrent.FutureTask.run(FutureTask.java:271)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641)
at java.lang.Thread.run(Thread.java:919)
Caused by: java.lang.IllegalArgumentException: Invalid column COUNT(*) AS count
at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:170)
at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:140)
at android.content.ContentProviderProxy.query(ContentProviderNative.java:423)
at android.content.ContentResolver.query(ContentResolver.java:946)
at android.content.ContentResolver.query(ContentResolver.java:881)
at androidx.core.content.ContentResolverCompat.query(ContentResolverCompat.java:81)
at androidx.loader.content.CursorLoader.loadInBackground(CursorLoader.java:63)
at com.zhihu.matisse.internal.loader.AlbumLoader.loadInBackground(AlbumLoader.java:97)
at com.zhihu.matisse.internal.loader.AlbumLoader.loadInBackground(AlbumLoader.java:33)
at androidx.loader.content.AsyncTaskLoader.onLoadInBackground(AsyncTaskLoader.java:307)
at androidx.loader.content.AsyncTaskLoader$LoadTask.doInBackground(AsyncTaskLoader.java:60)
at androidx.loader.content.AsyncTaskLoader$LoadTask.doInBackground(AsyncTaskLoader.java:48)
at androidx.loader.content.ModernAsyncTask$2.call(ModernAsyncTask.java:141)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641)
at java.lang.Thread.run(Thread.java:919)

compileSdkVersion 29
defaultConfig { applicationId 'com.example.testmatisse' minSdkVersion 14 targetSdkVersion 29 versionCode 1 versionName "1.0" }

另外，我运行Demo时没有出问题，但是我已经基本保持和Demo一致的环境了，唯一不同就是依赖方式了。

baizhu0414 · 2021-05-07T01:47:17Z

我遇到了类似的问题：（已经调整编译环境到buildVersion29）
2021-05-06 19:33:13.231 5150-5239/com.example.testmatisse E/AndroidRuntime: FATAL EXCEPTION: ModernAsyncTask #1
Process: com.example.testmatisse, PID: 5150
java.lang.RuntimeException: An error occurred while executing doInBackground()
at androidx.loader.content.ModernAsyncTask$3.done(ModernAsyncTask.java:164)
at java.util.concurrent.FutureTask.finishCompletion(FutureTask.java:383)
at java.util.concurrent.FutureTask.setException(FutureTask.java:252)
at java.util.concurrent.FutureTask.run(FutureTask.java:271)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641)
at java.lang.Thread.run(Thread.java:919)
Caused by: java.lang.IllegalArgumentException: Invalid column COUNT(*) AS count
at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:170)
at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:140)
at android.content.ContentProviderProxy.query(ContentProviderNative.java:423)
at android.content.ContentResolver.query(ContentResolver.java:946)
at android.content.ContentResolver.query(ContentResolver.java:881)
at androidx.core.content.ContentResolverCompat.query(ContentResolverCompat.java:81)
at androidx.loader.content.CursorLoader.loadInBackground(CursorLoader.java:63)
at com.zhihu.matisse.internal.loader.AlbumLoader.loadInBackground(AlbumLoader.java:97)
at com.zhihu.matisse.internal.loader.AlbumLoader.loadInBackground(AlbumLoader.java:33)
at androidx.loader.content.AsyncTaskLoader.onLoadInBackground(AsyncTaskLoader.java:307)
at androidx.loader.content.AsyncTaskLoader$LoadTask.doInBackground(AsyncTaskLoader.java:60)
at androidx.loader.content.AsyncTaskLoader$LoadTask.doInBackground(AsyncTaskLoader.java:48)
at androidx.loader.content.ModernAsyncTask$2.call(ModernAsyncTask.java:141)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641)
at java.lang.Thread.run(Thread.java:919)

compileSdkVersion 29
defaultConfig { applicationId 'com.example.testmatisse' minSdkVersion 14 targetSdkVersion 29 versionCode 1 versionName "1.0" }

另外，我运行Demo时没有出问题，但是我已经基本保持和Demo一致的环境了，唯一不同就是依赖方式了。

抱歉，我修改到0.5.3-beta后此问题解决。请问为什么没有0.5.3正式版呢？是问题没有彻底解决吗？

DanteAndroid · 2022-11-25T02:18:13Z

有临时解决方案吗？项目用的是源码依赖的方式，没法直接升级……

REBOOTERS added the bug label Sep 4, 2019

Carlos2927 mentioned this issue Oct 3, 2019

能否支持Android 10? NFLeo/Matisse-Kotlin#6

Closed

REBOOTERS mentioned this issue Oct 11, 2019

关于AndroidQ适配的问题 #680

Closed

REBOOTERS mentioned this issue Oct 18, 2019

可以尽快适配一下Android 10 吗？谢谢 #685

Closed

REBOOTERS added a commit that referenced this issue Oct 23, 2019

closes #676, closes #466, closes #167, cloese #602, closes #659, closes

d956453

#646, closes #603, closes #602, closes #667

moodcal pushed a commit to moodcal/Matisse that referenced this issue Mar 7, 2020

closes zhihu#676, closes zhihu#466, closes zhihu#167, cloese zhihu#602,…

3894958

… closes zhihu#659, closes zhihu#646, closes zhihu#603, closes zhihu#602, closes zhihu#667

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

升级到 Android 10,后调用Matisse崩溃 : Invalid column COUNT(*) AS count #659

升级到 Android 10,后调用Matisse崩溃 : Invalid column COUNT(*) AS count #659

JakePrim commented Sep 4, 2019

REBOOTERS commented Sep 4, 2019

vee-zhang commented Sep 5, 2019

yccheok commented Sep 11, 2019 •

edited

Loading

yccheok commented Sep 11, 2019 •

edited

Loading

yccheok commented Sep 11, 2019

JocelynDavid commented Sep 28, 2019

REBOOTERS commented Oct 11, 2019

Jocerly commented Oct 14, 2019

kilo-swodh commented Nov 11, 2019

REBOOTERS commented Nov 11, 2019

kilo-swodh commented Nov 12, 2019

wlong800 commented Nov 14, 2019

wlong800 commented Nov 14, 2019

serreau commented Mar 26, 2020

baizhu0414 commented May 6, 2021 •

edited

Loading

baizhu0414 commented May 7, 2021 •

edited

Loading

DanteAndroid commented Nov 25, 2022

升级到 Android 10,后调用Matisse崩溃 : Invalid column COUNT(*) AS count #659

升级到 Android 10,后调用Matisse崩溃 : Invalid column COUNT(*) AS count #659

Comments

JakePrim commented Sep 4, 2019

REBOOTERS commented Sep 4, 2019

vee-zhang commented Sep 5, 2019

yccheok commented Sep 11, 2019 • edited Loading

yccheok commented Sep 11, 2019 • edited Loading

yccheok commented Sep 11, 2019

JocelynDavid commented Sep 28, 2019

REBOOTERS commented Oct 11, 2019

Jocerly commented Oct 14, 2019

kilo-swodh commented Nov 11, 2019

REBOOTERS commented Nov 11, 2019

kilo-swodh commented Nov 12, 2019

wlong800 commented Nov 14, 2019

wlong800 commented Nov 14, 2019

serreau commented Mar 26, 2020

baizhu0414 commented May 6, 2021 • edited Loading

baizhu0414 commented May 7, 2021 • edited Loading

DanteAndroid commented Nov 25, 2022

yccheok commented Sep 11, 2019 •

edited

Loading

yccheok commented Sep 11, 2019 •

edited

Loading

baizhu0414 commented May 6, 2021 •

edited

Loading

baizhu0414 commented May 7, 2021 •

edited

Loading