My Music - need your thoughts on how to improve and enhance | Page 56

Discussion in 'Listen Music' started by SteveV, December 13, 2005.

Thread Status:
Not open for further replies.
  1. hwahrmann
    • Team MediaPortal

    hwahrmann Development Group

    Joined:
    September 15, 2004
    Messages:
    4,495
    Likes Received:
    1,638
    Gender:
    Male
    Location:
    Vienna, Austria
    Ratings:
    +2,264 / 1
    Home Country:
    Austria Austria
    We want to see happy users. :D :D


     
  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. mzemina
    • Team MediaPortal

    mzemina Retired Team Member

    Joined:
    February 23, 2005
    Messages:
    2,065
    Likes Received:
    13
    Occupation:
    Project Manager
    Location:
    Tulsa, OK
    Ratings:
    +13 / 0
    Home Country:
    United States of America United States of America
    There are many developers doing just that! Thanks to all of you guys!!
    :D
     
  4. HappyTalk

    HappyTalk Portal Pro

    Joined:
    July 16, 2006
    Messages:
    307
    Likes Received:
    8
    Occupation:
    Coder
    Location:
    UK
    Ratings:
    +8 / 0
    wow that was quick, tried latest svn (10199) and got some errors.

    Set up Albums view as:-
    album group 1
    album
    title
    => compilation albums appear repeatedly once per artist. Though this is obviously when on the ungrouped second entry

    Set up Albums view as:-
    album group 1
    album group 2
    album
    title
    => Get A..Z but all subfolders appear empty
    [ERROR] SQL:MusicDatabaseV7.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:no such column: strTitle query:select UPPER(SUBSTR(strTitle,1,3)) IX, Count(*) from album where album.strAlbum like 'A%' group by ix order by strAlbum asc
    [ERROR] musicdatabase exception err:confused:QL:MusicDatabaseV7.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:no such column: strTitle query:select UPPER(SUBSTR(strTitle,1,3)) IX, Count(*) from album where album.strAlbum like 'A%' group by ix order by strAlbum asc stack: at SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err) in D:\devel\vs7\mediaportal\Databases\SQLiteClient.cs:line 215
    at SQLite.NET.SQLiteClient.Execute(String query) in D:\devel\vs7\mediaportal\Databases\SQLiteClient.cs:line 250
    at MediaPortal.Music.Database.MusicDatabase.GetSongsByIndex(String sql, List`1& songs, Int32 level, Boolean artistTable, Boolean albumTable, Boolean songTable, Boolean genreTable) in D:\devel\vs7\mediaportal\Databases\Music\Database.cs:line 601


    I set Songs up as:-
    title Group 1
    title Group 2
    title
    => and nothing appears!
    error.log = 031 [ERROR] musicdatabase exception err:Index was outside the bounds of the array. stack: at MediaPortal.Music.Database.MusicDatabase.GetSongsByIndex(String sql, List`1& songs, Int32 level, Boolean artistTable, Boolean albumTable, Boolean songTable, Boolean genreTable) in D:\devel\vs7\mediaportal\Databases\Music\Database.cs:line 616


    It may be cos I'm using a music db with 41,000 song entries. It seems to work on albums and artists with 1 group entry but not 2 successive ones. Songs won't work at all with groups, without groups they work as before but takes about a minute for the view to load up. Great fast work though, cheers.
     
  5. hwahrmann
    • Team MediaPortal

    hwahrmann Development Group

    Joined:
    September 15, 2004
    Messages:
    4,495
    Likes Received:
    1,638
    Gender:
    Male
    Location:
    Vienna, Austria
    Ratings:
    +2,264 / 1
    Home Country:
    Austria Austria
    Happytalk,

    i have to look into the compilatin albums.

    all the others work for me.
    will have a look on it on Monday.
    Weekend is reserved for other private activities

    thx for testing,

    Helmut
     
  6. murf

    murf Portal Member

    Joined:
    February 16, 2006
    Messages:
    5
    Likes Received:
    0
    Ratings:
    +0 / 0
    Hi,

    Since the lasts updates I can no longer use the play button of my MCE remote control to play musics, when I do that, the music starts but no longer the "Now Playing screen" and the MediaPortal GUI crash, I can no longer move in menu either with remote control, mouse or keyboard, all I can do is to kill Mediaportal.

    But if I select a track and press the ok button of the remote everything is fine.

    Did someone else have the same problem?
     
  7. HappyTalk

    HappyTalk Portal Pro

    Joined:
    July 16, 2006
    Messages:
    307
    Likes Received:
    8
    Occupation:
    Coder
    Location:
    UK
    Ratings:
    +8 / 0
    OK I can see in my second example thats error logging that it seems to be selecting strTitle from album table instead of strAlbum


    One other aspect I was keen for was the ability to group based on number of entries. It seems that using group in conjunction with the Limit column would naturally facilitate this. So for songs it could be used:-
    Code (Text):
    1.  
    2. selection    Operat    Restrict    Limit
    3. title            Group          1  
    4. title            Group         16          25
    5. title
    6.  
    Which assuming I selected A from the first page would then present me the first 16 chars (followed by ... to indicate further entries) of every 25th song. (Or I could leave Restrict blank to get whole song name...)

    I had to use a temp table as after much experimentation could see no other way to achieve this. By naming the main columns idRecord & strRecord I figured the select would be the same for artist, albums, songs etc. I figured using a temp table + select statement, for each step of the view would make it a lot easier to control as things could get pretty complex. I used a 'drop table' first to avoid having to tidy up temp tables (DROP IF EXISTS is in SQLite 3.3.0 dunno what ver MP is using)

    view_level1
    Code (Text):
    1.  
    2. drop table view1;
    3. create temp table view1 AS SELECT UPPER(SUBSTR(strTitle,1,1)) AS strRecord, COUNT(*) AS cntRecord FROM song WHERE strRecord >= 'A' AND strRecord <= 'Z'  GROUP BY strRecord ORDER BY strRecord;
    4. INSERT INTO view1 VALUES('#', (SELECT cntRecord FROM (SELECT UPPER(SUBSTR(strTitle,1,1)) AS strRecord, count(strTitle) as cntRecord FROM song WHERE strRecord < 'A' OR strRecord  > 'Z')));
    5. select * FROM view1;
    6.  

    If I select 'A' then view_level2 =
    Code (Text):
    1.  
    2. drop table view2;
    3. create temp table view2 as select idSong AS idRecord, UPPER(strTitle) AS strRecord from song WHERE strRecord LIKE 'A%' ORDER BY strRecord asc;
    4. select SUBSTR(strRecord,1,16) || '...',rowid from view2 where rowid % 25 = 0;
    5.  

    If I then select one of the 'song.....' columns I would use the rowid in a limit clause to create view_level3 for the third stage of filtering.
    Code (Text):
    1.  
    2. drop table view3;
    3. create temp table view3 as SELECT * from view2 limit 100,25;
    4. select strTitle FROM song WHERE idSong IN (SELECT idRecord from view3) ORDER BY UPPER(strTitle);
    5.  
    I experimented a lot with this concept to test it's viability and it seemed to work really well. Thanks for listening.
     
  8. juandionis

    juandionis Portal Pro

    Joined:
    December 15, 2005
    Messages:
    65
    Likes Received:
    0
    Ratings:
    +0 / 0
    Murf same problem here. I do not know if it is a known bug or a new one. MP crashes if "go to playnow window is marked" in My music settings. The other two options are OK.

    juan
     
  9. ivankurac3

    ivankurac3 Portal Pro

    Joined:
    December 21, 2005
    Messages:
    59
    Likes Received:
    0
    Location:
    Zagreb, Croatia
    Ratings:
    +0 / 0
    Home Country:
    Croatia Croatia
    There are two things that would be easy to do, and I think many users will be happy to see. Specially those "not so organised", and those who don't want to tag their song if they don't already have tags.

    Wherever it is possible for "unknown" to appear instead of something meaningfull, there should be a filename! So if the tags are not available let the filename be displayed. This is the first thing.

    The second thing is an option not to start playing the playlist automatically when a song is added to it.

    I know this shouldn't be difficult to do because I made such changes on the source for myself.

    Regards
     
  10. hwahrmann
    • Team MediaPortal

    hwahrmann Development Group

    Joined:
    September 15, 2004
    Messages:
    4,495
    Likes Received:
    1,638
    Gender:
    Male
    Location:
    Vienna, Austria
    Ratings:
    +2,264 / 1
    Home Country:
    Austria Austria
    Murf, juandionis,

    your problems will be fixed tommorow.

    ivankurac3, i'll look into that as soon as i find more time.

    regards,

    Helmut
     
  11. Lyxalig
    • Premium Supporter

    Lyxalig MP Donator

    Joined:
    January 30, 2005
    Messages:
    276
    Likes Received:
    1
    Occupation:
    IT student
    Location:
    Norway
    Ratings:
    +1 / 0
    Home Country:
    Norway Norway

    A quick fix.. now-playing screen has been refurbished.
    I assume you're using another skin than B2.
    Copy the MyMusic now playing xml-file from B2 skin-directory into the skin-folder you're using. Or just wait..;)
     
Loading...
Thread Status:
Not open for further replies.

Users Viewing Thread (Users: 0, Guests: 0)

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice
  • About The Project

    The vision of the MediaPortal project is to create a free open source media centre application, which supports all advanced media centre functions, and is accessible to all Windows users.

    In reaching this goal we are working every day to make sure our software is one of the best.

             

  • Support MediaPortal!

    The team works very hard to make sure the community is running the best HTPC-software. We give away MediaPortal for free but hosting and software is not for us.

    Care to support our work with a few bucks? We'd really appreciate it!