...SELECT DISTINCT to only get album printed once...?
--
tommypeters
SB3--Meridian G68--NuForce Ref8--Bc Acoustique ACT A3
tommypeters's Profile: http://forums.slimdevices.com/member.php?userid=6528
View this thread:
Or, even better,
select distinct contributors.name , albums.title from contributors ,
albums , contributor_album where
contributors.id=contributor_album.contributor and
contributor_album.role=1 and albums.id=contributor_album.album order by
contributors.name, albums.title
... which
Hi
Can anybody tell me the purpose of having the MusicMagic menu in the
server settings? Today I played around with creating a longer mix of
say 30 tracks.
When I change the length of mix number under the;
Home / Server Settings / MusicMagic
I create a mix via the SS web, there is no change
Have you enabled player settings or not?
From the server settings page...
You may choose to give each player access to the musicmagic mix
settings before generating a mix. Any player-chosen settings will
override the server settings and remain, until they are changed again
from the player. If
How about this:
SELECT DISTINCT c.name AS artist, a.title AS album
FROM contributors c, albums a, contributor_album ca
WHERE c.id=ca.contributor AND (ca.role=1 or ca.role=5)
AND a.id=ca.album and (a.compilation IS NULL OR a.compilation=0)
UNION
SELECT DISTINCT 'Various Artists', a.title
FROM
ceejay;151821 Wrote:
Have you enabled player settings or not?
From the server settings page...
You may choose to give each player access to the musicmagic mix
settings before generating a mix. Any player-chosen settings will
override the server settings and remain, until they are changed
Not had any problems since I got it.
Is your network wired or wireless? Mine's running on a 10MBps wired
network and has never dropped out once. Never experienced the remote
being slow either.
What's PC setup is slimserver running etc, any more detail on the
problem as in exactly what is it
azinck3;151715 Wrote:
I've occasionally had this experience with virtually every networked
device I've ever owned. Networking's not trivial and is dependent upon
lots of pieces of the puzzle working properly together.
My thoughts exactly with one addition:
-I've occasionally had this
Along with all these other good suggestions, it took me almost 2 weeks
to get a reliable signal to my squeezebox. I live in an inner city area
and, for some reason or other, I could not get reliable SB3 operation on
the default wireless channel for my region. I ended up on channel 13. It
may end
jku;151843 Wrote:
My thoughts exactly with one addition:
-I've occasionally had this experience with virtually every *wireless*
device I've ever owned. *Wireless* networking's not trivial and is
dependent upon lots of pieces of the puzzle working properly
together.-
Stick to wires if
monkeydust;151850 Wrote:
wireless - so yea I guess this will just happen now and again the pain
is everytime you reset the SB box you have to re-enter network Ids
again - anyway only happened once - overally love this thing!
If you mean by factory resetting the SB, then, yes, you need to
I was all set to reply that this is all very well but I don't set the
compilation tag - however I just checked and of course slimserver does
this for me, based on the various artists logic - so this query works
nicely.
One day I really must learn SQL instead of just hacking at it...
Ceejay
--
One oddity, however, with all of these queries - not of any importance,
I'm just fascinated ...
I ran the query in SQLyog, copied the result to the clipboard using
Excel friendy values for escape characters, and copied into Excel. No
problem at all, looks lovely.
But... one of my album titles
ceejay;151867 Wrote:
But... one of my album titles is True and in the resulting Excel file
it, and it alone, is capitalised and centred - TRUE. I assume this
is due to some part of the process assuming this is a boolean value
instead of a string, though there's no obvious difference in the
Why not just the one menu under each player? So if I had two
slimplayers in different rooms I can have different mixes on them. I
dont get the purpose of the server settings which is just duplication
for no benefit, or is there some special purpose that I'm not
understanding?
Basically,
JJZolx;151870 Wrote:
The default format for Excel cells is 'General' and it does what it can
to figure out the type of data automatically. Change the format to
type 'Text' and this should go away.
Thanks Jim - a quick test suggests that changing the format of the cell
from General to Text
Now that the Transporter isworking its way to the firstowner's hands,lots of people arewaiting to hear about this new piece of hardware:
How does it compare to the SB?
Does it live up to the hype / expectations?
How does 128k compareto 192k, 256k and FLAC? Where is the sweet spot?
Tell us about
Now that the Transporter is working its way to the first owner's hands,
lots of people are waiting to hear about this new piece of hardware:
I think you'd find most stories in the audiophile forum (where most Tx
owners might be active).
How does it compare to the SB?
Great :-). Even my
Michael Herger;151890 Wrote:
... even with some of
my - please forgive me - 128k MP3s...).
--
Michael
-
http://www.herger.net/SlimCD - your SlimServer on a CD
http://www.herger.net/slim - AlbumReview, Biography,
This used to be a config option.
I prefer to have it only rescan at my request (manual rescan).
Or perhaps ever Fri at 2:00am or something like that.
--
BKDotCom
BKDotCom's Profile:
It still is. Plugins/Rescan Music Directory in both 6.5.0 and 6.5.1.
AFAIK.
--
Siduhe
Siduhe's Profile: http://forums.slimdevices.com/member.php?userid=723
View this thread:
Ben Sandee;151743 Wrote:
On 11/1/06, BKDotCom BKDotCom.2gmgtb1162432201 (AT) no-mx (DOT)
forums.slimdevices.com
wrote:
Via Event Viewer:
Carp::Clan::__ANON__(): Error executing 'SELECT COUNT( DISTINCT(
album.id ) ) FROM contributors me LEFT JOIN contributor_album
constant state of sleep deprivation
--
BKDotCom
BKDotCom's Profile: http://forums.slimdevices.com/member.php?userid=15
View this thread: http://forums.slimdevices.com/showthread.php?t=29312
Hi All,
I have been using my SB3 for nearly a year now and it is the BEST
gadget i have bought so far.
I was trying to update my Slimserver SW from ver. 6.2.1 (this is what
came with my SB3) to ver. 6.50.
- Software got installed okay on my PC that acts as a server
- SB3 was firmware updated
How exactly are you doing the search? If I click on Search Music from
the SS web home page, and put Various in the search box, I don't get
Various Artists among my results. Do you? If so, do you have some
albums tagged with Various Artists as the Artist or Album Artist?
Ceejay
--
ceejay
I have ripped my CD collection to my Windows box in my study. There's
about 500GB using Apple lossless. I have a SB3 connected to my stereo
system in my front room, and talking to my 802.11g router in my study.
The sound quality is fine, but the user interface on the SB makes it
very difficult to
I was trying to update my Slimserver SW from ver. 6.2.1 (this is what
came with my SB3) to ver. 6.50.
Please give 6.5.1 a try before we investigate any further. I know, it's
not official yet, but many bugs have already been fixed. I'm currently
using a 6.5.1 from about a week ago and I have
As far as I know it's always 24-bit. My understanding is that RG is
applied using the same algorithm as the regular digital volume control.
--
radish
radish's Profile: http://forums.slimdevices.com/member.php?userid=77
My problem with browsing music folders would not completely go away
despite trying different setting on the server. Eventually, I started
to look at the code and here it was. In Perl module Info.pm there is a
simple test to see if a particular path is a directory or a file. Some
of my directories
I have a Linksys WRT54G v5, I upgraded the firmware as soon as I got it
(twice now) and it has worked perfectly ever since; I have never had
any problems with my wireless SB2 either. I believe most of the bad
comments about version 5 don't apply now.
--
vdorta
DIY computer (EAC/FLAC) --
pfraser;151924 Wrote:
I have ripped my CD collection to my Windows box in my study. There's
about 500GB using Apple lossless. I have a SB3 connected to my stereo
system in my front room, and talking to my 802.11g router in my study.
The sound quality is fine, but the user interface on the SB
vdorta;151936 Wrote:
I have a Linksys WRT54G v5, I upgraded the firmware as soon as I got it
(twice now) and it has worked perfectly ever since; I have never had
any problems with my wireless SB2 either. I believe most of the bad
comments about version 5 don't apply now.
I too have a V.5
saltydog4791;150743 Wrote:
But I am confused. Doesn't browse music folders do just that?
Shouldn't it just be reading what is in the folders, even at the root?
I don't see why altering the DB or doing a rescan should matter. If I
were to drill down thru the directories it would function
You might also want to check out the router notes and comments available
in the Slim Devices wiki:
http://wiki.slimdevices.com/index.cgi?RouterStatus
--
Jeff52
Jeff52's Profile:
I'm using a OneForAll remote which I program with JP1. This remote has
thumbs up and down buttons which would be ideal for LastFM love/ban
functions.
I've seen the thread at
http://forums.slimdevices.com/showthread.php?p=86590
which explains how to modify the .map and .ir files, but I want to
Given that Logitech is:
one of Microsoft´s premier hardware peripherals partner for marketing
Windows Vista-based communications solutions
http://www.logicool.co.jp/index.cfm/news/CA/EN,contentid=12915,crid=34
and with the launch of Vista at the end of this month, I wonder how
plausable it is
The latest WRT54G v5 firmware is 'here'
(http://www.linksys.com/servlet/Satellite?c=L_Download_C2childpagename=US%2FLayoutcid=1115417109974packedargs=sku%3D1127782957298pagename=Linksys%2FCommon%2FVisitorWrapper).
--
vdorta
DIY computer (EAC/FLAC) -- wireless SB2 (Bolder digital analog mods,
Yes, the basic search brings up Various Artists for me. And clicking
the link crashes the server in 7.0, r10536.
http://bugs.slimdevices.com/show_bug.cgi?id=4461
--
JJZolx
Jim
JJZolx's Profile:
azinck3;151938 Wrote:
From what you've said, I imagine you'll be dissatisfied with the speed
of the 770. You should consider slimremote or telcanto for a pocketpc
or similar device. They're free-standing apps so they're much faster
than the web interface on those underpowered devices.
Ah, you're using 7.0 ... you might want to note Dan's observation that
the code is unstable and to hold off doing too many bug reports at the
moment...
http://forums.slimdevices.com/showthread.php?t=29218
Ceejay
--
ceejay
vdorta;151955 Wrote:
The latest WRT54G v5 firmware is 'here'
(http://www.linksys.com/servlet/Satellite?c=L_Download_C2childpagename=US%2FLayoutcid=1115417109974packedargs=sku%3D1127782957298pagename=Linksys%2FCommon%2FVisitorWrapper).
I guess I misunderstood your post. I replaced the Linksys
It's just sound quality what gets harmed - Extenders creators apparently
have different priorities.
If Logitech wants a combo - fine with me as long as it doesn't ruin
current level of SB sound quality. Next step - a dishwasher with
embedded SB?
--
325xi
simaudio nova cdp simaudio moon i-5
6.5.1 Nightlies
I have cue file'd mp3s in my collection...
After a scan this creates empty albums (no tracks) that show up in the
album list (from the source mp3's id3 info)
It also creates contributors without any parent tracks or albums, but
these empty artists (orphans?) don't show up in
Hello all,
I have been a keen user of Slimp3 then SB and now SB2s
and it has completely revolutionised the way we listen to music here
total access to entire collection etc.etc.etc we know all this!
There is another gadget that has had a similar effect
on home entertainment in our
I recently updated my SlimServer to 6.5.0, and there seems to be a
change in one of the menu behaviours.
Previously, if you were on the Now Playing item and hit right arrow,
you arrived at a list of details about the currently playing track. One
of the items in the list was the artist. You could
pfraser;151970 Wrote:
Thanks. I'm ignorant of pocket pc stuff so these questions might be
dumb. The Dell X51V seems reasonable, and is reasonably reviewed. Any
thoughts? Will slimremote or telcanto work on an XP machine? This would
allow me to get an idea of the interface before I commit to
I said the empty artists don't show up. I take that back.
They show up.. and link to the empty albums...
Once i remove the empty albums from the db these associated artists
(while still in the db) don't show up.
--
BKDotCom
There is a bug in 6.5.0 which prevents the Artist being displayed in the
formatted title string in Now Playing if the track has Album Artist and
Track Artist set but Compilation is not set. My guess is that you're
seeing another effect of the same bug. It's supposed to be fixed in
6.5.1 but I
Similar thing is now happening to me after I upgraded to 6.5.0 the other
day - I turn my pc off every night and when I turn it back on again the
next day, my SB won't connect to slimserver automatically. It's a
small but very annoying thing.
I'll upgrade to 6.5.1 and see if it makes any
Just received my transporter 2 days ago, replacing my SB3. Definitely
better, Far better. Soundstage, accuracy, details ( i REALLY discover
NEW sounds even on tunes i used as a tester for my whole HIFI purchases
in the last 10 years).
No doubt: the best price performance High end source
Hi Again,
Tried the recomended version and did the updating on the server side as
well as the update on SB3. Even did a factory reset of SB3 afterwards !
Brgds
/Claus
--
ClausL
ClausL's Profile:
if you set it to anything that slim is not using and go to telnet and
turn listen on it will tell you the full code you need as an unknownir
if you then edit the config for this hex code you should be ok
slimserver does not decode all ir streams so you may need to try a few
hope that helps -
If it doesn't help try disabling the PowerSave plugin (under SlimServer
server settings plugins) and redoing your network setup (Hold the
left button on the remote for 5 seconds to start setup). Those are the
only things I did and it hasn't happened to me in a couple of days.
--
MeSue
Sue
radish;151985 Wrote:
There is a bug in 6.5.0 which prevents the Artist being displayed in the
formatted title string in Now Playing if the track has Album Artist and
Track Artist set but Compilation is not set. My guess is that you're
seeing another effect of the same bug. It's supposed to
An update. I was able to edit the playlist files I have restored from
tape with kedit (Linux editor). So, to try and expedite the problem, I
recreated most of the old playlists in the Slimserver Web interface.
Unfortunately, after a full rescan, all of the playlists appear in
duplicate, but only
Can anyone else play via SlimServer? (i.e. it works via Mplayer):
http://www.barnabasroad.com/WMBI.asx
or what it resolves to:
mms://70.85.184.228/wmbiM007
Here's the stream props - Windows Media Audio V8
20 kbps, 22 kHz, mono
It use to work reliably, something changed, but can't figure it
randybrand;151768 Wrote:
Is it time for more CPU?
You can see if slimserver is stuffering from lack of CPU by turning on
server proformance monitoring and checking the server response time, on
the web interface:
Help
Server and Network Health
enable performance monitoring
Then leave the
Got it working - it seems that the hex codes in the .ir file all start
with 7689. The last 4 hex digits always add up to FF, eg:
76899867 - 98+67=FF
7689f00f - f0+0f=FF
768908f7 - 08+f7=FF
So, with that in mind I set up 3 new entries in the .ir file:
skip=
Richard Scales;151983 Wrote:
It might be interesting to know how many other Slimp3/Squeezebox users
are
also Toppy owners!
Me for one!
It's definitely in the same category as the Squeezebox i.e. if you have
the technical know-how and can be bothered spending time on it then it
will work
cliveb;151999 Wrote:
My files just have the generic ARTIST tag, so I'm guessing that album
artist and track artist are some sort of Slimserver thing, which it
builds when scanning: is that so? (I never use compilation tags, even
on various artist albums).
No - Album Artist is a seperate
That would make sense for the internal data going to the internal DAC
since the designers know it will take 24-bit input.
I would be a bit surprised if the SPDIF output defaulted to 24-bit
since some external DACs only take 16-bit input. I suppose you could
still use those DACs by disabling
Hi all,
I'm thinking of getting a Transporter and have searched the forum as to
whether the description of the digital optical and coaxial inputs can be
changed to a more friendly format on the display, eg. DVD or
Digibox.
If they can then I should be able to convince my wife that we need
one.
Never liked wireless
The ironic thing is that my wireless which was free and made by
Microsoft, of all people has always worked perfectly were as his very
expensive top of the range at the time Linksys is causing me
problems
I have had some experience with using sockets as network
Not right now (as far as I know) but it's been brought up before. There
may well be an enhancement request you can vote for.
--
radish
radish's Profile: http://forums.slimdevices.com/member.php?userid=77
View this thread:
coop250;152046 Wrote:
Hi all,
I'm thinking of getting a Transporter and have searched the forum as to
whether the description of the digital optical and coaxial inputs can be
changed to a more friendly format on the display, eg. DVD or
Digibox.
If they can then I should be able to
Yes they can be changed via editing of a text file in one of the server
subdirectories. Can't remember where at the moment. I have done this -
and for the aame WAF reason - to make mine all read Not Used except
for the optical input which says CD Player. Not surprisingly this is
connected to a
Edit the strings at the end of Plugins/DigitalInput/Plugin.pm
-kdf
___
discuss mailing list
discuss@lists.slimdevices.com
http://lists.slimdevices.com/lists/listinfo/discuss
Hey everyone,
Is there any way to view the stats on the active Transporter digital
input? I'd like to be able to sanity-check whatever is coming in to it
to see what sample/bit rate is being fed to it by my Denon universal
player. I'm thinking of something similar to when you click on the
radish;150794 Wrote:
Ahhh thankyou - I was looking in the wrong place! You're right - it does
come up under Browse in the web interface, not in the settings area as
I was expecting. It also only appears if you have a Transporter selected
as the current player, which is clever but a little
I have been meaning to request these features for some time now, but
didn't. Slimserver 7 would be a good opportunity.
A. Option to automatically traverse folders when playing using 'Browse
Music folder'.
Consider I have music organized in directories by Artist, with each
album by that artist
I dont quite know whats going on either, I am having problems with my
library contents not showing up for certain albums having the
squeezebox crash now and then. Wasnt having any issues at all when i
was using the last software version. Anyone have idea when the next
update is coming out cuz
Hi, I'm running SlimServer 6.5.0 on Win2k3.
This evening, I got home and noticed my SB's screen was dark.
Checked the server and found out it had crashed ... probably after my
scheduled scan, which occurs at 4:00 AM.
I looked in my Application Event log and found the following at 4:26
AM:
anything else scheduled to run at that time?
http://bugs.slimdevices.com/show_bug.cgi?id=4423
-kdf
___
discuss mailing list
discuss@lists.slimdevices.com
http://lists.slimdevices.com/lists/listinfo/discuss
Hi all. I am now the proud owner of a shiny new SB3, all installed and
working fine except for one small problem. When I use AlienBBC or
Internet Radio, the Analog and Digital VUs become very jerky. The
server is running quite happily at 4% CPU, plenty of network bandwidth
is available (Im
kdf;152082 Wrote:
anything else scheduled to run at that time?
http://bugs.slimdevices.com/show_bug.cgi?id=4423
-kdf
Nope, the machine is a dedicated SS box, and I have no other scheduled
processes running against it.
--
jeffluckett
I just happened to be looking at activity monitor under OSX, and noticed
that there were 5-6 instances of lame and flac running, though none of
them appeared to be using any CPU resources. There were no current
connections to slimserver at that particular moment, so I am a bit
confused. I was
Forget about all this smart playlist stuff. How about some friggin'
BASIC playlist management? Slimserver's support for playlist
management is horrible, virtually non-existent.
In the web interface, what I'd like to see is better integration
between the active playlist on the right, and the
emeraldcityeg;152061 Wrote:
Is there any way to view the stats on the active Transporter digital
input? I'd like to be able to sanity-check whatever is coming in to it
to see what sample/bit rate is being fed to it by my Denon universal
player. I'm thinking of something similar to when you
I have a script that drops a daily NPR playlist in my ./playlists folder
and also deletes playlists 7 days old. Now with Slim 6.5, it seems
that deleting the playlist file doesn't purge it from the database.
How can I delete playlists programatically?
Thanks,
-Ed
--
threetwelve72
I use smartplaylists a lot more than standard playlists, but I agree
with you. They really need to improve the web interface. Drag drop
would be a bare minimum, but it seems to be really hard to implement in
a web interface. The Slimserver interface should be as good or better
than the iTunes
Hi,
My squeezebox2 suddenly ceased to function without any reason, nothing
shows up on display. The power supply is working fine. Anyone knows how
to check the malfunction in the circuity? Thanks.
--
jazzy71
jazzy71's
jeffluckett;151973 Wrote:
I guess I misunderstood your post. I replaced the Linksys firmware with
the DD-WRT open-source firmware which gives you a lot more
capabilities.
I see, it's too fancy for me. I just need a wireless router that works
with my SB2, and both are in the same room.
--
I'm trying to get AAC files to play on SB3. I read through the FAQ at
Slim's website, and downloaded LAME 3.97. It's sitting in my desktop
in the form of a .TAR file. How can I unpack this? Is there freeware
for handing these .TAR files?
When I do unpack it, it goes into the
What OS are you running? If it's in a tar you probably have a version
intended for linux (or the source code)...in which case untar will open
it for you. If you're running Windows the usual place to get it is
http://www.rarewares.org/mp3.html, you need the first bundle listed
under 3.97 release,
Would I be right in thinking that you have got some device doing the
EthernetUSB connection at the Toppy end?
I have heard that the next version of the product will be networkable which
would open the door to all sorts of opportunities!
-Original Message-
From: dSw [mailto:[EMAIL
earthbased;150284 Wrote:
I think a cool idea would be for the SB to have a video output so lyrics
and album info/art could be shown on the TV.
Not crazy about the idea unless it doesn't take away from the focus on
the LCD. I bought a squeezebox cuz I didn't want to have to use a TV to
listen
86 matches
Mail list logo
