Playcount metadata

[Bigmack3000]

Quick question. Where is the playcount metadata stored? And is it editable?

My sonos player wasn't working right and gave back some incorrect playcount numbers. I was wondering if I could fix it.

[epoupon]

Hello,
There is a internal tracklist which stores all your listening history (one entry per actual listen, with a timestamp). There is no play count per track.
This is done like this to be able to sync listens with listenbrainz.

[Bigmack3000]

Ah, ok. I had a small issue where if I was casting to my sonos through synfomium, the song would shoot up in playcount. Possibly from 1 to 30 plays. They said it was due to the sonos giving invalid data. But I knew that data is stored on this end. So there's no way for me to fix those counts?

[simonbun]

I saw your post on the Symfonium forum and I'm planning to test my Play 1's tomorrow :-)

If it's safe to do from a database perspective (after stopping the container) then it's not too difficult to do - assuming the logic is to delete all repeated plays.

This is your full listening history:

select a.id,
       a.date_time,
       b.absolute_file_path
  from listen a
         inner join
       track b on (a.track_id = b.id)
  order by a.date_time;

These are the repeated tracks:

with multiplay as (
  select id,
         track_id,
         lag(track_id, 1, 0) over (order by date_time) as prev_track_id
    from listen
)
select * from listen where id in (select id from multiplay where track_id = prev_track_id);

Oh, do you have multiple users in the database?

I've had a quick test and it looks ok, but I'd recommend exporting both and sanity checking first.

[Bigmack3000]

How would i get to this using terminal on a mac?

I'm the only user.

[simonbun]

How would i get to this using terminal on a mac?

Is LMS installed on the mac or another machine? If it's installed on another machine can you SSH to that machine?

sqlite3 is a command line tool available on most platforms, but if you've never used it a GUI (DB Browser for SQLite) may be easier, at least for testing the logic. To use the gui you'll need to download the database (lms.db) to the mac.

Before doing anything with the database, stop the container, make sure that the jounalling files (lms.db-wal and lms.db-shm) have been cleared down (automatically), and take a backup.