Re: [SlimDevices: Plugins] SQL Query usage in Database query plugin

2022-02-02 Thread Michael Herger

WHERE ( id IN ( SELECT me.album FROM tracks me WHERE ( (

...

/lms/Slim/Schema/Storage.pm line 125 , ambiguous column name: id


This time you'll have to specify what table's ID you refer to here. I 
guess that would be "me.id".

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


Re: [SlimDevices: Plugins] Starting Spotty Playlist via Node Red

2022-02-02 Thread Michael Herger

i'm trying to figure out the command syntax under the squeezebox node in
node red. Currently I have it set to play a track via this
"play,spotify:track:3Kkjo3cT83cw09VJyrLNwX" but it only plays on my LMS
server. I have 3 other squeezeboxs around the house, what is the command
to designate the track or playlist to be played on another player?


You need to be able to tell Node which player you want to control. I 
don't know what you mean by "plays on my LMS", as LMS isn't a player.

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


Re: [SlimDevices: Plugins] SQL Query usage in Database query plugin

2022-02-02 Thread mamema


this:

SELECT contributors.name, 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.extid, me.title
FROM albums me JOIN contributors ON contributors.id = me.contributor
WHERE ( id IN ( SELECT me.album FROM tracks me WHERE ( (
me.audio = 1 AND me.year = 2010 AND samplesize = 16 ) ) GROUP BY me.id )
)
ORDER BY me.disc, me.titlesort COLLATE de_DE LIMIT 1001

leads to:

Error: Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db prepare
failed: ambiguous column name: id [for Statement " SELECT
contributors.name, 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.extid, me.title FROM albums me JOIN contributors ON contributors.id =
me.contributor WHERE ( id IN ( SELECT me.album FROM tracks me WHERE ( (
me.audio = 1 AND me.year = 2010 AND samplesize = 16 ) ) GROUP BY me.id )
) ORDER BY me.disc, me.titlesort COLLATE de_DE LIMIT 1001 "] at
/lms/Slim/Schema/Storage.pm line 125 , ambiguous column name: id



mamema's Profile: http://forums.slimdevices.com/member.php?userid=44662
View this thread: http://forums.slimdevices.com/showthread.php?t=115686

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


Re: [SlimDevices: Plugins] Starting Spotty Playlist via Node Red

2022-02-02 Thread anacomm


i'm trying to figure out the command syntax under the squeezebox node in
node red. Currently I have it set to play a track via this
"play,spotify:track:3Kkjo3cT83cw09VJyrLNwX" but it only plays on my LMS
server. I have 3 other squeezeboxs around the house, what is the command
to designate the track or playlist to be played on another player?



anacomm's Profile: http://forums.slimdevices.com/member.php?userid=72549
View this thread: http://forums.slimdevices.com/showthread.php?t=115687

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


Re: [SlimDevices: Plugins] Alternatives to spotify / spotty?

2022-02-02 Thread slartibartfast


Jaca wrote: 
> I have only run 2 different tracks so not in depth but I would probably
> share your conclusions. On one of them TIDAL was quieter but on other it
> was louder. 
> My settings with -5 for remote streams ..  Signal going from Touch (100%
> volume) thru Focusrite audio interface to DAW.
> 
> 
> Chic Corea - 500 miles hight
> 37105 
> 
> 
> Snarky Puppy - Bent Nails 
> 37106Of course we don't know if volume normalisation is available for Tidal
via LMS. Maybe @mherger can tell us more. It looks as though it isn't on
by default explaining why The Wall is so quiet.

Sent from my Pixel 3a using Tapatalk





slartibartfast's Profile: http://forums.slimdevices.com/member.php?userid=35609
View this thread: http://forums.slimdevices.com/showthread.php?t=115850

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


Re: [SlimDevices: Plugins] Alternatives to spotify / spotty?

2022-02-02 Thread Jaca


slartibartfast wrote: 
> I tried a few more tracks and now it seems albums with a low replaygain
> adjustment (The Wall has an Album Gain of -1.69dB) seem to be noticeably
> quieter on Tidal. I tried "Flaming Lips - At War With the Mystics" which
> has an Album Gain of -11.07dB and Tidal wasn't obviously quieter.
> My settings were "Album Gain" and Default Adjustment for Remote Streams
> -7. So I guess if the Default Adjustment was -5 the Flaming Lips could
> have been louder while Pink Floyd would still have been quieter. 
> Whatever Tidal are using for Volume Normalisation isn't working. I found
> this which implies they are meant to be using some kind of album gain.
> https://productionadvice.co.uk/tidal-normalization-upgrade/
> 
> 
> Sent from my Pixel 3a using Tapatalk

I have only run 2 different tracks so not in depth but I would probably
share your conclusions. On one of them TIDAL was quieter but on other it
was louder. 
My settings with -5 for remote streams ..  Signal going from Touch (100%
volume) thru Focusrite audio interface to DAW.


Chic Corea - 500 miles hight
37105 


Snarky Puppy - Bent Nails 
37106


+---+
|Filename: bent nails.JPG   |
|Download: http://forums.slimdevices.com/attachment.php?attachmentid=37106|
+---+


3x Squeezebox Touch, 4x Squeezebox Radio, Squeezelite (RPi 3B with
HiFiBerry DAC+Pro on OSMC), Material Skin Apk, Squeeze Commander,
Logitech Media Server Version: 8.2.0 with Material Skin (Docker in
DS218+)

Jaca's Profile: http://forums.slimdevices.com/member.php?userid=58187
View this thread: http://forums.slimdevices.com/showthread.php?t=115850

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


Re: [SlimDevices: Plugins] Alternatives to spotify / spotty?

2022-02-02 Thread slartibartfast


Jaca wrote: 
> Will try bit laterI tried a few more tracks and now it seems albums with a 
> low replaygain
adjustment (The Wall has an Album Gain of -1.69dB) seem to be noticeably
quieter on Tidal. I tried "Flaming Lips - At War With the Mystics" which
has an Album Gain of -11.07dB and Tidal wasn't obviously quieter.
My settings were "Album Gain" and Default Adjustment for Remote Streams
-7. So I guess if the Default Adjustment was -5 the Flaming Lips could
have been louder while Pink Floyd would still have been quieter. 
Whatever Tidal are using for Volume Normalisation isn't working. I found
this which implies they are meant to be using some kind of album gain.
https://productionadvice.co.uk/tidal-normalization-upgrade/


Sent from my Pixel 3a using Tapatalk





slartibartfast's Profile: http://forums.slimdevices.com/member.php?userid=35609
View this thread: http://forums.slimdevices.com/showthread.php?t=115850

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


Re: [SlimDevices: Plugins] announce: ShairTunes2W - Airtunes on LMS (forked version with Windows support)

2022-02-02 Thread AndrewJs

superstar19 wrote: 
> Noticing that none of my other household devices have any issues getting
> spotted by the iPhones for airplay mode. It just seems to be the Touch,
> Radio and SB which are all the oldest devices in the house that I'm
> trying to connect. Wondering if there was a change in iOS/airplay which
> is preventing these older devices from being found. Anybody else having
> trouble with a Tourch/Radio/Squeezebox and AirPlay?

I’ve been having issues with some squeezelite players using 2.4ghz Wi-Fi
band. The connections have not been stable and so would sometimes appear
and be able to connect with airplay briefly or not appear at all. This
has been caused by my router ASUS zenwifi XT8. I’ve had to roll back to
older firmware 42095 for the connections issues to go away. This is only
when connecting to the second node which is connected via wireless
backhaul. 

I have also seen reports of older touch devices having connection issues
potentially due to Wi-Fi6 routers / mesh networks when I was
investigating my issue. Not sure if it help but could be an avenue to
explore?



AndrewJs's Profile: http://forums.slimdevices.com/member.php?userid=70580
View this thread: http://forums.slimdevices.com/showthread.php?t=106289

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


Re: [SlimDevices: Plugins] Alternatives to spotify / spotty?

2022-02-02 Thread Jaca


whitman wrote: 
> Curious to know how you got nested folders anywhere in Spy.I mean in 
> official Spotify you can create folder in playlists and then
another folder with this folder..
This was reflected in spotty with token trick described on spotty
settings page
.
Weirdly I lost folder structure on my LMS.. 
Maybe cos I have cancelled premium already or  maybe token expired hmm.
It sure



3x Squeezebox Touch, 4x Squeezebox Radio, Squeezelite (RPi 3B with
HiFiBerry DAC+Pro on OSMC), Material Skin Apk, Squeeze Commander,
Logitech Media Server Version: 8.2.0 with Material Skin (Docker in
DS218+)

Jaca's Profile: http://forums.slimdevices.com/member.php?userid=58187
View this thread: http://forums.slimdevices.com/showthread.php?t=115850

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


Re: [SlimDevices: Plugins] Alternatives to spotify / spotty?

2022-02-02 Thread Jaca


slartibartfast wrote: 
> Try playing a local track and compare to the same track on Tidal, I used
> Pink Floyd - The Wall. For me Tidal was much quieter. If it isn't on
> yours that is very strange. I even tried changing the normalisation
> setting in the Tidal phone app, it made no difference. I might record
> the waveforms from Squeezeplay using Audacity to show the volume
> difference.
> 
> Sent from my Pixel 3a using TapatalkWill try bit later



3x Squeezebox Touch, 4x Squeezebox Radio, Squeezelite (RPi 3B with
HiFiBerry DAC+Pro on OSMC), Material Skin Apk, Squeeze Commander,
Logitech Media Server Version: 8.2.0 with Material Skin (Docker in
DS218+)

Jaca's Profile: http://forums.slimdevices.com/member.php?userid=58187
View this thread: http://forums.slimdevices.com/showthread.php?t=115850

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


Re: [SlimDevices: Plugins] Alternatives to spotify / spotty?

2022-02-02 Thread whitman


Jaca wrote: 
> Only annoyance was I had to tweak playlists structure as had nested
> folders on Spotify and only 1st level of folder is allowed on Tidal.
> Which BTW isn't even visible on LMS or TV app..

Curious to know how you got nested folders anywhere in Spy.



whitman's Profile: http://forums.slimdevices.com/member.php?userid=9053
View this thread: http://forums.slimdevices.com/showthread.php?t=115850

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


Re: [SlimDevices: Plugins] Alternatives to spotify / spotty?

2022-02-02 Thread slartibartfast


Jaca wrote: 
> Yes it's on  - 5Try playing a local track and compare to the same track on 
> Tidal, I used
Pink Floyd - The Wall. For me Tidal was much quieter. If it isn't on
yours that is very strange. I even tried changing the normalisation
setting in the Tidal phone app, it made no difference. I might record
the waveforms from Squeezeplay using Audacity to show the volume
difference.

Sent from my Pixel 3a using Tapatalk





slartibartfast's Profile: http://forums.slimdevices.com/member.php?userid=35609
View this thread: http://forums.slimdevices.com/showthread.php?t=115850

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


Re: [SlimDevices: Plugins] Alternatives to spotify / spotty?

2022-02-02 Thread Jaca


Jaca wrote: 
> This can't be right.. I believe mine is on - 5 or even - 8 for remote
> streams and Tidal is little louder.. HmmmYes it's on  - 5



3x Squeezebox Touch, 4x Squeezebox Radio, Squeezelite (RPi 3B with
HiFiBerry DAC+Pro on OSMC), Material Skin Apk, Squeeze Commander,
Logitech Media Server Version: 8.2.0 with Material Skin (Docker in
DS218+)

Jaca's Profile: http://forums.slimdevices.com/member.php?userid=58187
View this thread: http://forums.slimdevices.com/showthread.php?t=115850

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


Re: [SlimDevices: Plugins] Alternatives to spotify / spotty?

2022-02-02 Thread slartibartfast

d6jg wrote: 
> I don’t use Tidal but I do use Qobuz and I’ve never touched the Default
> Adjustment for Remote Streams setting. Sometimes Qobuz is slightly
> louder but only very slightly and it doesn’t make me scrabble for a
> phone/tablet/remote to turn it down.In that case Qobuz probably doesn't have 
> replaygain built in. Before
Spotty allowed replaygain I didn't need to change the Default Adjustment
either. This seems to be unique to Tidal.

Sent from my Pixel 3a using Tapatalk





slartibartfast's Profile: http://forums.slimdevices.com/member.php?userid=35609
View this thread: http://forums.slimdevices.com/showthread.php?t=115850

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


Re: [SlimDevices: Plugins] Alternatives to spotify / spotty?

2022-02-02 Thread d6jg

slartibartfast wrote: 
> I think LMS replaygain doesn't work on Tidal, it uses the "Default
> Adjustment for Remote streams". I think if you disable replaygain Tidal
> will still be quieter. I have mine set to "Album gain" and the first
> thing I did was to compare a local album with the Tidal equivalent and
> the volume difference was obvious. I had to set the  remote stream
> adjustment to zero to equalise the volumes.
> 
> Sent from my Pixel 3a using Tapatalk

I don’t use Tidal but I do use Qobuz and I’ve never touched the Default
Adjustment for Remote Streams setting. Sometimes Qobuz is slightly
louder but only very slightly and it doesn’t make me scrabble for a
phone/tablet/remote to turn it down.



Jim
https://jukeradio.double6.net


VB2.4[/B] STORAGE *QNAP TS419P (NFS)
[B]Living Room* Joggler & Pi4/Khadas  -> Onkyo TXNR686 -> Celestion F20s

*Office* Joggler & Pi3 -> Denon RCD N8 -> Celestion F10s 
*Dining Room* SB Radio
*Bedroom (Bedside)* Pi Zero+DAC ->ToppingTP21 ->AKG Headphones
*Bedroom (TV) & Bathroom* SB Touch ->Denon AVR ->Mordaunt Short M10s +
Kef ceiling speakers
*Guest Room* Joggler > Topping Amp -> Wharfedale Modus Cubes

d6jg's Profile: http://forums.slimdevices.com/member.php?userid=44051
View this thread: http://forums.slimdevices.com/showthread.php?t=115850

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


Re: [SlimDevices: Plugins] Alternatives to spotify / spotty?

2022-02-02 Thread slartibartfast


Jaca wrote: 
> I haven't experienced that but I'm running it all on smart gain.. Had
> all my library scanned and replay gained.. I think perhaps Tidal is
> little bit louder than local music. But not every song so not sure if
> any normalisation is applied at all.. I will check this again when got
> opportunity. But it didn't seem like problem so far.. 
> 
> Also transfer was easy and very few tracks are missing from spotify
> library. 
> 
> Only annoyance was I had to tweak playlists structure as had nested
> folders on Spotify and only 1st level of folder is allowed on Tidal.
> Which BTW isn't even visible on LMS or TV app.. (yeah TV app - I was
> investigating connect substitutions and my android tv works as chrome
> cast player) 
> 
> In terms of connect its shame its not there.. I guess for ios users you
> can go with Airplay instead with shairtunes2 plugin.. For android it's
> only LMS connect app which allows to send thing to LMS by share function
> on Tidal app. Bit less convinient but possibly workableI think LMS replaygain 
> doesn't work on Tidal, it uses the "Default
Adjustment for Remote streams". I think if you disable replaygain Tidal
will still be quieter. I have mine set to "Album gain" and the first
thing I did was to compare a local album with the Tidal equivalent and
the volume difference was obvious. I had to set the  remote stream
adjustment to zero to equalise the volumes.

Sent from my Pixel 3a using Tapatalk





slartibartfast's Profile: http://forums.slimdevices.com/member.php?userid=35609
View this thread: http://forums.slimdevices.com/showthread.php?t=115850

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


Re: [SlimDevices: Plugins] Alternatives to spotify / spotty?

2022-02-02 Thread slartibartfast


d6jg wrote: 
> In Player Settings you can adjust volume for Remote Streams. In
> Material, do Settings Player, scroll down to Extra Settings then you
> will find it in the expanded Audio section.Yes but then Radio streams are too 
> loud. You can't win. I suppose Radio
streams rarely follow local tracks in a playlist so I could set the
remote stream adjustment to 0 but surely it isn't intentional that the
Tidal app has built in Replaygain that can't be turned off. 

Sent from my Pixel 3a using Tapatalk





slartibartfast's Profile: http://forums.slimdevices.com/member.php?userid=35609
View this thread: http://forums.slimdevices.com/showthread.php?t=115850

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


Re: [SlimDevices: Plugins] Alternatives to spotify / spotty?

2022-02-02 Thread Jaca


slartibartfast wrote: 
> How do you find the volume of Tidal tracks compared to local tracks? I
> am finding them far too quiet. The Tidal phone app has a setting for
> volume normalisation but the LMS app doesn't. It acts as if
> normalisation is always on.
> 
> Sent from my Pixel 3a using TapatalkI haven't experienced that but I'm 
> running it all on smart gain.. Had
all my library scanned and replay gained.. I think perhaps Tidal is
little bit louder than local music. But not every song so not sure if
any normalisation is applied at all.. I will check this again when got
opportunity. But it didn't seem like problem so far.. 

Also transfer was easy and very few tracks are missing from spotify
library. 

Only annoyance was I had to tweak playlists structure as had nested
folders on Spotify and only 1st level of folder is allowed on Tidal.
Which BTW isn't even visible on LMS or TV app.. (yeah TV app - I was
investigating connect substitutions and my android tv works as chrome
cast player) 

In terms of connect its shame its not there.. I guess for ios users you
can go with Airplay instead with shairtunes2 plugin.. For android it's
only LMS connect app which allows to send thing to LMS by share function
on Tidal app. Bit less convinient but possibly workable



3x Squeezebox Touch, 4x Squeezebox Radio, Squeezelite (RPi 3B with
HiFiBerry DAC+Pro on OSMC), Material Skin Apk, Squeeze Commander,
Logitech Media Server Version: 8.2.0 with Material Skin (Docker in
DS218+)

Jaca's Profile: http://forums.slimdevices.com/member.php?userid=58187
View this thread: http://forums.slimdevices.com/showthread.php?t=115850

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


Re: [SlimDevices: Plugins] Alternatives to spotify / spotty?

2022-02-02 Thread d6jg


slartibartfast wrote: 
> How do you find the volume of Tidal tracks compared to local tracks? I
> am finding them far too quiet. The Tidal phone app has a setting for
> volume normalisation but the LMS app doesn't. It acts as if
> normalisation is always on.
> 
> Sent from my Pixel 3a using Tapatalk

In Player Settings you can adjust volume for Remote Streams. In
Material, do Settings Player, scroll down to Extra Settings then you
will find it in the expanded Audio section.



d6jg's Profile: http://forums.slimdevices.com/member.php?userid=44051
View this thread: http://forums.slimdevices.com/showthread.php?t=115850

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


Re: [SlimDevices: Plugins] Alternatives to spotify / spotty?

2022-02-02 Thread slartibartfast

Jaca wrote: 
> I'm on £1 for 3months Tidal trial in UK and really hoping that I can
> stay.. Wanted to quit Spotify for long time. Apart of fact they  pay
> artist peanuts (which should be enough good reason to not use them) I
> remember theirs treatment of squeezebox community after dropping
> official support and calling my ecosystem " your squeezebox
> smartspeaker" and advising me to replace it with Spotify Connect
> devices.. I guess recent podcast drama is final straw for me.. I have
> actually already cancelled my premium although got another 3 weeks left.
> Its funny how cancellation process reminds of amazon prime (another one
> on my list to avoid.. Hopefully one day)
> Anyway fingers crossed Tidal will meet my needs and I can easily
> transfer some of playlists from SpotifyHow do you find the volume of Tidal 
> tracks compared to local tracks? I
am finding them far too quiet. The Tidal phone app has a setting for
volume normalisation but the LMS app doesn't. It acts as if
normalisation is always on.

Sent from my Pixel 3a using Tapatalk





slartibartfast's Profile: http://forums.slimdevices.com/member.php?userid=35609
View this thread: http://forums.slimdevices.com/showthread.php?t=115850

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


Re: [SlimDevices: Plugins] Announce: UPnPBridge = integrate UPnP/DLNA players with LMS (squeeze2upnp)

2022-02-02 Thread Fabien


Hello Philippe

i still have some trouble to control my pair of Devialet Phantom Gold,
even with the tricks you gave me.
The issues: 
whatever the HTTP mode, if i pause the track then it resumes few seconds
later.
Another issue is that the devialet remote does not work properly (cannot
resume after pause, cannot next/previous track).

But Devialet has released an IP Control interface, i wonder if you can
use it into a specific profile only to send
Play/Pause/Stop/Next/Previous?

https://help.devialet.com/hc/en-us/articles/4415207423378



Fabien's Profile: http://forums.slimdevices.com/member.php?userid=72327
View this thread: http://forums.slimdevices.com/showthread.php?t=103728

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


Re: [SlimDevices: Plugins] SQL Query usage in Database query plugin

2022-02-02 Thread Michael Herger

FROM albums JOIN contributors ON contributors.id = me.contributor me


That last "me" should probably go after "albums".
___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins


Re: [SlimDevices: Plugins] SQL Query usage in Database query plugin

2022-02-02 Thread mamema


normally your head is good, so it's me. :-)

This:

SELECT contributors.name, 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.extid, me.title
FROM albums JOIN contributors ON contributors.id = me.contributor me
WHERE ( id IN ( SELECT me.album FROM tracks me WHERE ( (
me.audio = 1 AND me.year = 2010 AND samplesize = 16 ) ) GROUP BY me.id )
)
ORDER BY me.disc, me.titlesort COLLATE de_DE LIMIT 1001

leads to this:

Error: Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db prepare
failed: near "me": syntax error [for Statement " SELECT
contributors.name, 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.extid, me.title FROM albums JOIN contributors ON contributors.id =
me.contributor me WHERE ( id IN ( SELECT me.album FROM tracks me WHERE (
( me.audio = 1 AND me.year = 2010 AND samplesize = 16 ) ) GROUP BY me.id
) ) ORDER BY me.disc, me.titlesort COLLATE de_DE LIMIT 1001 "] at
/lms/Slim/Schema/Storage.pm line 125 , near "me": syntax error



mamema's Profile: http://forums.slimdevices.com/member.php?userid=44662
View this thread: http://forums.slimdevices.com/showthread.php?t=115686

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


Re: [SlimDevices: Plugins] Spotty Issue

2022-02-02 Thread Michael Herger
Ok, this is 32 bit indeed. I'm no longer providing 32 bit binaries of 
Spotty. But you can grab the previous version from 
https://github.com/michaelherger/Spotty-Plugin/raw/e2a9c2c33e68368a78abae8dceb4c40918dbd238/Bin/MSWin32-x86-multi-thread/spotty.exe. 
Store it somewhere in your search path (see Settings/Information) as 
spotty-custom.exe. I recommend storing it outside the plugin folder, as 
it might be replaced during updates.

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


Re: [SlimDevices: Plugins] Announce: Music & Artist Information plugin

2022-02-02 Thread d6jg


Paul Webster wrote: 
> That could be a way to do it.
> The URL should be different for each set of lyrics though.
> 
> In this case it should be
> http: // www.chartlyrics.com/app/correct.aspx?lid=MQAxADcANQAxAA==
> (remove the spaces that I put in)

I have MAI set up as follows
37102

The slight issue with having a cached copy stored in this way is that
MAI won't update following a correction - I'd have to delete manually to
allow MAI to re-create - unless there was a handy "delete cached copy"
link at the bottom of the lyrics page!?

The upside of this mode is of course I can amend by hand but further
that a can do some clever symlinking which I was doing at the time I
discovered the incorrect lyrics.

The track in question is by Roxy Music as you discovered when searching
but a lot of their stuff has subsequently been re-recorded or performed
live by Bryan Ferry in his solo capacity but if you are playing a Ferry
version ChartLyrics doesn't find the track so rather than symlinking
file to file I have done it on a folder to folder basis

/lyrics/Bryan Ferry is symlinked to
/lyrics/Roxy Music

This uses the same store point for lyrics whether its Roxy Music or
Bryan Ferry that you are listening to and allows a one place correction
for both. Obviously my use is a bit esoteric but I thought I'd post this
just in case someone else finds it useful. 

I have 3 x LMS, 2 use the same NAS as their storage mounted identically
via NFS. The 3rd is at a remote site where there is a fully synced
backup NAS. The LMS there is also mounted with the same path so a change
at one location update all three instances of LMS accordingly. I have
yet to work out how to extend this to Advanced Genre Replacement as this
is (I think) a database thing rather than some simple cached file
containing the replacement table??


+---+
|Filename: 2022-02-02 13_58_47-Server Settings.jpg  |
|Download: http://forums.slimdevices.com/attachment.php?attachmentid=37102|
+---+


Jim
https://jukeradio.double6.net


VB2.4[/B] STORAGE *QNAP TS419P (NFS)
[B]Living Room* Joggler & Pi4/Khadas  -> Onkyo TXNR686 -> Celestion F20s

*Office* Joggler & Pi3 -> Denon RCD N8 -> Celestion F10s 
*Dining Room* SB Radio
*Bedroom (Bedside)* Pi Zero+DAC ->ToppingTP21 ->AKG Headphones
*Bedroom (TV) & Bathroom* SB Touch ->Denon AVR ->Mordaunt Short M10s +
Kef ceiling speakers
*Guest Room* Joggler > Topping Amp -> Wharfedale Modus Cubes

d6jg's Profile: http://forums.slimdevices.com/member.php?userid=44051
View this thread: http://forums.slimdevices.com/showthread.php?t=99537

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


Re: [SlimDevices: Plugins] Announce: Music & Artist Information plugin

2022-02-02 Thread d6jg


Paul Webster wrote: 
> That could be a way to do it.
> The URL should be different for each set of lyrics though.
> 
> In this case it should be
> http: // www.chartlyrics.com/app/correct.aspx?lid=MQAxADcANQAxAA==
> (remove the spaces that I put in)

Yes exactly that,



Jim
https://jukeradio.double6.net


VB2.4[/B] STORAGE *QNAP TS419P (NFS)
[B]Living Room* Joggler & Pi4/Khadas  -> Onkyo TXNR686 -> Celestion F20s

*Office* Joggler & Pi3 -> Denon RCD N8 -> Celestion F10s 
*Dining Room* SB Radio
*Bedroom (Bedside)* Pi Zero+DAC ->ToppingTP21 ->AKG Headphones
*Bedroom (TV) & Bathroom* SB Touch ->Denon AVR ->Mordaunt Short M10s +
Kef ceiling speakers
*Guest Room* Joggler > Topping Amp -> Wharfedale Modus Cubes

d6jg's Profile: http://forums.slimdevices.com/member.php?userid=44051
View this thread: http://forums.slimdevices.com/showthread.php?t=99537

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


Re: [SlimDevices: Plugins] Announce: Music & Artist Information plugin

2022-02-02 Thread Paul Webster


That could be a way to do it.
The URL should be different for each set of lyrics though.

In this case it should be
http: // www.chartlyrics.com/app/correct.aspx?lid=MQAxADcANQAxAA==
(remove the spaces that I put in)



Paul Webster
author of \"now playing\" plugins covering radio france (fip etc),
planetradio (bauer - kiss, absolute, scala, jazzfm etc), kcrw, abc
australia and cbc/radio-canada
and, via the extra \"radio now playing\" plugin lots more - see
https://forums.slimdevices.com/showthread.php?115201-announce-radio-now-playing-plugin

Paul Webster's Profile: http://forums.slimdevices.com/member.php?userid=105
View this thread: http://forums.slimdevices.com/showthread.php?t=99537

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


Re: [SlimDevices: Plugins] Announce: Music & Artist Information plugin

2022-02-02 Thread d6jg


Paul Webster wrote: 
> If you click the link in Michael's post you should see some XML - and in
> there is the field that I referred to.
> If you copy that URL and go to it then you are taken to an edit page on
> ChartLyrics.
> It requires an email address to be entered (but not checked as far as I
> could tell) and makes the update.
> 
> If you then use Michael's link again then you should see that the change
> has been made.
> I don't know if they have back-end processes that do some sanity
> checking of the submitted process and/or they go to human reviewers.
> 
> Note - I think that MAI can get the lyrics from more than one source ...
> so this would only work if the source is ChartLyrics.
> However, you would not see the URL in the LMS logs ... so to get to it
> you would have to search their site for the song and then make the
> update.
> 
> If MAI added the update URL to the MoreInfo field then it could
> potentially be easier to do.

If I understand the MAI process correctly it obtains the lyrics as raw
data and writes to a file as text. If this is correct I think it would
be simpler / cleaner to append a line to the end of the text file if
Micahel is up for it. You could also append the "correction" link if it
was felt sensible although some users wouldn't realise that you would
need to delete the cache version to see the amend.


Code:

Lyrics sourced from https://Chartlyrics.com/fullurl;>ChartLyrics.com on dd/mm/yy.



I modified the earlier example in my stored file and can confirm that
the url gets displayed correctly in both Material and Default and
responds like any other url.



Jim
https://jukeradio.double6.net


VB2.4[/B] STORAGE *QNAP TS419P (NFS)
[B]Living Room* Joggler & Pi4/Khadas  -> Onkyo TXNR686 -> Celestion F20s

*Office* Joggler & Pi3 -> Denon RCD N8 -> Celestion F10s 
*Dining Room* SB Radio
*Bedroom (Bedside)* Pi Zero+DAC ->ToppingTP21 ->AKG Headphones
*Bedroom (TV) & Bathroom* SB Touch ->Denon AVR ->Mordaunt Short M10s +
Kef ceiling speakers
*Guest Room* Joggler > Topping Amp -> Wharfedale Modus Cubes

d6jg's Profile: http://forums.slimdevices.com/member.php?userid=44051
View this thread: http://forums.slimdevices.com/showthread.php?t=99537

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


Re: [SlimDevices: Plugins] [Announce] Squeezelite-X

2022-02-02 Thread rgdawson


Lestrad wrote: 
> Hello. I've been using Squeezelite-X on Windows 7 for a good while, but
> suddenly it just won't play nice. When I start it up I was getting the
> following error message:
> 
> 37074
> 
> I just uninstalled reinstalled it (again) and it starts up after a
> while, but it can't find my Squeezebox Touch. Despite the
> uninstall-reinstalls, it opens a playlist with music I was listening to
> a couple of months ago. LMS, meanwhile, which is working fine with the
> Touch, can't find the Squeezelite-X player anymore.
> 
> Any suggestions would be welcome.

What version of SLX, btw?  It sounds like a bunch of things going on,
maybe network stuff.  I don't know your environment, so hard to say. 
You might try using IP Address of LMS server instead of name.

R Greg Dawson



Squeezelite-X

rgdawson's Profile: http://forums.slimdevices.com/member.php?userid=65236
View this thread: http://forums.slimdevices.com/showthread.php?t=108550

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


Re: [SlimDevices: Plugins] [Announce] Squeezelite-X

2022-02-02 Thread rgdawson


useiler wrote: 
> Hello 
> I have automated my environment and use squeezeliteX (headless).
> 
> I shut down the Windows10 on my NUC at night with a script. 
> The other day, in the afternoon I start the PC with wakeonLAN also with
> a script.
> 
> When I test the scripts, everything works fine. But when I use it in
> everyday life (shut down at night and let it start after a few hours), I
> always have to apply the settings page. 
> Since I'm using it headless, that's not possible.
> Somehow I feel that the settings file is broken. I could create a clean
> file and copy it before starting - but I would need to know the filename
> and location

SLX uses the Windows Registry for its settings. How are you shutting
down SLX with a script?  Is the squeezelite-x64.exe getting shut down
too?

Btw, if you are going through the effort of scripting and running SLX
headless, I'd probably say you should just be running the raw
squeezelite-x64.exe application, instead?

R Greg Dawson



Squeezelite-X

rgdawson's Profile: http://forums.slimdevices.com/member.php?userid=65236
View this thread: http://forums.slimdevices.com/showthread.php?t=108550

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


Re: [SlimDevices: Plugins] ANNOUNCE: YouTube Plugin (API v3)

2022-02-02 Thread lomcovaks

Hi Philippe,

I recently upgraded my Pi3 1Gb LMS system to a Pi4 8Gb with external SSD
and had to reconfigure my YouTube plugin.

I worked my way around the project creation and OAuth configuration
screens fairly well and authorised the plugin to access LMS.

The YouTube plugin is working fine - I can access my YouTube playlists
etc and see the artwork thumbnails in the overview screen.
You can see the artwork when within a particular playlist and both
individual tracks and playlists play.

However, when a playlist is selected to play, the playing track in the
screen only displays the generic YouTube icon and not the individual
track's artwork.

The log is also showing some errors (below the images) but I can't see
where I can correct the problem.

If you or anyone is able to offer any insights I'd much appreciate it.

Many thanks.

37101

Log -

"https://www.googleapis.com/youtube/v3/videos?key=AIzaSyCVjJF37f0W6sMOPjpfdN8dP-BJg_K2qSY=28761G6UKf0%2CtetvnQqkxGA%2CGYQWGomAbns%2C9f7UyUDHFaA%2CpzX4rIdODwM%2CRR8Bh4alfRI%2CNvryolGa19A%2CLrP73SfV-eM%2CuAcALH67-2A%2C9kZJI43p_gs%2CBOUpNtk5Spk%2CAmv_2A4__Bc=50=date=snippet%2CcontentDetails®ionCode=EN_GB;,
"400 Bad Request",
undef,
undef,
undef,
undef,
undef,
undef,
], "Slim::Networking::SimpleAsyncHTTP");
$a->[3]{DEBUG} = $a->[3]{ALL};
$a->[3]{FATAL} = $a->[3]{ERROR};
$a->[3]{INFO} = $a->[3]{ALL};
$a->[3]{OFF} = $a->[3]{ERROR};
$a->[3]{TRACE} = $a->[3]{ALL};
$a->[3]{WARN} = $a->[3]{ALL};
($a, "400 Bad Request");
} at
/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/YouTube/API.pm
line 169.
[22-02-02 12:45:53.5541] Plugins::YouTube::API::__ANON__ (170) 400 Bad
Request
[22-02-02 12:45:53.5543] Plugins::YouTube::ProtocolHandler::__ANON__
(932) 400 Bad Request


+---+
|Filename: playlists overview.jpg   |
|Download: http://forums.slimdevices.com/attachment.php?attachmentid=37101|
+---+


lomcovaks's Profile: http://forums.slimdevices.com/member.php?userid=38453
View this thread: http://forums.slimdevices.com/showthread.php?t=105840

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


Re: [SlimDevices: Plugins] Announce: Music & Artist Information plugin

2022-02-02 Thread Paul Webster


If you click the link in Michael's post you should see some XML - and in
there is the field that I referred to.
If you copy that URL and go to it then you are taken to an edit page on
ChartLyrics.
It requires an email address to be entered (but not checked as far as I
could tell) and makes the update.

If you then use Michael's link again then you should see that the change
has been made.
I don't know if they have back-end processes that do some sanity
checking of the submitted process and/or they go to human reviewers.

Note - I think that MAI can get the lyrics from more than one source ...
so this would only work if the source is ChartLyrics.
However, you would not see the URL in the LMS logs ... so to get to it
you would have to search their site for the song and then make the
update.

If MAI added the update URL to the MoreInfo field then it could
potentially be easier to do.



Paul Webster
author of \"now playing\" plugins covering radio france (fip etc),
planetradio (bauer - kiss, absolute, scala, jazzfm etc), kcrw, abc
australia and cbc/radio-canada
and, via the extra \"radio now playing\" plugin lots more - see
https://forums.slimdevices.com/showthread.php?115201-announce-radio-now-playing-plugin

Paul Webster's Profile: http://forums.slimdevices.com/member.php?userid=105
View this thread: http://forums.slimdevices.com/showthread.php?t=99537

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


Re: [SlimDevices: Plugins] Announce: Music & Artist Information plugin

2022-02-02 Thread d6jg


Paul Webster wrote: 
> FYI .. I used the LyricCorrectUrl field from the returned data and
> submitted a correction.

Paul, can you explain that procedure more fully? As I'm quite happy to
correct at source although in LMS terms I'd need to clear the cache for
track in question and allow MAI to re-create (not a big issue though).
Is the correction immediate do you know?



Jim
https://jukeradio.double6.net


VB2.4[/B] STORAGE *QNAP TS419P (NFS)
[B]Living Room* Joggler & Pi4/Khadas  -> Onkyo TXNR686 -> Celestion F20s

*Office* Joggler & Pi3 -> Denon RCD N8 -> Celestion F10s 
*Dining Room* SB Radio
*Bedroom (Bedside)* Pi Zero+DAC ->ToppingTP21 ->AKG Headphones
*Bedroom (TV) & Bathroom* SB Touch ->Denon AVR ->Mordaunt Short M10s +
Kef ceiling speakers
*Guest Room* Joggler > Topping Amp -> Wharfedale Modus Cubes

d6jg's Profile: http://forums.slimdevices.com/member.php?userid=44051
View this thread: http://forums.slimdevices.com/showthread.php?t=99537

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


Re: [SlimDevices: Plugins] Announce: Music & Artist Information plugin

2022-02-02 Thread Paul Webster


FYI .. I used the LyricCorrectUrl field from the returned data and
submitted a correction.



Paul Webster
author of \"now playing\" plugins covering radio france (fip etc),
planetradio (bauer - kiss, absolute, scala, jazzfm etc), kcrw, abc
australia and cbc/radio-canada
and, via the extra \"radio now playing\" plugin lots more - see
https://forums.slimdevices.com/showthread.php?115201-announce-radio-now-playing-plugin

Paul Webster's Profile: http://forums.slimdevices.com/member.php?userid=105
View this thread: http://forums.slimdevices.com/showthread.php?t=99537

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


Re: [SlimDevices: Plugins] Announce: Music & Artist Information plugin

2022-02-02 Thread d6jg


mherger wrote: 
> > The example is
> > Roxy Music - In every dream home a heartache
> 
> Well, those lyrics come with invalid characters in them. See 
> http://api.chartlyrics.com/apiv1.asmx/GetLyric?lyricId=11751=82782698d7b702867a23970c14da081b.
> 
> It's literally returning this line:
> 
> Theyamp;amp;acute;re rising daily
> 
> That's invalid HTML encoding.  is the encoded ampersand sign. The 
> rest there is missing the leading... ampersand! I guess this has gone 
> through too many encodings/decodings. I can't do much about this kind of
> 
> error. Garbage in - garbage out. You can only hope that over time they 
> would fix it. And until then you can modify the cached copy on your
> disk.
> 
> On their page:
> 
> 37094


I had realised that it was an HTML encoding that hadn't been removed at
source - I code HTML by hand for my sins - but wondered if there was any
regular expression translation already in MAI for display.
I can do a search and replace over the cache files fairly easily but
thanks for looking anyway.



Jim
https://jukeradio.double6.net


VB2.4[/B] STORAGE *QNAP TS419P (NFS)
[B]Living Room* Joggler & Pi4/Khadas  -> Onkyo TXNR686 -> Celestion F20s

*Office* Joggler & Pi3 -> Denon RCD N8 -> Celestion F10s 
*Dining Room* SB Radio
*Bedroom (Bedside)* Pi Zero+DAC ->ToppingTP21 ->AKG Headphones
*Bedroom (TV) & Bathroom* SB Touch ->Denon AVR ->Mordaunt Short M10s +
Kef ceiling speakers
*Guest Room* Joggler > Topping Amp -> Wharfedale Modus Cubes

d6jg's Profile: http://forums.slimdevices.com/member.php?userid=44051
View this thread: http://forums.slimdevices.com/showthread.php?t=99537

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


Re: [SlimDevices: Plugins] Announce: Denon AVP Control Plugin

2022-02-02 Thread oliverbg1


Just for information, all steps are now available on piCorePlayer 'wiki
area' (https://docs.picoreplayer.org/projects/using-ser2net/) too.



oliverbg1's Profile: http://forums.slimdevices.com/member.php?userid=71652
View this thread: http://forums.slimdevices.com/showthread.php?t=60114

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


Re: [SlimDevices: Plugins] Spotty Issue

2022-02-02 Thread Ranz


mherger wrote: 
> Is this a 32 bit Windows version? Platform says "586"
... and spotty worked very well (thank you for it!!!) a few months till
a few days ago

Cheers

Ranz



Ranz's Profile: http://forums.slimdevices.com/member.php?userid=37745
View this thread: http://forums.slimdevices.com/showthread.php?t=115877

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


Re: [SlimDevices: Plugins] Spotty Issue

2022-02-02 Thread Ranz


mherger wrote: 
> Is this a 32 bit Windows version? Platform says "586"

Thanks for your reply, Michael!

It looks like this:

37097


+---+
|Filename: Unbenannt.png|
|Download: http://forums.slimdevices.com/attachment.php?attachmentid=37097|
+---+


Ranz's Profile: http://forums.slimdevices.com/member.php?userid=37745
View this thread: http://forums.slimdevices.com/showthread.php?t=115877

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