0013082: USB sync failure to android device when a default auto-playlist was synced prior to MMA install (regression in MMA 1.1.3)

ID	Project	Category	View Status	Date Submitted	Last Update

0013082	MMW v4	Synchronization	public	2016-01-20 21:29	2016-01-21 13:33

Reporter	Ludek	Assigned To
Priority	immediate	Severity	minor	Reproducibility	always
Status	closed	Resolution	fixed
Product Version	4.1
Target Version	4.1.11	Fixed in Version	4.1.11

Summary	0013082: USB sync failure to android device when a default auto-playlist was synced prior to MMA install (regression in MMA 1.1.3)
Description	We added empty playlist GUID handling in cource of fixing MMA's issue 0012983 which has a side effect: 1) Fresh MMW install with newly created MM.DB 1) Sync default auto-playlists prior to MMA install to device 2) Install MMA 3) Perform USB sync => SQL error on mmstore.db UPDATE Playlists SET _data = '/storage/sdcard1/Playlists/Last 50 played.m3u' WHERE _id = 1" : constraint failed (19, 19) This is because the default auto-playlists doesn't have GUID assigned in MMW (when new MM.DB is created) and MMW finds another playlist according to empty GUID resulting in the constraint failure (because it wants to assign path '/storage/sdcard1/Playlists/Last 50 played.m3u' to another playlist with empty GUID in mmstore.db) Originally found by Peke here: 0013081
Tags	No tags attached.

Fixed in build	1780

child of	0013081	closed	marek	MMA	Crashes arter WiFi Sync that only paired tracks
child of	0012983	closed	Ludek	MMA	Playlists synced prior to MMA install result in duplicates after WiFi sync