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:
--------------------
608950 CDImage
608961 CDImage
608978 CDImage
608994 CDImage
608999 CDImage
616172 Richard Wagner - Das Rheingold - Solti-CD 1
616189 R.Wagner - Das Rheingold - Solti-CD 2
616206 R.Wagner - Die Walkure-Solti-CD 1
616220 R. Wagner - Die Walkure-Solti-CD 2
616234 R.Wagner - Die Walkure-Solti-CD 3
616241 R.Wagner - Die Walkure-Solti -CD 4
616257 R.Wagner - Siegfried-Solti- CD 1
616274 R.Wagner - Siegfried- Solti-CD 2
616289 R.Wagner - Siegfried-Solti- CD 3
616303 R.Wagner - Siegfried-Solti- CD 4
616316 R. Wagner - Gotterdamerung-Solti- CD 1
616331 R.Wagner - Gotterdammerung-Solti- CD 2
616342 R. Wagner - Gotterdammerung -Solti- CD 3
616358 R.Wagner - Gotterdammerung- Solti- CD 4
623867 Prince - For You
623878 Prince - Prince
623896 Prince Controversy 1981
623936 Prince - Parade
623950 Sign O' The Times Disc1
623961 Sign O' The Times Disc2
623971 Prince - Lovesexy (1988)
623981 Prince Batman 1989
623992 Prince Graffiti Bridge 1990
624020 Diamonds And Pearls
624035 Prince - Love Symbol
624070 Track02
624092 Track02
624112 Track02
624139 Classic Metropolitan Orchestra Plays Prince - Diamonds And
Pearls
624202 The Gold Experience 1995
624233 Emancipation CD1 1996
624247 Emancipation CD2 1996
624261 Emancipation CD3
624275 Track02
624287 Track02
624300 Track02
624311 Track02
624354 Undisputed (Feat. Chuck D)
624374 It's About That Walk
624386 The Rainbow Children
624428 Prince - N.E.W.S. 2003
624434 Prince - Musicology
624538 Track02
624574 Track02
624600 Prince Letitgo maxi-single
624610 The Beautiful Experience maxi-single 1994
624634 Track02
629831 01-va and bill laswell-trojan dub massive chapter
one-proper-2005
629851 01-va and bill laswell-trojan dub massive chapter
two-proper-2005
631914 isos 4 cd1
--------------------
Same query on the current dB
Code:
--------------------
837203 CDImage
837214 CDImage
837231 CDImage
837247 CDImage
837252 CDImage
844423 Richard Wagner - Das Rheingold - Solti-CD 1
844440 R.Wagner - Das Rheingold - Solti-CD 2
844457 R.Wagner - Die Walkure-Solti-CD 1
844471 R. Wagner - Die Walkure-Solti-CD 2
844485 R.Wagner - Die Walkure-Solti-CD 3
844492 R.Wagner - Die Walkure-Solti -CD 4
844508 R.Wagner - Siegfried-Solti- CD 1
844525 R.Wagner - Siegfried- Solti-CD 2
844540 R.Wagner - Siegfried-Solti- CD 3
844554 R.Wagner - Siegfried-Solti- CD 4
844567 R. Wagner - Gotterdamerung-Solti- CD 1
844582 R.Wagner - Gotterdammerung-Solti- CD 2
844593 R. Wagner - Gotterdammerung -Solti- CD 3
844609 R.Wagner - Gotterdammerung- Solti- CD 4
852120 Prince - For You
852131 Prince - Prince
852149 Prince Controversy 1981
852189 Prince - Parade
852203 Sign O' The Times Disc1
852214 Sign O' The Times Disc2
852224 Prince - Lovesexy (1988)
852234 Prince Batman 1989
852245 Prince Graffiti Bridge 1990
852273 Diamonds And Pearls
852288 Prince - Love Symbol
852323 Track02
852345 Track02
852365 Track02
852392 Classic Metropolitan Orchestra Plays Prince - Diamonds And
Pearls
852455 The Gold Experience 1995
852486 Emancipation CD1 1996
852500 Emancipation CD2 1996
852514 Emancipation CD3
852528 Track02
852540 Track02
852553 Track02
852564 Track02
852607 Undisputed (Feat. Chuck D)
852627 It's About That Walk
852639 The Rainbow Children
852681 Prince - N.E.W.S. 2003
852687 Prince - Musicology
852791 Track02
852827 Track02
852853 Prince Letitgo maxi-single
852863 The Beautiful Experience maxi-single 1994
852887 Track02
858080 01-va and bill laswell-trojan dub massive chapter
one-proper-2005
858100 01-va and bill laswell-trojan dub massive chapter
two-proper-2005
860163 isos 4 cd1
--------------------
This seems to be some of my known broken items i know i have to fix
eventually :D
--------------------------------------------------------------------
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
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta
