0019076: Certain auto-playlists imported from MM4 fails to populate and throws SQL error on sync

ID	Project	Category	View Status	Date Submitted	Last Update

0019076	MMW 5	Playlists	public	2022-05-12 20:19	2022-07-15 16:46

Reporter	Ludek	Assigned To
Priority	urgent	Severity	major	Reproducibility	always
Status	closed	Resolution	reopened
Product Version	5.0
Target Version	5.0.4	Fixed in Version	5.0.4

Summary	0019076: Certain auto-playlists imported from MM4 fails to populate and throws SQL error on sync
Description	User from ticket # 3772 provided a database on which hist auto-playlist _sync > _mobile fails to populate and throws SQL error on syncing. Seems a regression related to issue 0017365 The auto-playlist criteria example on the picture below.
Tags	No tags attached.

Fixed in build	2657

Ludek 2022-05-12 20:20 developer ~0068122	image.png (35,594 bytes) image.png (35,594 bytes)

Ludek 2022-05-12 20:36 developer ~0068123	The key to replicate seems to be combination of [x] Limit to: [...] Selected by: [Sort order] Sort by: Random Album

Ludek 2022-05-12 20:39 developer ~0068124	Fixed in 5.0.3.2625

peke 2022-05-13 20:31 developer ~0068137	Verified 2625

Ludek 2022-07-11 20:51 developer ~0068802 Last edited: 2022-07-12 21:30	Re-opened as this still fails for certain specific auto-playlists, e.g. on user's DB from ticket # 4472 EDIT: It seems still broken for auto-playlists including [x] Limit to: [...] Selected by: [Sort order] Sort by: Rating, Random

Ludek 2022-07-12 21:36 developer ~0068808	Fixed in 2657

peke 2022-07-15 16:46 developer ~0068836	Verified 2657 I also retested 0017365