Re: [SlimDevices: Beta] 7.9 Problems/Bugs

2014-06-24 Thread Michael Herger

I suspect that some of my tagging is causing some compilation albums to
appear multiple times, in some cases an album for each track.


In Album Artists, All Artists or are you using the single configurable 
artists list (Settings/My Music)?



What is the selection criteria for a compilation ? (I thought it would
be files in a folder that all have the same data in the Album tag and
but different data in the Artist tag, and/or Compilation set to 1)


This comes pretty close. I'm sure there are some other corner cases, but 
that's basically it.


But there's not only ARTIST as a tag, there's the ALBUMARTIST as well 
as COMPOSER, CONDUCTOR and BAND tags. You could eg. have an ALBUMARTIST 
of Various Artists, but a different ARTIST for every track. Those 
tracks would create separate items in the All Artists menu.



I suppose that I am asking what tags should be populated for an album
with multiple artists to appear as a single entry in the new
Compilations browse function?


compilation=1 should do it.

--

Michael
___
beta mailing list
beta@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/beta


Re: [SlimDevices: Beta] 7.9 Problems/Bugs

2014-06-24 Thread Wirrunna

mherger wrote: 
 
 In Album Artists, All Artists or are you using the single configurable
 
 artists list (Settings/My Music)?

No, Use two separate lists for Album Artists and All Artists is
selected.

mherger wrote: 
 
  What is the selection criteria for a compilation ? (I thought it
 would
  be files in a folder that all have the same data in the Album tag and
  but different data in the Artist tag, and/or Compilation set to 1)
 
 This comes pretty close. I'm sure there are some other corner cases, but
 
 that's basically it.
 
 But there's not only ARTIST as a tag, there's the ALBUMARTIST as well
 
 as COMPOSER, CONDUCTOR and BAND tags. You could eg. have an ALBUMARTIST
 
 of Various Artists, but a different ARTIST for every track. Those 
 tracks would create separate items in the All Artists menu.

Thank you for that explanation, I can understand that for the All
Artists Menu.

mherger wrote: 
 
  I suppose that I am asking what tags should be populated for an album
  with multiple artists to appear as a single entry in the new
  Compilations browse function?
 
 compilation=1 should do it.

In which case there are some albums that are appearing more than once in
the Compilations.
A clue may be that several tracks have the same artist


+---+
|Filename: hundred1.jpg |
|Download: http://forums.slimdevices.com/attachment.php?attachmentid=16104|
+---+


A camel is a racehorse designed by a committee.

Wirrunna's Profile: http://forums.slimdevices.com/member.php?userid=3225
View this thread: http://forums.slimdevices.com/showthread.php?t=101516

___
beta mailing list
beta@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/beta


Re: [SlimDevices: Beta] 7.9 Problems/Bugs

2014-06-24 Thread Michael Herger

I suppose that I am asking what tags should be populated for an album
with multiple artists to appear as a single entry in the new
Compilations browse function?


compilation=1 should do it.


In which case there are some albums that are appearing more than once in
the Compilations.
A clue may be that several tracks have the same artist


Ok, compilation=1 and identical ALBUMARTIST values (if they do exist) 
are needed. As you show in your screenshots there are several different 
ALBUMARTIST values for different tracks of the same album. That doesn't 
really make sense.


--

Michael
___
beta mailing list
beta@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/beta


Re: [SlimDevices: Beta] LMS 7.9 and DSD

2014-06-24 Thread Caad

Triode wrote: 
 Is this with DoP or with the plugin converting from DSD to PCM.  If the
 latter case I don't understand why the dac would loose lock as the touch
 should be producing standard output (assuming you don't have the EDO
 applet installed?)

Hi , I have the EDO applet installed and are able to play 176 and 192
kHz samples without any problems. I dont have an extra DoP applet
installed for playing these PCM files in to my DAC,,

Br
Caad



Caad's Profile: http://forums.slimdevices.com/member.php?userid=9350
View this thread: http://forums.slimdevices.com/showthread.php?t=101641

___
beta mailing list
beta@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/beta


Re: [SlimDevices: Beta] 7.9 Problems/Bugs

2014-06-24 Thread Wirrunna

