[Bug report] SQL syntax error on Android

[po1arbear]

Version

3.8.0

Platforms

Android

Device Model

huawei p30 pro

flutter info

Doctor summary (to see all details, run flutter doctor -v):
[!] Flutter (Channel [user-branch], 3.19.0, on macOS 15.7.1 24G231 darwin-arm64, locale zh-Hans-CN)
    ! Flutter version 3.19.0 on channel [user-branch] at /Users/lingoace/.develop_sdks/flutter
      Currently on an unknown channel. Run `flutter channel` to switch to an official channel.
      If that doesn't fix the issue, reinstall Flutter by following instructions at
      https://flutter.dev/docs/get-started/install.
    ! Upstream repository unknown source is not a standard remote.
      Set environment variable "FLUTTER_GIT_URL" to unknown source to dismiss this error.
[✓] Android toolchain - develop for Android devices (Android SDK version 35.0.0)
[✓] Xcode - develop for iOS and macOS (Xcode 26.0.1)
[✓] Chrome - develop for the web
[✓] Android Studio (version 2022.2)
[✓] Connected device (2 available)
[✓] Network resources

! Doctor found issues in 1 category.

How to reproduce?

Selecting images and videos keeps loading indefinitely, and the following error is reported:
I/flutter ( 9121): [E]: message: {exception : Bad state: Failed to load ., stackTrace: }
I/flutter ( 9121): [E]: message: {error: PlatformException(The getAssetListPaged method has an error: Failed to obtain the cursor., java.lang.RuntimeException: Failed to obtain the cursor.
I/flutter ( 9121): at com.fluttercandies.photo_manager.core.utils.IDBUtils$DefaultImpls.throwMsg(IDBUtils.kt:892)
I/flutter ( 9121): at com.fluttercandies.photo_manager.core.utils.AndroidQDBUtils.throwMsg(AndroidQDBUtils.kt:26)
I/flutter ( 9121): at com.fluttercandies.photo_manager.core.utils.IDBUtils$DefaultImpls.logQuery(IDBUtils.kt:859)
I/flutter ( 9121): at com.fluttercandies.photo_manager.core.utils.AndroidQDBUtils.logQuery(AndroidQDBUtils.kt:26)
I/flutter ( 9121): at com.fluttercandies.photo_manager.core.utils.AndroidQDBUtils.getAssetListPaged(AndroidQDBUtils.kt:164)
I/flutter ( 9121): at com.fluttercandies.photo_manager.core.PhotoManager.getAssetListPaged(PhotoManager.kt:72)
I/flutter ( 9121): at com.fluttercandies.photo_manager.core.PhotoManagerPlugin.handleMethodResult(PhotoManagerPlugin.kt:373)
I/flutter ( 9121): at com.fluttercandies.photo_manager.core.PhotoManagerPlugin.handleOtherMethods$lambda$0(PhotoManagerPlugin.kt:276)
I/flutter ( 9121): at com.fluttercandies.photo_manager.core.Photo

Logs

Example code (optional)

Contact

No response

[fluttercandies-dev]

AI Summary: The app hangs indefinitely while loading images/videos, throwing a "Failed to obtain the cursor" error on a Huawei P30 Pro device.

[Orilx]

Having the same issue on realme X2 (Android 10). The error log is as follows:

======== Exception caught by wechat_assets_picker ==================================================
The following PlatformException was thrown:
PlatformException(The getAssetListRange method has an error: near "descLIMIT": syntax error (code 1 SQLITE_ERROR): , while compiling: SELECT _display_name, _data, _id, title, bucket_id, bucket_display_name, width, height, orientation, date_added, date_modified, mime_type, datetaken, duration, media_type, relative_path FROM files WHERE ((is_pending=0) AND (is_trashed=0) AND (volume_name IN ( 'external_primary' , '26d2-1521' )) AND (invalid=0)) AND (bucket_id IS NOT NULL  AND ( ( ( media_type = ?  AND width >= ? AND width <= ? AND height >= ? AND height <=? ) ) AND ( date_added >= ? AND date_added <= ? )  AND (( media_type = 1 AND width > 0 AND height > 0 ) ) )) ORDER BY _id descLIMIT 1 OFFSET 0, android.database.sqlite.SQLiteException: near "descLIMIT": syntax error (code 1 SQLITE_ERROR): , while compiling: SELECT _display_name, _data, _id, title, bucket_id, bucket_display_name, width, height, orientation, date_added, date_modified, mime_type, datetaken, duration, media_type, relative_path FROM files WHERE ((is_pending=0) AND (is_trashed=0) AND (volume_name IN ( 'external_primary' , '26d2-1521' )) AND (invalid=0)) AND (bucket_id IS NOT NULL  AND ( ( ( media_type = ?  AND width >= ? AND width <= ? AND height >= ? AND height <=? ) ) AND ( date_added >= ? AND date_added <= ? )  AND (( media_type = 1 AND width > 0 AND height > 0 ) ) )) ORDER BY _id descLIMIT 1 OFFSET 0
	at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:184)
	at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:140)
	at android.content.ContentProviderProxy.query(ContentProviderNative.java:423)
	at android.content.ContentResolver.query(ContentResolver.java:963)
	at android.content.ContentResolver.query(ContentResolver.java:898)
	at android.content.ContentResolver.query(ContentResolver.java:854)
	at com.fluttercandies.photo_manager.core.utils.IDBUtils$DefaultImpls.logQuery(IDBUtils.kt:857)
	at com.fluttercandies.photo_manager.core.utils.AndroidQDBUtils.logQuery(AndroidQDBUtils.kt:26)
	at com.fluttercandies.photo_manager.core.utils.AndroidQDBUtils.getAssetListRange(AndroidQDBUtils.kt:207)
	at com.fluttercandies.photo_manager.core.PhotoManager.getAssetListRange(PhotoManager.kt:83)
	at com.fluttercandies.photo_manager.core.PhotoManagerPlugin.handleMethodResult(PhotoManagerPlugin.kt:392)
	at com.fluttercandies.photo_manager.core.PhotoManagerPlugin.handleOtherMethods$lambda$0(PhotoManagerPlugin.kt:276)
	at com.fluttercandies.photo_manager.core.PhotoManagerPlugin.$r8$lambda$qVA-ZeSSSbjRdPryilx_OztJZ0g(Unknown Source:0)
	at com.fluttercandies.photo_manager.core.PhotoManagerPlugin$$ExternalSyntheticLambda1.invoke(D8$$SyntheticClass:0)
	at com.fluttercandies.photo_manager.core.PhotoManagerPlugin$Companion.runOnBackground$lambda$0(PhotoManagerPlugin.kt:44)
	at com.fluttercandies.photo_manager.core.PhotoManagerPlugin$Companion.$r8$lambda$zjM-zNFinK0lWvN-57g47UHqyTo(Unknown Source:0)
	at com.fluttercandies.photo_manager.core.PhotoManagerPlugin$Companion$$ExternalSyntheticLambda0.run(D8$$SyntheticClass:0)
	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)
