[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.

Page 9 of 11
  1. ajs
    • Team MediaPortal

    ajs Development Group

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


     
    ajs, March 23, 2015
    • 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
    March 26, 2015 #82
    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)
    {
    }
     
    hkjensen, March 26, 2015
  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
    March 26, 2015 #83
    Can you explain it? Do you have any issue with this?
     
    regeszter, March 26, 2015
  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
    March 26, 2015 #84
    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
     
    hkjensen, March 26, 2015
    • 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
    March 26, 2015 #85
    Please try this dll.
     

    Attached Files:

    • Databases.zip
      File size:
      166.1 KB
      Uploaded:
      March 26, 2015
      Views:
      92
    regeszter, March 26, 2015
  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
    March 26, 2015 #86
    Tested dll and i works only for movie filename doublepling2.png
    but not for thumbnail doublepling1.png
     
    Last edited: March 26, 2015
    hkjensen, 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
    March 26, 2015 #87
    Can you test this too?
     
    regeszter, March 26, 2015
    • 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
    March 29, 2015 #88
    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
     
    hkjensen, March 29, 2015
  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
    March 29, 2015 #89
    Can you send me a backup of the videodatabase for testing?
     
    regeszter, March 29, 2015
  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
    April 3, 2015 #90
    MediaPortalSetup_1.11.0_2015-04-03-16-34
    • Bugfixes
     
    regeszter, April 3, 2015
    • Thank You! Thank You! x 2
Page 9 of 11
Loading...
Similar Threads - Centralised database Video
  1. jonm

    Centralised database?

    jonm, July 25, 2010, in forum: General Support
    Replies:
    0
    Views:
    619
    jonm
    July 25, 2010
  2. 1gkar

    Unable to get centralised database working

    1gkar, August 30, 2009, in forum: General Support
    Replies:
    10
    Views:
    1,357
    rekenaar
    September 6, 2009
  3. Toga

    Fanart and Centralised databases

    Toga, July 5, 2009, in forum: Moving Pictures
    Replies:
    6
    Views:
    1,643
    rekenaar
    July 19, 2009
  4. csapollo

    MediaPortal - Centralised Databases - Help

    csapollo, April 4, 2009, in forum: MediaPortal 1 Talk
    Replies:
    4
    Views:
    1,225
    csapollo
    April 29, 2009
  5. swifty

    Centralised Database causes problem resuming from standby

    swifty, July 17, 2008, in forum: General Support
    Replies:
    4
    Views:
    756
    charli181
    July 19, 2008

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.
    Accept Learn More...
    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.

             

  • Quick Navigation

  • 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!