mherger wrote: 
 
 Ok, compilation=1 and identical ALBUMARTIST values (if they do exist) 
 are needed. As you show in your screenshots there are several different
 
 ALBUMARTIST values for different tracks of the same album. That doesn't
 
 really make sense.
 Michael

Michael, thank you, and apologies for not putting these questions in the
Beginners forum.
Removing the ALBUMARTIST tags and leaving ARTIST and Compilation=1 gets
compilation albums appearing once only in the Compilations menu.



A camel is a racehorse designed by a committee.

Wirrunna's Profile: http://forums.slimdevices.com/member.php?userid=3225
View this thread: http://forums.slimdevices.com/showthread.php?t=101516

___
beta mailing list
beta@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/beta


Re: [SlimDevices: Beta] 7.9 Problems/Bugs

2014-06-24 Thread JJZolx

Wirrunna wrote: 
 Michael, thank you, and apologies for not putting these questions in the
 Beginners forum.
 Removing the ALBUMARTIST tags and leaving ARTIST and Compilation=1 gets
 compilation albums appearing once only in the Compilations menu.

You _want_ that album to be considered a compilation? I don't understand
that. Is it not an Alison Krauss collection? The way I (and I think most
people) would tag it is:

ALBUMARTIST: Alison Krauss
ARTIST: can be different for each track
COMPILATION:(delete this tag from all tracks)

This way, when you browse albums sorted by artist name, it will appear
sorted under Alison Krauss and appear with her other albums, and the
artist name shown for the album will be 'Alison Krauss' instead of
'Various Artists'.



JJZolx's Profile: http://forums.slimdevices.com/member.php?userid=10
View this thread: http://forums.slimdevices.com/showthread.php?t=101516

___
beta mailing list
beta@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/beta


Re: [SlimDevices: Beta] 7.9 Problems/Bugs

2014-06-24 Thread ralphy

mherger wrote: 
  The perl 5.10 Audio::Scan module for armel is still 0.93
 
  CPAN/arch/5.10/arm-linux-gnueabi-thread-multi/auto/Audio/Scan/Scan.so
 
 Thanks! What hardware are you using?
 -- 
 Michael

ralphy wrote: 
 I compiled it on my Seagate FreeAgent DockStar
 
 Feroceon 88FR131 rev 1 (v5l) - armv5tel

Michael,

Attached is Audio:Scan 0.95 binary module for armel perl 5.10

Thanks,


+---+
|Filename: scan-so-0.95-arm-linux-gnueabi.tar.gz|
|Download: http://forums.slimdevices.com/attachment.php?attachmentid=16107|
+---+


Ralphy

