I had no issues on my end with the album you provided.
Typically this type of issue is caused by insufficient permissions. MPD needs to have read ® permission to the music files and execute (x) permission on all parent directories of the music files. The MPD log can be viewed via moodeutl --mpdlog and will contain permission errors for directories or files it cannot access during database update.
Couple of questions:
1. What format is the drive (NTFS, Fat32, Exfat etc)?
2 How did you copy the files to the drive?
3. What are the permission listed for the "Waltz For Debby [LP SMJ-6118]" album directory and music files?
Code:
# Directory
stat "/media/PATH_TO_Waltz For Debby [LP SMJ-6118]"
# Files
ls -l "/media/PATH_TO_Waltz For Debby [LP SMJ-6118]"
Here's an example using the test album you provided. I copied it to a USB drive.
# Directory
pi@moode9:~ $ stat "/media/VFAT64/Test/Dastinger/Waltz For Debby [LP SMJ-6118]"
File: /media/VFAT64/Test/Dastinger/Waltz For Debby [LP SMJ-6118]
Size: 32768 Blocks: 64 IO Block: 32768 directory
Device: 8,1 Inode: 163 Links: 2
Access: (0755/drwxr-xr-x) Uid: ( 0/ root) Gid: ( 0/ root)
Access: 2024-09-23 20:00:00.000000000 -0400
Modify: 2024-09-24 06:28:56.000000000 -0400
Change: 2024-09-24 06:28:56.000000000 -0400
Birth: 2024-09-24 02:25:21.090000000 -0400
# Files
pi@moode9:~ $ ls -l "/media/VFAT64/Test/Dastinger/Waltz For Debby [LP SMJ-6118]"
total 611744
-rw-r--r-- 1 root root 80050275 Sep 14 16:38 '01 Bill Evans Trio - My Foolish Heart.flac'
-rw-r--r-- 1 root root 110992954 Sep 14 16:38 '02 Bill Evans Trio - Waltz For Debby.flac'
-rw-r--r-- 1 root root 122149206 Sep 14 16:38 '03 Bill Evans Trio - Detour Ahead.flac'
-rw-r--r-- 1 root root 117928299 Sep 14 16:38 '04 Bill Evans Trio - My Romance.flac'
-rw-r--r-- 1 root root 78073910 Sep 14 16:38 '05 Bill Evans Trio - Some Other Time.flac'
-rw-r--r-- 1 root root 116649103 Sep 14 16:38 '06 Bill Evans Trio - Milestones.flac'
-rw-r--r-- 1 root root 493832 Sep 14 16:43 folder.png