, {start: 0, end: 1, cancelToken: 7, id: isAll, type: 1, option: {type: 0, child: {image: {duration: {min: 0, allowNullable: false, max: 86400000}, size: {minHeight: 0, maxHeight: 100000, minWidth: 0, maxWidth: 100000, ignoreSize: false}, title: true}, updateDate: {min: 0, max: 1764147459912, ignore: true}, includeHiddenAssets: false, containsLivePhotos: true, containsPathModified: false, orders: [], video: {duration: {min: 0, allowNullable: false, max: 86400000}, size: {minHeight: 0, maxHeight: 100000, minWidth: 0, maxWidth: 100000, ignoreSize: false}, title: false}, audio: {duration: {min: 0, allowNullable: false, max: 86400000}, size: {minHeight: 0, maxHeight: 100000, minWidth: 0, maxWidth: 100000, ignoreSize: false}, title: false}, onlyLivePhotos: false, createDate: {min: 0, max: 1764147459911, ignore: false}}}}, null)

When the exception was thrown, this was the stack: 
#0      StandardMethodCodec.decodeEnvelope (package:flutter/src/services/message_codecs.dart:652:7)
#1      MethodChannel._invokeMethod (package:flutter/src/services/platform_channel.dart:370:18)
<asynchronous suspension>
#2      PhotoManagerPlugin.getAssetListRange (package:photo_manager/src/internal/plugin.dart:240:21)
<asynchronous suspension>
#3      DefaultAssetPickerProvider.getThumbnailFromPath (package:wechat_assets_picker/src/provider/asset_picker_provider.dart:490:40)
<asynchronous suspension>
#4      DefaultAssetPickerProvider.getPaths.<anonymous closure> (package:wechat_assets_picker/src/provider/asset_picker_provider.dart:396:9)
<asynchronous suspension>

rolling back to 3.7.1 works fine

[sj1910]

There is the same problem when using 3.8.0, and it is also a Huawei mobile phone.