*1*-Touch, *4*-Classics, *2*-Booms, *1*-Reverted UE Radio
'Squeezebox client builds'
(https://www.mediafire.com/folder/4q8dvq20iyz9e/Builds) 'donations'
(https://www.paypal.com/cgi-bin/webscr?cmd=_donationsbusiness=LL5P6365KQEXNlc=CAitem_name=Squeezeslavecurrency_code=USDbn=PP%2dDonationsBF%3abtn_donate_SM%2egif%3aNonHosted)
always appreciated.

ralphy's Profile: http://forums.slimdevices.com/member.php?userid=3484
View this thread: http://forums.slimdevices.com/showthread.php?t=101516

___
beta mailing list
beta@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/beta


Re: [SlimDevices: Beta] 7.9 Problems/Bugs

2014-06-24 Thread Michael Herger

Attached is Audio:Scan 0.95 binary module for armel perl 5.10


Thanks! Did you build from the slimserver-vendors repository?

--

Michael
___
beta mailing list
beta@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/beta


Re: [SlimDevices: Beta] 7.9 Problems/Bugs

2014-06-24 Thread ralphy

mherger wrote: 
  Attached is Audio:Scan 0.95 binary module for armel perl 5.10
 
 Thanks! Did you build from the slimserver-vendors repository?
 
 -- 
 
 Michael

Yes.



Ralphy

*1*-Touch, *4*-Classics, *2*-Booms, *1*-Reverted UE Radio
'Squeezebox client builds'
(https://www.mediafire.com/folder/4q8dvq20iyz9e/Builds) 'donations'
(https://www.paypal.com/cgi-bin/webscr?cmd=_donationsbusiness=LL5P6365KQEXNlc=CAitem_name=Squeezeslavecurrency_code=USDbn=PP%2dDonationsBF%3abtn_donate_SM%2egif%3aNonHosted)
always appreciated.

ralphy's Profile: http://forums.slimdevices.com/member.php?userid=3484
View this thread: http://forums.slimdevices.com/showthread.php?t=101516

___
beta mailing list
beta@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/beta


Re: [SlimDevices: Beta] Scanner/LMS display of the same album by the same artist, different releases

2014-06-24 Thread get.amped

Just in case my initial post was too confusing, it boils down to this:

Should the scanner always treat files in different subdirectories as
different albums, even if the artist and album title are the same?



Win7Pro(x64)[3.3Ghz i5, 8GB RAM, 120GB SSD system, 15TB storage], LMS
7.9.0 - Logitech Squeezebox Classic V.3 - Cambridge Audio DacMagic -
NAD C160 - 2 x NAD C272 - Quad 22L2

get.amped's Profile: http://forums.slimdevices.com/member.php?userid=10022
View this thread: http://forums.slimdevices.com/showthread.php?t=101746

___
beta mailing list
beta@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/beta


Re: [SlimDevices: Beta] LMS 7.9 and DSD

2014-06-24 Thread Triode

Caad wrote: 
 Hi again
 
 I have tested with an other USB/I2S with a DAC board using AK4396
 DACchip, from JLsounds.com. This usb/I2S interface used Xmos chipset and
 the same issue happens here. 
 a more detailed descriptions is that the lock LED for 44k1 samples
 blicks every about 1sec, when receiving DSD64 or DSD128.  (same
 indication as the Amanero USB/I2S)
 
 FYI: The Amanero uses there own programmed CPLD for USB interface.
 
 I have also made a factory reset and reinstalled the EDO applet.. Same
 issue!!
 Br
 CAAD

This is without DoP set on the server?  If so the server is supposed to
resample to the highest rate supported by the player.  In the case of
EDO this would be 192k or 176k.  Can the LMS machine handle the
resampling ok - is there enough cpu power and is the network capable of
handling it. 

I don't currently see why the touch needs resetting if it is not doing
anything other than playing flac files (which is all it should be
doing).  I wonder if the flac version causes a problem.



Triode's Profile: http://forums.slimdevices.com/member.php?userid=17
View this thread: http://forums.slimdevices.com/showthread.php?t=101641

___
beta mailing list
beta@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/beta


Re: [SlimDevices: Beta] LMS 7.9 and DSD

2014-06-24 Thread Triode

JIJ3 wrote: 
 Mine was a week old. I just downloaded the latest. Same result. For some
 reason I can't upload my entire server log, but here is a piece
 
 
 
 
 [14-06-22 18:07:03.6116] Slim::Player::TranscodingHelper::checkBin (232)
 enabled
 [14-06-22 18:07:03.6118] Slim::Player::TranscodingHelper::checkBin (234)
 Found command: [dsdplay] -R hMs:: $START$ $END$ $RESAMPLE$ $FILE$
 [14-06-22 18:07:03.6121]
 Slim::Player::TranscodingHelper::getConvertCommand2 (421) Matched:
 dsf-flc via: [dsdplay] -R hMs:: $START$ $END$ $RESAMPLE$ $FILE$
 [14-06-22 18:07:03.6123] Slim::Player::Song::open (408) Transcoder:
 streamMode=F, streamformat=flc
 [14-06-22 18:07:03.6133]
 Slim::Player::TranscodingHelper::tokenizeConvertCommand2 (546) Using
 command for conversion:
 C:\ProgramData\Squeezebox\Cache\InstalledPlugins\Plugins\PlayDSD\Bin\MSWin32-x86-multi-thread\dsdplay.exe
 -R hMs:: E:\Music\Jazz\Oliver Nelson\The Blues and the Abstract
 Truth\01 - Oliver Nelson - Stolen Moments.dsf |
 [14-06-22 18:07:03.6136] Slim::Player::Song::open (558) Tokenized
 command:
 C:\ProgramData\Squeezebox\Cache\InstalledPlugins\Plugins\PlayDSD\Bin\MSWin32-x86-multi-thread\dsdplay.exe
 -R hMs:: E:\Music\Jazz\Oliver Nelson\The Blues and the Abstract
 Truth\01 - Oliver Nelson - Stolen Moments.dsf |
 [14-06-22 18:07:03.6278] Slim::Player::SongStreamController::new (31)
 live=1
 [14-06-22 18:07:03.6287] Slim::Player::StreamingController::_Stream
 (1277) 00:04:20:22:0b:20: stream
 [14-06-22 18:07:03.6353] Slim::Player::StreamingController::_Stream
 (1314) Song queue is now 3
 [14-06-22 18:07:03.6356]
 Slim::Player::StreamingController::_setPlayingState (2366) new playing
 state BUFFERING
 [14-06-22 18:07:03.6358]
 Slim::Player::StreamingController::_setStreamingState (2375) new
 streaming state STREAMING
 [14-06-22 18:07:03.6361] Slim::Player::StreamingController::_eventAction
 (303) 00:04:20:22:0b:20: NextTrackReady - new state BUFFERING-STREAMING
 [14-06-22 18:07:03.6363] Slim::Player::StreamingController::_eventAction
 (303) 00:04:20:22:0b:20: Play - new state BUFFERING-STREAMING
 [14-06-22 18:07:04.7037] Slim::Player::StreamingController::_eventAction
 (271) 00:04:20:22:0b:20: StatusHeartbeat in BUFFERING-STREAMING -
 Slim::Player::StreamingController::_NoOp
 [14-06-22 18:07:05.1712] Slim::Formats::loadTagFormatForType (110)
 Error: Couldn't load module: Slim::Formats::DSF : [Can't locate
 Slim/Formats/DSF.pm in @INC (@INC contains:
 C:\ProgramData\Squeezebox\Cache\InstalledPlugins\Plugins\SongLyrics\lib
 C:\ProgramData\Squeezebox\Cache\InstalledPlugins
 C:\PROGRA~2\SQUEEZ~1\server\CPAN\arch\5.14\MSWin32-x86-multi-thread
 C:\PROGRA~2\SQUEEZ~1\server\CPAN\arch\5.14\MSWin32-x86-multi-thread\auto
 C:\PROGRA~2\SQUEEZ~1\server\CPAN\arch\5.14.1\MSWin32-x86-multi-thread
 C:\PROGRA~2\SQUEEZ~1\server\CPAN\arch\5.14.1\MSWin32-x86-multi-thread\auto
 C:\PROGRA~2\SQUEEZ~1\server\CPAN\arch\MSWin32-x86-multi-thread
 C:\PROGRA~2\SQUEEZ~1\server\CPAN\arch\5.14
 C:\PROGRA~2\SQUEEZ~1\server\lib C:\PROGRA~2\SQUEEZ~1\server\CPAN
 C:/PROGRA~2/SQUEEZ~1/server
 C:\Users\Jack\AppData\Local\Temp\pdk-Jack-5096\
 C:\PROGRA~2\SQUEEZ~1\server) at (eval 2394) line 2.
 BEGIN failed--compilation aborted at (eval 2394) line 2.
 ]
 [14-06-22 18:07:05.1715] Slim::Formats::loadTagFormatForType (110)
 Backtrace:
 
 frame 0: Slim::Utils::Log::logBacktrace
 (/C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exeSlim/Formats.pm line 110)
 frame 1: Slim::Formats::loadTagFormatForType
 (/C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exeSlim/Player/Protocols/File.pm
 line 405)
 frame 2: Slim::Player::Protocols::File::canSeek
 (/C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exeSlim/Player/Song.pm line
 821)
 frame 3: Slim::Player::Song::canDoSeek
 (/C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exeSlim/Player/Song.pm line
 791)
 frame 4: Slim::Player::Song::canSeek
 (/C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exeSlim/Music/Info.pm line
 1136)
 frame 5: Slim::Music::Info::canSeek
 (/C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exeSlim/Control/Queries.pm
 line 3381)
 frame 6: Slim::Control::Queries::statusQuery
 (/C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exeSlim/Control/Request.pm
 line 1885)
 frame 7: (eval)
 (/C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exeSlim/Control/Request.pm
 line 1885)
 frame 8: Slim::Control::Request::execute
 (/C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exeSlim/Control/Request.pm
 line 2486)
 frame 9: Slim::Control::Request::__autoexecute
 (/C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exeSlim/Utils/Timers.pm line
 266)
 frame 10: (eval)
 (/C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exeSlim/Utils/Timers.pm line
 266)
 frame 11: Slim::Utils::Timers::__ANON__
 (/C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exeSlim/Networking/IO/Select.pm
 line 168)
 frame 12: (eval)
 (/C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exeSlim/Networking/IO/Select.pm
 line 168)
 frame 13: Slim::Networking::IO::Select::loop (slimserver.pl line
 715)
 frame 14: main::idle (slimserver.pl line 63)
 frame 15: PerlSvc::Startup
 

Re: [SlimDevices: Beta] LMS 7.9 and DSD

2014-06-24 Thread JIJ3

Triode wrote: 
 If you try the latest LMS 7.9 version does this work?

The latest version won't even startup on my server! Will wait for the
next nightly



JIJ3's Profile: http://forums.slimdevices.com/member.php?userid=36534
View this thread: http://forums.slimdevices.com/showthread.php?t=101641

___
beta mailing list
beta@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/beta


Re: [SlimDevices: Beta] 7.9 Problems/Bugs

2014-06-24 Thread Mnyb

Mnyb wrote: 
 Yes i did it was huge so i had to zip it to 20mb .
 
 I think i've found a clue to the problem .
 
 Some of the playlist had file paths like:
 
 file:///media/music1/
 
 And other had file paths like:
 
 /media/music1/
 
 A little search and replace and I adjusted all playlist to .
 
 /media/music1/
 
 And now we are down to 43000 files again (but i still want it to be more
 like 42600) :) and improvement of some magnitude :)
 
 This is very strange some of these playlist have have been there for
 years ,unchanged ?

OK is this the expected behaviour of the LMS scanner ?

That :

FILE:///MEDIA/MUSIC1/

And other paths like:

/MEDIA/MUSIC1/

Leading to the same files should make LMS thinks these are files from
different albums ?
As i said my problems are gone when i edited the playlist files ,but it
still does not explain whats changed in LMS to suddenly expose this ?




Main hifi: Touch + CIA PS +MeridianG68J MeridianHD621 MeridianG98DH 2 x
MeridianDSP5200 MeridianDSP5200HC 2 xMeridianDSP3100 +Rel Stadium 3
sub.
Bedroom/Office: Boom
Kitchen: Touch + powered Fostex PM0.4
Misc use: Radio (with battery)
iPad1 with iPengHD  SqueezePad
(in storage SB3, reciever ,controller )
server HP proliant micro server N36L with ClearOS Linux

http://people.xiph.org/~xiphmont/demo/neil-young.html

Mnyb's Profile: http://forums.slimdevices.com/member.php?userid=4143
View this thread: http://forums.slimdevices.com/showthread.php?t=101516

___
beta mailing list
beta@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/beta


Re: [SlimDevices: Beta] 7.9 Problems/Bugs

2014-06-24 Thread Michael Herger

OK is this the expected behaviour of the LMS scanner ?


I would really love to see your db to understand what's going on here... 
Did I ask before?



That :

FILE:///MEDIA/MUSIC1/

And other paths like:

/MEDIA/MUSIC1/

Leading to the same files should make LMS thinks these are files from
different albums ?


They should result in the same values in the DB.


As i said my problems are gone when i edited the playlist files ,but it
still does not explain whats changed in LMS to suddenly expose this ?


What I did change is the way how tracks etc. are counted. In the past we 
used several different ways to access the raw data. As the introduction 
of library_id etc. caused changes in all these places, I tried to 
consolidate how things are done, sharing more code across the 
application. The resulting query might indeed be different (but should 
return the same results, of course).



--

Michael
___
beta mailing list
beta@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/beta


Re: [SlimDevices: Beta] 7.9 Problems/Bugs

2014-06-24 Thread mherger

Mnyb wrote: 
 As i said my problems are gone when i edited the playlist files ,but it
 still does not explain whats changed in LMS to suddenly expose this ?

I have no explanation for the albums count being different yet. But the
titles count does run a different query from before which _potentially_
might result in a different result. Could you please run the following
query on your library.db?


Code:

SELECT tracks.id AS 'tracks.id', tracks.title AS 'tracks.title'
  FROM tracks 
  WHERE (tracks.content_type != cpl AND tracks.content_type != src AND 
tracks.content_type != ssp AND tracks.content_type != dir) AND audio != 1
  



Does it find anything?



Michael

http://www.herger.net/slim-plugins - MusicArtistInfo, MusicInfoSCR,
Smart Mix

mherger's Profile: http://forums.slimdevices.com/member.php?userid=50
View this thread: http://forums.slimdevices.com/showthread.php?t=101516

___
beta mailing list
beta@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/beta


Re: [SlimDevices: Beta] 7.9 Problems/Bugs

2014-06-24 Thread Mnyb

mherger wrote: 
 I have no explanation for the albums count being different yet. But the
 titles count does run a different query from before which _potentially_
 might result in a different result. Could you please run the following
 query on your library.db?
 
  
Code:

  SELECT tracks.id AS 'tracks.id', tracks.title AS 'tracks.title'
   FROM tracks 
   WHERE (tracks.content_type != cpl AND tracks.content_type != src AND 
tracks.content_type != ssp AND tracks.content_type != dir) AND audio != 1
   

  
 
 Does it find anything?

I try to mail  the dB again




Main hifi: Touch + CIA PS +MeridianG68J MeridianHD621 MeridianG98DH 2 x
MeridianDSP5200 MeridianDSP5200HC 2 xMeridianDSP3100 +Rel Stadium 3
sub.
Bedroom/Office: Boom
Kitchen: Touch + powered Fostex PM0.4
Misc use: Radio (with battery)
iPad1 with iPengHD  SqueezePad
(in storage SB3, reciever ,controller )
server HP proliant micro server N36L with ClearOS Linux

http://people.xiph.org/~xiphmont/demo/neil-young.html

Mnyb's Profile: http://forums.slimdevices.com/member.php?userid=4143
View this thread: http://forums.slimdevices.com/showthread.php?t=101516

___
beta mailing list
beta@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/beta


Re: [SlimDevices: Beta] 7.9 Problems/Bugs

2014-06-24 Thread Mnyb

mherger wrote: 
 I have no explanation for the albums count being different yet. But the
 titles count does run a different query from before which _potentially_
 might result in a different result. Could you please run the following
 query on your library.db?
 
  
Code:

  SELECT tracks.id AS 'tracks.id', tracks.title AS 'tracks.title'
   FROM tracks 
   WHERE (tracks.content_type != cpl AND tracks.content_type != src AND 
tracks.content_type != ssp AND tracks.content_type != dir) AND audio != 1
   

  
 
 Does it find anything?

I'll try I have sqlite manager ? i think i've figured how to query (i
dont know any sql language )

This from the old broken dB file


Code:


  608950CDImage
  608961CDImage
  608978CDImage
  608994CDImage
  608999CDImage
  616172Richard Wagner - Das Rheingold - Solti-CD 1
  616189R.Wagner - Das Rheingold - Solti-CD 2
  616206R.Wagner - Die Walkure-Solti-CD 1
  616220R. Wagner - Die Walkure-Solti-CD 2
  616234R.Wagner - Die Walkure-Solti-CD 3
  616241R.Wagner - Die Walkure-Solti -CD 4
  616257R.Wagner - Siegfried-Solti- CD 1
  616274R.Wagner - Siegfried- Solti-CD 2
  616289R.Wagner - Siegfried-Solti- CD 3
  616303R.Wagner - Siegfried-Solti- CD 4
  616316R. Wagner - Gotterdamerung-Solti- CD 1
  616331R.Wagner - Gotterdammerung-Solti- CD 2
  616342R. Wagner - Gotterdammerung -Solti- CD 3
  616358R.Wagner - Gotterdammerung- Solti- CD 4
  623867Prince - For You
  623878Prince - Prince
  623896Prince Controversy 1981
  623936Prince - Parade
  623950Sign O' The Times Disc1
  623961Sign O' The Times Disc2
  623971Prince - Lovesexy (1988)
  623981Prince Batman 1989
  623992Prince Graffiti Bridge 1990
  624020Diamonds And Pearls
  624035Prince - Love Symbol
  624070Track02
  624092Track02
  624112Track02
  624139Classic Metropolitan Orchestra Plays Prince - Diamonds And 
Pearls
  624202The Gold Experience 1995
  624233Emancipation CD1 1996
  624247Emancipation CD2 1996
  624261Emancipation CD3
  624275Track02
  624287Track02
  624300Track02
  624311Track02
  624354Undisputed (Feat. Chuck D)
  624374It's About That Walk
  624386The Rainbow Children
  624428Prince - N.E.W.S. 2003
  624434Prince - Musicology
  624538Track02
  624574Track02
  624600Prince Letitgo maxi-single
  624610The Beautiful Experience maxi-single 1994
  624634Track02
  62983101-va and bill laswell-trojan dub massive chapter 
one-proper-2005
  62985101-va and bill laswell-trojan dub massive chapter 
two-proper-2005
  631914isos 4 cd1
  
  



Same query on the current dB


Code:


  837203CDImage
  837214CDImage
  837231CDImage
  837247CDImage
  837252CDImage
  844423Richard Wagner - Das Rheingold - Solti-CD 1
  80R.Wagner - Das Rheingold - Solti-CD 2
  844457R.Wagner - Die Walkure-Solti-CD 1
  844471R. Wagner - Die Walkure-Solti-CD 2
  844485R.Wagner - Die Walkure-Solti-CD 3
  844492R.Wagner - Die Walkure-Solti -CD 4
  844508R.Wagner - Siegfried-Solti- CD 1
  844525R.Wagner - Siegfried- Solti-CD 2
  844540R.Wagner - Siegfried-Solti- CD 3
  844554R.Wagner - Siegfried-Solti- CD 4
  844567R. Wagner - Gotterdamerung-Solti- CD 1
  844582R.Wagner - Gotterdammerung-Solti- CD 2
  844593R. Wagner - Gotterdammerung -Solti- CD 3
  844609R.Wagner - Gotterdammerung- Solti- CD 4
  852120Prince - For You
  852131Prince - Prince
  852149Prince Controversy 1981
  852189Prince - Parade
  852203Sign O' The Times Disc1
  852214Sign O' The Times Disc2
  852224Prince - Lovesexy (1988)
  852234Prince Batman 1989
  852245Prince Graffiti Bridge 1990
  852273Diamonds And Pearls
  852288Prince - Love Symbol
  852323Track02
  852345Track02
  852365Track02
  852392Classic Metropolitan Orchestra Plays Prince - Diamonds And 
Pearls
  852455The Gold Experience 1995
  852486Emancipation CD1 1996
  852500Emancipation CD2 1996
  852514Emancipation CD3
  852528Track02
  852540Track02
  852553Track02
  852564Track02
  852607Undisputed (Feat. Chuck D)
  852627It's About That Walk
  852639The Rainbow Children
  852681Prince - N.E.W.S. 2003
  852687Prince - Musicology
  852791Track02
  852827Track02
  852853Prince 

Re: [SlimDevices: Beta] 7.9 Problems/Bugs

2014-06-24 Thread Michael Herger
  852827Track02
  852853Prince Letitgo maxi-single
  852863The Beautiful Experience maxi-single 1994
  852887Track02
  85808001-va and bill laswell-trojan dub massive chapter one-proper-2005
  85810001-va and bill laswell-trojan dub massive chapter two-proper-2005
  860163isos 4 cd1
 
 This seems to be some of my known broken items i know i have to fix
 eventually :D

Interesting! Do you happen to know how many of these items there are? This 
might actually explain the difference: the old counting code filtered for 
audio=1, the new query does check for content types. The list you're seeing 
is a list of items which would be counted in the new code, but not in the old. 
It'll be interesting to see what kind of items these are.

Why do you call them broken? What's special about them?
___
beta mailing list
beta@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/beta