View Issue Details

IDProjectCategoryView StatusLast Update
0011545MMAGeneralpublic2013-12-05 17:42
Reporterrusty Assigned To 
PriorityimmediateSeveritymajorReproducibilityalways
Status closedResolutionfixed 
Product Version1.0.4 
Target Version1.0.4Fixed in Version1.0.4 
Summary0011545: When browsed in MMW, unplayed tracks show a last played date of 1/1/1970
DescriptionAs described at ticket FVK-203242 , the last-played date for many tracks in MMA displays as 1/1/1970. Ludek explained at 0011524:0038489 that this is because MMA is storing the date based on seconds from 1/1/1970 (default used in unix).
TagsNo tags attached.
Fixed in build191

Relationships

related to 0011511 closedLudek MMW v4 When browsing Android device with MMA, MMW doesn't display play history correctly 
related to 0011524 closedLudek MMW v4 Playlists sync from Android device (with MMA) unnecessarily (over USB) 
related to 0011670 closedLudek MMW v4 Right-click -> Properties on device track => LTP disappears 

Activities

Ludek

2013-12-04 21:55

developer   ~0038491

Last edited: 2013-12-04 22:16

It must be a regression, all tracks synced via USB to MMA have media.last_time_played = null in MMA's DB (mmstore.db).

I veryfied that MMW writes media.last_time_played to mmstore.db.synced correctly, so it must be an issue on MMA side.

Anyhow I fixed the showing on MMW side in build 1673, i.e. values like 01/01/1970, 01/01/2057 for unplayed tracks are ignored and LTP field remains empty for such a tracks

Ludek

2013-12-04 22:21

developer   ~0038492

Last edited: 2013-12-04 23:01

Further testing shown that the problem has a random nature, I can't replicate anymore :-/

The only that I know is that it must be on MMA side, because MMW doesn't write NULL to media.last_time_played

Ludek

2013-12-04 23:31

developer   ~0038493

Last edited: 2013-12-04 23:31

Further testing shown that the values get there via WiFi sync, I WiFi synced several tracks and the vlaues are like 1972, 1994, 1981 etc.

Marek is looking into it.

marek

2013-12-05 00:18

developer   ~0038496

Last edited: 2013-12-05 00:44

Yes weird values are synced over wifi. MMW sets the last time played date for tracks that were not played as 1899-12-30 0:00:00. That is why MMA contained in DB negative values. This was also fixed on MMA side (do not allow negative values)

Example:
<upnp:MM_LastTimePlayed>1899-12-30 00:00:00</upnp:MM_LastTimePlayed>

There was also bug on MMA side: the date was converted to miliseconds instead of seconds. It was fixed in build 191.

marek

2013-12-05 09:57

developer   ~0038501

Btw I have changed all storing of LTP - null value is not used. 0 is stored for tracks that were never played.

marek

2013-12-05 10:25

developer   ~0038502

I am still not able to replicate the issue with USB sync. Please send logs when it occurs.

Ludek

2013-12-05 11:02

developer   ~0038503

Last edited: 2013-12-05 11:03

I am also not able to replicate it anymore, but because it was broken for WiFI sync then there is a probability that it came from there, there were also some others changes on both MMA/MMW sides that should prevent this from happening.

Resolved, to be tested in MMA 192 / MMW 1673

rusty

2013-12-05 17:42

administrator   ~0038514

Verified 191.