[WiP] Centralised database in My Video, My Pictures and folder settings (1 Viewer)

hkjensen

MP Donator
  • Premium Supporter
  • June 11, 2007
    164
    65
    Copenhagen
    Denmark Denmark
    Country flag
    Hi

    Strings with singel pling ' is not saved correctly due to the RemoveInvalidChars function
    ' should not be escaped by another single pling

    RemoveInvalidChars should NOT alter strings for mySQL database

    For VideoDataBaseADO:
    public void RemoveInvalidChars(ref string strTxt)
    {
    }
     

    regeszter

    Retired Team Member
  • Premium Supporter
  • October 29, 2005
    5,335
    4,954
    Hungary Hungary
    Hi

    Strings with singel pling ' is not saved correctly due to the RemoveInvalidChars function
    ' should not be escaped by another single pling

    RemoveInvalidChars should NOT alter strings for mySQL database

    For VideoDataBaseADO:
    public void RemoveInvalidChars(ref string strTxt)
    {
    }
    Can you explain it? Do you have any issue with this?
     

    hkjensen

    MP Donator
  • Premium Supporter
  • June 11, 2007
    164
    65
    Copenhagen
    Denmark Denmark
    Country flag
    Movie with filename "C'est Pas Moi, Je Le Jure! (2008).mkv" get imported and saved as "\C''est Pas Moi, Je Le Jure! (2008)" in table files
    When movie is selected in MP (view: title index) Mp can't find file "C''est Pas Moi, Je Le Jure! (2008).mkv"

    Also for GetMovieTitlesByGenre

    The query should be changed to :
    var query = (from sql in _connection.movieinfoes
    join s3 in _connection.genrelinkmovies on sql.idMovie equals s3.idMovie
    join s4 in _connection.genres on s3.idGenre equals s4.idGenre
    where s4.strGenre == strGenre
    orderby sql.strTitle ascending
    select sql).ToList();

    The all movies with f.ex genre "Horror" get listet and not only movies with only genre "Horror"
    sql.strGenre = "Horror / Sci-Fi" dos not get selected with current query
    where sql.strGenre == strGenre //|| sql.strGenre.Contains(strGenre) //like?
    The Contains(strGenre) could work but using the genrelinkmovies should be faster
     

    regeszter

    Retired Team Member
  • Premium Supporter
  • October 29, 2005
    5,335
    4,954
    Hungary Hungary
    Movie with filename "C'est Pas Moi, Je Le Jure! (2008).mkv" get imported and saved as "\C''est Pas Moi, Je Le Jure! (2008)" in table files
    When movie is selected in MP (view: title index) Mp can't find file "C''est Pas Moi, Je Le Jure! (2008).mkv"
    Please try this dll.
     

    Attachments

    hkjensen

    MP Donator
  • Premium Supporter
  • June 11, 2007
    164
    65
    Copenhagen
    Denmark Denmark
    Country flag
    Movie with filename "C'est Pas Moi, Je Le Jure! (2008).mkv" get imported and saved as "\C''est Pas Moi, Je Le Jure! (2008)" in table files
    When movie is selected in MP (view: title index) Mp can't find file "C''est Pas Moi, Je Le Jure! (2008).mkv"
    Please try this dll.
    Tested dll and i works only for movie filename doublepling2.png
    but not for thumbnail doublepling1.png
     
    Last edited:

    hkjensen

    MP Donator
  • Premium Supporter
  • June 11, 2007
    164
    65
    Copenhagen
    Denmark Denmark
    Country flag
    The all movies with f.ex genre "Horror" get listet and not only movies with only genre "Horror"
    Can you test this too?
    When I select genre='Horror' i only get listed 8 movies on the right
    10-49-02.png
    the list should contain 131 titles (out of 1509), with current select you could end up with a list with no titles.

    Select from my database:
    select count(*) from movieinfo
    where strGenre='Horror'
    count=8

    select count(*) from movieinfo, genre, genrelinkmovie
    where genre.strGenre='Horror' and Genre.idGenre=genrelinkmovie.idGenre and movieinfo.idMovie=genrelinkmovie.idMovie
    count=131
     

    regeszter

    Retired Team Member
  • Premium Supporter
  • October 29, 2005
    5,335
    4,954
    Hungary Hungary
    The all movies with f.ex genre "Horror" get listet and not only movies with only genre "Horror"
    Can you test this too?
    When I select genre='Horror' i only get listed 8 movies on the right
    View attachment 163393
    the list should contain 131 titles (out of 1509), with current select you could end up with a list with no titles.

    Select from my database:
    select count(*) from movieinfo
    where strGenre='Horror'
    count=8

    select count(*) from movieinfo, genre, genrelinkmovie
    where genre.strGenre='Horror' and Genre.idGenre=genrelinkmovie.idGenre and movieinfo.idMovie=genrelinkmovie.idMovie
    count=131
    Can you send me a backup of the videodatabase for testing?
     

    Users Who Are Viewing This Thread (Users: 0, Guests: 1)

    OP Similar threads Forum Replies Date
    toricred Using TMM, How to Stop Importer From Going to The Movie Database for Data General 1
    H MP2 database won't keep in synch with recordings General 8
    F How to reset tv recordings database General 5
    A Synchronizing client databases MediaPortal 1 Talk 10
    R Problems accessing MySQL database remotely MediaPortal 1 Talk 0
    globaldonkey Music Database Error Listen Music 1
    R [solved] Files moved to new location - Easy way to update database? My TVSeries 7
    R Files moved to different location - Easy way to update database? Moving Pictures 2
    H [solved] Video database genres, sort titles and collection thumbnails Newcomers Forum 12
    G MP1 TV Server "failed to upgrade the database" using MS Sql Server Installation, configuration support 3
    D PC rebuild & MP2 upgrade - how to preserve database and settings? General 1
    H MP1.21F video database scan, can it be scheduled to automatically run in background General Support 5
    D Large xml database in My Movies Management. I remain unclear on use My Films as bridge to MP2.2 General 9
    ajs Sync databases by Media Sync Service MediaPortal 1 Talk 26
    J Database schema General 0
    W [solved] MP 1.20 Video IMDB no showing plot General Support 129
    hounddog How to get My Films working in MP 1.20 My Films 5
    C How well can MediaPortal handle 10,000+ recordings? MediaPortal 1 Talk 3
    H Database migration Archive 85
    D Single Seat Install - can another single seat use the same databases? Installation, configuration support 1
    P [Resolved] Missing column in database My TVSeries 7
    M Need advice on writing plugin that modifies EPG database TV-Server 2
    Rob Hexenmeister Skinning Online Videos question OnlineVideos 2
    A [solved] How to Play All Videos in a List watch/edit Videos 3
    O 1.25.0 Codecs and Video Format for PlayStation 2 Codecs, External Players 0
    Similar threads

























    Top Bottom