[bug#8715] AutoPlaylists - Sort by Last Played

[nohitter151]

Creating a new auto playlist sorted by the "last played" field actually generates wrong results.
Each entry in the playlist seems to be last played at 01:00am and most of the entries that should be there are missing.

Selecting the entire library node and using the column header to sort it seems to display the expected results.
Please note that many entries are still tagged as last played at 01:00am, don't know if it's correct or what. Actually it seems strange to me.

I attached some screenshots of the issue below.

I'm using Windows 7 x64 and I recently upgraded from version 3.
I'm using the iTunes plugin to sync music and playlists to an iPhone.
Should I attach a debug log?


Screenshots:

[WRONG] Playlist sorted by Last Played Descending:


[CORRECT?] Entire Library, ordered by Last Played using column headers:


Playlist Settings:

[nohitter151]

For me it works fine. What happens if you play a track to completion and refresh your autoplaylist? Does it appear at the top of the list?

[Silver]

No man, it does not! I haven't been wasting my time for posting the above if it was so simple
The two screenshots were taken on the same time and shows completely different results.

[nohitter151]

No man, it does not! I haven't been wasting my time for posting the above if it was so simple
The two screenshots were taken on the same time and shows completely different results.

Well I was trying to rule out whether something with the iTunes plugin might have caused the problem, or if the issue was somehow related to the database upgrade process from MM3 to MM4. But if even now you play a track in MM and it doesn't appear in your auto-playlist, it must be some other problem. But I've set the exact same autoplaylist in my library and everything works fine.

Maybe try to maintain the database file with File > Maintain library > Optimize database (complete).

[Silver]

Already tried, unfortunately with no luck.
I PM you the link to the database file if it can help.

[nohitter151]

Already tried, unfortunately with no luck.
I PM you the link to the database file if it can help.

Sure, send me a PM.

[nohitter151]

Well there's definitely a problem, but I can't see why it happens for your database but not for mine. See the image below:




As you can see the recently played tracks will appear in the playlist but much further down than they should, around the 143 track mark. I'll have to bring your DB to the developers attention, I will keep you updated.

[Silver]

Ok, thank you!

[nohitter151]

FYI the issue is being tracked here:
http://www.ventismedia.com/mantis/view.php?id=8715

To summarize:

The problem is clearly on the DB layer that it doesn't consider 40,1 and 40.1 as equal values when sorting.

Another question is how could the values with the comma get to his DB, with my DB all values have the dot as decimal separator. Maybe a script?

[Silver]

For reference:

I recently started using the iTunes device plugin because MM is not currently compatible with devices running iOS 5.
I downloaded the plugin from this thread: http://www.mediamonkey.com/forum/viewtopic.php?f=2&t=45713.

I've done some testing and I think the issue is related to this plugin when it syncs last played date back from iTunes to MM.

Don't know if it can help but reading here http://www.ventismedia.com/mantis/view.php?id=8715 I noticed you were referring to a locale issue.
I'm using MM in English but my regional settings in Windows is set to "Italian (Italy)". The decimal separator here is comma rather than dot.

[markstuartwalker]

I've PM backed to Silver but will also admit that I think this may be related to my plugin.

I had some issues with some German and Portugese users with the MM3 version. It tracked back to dates being stored in the DB with the wrong decimal separator. Like nohitter I couldn't reproduce the issues as I was EN locale.

I've examined my code and it has various strategies

* It determines the locale separator at startup '.' or ','
* The determined separator is used to control how dates are parsed from DB to make it tolerant to both separators.
* When dates are written to the DB I use the MM locale function to convert the float to the appropriate locale

It has been working this way for many months with no reported problems. The code was ported unchanged from the MM3 to the MM4 variant. Again none of my beta testers reported any issues.

I'm unsure if Silver's experience is related so one-off malfunction or a fault related to the Italian locale. I don't know if I've got any other Italians using the plugin.

I'm happy to help investigate further if needed. Simply PM me.

[markstuartwalker]

Did anything happen about this? I heard nothing more.

[nohitter151]

Did anything happen about this? I heard nothing more.

In the ticket Jiri said he contacted you since it couldn't be resolved on their end.

[markstuartwalker]

Only an email point at http://www.ventismedia.com/mantis/view.php?id=8715

This part of the code is probably over 12 months old and I've have no other users reporting this problem so this is a very isolated case. Has it been demonstrated that the problem is repeatable? I've seen a screen shot showing data that I don't understand but nothing more.

I suggest somebody PMs me so we can look at this issue.

[nohitter151]

Only an email point at http://www.ventismedia.com/mantis/view.php?id=8715

This part of the code is probably over 12 months old and I've have no other users reporting this problem so this is a very isolated case. Has it been demonstrated that the problem is repeatable? I've seen a screen shot showing data that I don't understand but nothing more.

I suggest somebody PMs me so we can look at this issue.

You'd have to ask the user in question. Supposedly the issue only occurs on systems where the windows regional settings have been changed to languages where , is used as a decimal separator.