⚠️ 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.