Example:
A directory in the file tree browser
Inside:
Moderator: moderators
goatsofdoom wrote:I'm not able to scan folders with names that include Unicode characters or certain characters nor do their contents show up in the file tree browser. Any idea how to fix this or is it a bug; it never happened with vanilla subsonic
java \
-Xmx512m \
-cp /path/to/subsonic-booter-jar-with-dependencies.jar \
-Dsubsonic.httpsPort=0 \
-Dsubsonic.port=4040 \
-Dfile.encoding=UTF8 \
-Dsubsonic.war=/path/to/subsonic.war \
(...)
phantom4 wrote:I'm really liking the 0.7.8 release, but I found a couple of issues. For some reason, I'm getting a NullPointerException when trying to load some playlists. It doesn't happen on every playlist, but there doesn't appear to be anything different about the ones that don't load. They're standard m3u files and worked fine in version 0.5.5 and Subsonic 4.6/4.7b3.
hakko wrote:It works using substrings - for example, if you search for "yellow sub beatles", most people could guess what I'm thinking of. It seems that the default Subsonic (4.7) doesn't match this, though. MusicCabinet didn't either, until now. In my new version, it happily returns Yellow Submarine. yay!
select art.artist_name, alb.album_name, mt.track_name from library.track lt inner join music.track mt on lt.track_id = mt.id inner join music.album alb on lt.album_id = alb.id inner join music.artist art on mt.artist_id = art.id where track_name_search like '%LOVE%ME%' order by art.artist_name, mt.track_name;
hakko wrote:Could it be that there are more than 25 results matching "love me"? I'm still using the original code where only the top 25 hits are returned. Paging in search result may appear later on.
Could you connect to your Postgresql database and issue the commandand verify that your Beatles track is included?
- Code: Select all
select art.artist_name, alb.album_name, mt.track_name from library.track lt inner join music.track mt on lt.track_id = mt.id inner join music.album alb on lt.album_id = alb.id inner join music.artist art on mt.artist_id = art.id where track_name_search like '%LOVE%ME%' order by art.artist_name, mt.track_name;
Edit: it would make sense to rank exact matches first, though
hakko wrote::) you could also just add the word beatles to your search ("beatles love me"), that'll narrow the number of returned tracks.
SELECT artist.artist_name FROM music.artist WHERE artist.artist_name = 'GOTYE';
Users browsing this forum: No registered users and 4 guests