leafpicrevived API level 29 causes issues with the SQLite implementation

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: https://github.com/bilibili/boxing/issues/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.

Mar 22 '20 14:03 apcro

Have you solve this?

Jun 22 '20 10:06 RB4915

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

Jun 22 '20 20:06 apcro

@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

Jul 15 '20 06:07 atif42

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

Jul 27 '20 08:07 apcro

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

Jul 28 '20 07:07 atif42