Bug 3691 – Final album appears first

Bug 3691 - Final album appears first

Summary:

Final album appears first

Status:	RESOLVED DUPLICATE of bug 3685

Product:	Logitech Media Server
Classification:	Unclassified
Component:	Scanner
Version:	6.5b1
Platform:	PC Windows XP

Importance:	P2 normal with 1 vote (vote)
Target Milestone:	---
Assigned To:	Chris Owens

URL:
Keywords:

Depends on:
Blocks:
	Show dependency tree / graph

Reported:	2006-07-03 15:24 UTC by Christopher Key
Modified:	2008-09-15 14:39 UTC (History)
CC List:	0 users

See Also:
Category:	---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

Description Christopher Key 2006-07-03 15:24:55 UTC

Using SlimServer 6.5 R8268 with iTunes, the last album to be scanned ends up first.  This is because the titlesort and titlesearch are NULL for this album in the database.  The tail of the log file shows that these fields are being set to NULL during the playlist part of the search for tracks without an album.

2006-07-03 23:07:01.6580 Adding file:///D:/iTunes%20Music/Toploader/Magic%20Hotel/11%20She%27s%20Some%20Kind%20of%20Wonderful.m4a : timestamp to 1151022880
2006-07-03 23:07:01.6587 Adding file:///D:/iTunes%20Music/Toploader/Magic%20Hotel/11%20She%27s%20Some%20Kind%20of%20Wonderful.m4a : audio_offset to 0
2006-07-03 23:07:01.6594 Adding file:///D:/iTunes%20Music/Toploader/Magic%20Hotel/11%20She%27s%20Some%20Kind%20of%20Wonderful.m4a : drm to 0
2006-07-03 23:07:01.6602 Adding file:///D:/iTunes%20Music/Toploader/Magic%20Hotel/11%20She%27s%20Some%20Kind%20of%20Wonderful.m4a : titlesearch to SOME KIND OF WONDERFUL
2006-07-03 23:07:01.6609 Adding file:///D:/iTunes%20Music/Toploader/Magic%20Hotel/11%20She%27s%20Some%20Kind%20of%20Wonderful.m4a : disc to 1
2006-07-03 23:07:01.6616 Adding file:///D:/iTunes%20Music/Toploader/Magic%20Hotel/11%20She%27s%20Some%20Kind%20of%20Wonderful.m4a : filesize to 24375531
2006-07-03 23:07:01.6623 Adding file:///D:/iTunes%20Music/Toploader/Magic%20Hotel/11%20She%27s%20Some%20Kind%20of%20Wonderful.m4a : samplerate to 44100
2006-07-03 23:07:01.6631 Adding file:///D:/iTunes%20Music/Toploader/Magic%20Hotel/11%20She%27s%20Some%20Kind%20of%20Wonderful.m4a : bitrate to 1003000
2006-07-03 23:07:01.6732 INSERT INTO tracks (audio, audio_offset, audio_size, bitrate, content_type, disc, drm, filesize, lossless, remote, samplerate, secs, timestamp, title, titlesearch, titleso
rt, tracknum, url, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (`1', `0', `24260820', `1003000', `mov', `1', `0', `24375531', `0', `0', `44100', `193.333', `1151022880',
 `Some Kind of Wonderful', `SOME KIND OF WONDERFUL', `SOME KIND OF WONDERFUL', `11', `file:///D:/iTunes%20Music/Toploader/Magic%20Hotel/11%20She%27s%20Some%20Kind%20of%20Wonderful.m4a', `2002')
2006-07-03 23:07:01.6813 SELECT me.id, me.name, me.namesort, me.namesearch, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable FROM genres me WHERE ( me.name = ? AND me.namesearch = ? AN
D me.namesort = ? ) (`Rock', `ROCK', `ROCK')
2006-07-03 23:07:01.6876 SELECT me.genre, me.track FROM genre_track me WHERE ( me.genre = ? AND me.track = ? ) (`1', `1552')
2006-07-03 23:07:01.6917 INSERT INTO genre_track (genre, track) VALUES (?, ?) (`1', `1552')
2006-07-03 23:07:01.6984 SELECT me.id, me.name, me.namesort, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.namesearch, me.musicbrainz_id FROM contributors me WHERE ( me.musicbra
inz_id IS NULL AND me.name = ? AND me.namesearch = ? AND me.namesort = ? ) (`Toploader', `TOPLOADER', `TOPLOADER')
2006-07-03 23:07:01.7050 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( me.contributor = ? AND me.role = ? AND me.track = ? ) (`143', `1', `1552')
2006-07-03 23:07:01.7094 INSERT INTO contributor_track (contributor, role, track) VALUES (?, ?, ?) (`143', `1', `1552')
2006-07-03 23:07:01.7130 _postCheckAttributes: Same album 'Magic Hotel' than previous track
2006-07-03 23:07:01.7218 SELECT me.role, me.contributor, me.album FROM contributor_album me WHERE ( me.album = ? AND me.contributor = ? AND me.role = ? ) (`90', `143', `1')
2006-07-03 23:07:01.7266 UPDATE tracks SET album = ? WHERE ( id = ? ) (`90', `1552')
2006-07-03 23:07:01.7348 SELECT me.id, me.titlesort, me.contributor, me.compilation, me.year, me.artwork, me.disc, me.discc, me.musicmagic_mixable, me.titlesearch, me.replay_gain, me.replay_peak,
me.musicbrainz_id, me.title FROM albums me WHERE ( ( ( me.id = ? ) ) ) (`90')
2006-07-03 23:07:01.7423 forceCommit: syncing to the database.
2006-07-03 23:07:01.7882 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.a
udio, 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 WHER
E ( content_type IN ( ? ) ) ORDER BY titlesort (`itu')
2006-07-03 23:07:01.7932 forceCommit: syncing to the database.
2006-07-03 23:07:02.3512 Starting playlist folder scan
2006-07-03 23:07:02.3539 SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ) (`lastRescanTime')
2006-07-03 23:07:02.3971 About to look for files in D:\My Playlists
2006-07-03 23:07:02.3997 For files with extensions in: [(?i-xsm:\.(?:asf|wax|asx|lnk|wpl|m3u|pls|xspf|cue|lnk)$)]
2006-07-03 23:07:02.4842 Found 2 files in D:\My Playlists
2006-07-03 23:07:02.4875 m3u file type for file:///D:/My%20Playlists/CUR1350.m3u
2006-07-03 23:07:02.4918 New Playlist for file:///D:/My%20Playlists/CUR1350.m3u
2006-07-03 23:07:02.4928 Adding file:///D:/My%20Playlists/CUR1350.m3u : musicmagic_mixable to 1
2006-07-03 23:07:02.4935 Adding file:///D:/My%20Playlists/CUR1350.m3u : remote to 0
2006-07-03 23:07:02.6530 INSERT INTO tracks (musicmagic_mixable, remote, url) VALUES (?, ?, ?) (`1', `0', `file:///D:/My%20Playlists/CUR1350.m3u')
2006-07-03 23:07:02.6997 Trying to load Slim::Formats::Playlists::M3U
2006-07-03 23:07:02.8058 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.a
udio, 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 WHER
E ( url = ? ) (`http://cur.chu.cam.ac.uk:1863/cur.ogg')
2006-07-03 23:07:02.8154 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.a
udio, 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 WHER
E ( url = ? ) (`http://cur.chu.cam.ac.uk:1863/cur.ogg')
2006-07-03 23:07:02.8192 New Track for http://cur.chu.cam.ac.uk:1863/cur.ogg
2006-07-03 23:07:02.8199 readTag was 1 for http://cur.chu.cam.ac.uk:1863/cur.ogg
2006-07-03 23:07:02.8206 reading tags for: http://cur.chu.cam.ac.uk:1863/cur.ogg
2006-07-03 23:07:02.8215 ogg file type for http://cur.chu.cam.ac.uk:1863/cur.ogg
2006-07-03 23:07:02.8223 Info: no title found, calculating title from url for http://cur.chu.cam.ac.uk:1863/cur.ogg
2006-07-03 23:07:02.8230 Plain title for: http://cur.chu.cam.ac.uk:1863/cur.ogg
2006-07-03 23:07:02.8237  is http://cur.chu.cam.ac.uk:1863/cur.ogg
2006-07-03 23:07:02.8252 Adding http://cur.chu.cam.ac.uk:1863/cur.ogg : content_type to ogg
2006-07-03 23:07:02.8260 Adding http://cur.chu.cam.ac.uk:1863/cur.ogg : remote to 1
2006-07-03 23:07:02.8266 Adding http://cur.chu.cam.ac.uk:1863/cur.ogg : titlesearch to CUR1350
2006-07-03 23:07:02.8273 Adding http://cur.chu.cam.ac.uk:1863/cur.ogg : titlesort to CUR1350
2006-07-03 23:07:02.8281 Adding http://cur.chu.cam.ac.uk:1863/cur.ogg : title to  CUR1350
2006-07-03 23:07:02.8343 INSERT INTO tracks (content_type, remote, title, titlesearch, titlesort, url) VALUES (?, ?, ?, ?, ?, ?) (`ogg', `1', ` CUR1350', `CUR1350', `CUR1350', `http://cur.chu.cam.
ac.uk:1863/cur.ogg')
2006-07-03 23:07:02.8446 UPDATE albums SET compilation = ?, titlesearch = ?, titlesort = ? WHERE ( id = ? ) (`NULL', `NULL', `NULL', `90')
2006-07-03 23:07:02.8491 UPDATE tracks SET album = ? WHERE ( id = ? ) (`90', `1554')
2006-07-03 23:07:02.8508 DELETE FROM playlist_track WHERE ( playlist = ? ) (`1553')
2006-07-03 23:07:03.0273 INSERT INTO playlist_track (playlist, position, track) VALUES (?, ?, ?) (`1553', `0', `1554')
2006-07-03 23:07:03.1482 m3u file type for file:///D:/My%20Playlists/Magic.m3u
2006-07-03 23:07:03.1526 New Playlist for file:///D:/My%20Playlists/Magic.m3u
2006-07-03 23:07:03.1535 Adding file:///D:/My%20Playlists/Magic.m3u : musicmagic_mixable to 1
2006-07-03 23:07:03.1542 Adding file:///D:/My%20Playlists/Magic.m3u : remote to 0
2006-07-03 23:07:03.1925 New Track for mms://earth.radica.com/magic32kbit?WMReconnect=3
2006-07-03 23:07:03.1932 readTag was 1 for mms://earth.radica.com/magic32kbit?WMReconnect=3
2006-07-03 23:07:03.1939 reading tags for: mms://earth.radica.com/magic32kbit?WMReconnect=3
2006-07-03 23:07:03.1947 mms file type for mms://earth.radica.com/magic32kbit?WMReconnect=3
2006-07-03 23:07:03.1954 Info: no title found, calculating title from url for mms://earth.radica.com/magic32kbit?WMReconnect=3
2006-07-03 23:07:03.1961 Plain title for: mms://earth.radica.com/magic32kbit?WMReconnect=3
2006-07-03 23:07:03.1969  is mms://earth.radica.com/magic32kbit?WMReconnect=3
2006-07-03 23:07:03.1983 Adding mms://earth.radica.com/magic32kbit?WMReconnect=3 : content_type to mms
2006-07-03 23:07:03.1991 Adding mms://earth.radica.com/magic32kbit?WMReconnect=3 : remote to 1
2006-07-03 23:07:03.1998 Adding mms://earth.radica.com/magic32kbit?WMReconnect=3 : titlesearch to MAGIC
2006-07-03 23:07:03.2005 Adding mms://earth.radica.com/magic32kbit?WMReconnect=3 : titlesort to MAGIC
2006-07-03 23:07:03.2013 Adding mms://earth.radica.com/magic32kbit?WMReconnect=3 : title to  Magic
2006-07-03 23:07:03.2424 finished background scan of playlist folder.
2006-07-03 23:07:03.6477 forceCommit: syncing to the database.

Comment 1 Chris Owens 2006-07-06 10:05:49 UTC

Okay, so it looks like you also have musicmagic/moodlogic going.

But forgive me, my brain might not be working yet this morning:  The album appears first WHERE?

Comment 2 Christopher Key 2006-07-06 10:17:17 UTC

(In reply to comment #1)
> Okay, so it looks like you also have musicmagic/moodlogic going.
> But forgive me, my brain might not be working yet this morning:  The album
> appears first WHERE?

It appeared first in any alphabetic listing, as the NULL value for title_sort was being placed before everything else.  Having looked again, this appears to be a duplicate of bug 3685, which was fixed in R8291.

*** This bug has been marked as a duplicate of 3685 ***