Stash v0.9.82

⚠️ You only need this update if sync is failing for you

If sync works fine on your current version, there is nothing else in this release — skip it. Update only if you've seen "Sync failed: FOREIGN KEY constraint failed", "Sync failed: too many SQL variables", or playlists syncing as empty shells with cover art but 0 songs.

Hotfix for the sync failures reported this week in #337 — both were regressions introduced by the sync speed-up in v0.9.79.

Fixed

• Sync failed: FOREIGN KEY constraint failed (code 787) — syncing one of your own playlists that contains the same song twice aborted the entire sync run. This is why affected playlists appeared with cover art but 0 songs (the playlist row was created, then its tracks rolled back), and why unchecking your personal playlists made sync work again: Daily Mixes and Liked Songs are de-duplicated by Spotify/YTM, so only user-created playlists triggered it. Duplicate entries in a playlist now resolve to a single local track, matching pre-v0.9.79 behavior. (#357 — thanks @JoshDui, and @ParaliyzedEvo whose #355 arrived at the same fix first)
• Sync failed: too many SQL variables (code 1) — on Android 11 and older, syncing any playlist of roughly 500+ tracks exceeded SQLite's 999-parameter query limit and killed the sync. The batched track lookup now runs in chunks that stay under the limit on every Android version. (#358)

After updating

Playlists that synced as empty shells will fill in on your next sync. If you unchecked playlists under Settings → Sync Preferences while troubleshooting, re-check them. No local files or downloads were lost — every failed sync rolled back cleanly.