Bug 3458 - 6.5 (split-scanner merged) browsing issues
: 6.5 (split-scanner merged) browsing issues
Status: RESOLVED FIXED
Product: Logitech Media Server
Classification: Unclassified
Component: Database
: 6.5b1
: Macintosh All
: P1 normal (vote)
: ---
Assigned To: Dan Sully
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2006-05-26 15:28 UTC by Dan Sully
Modified: 2009-09-08 09:18 UTC (History)
3 users (show)

See Also:
Category: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Dan Sully 2006-05-26 15:28:22 UTC
* First year in Browse->Years is blank, 

* Browse -> Genre -> Artist -> Blank and player locked up. 

* Browse -> New muisc -> Album, press play, nothing played, 

* Browse -> New Music -> Album -> Song, press play, only plays one song. 

* Browse -> Playlists, press play on playlist name, nothing plays, 

* Browse -> Playlists -> Playlist name -> locked up and blank, 

* Browse -> Albums -> Album -> Song, press play, only plays one song. 

* Browse -> Artists -> Artist name, press play, plays nothing. 

* Browse -> Arstists -> artist name -> album, press play, plays nothing. 

10) Browse -> Artists -> artist name -> album -> song, press play plays one song.
Comment 1 Adrian Smith 2006-06-03 04:39:58 UTC
Couple of additions to this:

* sort parameter is not currently used in browse pages

* tracks are not sorted by track number in when browsing contents of an album (should Slim::Schema::ResultSet::Album::descendTrack actually sort the results by track number)

* browse artwork pagebar links to browse album [artwork param needs to be be added to otherparams in same way as sort?]
Comment 2 Dan Sully 2006-06-03 08:31:10 UTC
Yeah, the sort parameter is mucked up - somewhere it thinks it's an array ref, and that gets stringified. I've not managed to track it down yet.

Yes on your other two comments.

From the initial report, the year with empty item is fixed.
Comment 3 Dan Sully 2006-06-09 16:57:00 UTC
Dean - all of your issues should be fixed now, as of change 7863.

Still need to work on Triode's issues.
Comment 4 Adrian Smith 2006-06-10 11:11:15 UTC
Dan, running r7868 and still see a problem with:

Browse -> Artists -> Artist name, press play, plays nothing.

Actually get the following:
2006-06-10 19:03:40.3004 DBD::mysql::st execute failed: Unknown column 'contributor' in 'where clause' at /usr/local/slimserver/CPAN/DBIx/Class/Storage/DBI.pm line 525.
2006-06-10 19:03:40.3012 ERROR: Request: Error when trying to run function coderef: [DBIx::Class::ResultSet::all(): Error executing 'SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.tag, me.disc, me.thumb, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak FROM tracks me WHERE ( contributor = ? ) ORDER BY me.disc, me.tracknum, me.titlesort' (`72'): DBD::mysql::st execute failed: Unknown column 'contributor' in 'where clause' at /usr/local/slimserver/CPAN/DBIx/Class/Storage/DBI.pm line 525.

[looks to be similar issue to bug 3465]
Comment 5 Chris Doherty 2006-06-10 21:23:36 UTC
*** Bug 3467 has been marked as a duplicate of this bug. ***
Comment 6 Dan Sully 2006-06-15 10:35:00 UTC
I believe everything in here is fixed.

Please open new bugs for other specific issues (easier to track).

Thanks.