Problems loading database (1 Viewer)

styrsven

Portal Pro
January 6, 2013
115
51
59
Sweden Sweden
Country flag
I have been looking at returning to myfilms for some time, so I started experimenting with it. With 6.1.3.1470 the long standing issue of not being able to create a catalog from scratch was fixed, so I thought I would give it another try.
I scanned my collection, that have .nfo files created by TMM. Moving pictures and Kodi have no problems with loading the the files. All the files were scanned, but selecting the "View Movies" tab in the AMC Updater gives this:
upload_2017-10-21_7-47-50.png

If i quit AMC Updater and start "MyFilms setup" and push "Save" i get this:
upload_2017-10-21_7-53-35.png

And pushing Ok gives this:
upload_2017-10-21_7-55-24.png

If I manually edit the catalog file and remove the problematic file from the catalog another file gets reported as the source of the problem.
I have tried to build the program to run a debug session, but I fail at compiling it (I'm much more at home in a unix/linux environment).

I wonder if someone wants to have a look at this issue?

upload_2017-10-21_7-47-50.png
upload_2017-10-21_7-53-35.png
upload_2017-10-21_7-55-24.png
upload_2017-10-21_7-47-50.png
upload_2017-10-21_7-53-35.png
upload_2017-10-21_7-55-24.png
 

styrsven

Portal Pro
January 6, 2013
115
51
59
Sweden Sweden
Country flag
After some time, I have started to experiment with myfilms again. Using the nfo grabber (as I always do) and the same version of myfilms as above, i have found that at scanning the database I get entries like this
Code:
<Movie Number="1" Checked="False" MediaType="HDD" Source="\\Nas\htpc\Videos\¡Tre amigos! (1986)\¡Tre amigos! (1986).mkv" Date="2015-02-01" Rating="6.4" OriginalTitle="¡Tre amigos!" TranslatedTitle="¡Tre amigos!" FormattedTitle="¡Tre amigos!" Director="John Landis" Country="Amerikas Förenta Stater" Category="Komedi, Västern" Year="1986" Length="99" Actors="Steve Martin (Lucky Day), Chevy Chase (Dusty Bottoms), Martin Short (Ned Nederlander), Alfonso Arau (El Guapo), Tony Plana (Jefe), Patrice Martinez (Carmen), Jorge Cervera Jr. (Bandito #1), Kai Wulff (German), Abel Franco (Papa Sanchez), Fred Asparagus (Bartender), Jon Lovitz (Morty), Joe Mantegna (Harry Flugleman), Philip Gordon (Rodrigo), Michael Wren (Cowboy), Gene Hartline (Silent Movie Bandito), William B. Kaplan (Silent Movie Bandito), Sophia Lamour (Silent Movie Senorita), Santos Morales (Telegrapher), Phil Hartman (Sam), Tino Insana (Studio Guard), Craig Berenson (Telegram Delivery Boy), Joshua Gallegos (Bar Patron), Norbert Weisser (German's Friend), Brian Thompson (German's Other Friend), Hector Elias (Pedro), Hector Morales (Carlos), Betty Carvalho (Mama Sanchez), Benita Telles (Rosita), Dyana Ortelli (Juanita), Humberto Ortiz (Pablo), Candy Castillo (Bandito #2), Jeff O'Haco (Bandito #3), Loyda Ramos (Conchita), Carl La Fong (Tortoise), Randy Newman (Singing Bush), Rebecca Ferratti (Señorita Kissing Ned), Cosmo Mata (Man in Bar), Brinke Stevens (Actress in Silent Movie), Tom Tangen (Stagecoach Passenger)" URL="\\Nas\htpc\Videos\¡Tre amigos! (1986)\¡Tre amigos! (1986).nfo" Description="Tre arbetslösa stumfilmsskådespelare får ett gig: de ska åka till en mexikansk by för att spela westernhjältar. Vad de inte vet är att deras motspelare, banditerna, är riktiga." VideoFormat="AVC" VideoBitrate="4730" AudioFormat="AC3" AudioBitrate="448" Resolution="1280x720" Framerate="50.000" Languages="engelska, spanska, tyska" Size="3667" Disks="1" Picture="pictures\¡Three Amigos!.jpg" MediaLabel="" Subtitles="" Producer="" Comments="">
If I edit all the entries like this (I remove the empty attributes at the end of these very long lines) :
Code:
<Movie Number="1" Checked="False" MediaType="HDD" Source="\\Nas\htpc\Videos\¡Tre amigos! (1986)\¡Tre amigos! (1986).mkv" Date="2015-02-01" Rating="6.4" OriginalTitle="¡Tre amigos!" TranslatedTitle="¡Tre amigos!" FormattedTitle="¡Tre amigos!" Director="John Landis" Country="Amerikas Förenta Stater" Category="Komedi, Västern" Year="1986" Length="99" Actors="Steve Martin (Lucky Day), Chevy Chase (Dusty Bottoms), Martin Short (Ned Nederlander), Alfonso Arau (El Guapo), Tony Plana (Jefe), Patrice Martinez (Carmen), Jorge Cervera Jr. (Bandito #1), Kai Wulff (German), Abel Franco (Papa Sanchez), Fred Asparagus (Bartender), Jon Lovitz (Morty), Joe Mantegna (Harry Flugleman), Philip Gordon (Rodrigo), Michael Wren (Cowboy), Gene Hartline (Silent Movie Bandito), William B. Kaplan (Silent Movie Bandito), Sophia Lamour (Silent Movie Senorita), Santos Morales (Telegrapher), Phil Hartman (Sam), Tino Insana (Studio Guard), Craig Berenson (Telegram Delivery Boy), Joshua Gallegos (Bar Patron), Norbert Weisser (German's Friend), Brian Thompson (German's Other Friend), Hector Elias (Pedro), Hector Morales (Carlos), Betty Carvalho (Mama Sanchez), Benita Telles (Rosita), Dyana Ortelli (Juanita), Humberto Ortiz (Pablo), Candy Castillo (Bandito #2), Jeff O'Haco (Bandito #3), Loyda Ramos (Conchita), Carl La Fong (Tortoise), Randy Newman (Singing Bush), Rebecca Ferratti (Señorita Kissing Ned), Cosmo Mata (Man in Bar), Brinke Stevens (Actress in Silent Movie), Tom Tangen (Stagecoach Passenger)" URL="\\Nas\htpc\Videos\¡Tre amigos! (1986)\¡Tre amigos! (1986).nfo" Description="Tre arbetslösa stumfilmsskådespelare får ett gig: de ska åka till en mexikansk by för att spela westernhjältar. Vad de inte vet är att deras motspelare, banditerna, är riktiga." VideoFormat="AVC" VideoBitrate="4730" AudioFormat="AC3" AudioBitrate="448" Resolution="1280x720" Framerate="50.000" Languages="engelska, spanska, tyska" Size="3667" Disks="1" Picture="pictures\¡Three Amigos!.jpg">
This edited version is usable without any problem.
I can think of a number of workarounds/fixes:
  • I can write an xslt transform that runs as a postprocessor that filters away empty attributes
  • I can probably set AMC to not import the attributes that are sometimes (or almost always) empty
  • Maybe there is something in the nfo grabber that can be done
  • or maybe the code can be updated to handle this in a more elegant way.
I think I need to tell that the current number of films are 2587, so it could be that this issue need some size of the database to show itself.
Any comments?
 

styrsven

Portal Pro
January 6, 2013
115
51
59
Sweden Sweden
Country flag
I finally worked around this by downloading msxsl.exe from microsoft and put it in my catalog catalog, together with the attached xsl and bat files. I then configured AMCU to run the bat file as post-processing (under the Options tab). I anyone plan to reuse this you have to edit the bat file, as my catalog file name is hardcoded in it.
 

Attachments

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

OP Similar threads Forum Replies Date
F Problems with new install of MP2 Newcomers Forum 3
A [solved] DiseqC problems after upgrade to 1.25 General Support 12
M Problems with VFD Display after standby- Futaba DM140GINK Mini Display 0
R Connection (api) problems with thetvdb.com General 3
123vak123 [solved] 5008: The problem with scrolling text in the "listcontrol" in 4K General Support 22
framug 1.24.0 1.25.0 pre : problem with build ? 1.24-1.26 Pre Release 89
J Problems with 1.24 StreamedMP 19
Rob Hexenmeister Navigation problems adding menu buttons to EPG General Support 1
404 [solved] EPG problem after Win10 'upgrade' General Support 1
framug [EPG] Some problems with DVB EPG Improvement Suggestions 49
C strange tuner(?) problem TV-Cards 0
R Problems accessing MySQL database remotely MediaPortal 1 Talk 0
T [solved] Startup problem General 6
G Problems with DRR MediaPortal 1 Talk 1
rsbrux 1.23.0 MPE Manager Problem with LAV Filters Bugreports 2
S Problem with Remote Control One-for-all Streamer Newcomers Forum 6
joecrow Default Wide HD Xmas Theme Problem General Support 3
K Sleep mode problem after formating General Support 2
P IPTV Channel Problem TV-Server 0
C Problem playing videos created on IPhone X and Samsung S9 General Support 2
nominefi Problem scanning channels. General Support 0
E Swedish subtitles problem General 2
G Newb trying MP2, trouble with guide data General 5
G MP1 TV Server "failed to upgrade the database" using MS Sql Server Installation, configuration support 3
geotwticher [solved] Fatal Error 0x80070643 during MP2 installation General 7
Top Bottom