Syncing iPhone doesn't update Last Played [#18673]

Post a reply

Smilies
:D :) :( :o :-? 8) :lol: :x :P :oops: :cry: :evil: :roll: :wink:

BBCode is ON
[img] is ON
[url] is ON
Smilies are ON

Topic review
   

Expand view Topic review: Syncing iPhone doesn't update Last Played [#18673]

Re: Syncing iPhone doesn't update Last Played [#18673]

by sail2fast » Sun Apr 07, 2024 2:58 pm

Note that the previous workaround of setting 'play_count_recent' to 1 is no longer working. I haven't figured out any way to get 'Last Played' or 'play count' to sync from the iphone to media monkey database

Re: Syncing iPhone doesn't update Last Played [#18673]

by sail2fast » Fri Apr 05, 2024 9:22 pm

I just got caught out on this bug again. Any chance of getting it fixed?

Thanks!

Re: Syncing iPhone doesn't update Last Played [#18673]

by Ludek » Tue Dec 14, 2021 3:58 pm

Great! ;-)

Re: Syncing iPhone doesn't update Last Played [#18673]

by sail2fast » Tue Dec 14, 2021 3:50 pm

Happy news: I was able to use DB Browser to force the 'play_count_recent=1' for all the songs on my iphone that had a 'last_played' date. Then I re-synced in MMW5 and all the played# and 'last_played' were correctly updated. (and AnyTrans to move the MediaLibrary.sqlitedb file back and forth). This workaround saved me a lot of lost data towards a playlist I'm working on.

Thanks for all your assistance.

Re: Syncing iPhone doesn't update Last Played

by Ludek » Tue Dec 14, 2021 3:36 pm

Actually seeing that MediaLibrary.sqlitedb can potentially get out of sync with iTunesCDB this way (because of cleared 'play_count_recent' value).

I guess I will have to change the mechanism to rather always take the 'play_count_user' value and always use this value also when viewing the tracks in MM5 interface (Devices & Services > iPod > Music list)

Also seeing that MM5 already remembers the inital played# value synced to the device, so I could always use the 'play_count_user' and decrease it by the initial played# value when the track was synced from MM5 > iPod and update both the values after the sync.

i.e.
1) during MM5 > iPod sync use:
played_value_when_track_was_synced_to_iPhone = MM5.track.play_count

2) during iPod > MM5 sync use:
MM5.track.play_count = MM5.track.play_count + (iPod.play_count_user - played_value_when_track_was_synced_to_iPhone)
played_value_when_track_was_synced_to_iPhone = iPod.play_count_user;

Entered as: https://www.ventismedia.com/mantis/view.php?id=18673

EDIT: As for the current workaround: Yes, bulk increasing the 'play_count_recent' is possible, you can use iMazing app to download the MediaLibrary.sqlite from the iPhone and then open it in SQLite studio and update the 'play_count_recent' by SQL query like:

Code: Select all

UPDATE item_stats SET play_count_recent = 1 WHERE play_count_user > 0

Re: Syncing iPhone doesn't update Last Played

by sail2fast » Tue Dec 14, 2021 3:18 pm

Thanks, that is very helpful. I did cancel an auto-sync, so perhaps the 'play_count_recent' was reset but the other values were undone during the cancel.

Is there any easy way I can increment 'play_count_recent' to force an update of last_played or otherwise get these to update?

Re: Syncing iPhone doesn't update Last Played

by Ludek » Tue Dec 14, 2021 3:08 pm

Checking it now and MM5 is reading the Played# value from MediaLibrary.sqlitedb file on the iPhone.

Table 'item_stats' and column 'play_count_recent', during sync it increases the value in MM5 by the 'play_count_recent' value.

There is also column 'play_count_user' and this is where probably the "Song stats" takes the values, see:
https://www.dropbox.com/s/y3mxzyuf65re7 ... 4.png?dl=0

'play_count_recent' is cleared after the Played# is synced with MM5.
So that's explains the difference.

i.e. another app (or another MM instance) could already pick up the 'play_count_recent' value and clear it.

Re: Syncing iPhone doesn't update Last Played

by sail2fast » Tue Dec 14, 2021 2:55 pm

Also: all the songs played have been after the upgrade to MM5 and OS 15.

Re: Syncing iPhone doesn't update Last Played

by sail2fast » Tue Dec 14, 2021 2:54 pm

More info: Syncing the phone to MMW does not update "last played" in the MMW library unless the "played count" is non zero. I played a few songs just now for testing--the "played #" correctly increments and the 'last played' is correctly updated.

However, most songs that have been played (except a couple I just played in testing) show a played # = 0 in MMW. I installed an application on my iphone ("Song Stats")--this application correctly shows the actual played count and last played for all the songs on the iphone.

So Media Monkey is not retrieving the played # from the same location as the iPhone application "Song Stats".
And MMW is apparently not syncing "last played" if it (incorrectly) thinks the 'played #' is 0.

Re: Syncing iPhone doesn't update Last Played

by Ludek » Tue Dec 14, 2021 2:06 pm

Note that I can see the correct "Last Played" date when I view the Music list of the Iphone within MMW.
If you are seeing them in MMW then I guess that _syncing_ the device does update the playcount/lastplayed/rating in MMW, isn't it?

Re: Syncing iPhone doesn't update Last Played

by Lowlander » Tue Dec 14, 2021 1:49 pm

Is there a pattern to those that do have correct Last Played? Could they have been played before or after iOS 15 or MediaMonkey updates?

Syncing iPhone doesn't update Last Played [#18673]

by sail2fast » Tue Dec 14, 2021 1:14 pm

MMW 5.0.2. 2526 with Iphone 6s running OS 15. When I sync the phone, "Last Played" is not synced. Actually, a couple played songs have the correct "Last Played", but hundreds of other songs are not updated in MMW.

Note that I can see the correct "Last Played" date when I view the Music list of the Iphone within MMW.

BTW, I notice that most of the played songs on the Iphone show a correct "Last Played" date, but "Played #" = 0. The few songs that updated the played # in MMW do have a positive "Played #".

Syncing Last Played is very important for me--this broke recently upon upgrading the iPhone to OS15...

Top