[WiP] - Centralised database in My Video, My Pictures and folder settings | Page 9

Discussion in 'Area 51 - Testing Area' started by regeszter, February 6, 2015.

  1. ajs
    • Team MediaPortal

    ajs Development Group

    Joined:
    February 29, 2008
    Messages:
    8,828
    Likes Received:
    2,789
    Gender:
    Male
    Occupation:
    IT
    Location:
    Kyiv
    Ratings:
    +4,794 / 30
    Home Country:
    Ukraine Ukraine
    Show System Specs
    Remove the old database, install, run the configurator, imported NFO. Works, no errors. Speed import and enter the plugin Video increased.


     
    • Thank You! Thank You! x 2
  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. hkjensen
    • Premium Supporter

    hkjensen MP Donator

    Joined:
    June 11, 2007
    Messages:
    164
    Likes Received:
    47
    Location:
    Copenhagen
    Ratings:
    +63 / 0
    Home Country:
    Denmark Denmark
    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)
    {
    }
     
  4. regeszter
    • Premium Supporter

    regeszter Retired Team Member

    Joined:
    October 29, 2005
    Messages:
    5,335
    Likes Received:
    2,863
    Ratings:
    +5,152 / 18
    Home Country:
    Hungary Hungary
    Can you explain it? Do you have any issue with this?
     
  5. hkjensen
    • Premium Supporter

    hkjensen MP Donator

    Joined:
    June 11, 2007
    Messages:
    164
    Likes Received:
    47
    Location:
    Copenhagen
    Ratings:
    +63 / 0
    Home Country:
    Denmark Denmark
    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
     
    • Thank You! Thank You! x 1
  6. regeszter
    • Premium Supporter

    regeszter Retired Team Member

    Joined:
    October 29, 2005
    Messages:
    5,335
    Likes Received:
    2,863
    Ratings:
    +5,152 / 18
    Home Country:
    Hungary Hungary
    Please try this dll.
     

    Attached Files:

    • Databases.zip
      File size:
      166.1 KB
      Uploaded:
      March 26, 2015
      Views:
      91
  7. hkjensen
    • Premium Supporter

    hkjensen MP Donator

    Joined:
    June 11, 2007
    Messages:
    164
    Likes Received:
    47
    Location:
    Copenhagen
    Ratings:
    +63 / 0
    Home Country:
    Denmark Denmark
    Tested dll and i works only for movie filename doublepling2.png
    but not for thumbnail doublepling1.png
     
    Last edited: March 26, 2015
    • Like Like x 1
    • Thank You! Thank You! x 1
  8. regeszter
    • Premium Supporter

    regeszter Retired Team Member

    Joined:
    October 29, 2005
    Messages:
    5,335
    Likes Received:
    2,863
    Ratings:
    +5,152 / 18
    Home Country:
    Hungary Hungary
    Can you test this too?
     
    • Outdated Information Outdated Information x 1
  9. hkjensen
    • Premium Supporter

    hkjensen MP Donator

    Joined:
    June 11, 2007
    Messages:
    164
    Likes Received:
    47
    Location:
    Copenhagen
    Ratings:
    +63 / 0
    Home Country:
    Denmark Denmark
    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
     
  10. regeszter
    • Premium Supporter

    regeszter Retired Team Member

    Joined:
    October 29, 2005
    Messages:
    5,335
    Likes Received:
    2,863
    Ratings:
    +5,152 / 18
    Home Country:
    Hungary Hungary
    Can you send me a backup of the videodatabase for testing?
     
  11. regeszter
    • Premium Supporter

    regeszter Retired Team Member

    Joined:
    October 29, 2005
    Messages:
    5,335
    Likes Received:
    2,863
    Ratings:
    +5,152 / 18
    Home Country:
    Hungary Hungary
    MediaPortalSetup_1.11.0_2015-04-03-16-34
    • Bugfixes
     
    • Thank You! Thank You! x 2
Loading...

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!