Bug 2162 - playtime statistics show the least often played tracks
: playtime statistics show the least often played tracks
Status: RESOLVED FIXED
Product: Logitech Media Server
Classification: Unclassified
Component: Database
: 6.2.0
: PC Linux (other)
: P2 minor (vote)
: ---
Assigned To: Dan Sully
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2005-09-21 01:45 UTC by Hakan Tandogan
Modified: 2011-03-16 04:39 UTC (History)
0 users

See Also:
Category: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Hakan Tandogan 2005-09-21 01:45:18 UTC
Hi,

SlimServer SVN 4388 on Gentoo Linux with mysql backend.

The statistics always show the *least* often played tracks. with --d_sql, I see
the query to be "... ORDER BY tracks.playCount LIMIT 50"

While the loop over the returned list is properly reversed, the LIMIT 50 causes
the query to return only the least often played tracks.

chaning the sorting order to "tracks.playCount DESC" and removing the "reverse"
from the list processing should do the right thig but changing 'sortBy' =>
'playCount DESC' in History.pm removed the "ORDER BY" clause completely from the
query...


Regards,
Hakan

Regards,
Hakan
Comment 1 Dan Sully 2005-09-24 16:37:58 UTC
Fixed in subversion change 4423