Dark Mode

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

android.database.sqlite.SQLiteException: near "GROUP": syntax error in Android 10 #5

Open
Open
android.database.sqlite.SQLiteException: near "GROUP": syntax error in Android 10#5

Description

Hey,

I'm facing a loading gallery image in android 10. The same code is working fine for the below versions. Pls check.

Exception:
android.database.sqlite.SQLiteException: near "GROUP": syntax error (code 1 SQLITE_ERROR): , while compiling:
SELECT _id, bucket_display_name, bucket_id, _id, orientation
FROM images
WHERE ((is_pending=0) AND (is_trashed=0) AND (volume_name IN ( 'external_primary' ))) AND ((1) GROUP BY 1,(2))
ORDER BY date_modified DESC

code written :
Cursor cur = contentResolver.query(Media.EXTERNAL_CONTENT_URI, new String[]{"_id", "bucket_display_name", "bucket_id", "_id", "orientation"}, "1) GROUP BY 1,(2", null, "date_modified DESC");

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions