1.14.0 Recordings import assigns wrong channels (1 Viewer)

Johannes Franke

New Member
January 11, 2016
3
0
Germany Germany
Hi everyone,

I found a problem with MP 1.9.0 which apparently is still around with 1.13.0 and wanted to let you know about my findings.
I have a DVB-S setup (Hauppauge Win-TV 5500 HVR) and the previous scan revealed a lot of TV and radio stations. The scanner appears to add the radio stations first into the channels table so they get a lower record ID than the TV stations which reside in the same table. This is the result of a SELECT * FROM channel WHERE displayName = 'RTL2'

Code:
idChannel isRadio isTv timesWatched   totalTimeWatched  grabEpg lastGrabTime     sortOrder visibleInGuide externalId displayName epgHasGaps channelNumber
      142       1    0             0  01.01.2000 00:00        0 01.01.2000 00:00     10000              1            RTL2                 0         10000
      384       0    1             0  01.01.2000 00:00        1 11.01.2016 11:06         5              1            RTL2                 0         10000
I picked RTL2 because it is where I found the issue. But this is just a representative example. The problem will occur whenever a radio and TV station share the same displayName.
Recordings are supposed to go to a large harddrive that does not contain the Windows system installation. So the recordings base folder had to be redirected to the other harddrive. After that, I cleared all invalid records in the configuration wizard and clicked Change Channel to refresh the list of available recordings for import. All are shown as expected. Just to mention it, each .ts file has an accompanying .xml file containing the recording info.
After importing them, I found that not all recordings are shown in the MediaPortal client, even though a record for each exists in the recording table, and no files remained in the list of files to be imported. The ones not shown both have idChannel = 142.
I imagine that the following happened during the import:

  1. for each .ts file, the respective .xml file is looked up and, if found, parsed
  2. the .xml file has the channel name in it
  3. the channel name is looked up by name (displayName, to be exact) in the channel table
  4. actually this would result in multiple channel records matching but the first wins which unfortunately is the radio channel, not the TV
  5. the id of the first channel record is used for the new record in the recordings table and goes into the idChannel column
  6. when MediaPortal queries the available recordings, there is probably an inner join between the recordings and the channels table that excludes the radio-related channels
  7. as a result, the list of recordings is incomplete
Probably this might be fixed if in step 3 the query would be changed to retrieve the channel matching the given name AND having isTv = 1. Eventually this is all about video recordings, not radio (at least for me). Unfortunately, the actual source of the recording (radio or TV) cannot be found out from the XML data because there is no respective information in there. But at least a small analysis of the .ts file might reveal whether it contains pure audio (--> radio) or audio and video (--> TV).
So far, the only fix is changing the idChannel value from 142 to 384 wherever 142 is assigned...

The problem has been around for some time. Maybe I am not the first one to notice and address it. In that case, sorry for the time wasted.

Best regards,
Johannes
 

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

OP Similar threads Forum Replies Date
P Recordings not showing up unless re-imported and not possible to delete General 0
X Recording import hängt Allgemeines Support- und Diskussionsforum 0
N [Finished] [MP2-791] Radio recordings do not get imported into Recordings listing MediaPortal 2 25
P Recording films that have an "intermission" General 2
H MP2 database won't keep in synch with recordings General 2
toricred Only Show Actual Recordings General 1
ajs How recreate Recording thumbs TV-Server 4
P [solved] MP2 new install, 2 x hdhomerun tuners, client on same PC unable to view TV & recordings Newcomers Forum 8
CyberSimian [Proposal] Tool to display time of next recording MediaPortal 1 0
Golf4 TV-Records werden als Audio-Files importiert ? Allgemeines Support- und Diskussionsforum 0
R [solved] Unable to delete single recording General 2
R Correct setting for recordings on shared folder General 0
W [solved] MP suddenly Crashes when starting live TV on most channels and on recordings from the same channels General Support 20
W [solved] MP suddenly Crashes when starting live TV on some channels and on some recordings Television (MyTV frontend and TV-Server) 1
S Shortcuts MP1 My Recorded & TV Guide General 10
F How to reset tv recordings database General 5
F Recording starts at second time only MediaPortal 1 Talk 6
T TV Recording Schedule General 2
T Unwanted recording Newcomers Forum 18
bta489 [solved] DVB-T2 Recordings: Sometimes no Audio after muxing with mkvmerge Tools and other software 2
N Play a TV recording needs a double selection - twice ok on remote Television (MyTV frontend and TV-Server) 2
G Occasional Black screen on Live TV and Recorded TV Watch / Listen Media 5
B MP 1.23 First time click TV or Recorded TV fails, 2nd ... it will work General Support 5
M MP 2.2.3 Unable to play .ts recordings and MediaPortal stops working for TV viewing General 31
R [solved] MP will not delete recordings that are on NAS Television (MyTV frontend and TV-Server) 23
Similar threads

























Top Bottom