API level 29 causes issues with the SQLite implementation

[apcro]

Apparent changes in the way Android API level 29 (Q) handles SQLite query generation and execution is causing issues when the source is compiled using this target.

By way of example:

2020-03-21 11:00:03.761 17691-17691/com.alienpants.leafpicrevived.debug W/System.err: android.database.sqlite.SQLiteException: near "group": syntax error (Sqlite code 1 SQLITE_ERROR): , while compiling: SELECT parent, bucket_display_name, count(*), _data, max(date_modified) FROM files WHERE ((is_pending=0) AND (is_trashed=0) AND (volume_name IN ( 'external_primary' ))) AND ((media_type=? or media_type=?) group by (parent) HAVING (_data NOT LIKE ? )) ORDER BY max(date_modified) DESC, (OS error - 2:No such file or directory)

This appears related to the issue noted (and a resolution provided) here: bilibili/boxing#154, as well as the discussion on this StackOverflow question.

It is likely the process of retrieving albums from the mobile device will need to be rewritten.

[RB4915]

Have you solve this?

[apcro]

No, I have not managed to resolve this issue yet.

[atif42]

@apcro Kindly see this thread if you are having trouble in FilePicker library

https://github.com/jaiselrahman/FilePicker/issues/40

https://github.com/jaiselrahman/FilePicker/releases/tag/1.3.0

[apcro]

Thanks for the links, they've got some interesting information. I'm in the process of tracking down the issue now.

[atif42]

Thanks for the links, they've got some interesting information. I'm in the process of tracking down the issue now.

Welcome :) Best of luck with debugging ! Hope so you'll find soon