Music can no longer be found on v3.3.0 onwards

[HeConnor]

Music can no longer be found on v3.3.0 onwards

[OxygenCobalt]

Can't reproduce this on my Android 14 device, let me check if its an accidental regression on Android 10 and below.

[OxygenCobalt]

I can't reproduce the behavior of them acting the same. I think the issue now is that Auxio can't load any music anymore. "Include folders" is a bit of bad naming since it's moreso restricting what music Auxio can find to a particular folder rather than telling Auxio to look for music in that folder.

Can you please try this Debug APK @HeConnor? I need you to take a bug report following these instructions. There are also instructions in Chinese/中文 – 简体, if that helps.

(Forgot to upload APK, one second)

[OxygenCobalt]

Here's the APK I want you to try @HeConnor

Auxio_Canary.zip

[HeConnor]

Hello OxygenCobalt,
1. I used Auxio_Canary.zip on my phone, and return a dump file 2024-01-06_12-52-57_079.hprof..bin.zip, (I can't read instructions, I hope it's helpful for you).
2. I reinstall version 3.2.1, and then set my own music folder path to "include folder", music can be found. But I found "exclude and include folder" are all same my own music folder path (it's same as version 3.3.0, but music can't be found in v3.3.0). You can see my screenshot:

[OxygenCobalt]

Sadly, that file does not help. I'm also having trouble what you are communicating in the second statement.

In this case, if you cannot provide logs @HeConnor, I want you to test these APK files and tell me which ones work and which ones don't:

Auxio_5562c184157c38a1ad2aed3d30388f41f6106c4f.zip
Auxio_673629dd2639537c9e66ca38e8d6d15bd7157797.zip
Auxio_ec8e598d3bedfa7051e12ab1b60a4bb98c0be9bf.zip

This will allow me to narrow down exactly where the app broke.

[HeConnor]

em...
My work flow:

1. install app
2. runing (Grant permissions)
3. set my own music folder path to "include folder" and save setting
4. scan music folder

Only Auxio_5562.. is OK!

[najdshad]

I have the same issue on my Samsung A53 (Android 14, One UI 6.0)

[Richard38907]

Same issue on my OnePlus Nord (PixelExperience - Android 13). V 3.3.0 only too.

[OxygenCobalt]

Alright, here's some more APKs to try @HeConnor @najdshad @Richard38907. Report which ones work.

Auxio_ec8e598.zip
Auxio_d59230b.zip
Auxio_6956ca5.zip

[OxygenCobalt]

If you also can @najdshad @Richard38907, please take a bug report once music loading fails using the instructions here

[Richard38907]

Bug report option is suddenly missing in my developer options. Is it possible to generate it from ADB instead?

[OxygenCobalt]

I think adb bugreport also works @Richard38907. Also, make sure you're doing the bug report when music loading fails in one of the debug builds (like Auxio_Canary.zip).

[Richard38907]

I reproduced the bug on my OnePlus 10t (android 14)

The error is detailed here:

android.database.sqlite.SQLiteException: near "OR": syntax error (code 1 SQLITE_ERROR): , while compiling: SELECT _id, date_added, date_modified, _size, duration, mime_type, title, year, album, album_id, artist, album_artist, _display_name, volume_name, relative_path, cd_track_number, disc_number FROM audio WHERE ((((is_pending=0 AND NOT _modifier=4) OR (is_pending=1 AND lower(_data) NOT REGEXP '.*/.pending-(\d+)-([^/]+)$' AND owner_package_name IN ( 'org.oxycblt.auxio' )))) AND (is_trashed=0) AND (volume_name IN ( 'external_primary' ))) AND (NOT _size=0 AND is_music=1 AND NOT ( OR (volume_name LIKE ? AND relative_path LIKE ?)))
at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:186)
at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:142)
at android.content.ContentProviderProxy.query(ContentProviderNative.java:495)
at android.content.ContentResolver.query(ContentResolver.java:1255)
at android.content.ContentResolver.query(ContentResolver.java:1181)
at android.content.ContentResolver.query(ContentResolver.java:1137)
at org.oxycblt.auxio.music.fs.StorageUtilKt.safeQuery(Unknown Source:6)
at org.oxycblt.auxio.music.fs.MediaStoreExtractorImpl.query(SourceFile:369)
at org.oxycblt.auxio.music.MusicRepositoryImpl$indexImpl$mediaStoreQueryJob$1.invokeSuspend(SourceFile:37)
at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(Unknown Source:8)
at kotlinx.coroutines.DispatchedTask.run(Unknown Source:94)
at androidx.fragment.app.Fragment$4.run(SourceFile:43)
at kotlinx.coroutines.scheduling.TaskImpl.run(Unknown Source:2)
at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.run(SourceFile:92)

[OxygenCobalt]

I think two issues are being reported here. Yours is a logic problem that lead to an error, which is distinct from no music being found at all @Richard38907. I've just fixed the issue. I'd recommend removing all of your music folders for now, as that's the current reason why the music loading is failing.