The programids apparently get inserted by the mythfilldatabase run itself. The command I use is
The inserted programid ("MV94942868" for "Tatort") is nowhere to be found in the xml file. A web search for it does not return anything either. In the verbose log of the mythfilldatabase run I see a couple of entries with it:
Code: Select all
2019-05-23 12:24:34.963540 I [4884/4884] CoreContext mythdbcon.cpp:716 (exec) - MSqlQuery::exec(DBManager1) SELECT count(*) FROM program WHERE chanid = '10769' AND starttime = '2019-05-26T18:20:00Z' AND endtime = '2019-05-26T19:50:00Z' AND title = 'Tatort' AND subtitle = 'Die ewige Welle' AND description = 'Mikesch, Eisbachsurfer und ein früherer Freund Leitmayrs, wird Opfer einer Messerattacke. Er überlebt schwer verletzt. Doch anstatt zu kooperieren, flüchtet der schräge Vogel aus dem Krankenhaus und verschwindet vom Radar der Ermittler. Mikesch hat ein Geschäft abzuwickeln, bei dem die Polizei stört. Die Zeit drängt.' AND category = 'movie' AND category_type = 'movie'_TYPE AND airdate = '2019' AND stars >= ('0' - 0.001) AND stars <= ('0' + 0.001) AND previouslyshown = 'false' AND title_pronounce = 'Tatort'_PRONOUNCE AND audioprop = '8' AND videoprop = '0' AND subtitletypes = '0' AND partnumber = '0' AND parttotal = '0' AND seriesid = '94942868' AND showtype = '' AND colorcode = '' AND syndicatedepisodenumber = '' AND programid = 'MV94942868' AND inetref = '' <<<< Took 2ms, Returned 1 row(s)
2019-05-23 12:24:34.974035 I [4884/4884] CoreContext mythdbcon.cpp:716 (exec) - MSqlQuery::exec(DBManager1) REPLACE INTO program ( chanid, title, subtitle, description, category, category_type, starttime, endtime, closecaptioned, stereo, hdtv, subtitled, subtitletypes, audioprop, videoprop, partnumber, parttotal, syndicatedepisodenumber, airdate, originalairdate,listingsource, seriesid, programid, previouslyshown, stars, showtype, title_pronounce, colorcode, season, episode, totalepisodes, inetref ) VALUES( '10769', 'Tatort', 'Die ewige Welle', 'Mikesch, Eisbachsurfer und ein früherer Freund Leitmayrs, wird Opfer einer Messerattacke. Er überlebt schwer verletzt. Doch anstatt zu kooperieren, flüchtet der schräge Vogel aus dem Krankenhaus und verschwindet vom Radar der Ermittler. Mikesch hat ein Geschäft abzuwickeln, bei dem die Polizei stört. Die Zeit drängt.', 'movie', 'movie', '2019-05-26T18:20:00Z', '2019-05-26T19:50:00Z', 'false', 'false', 'false', 'false', '0', '8', '0', '0', '0', '', '2019', '', '4', '94942868', 'MV94942868', 'false', '0', '', 'Tatort'PRON, '', '0', '0', '0', '' ) <<<< Took 1ms
2019-05-23 12:24:35.172144 I [4884/4884] CoreContext mythdbcon.cpp:716 (exec) - MSqlQuery::exec(DBManager1) SELECT count(*) FROM program WHERE chanid = '10769' AND starttime = '2019-05-27T22:35:00Z' AND endtime = '2019-05-28T00:08:00Z' AND title = 'Tatort' AND subtitle = 'Die ewige Welle' AND description = '' AND category = 'movie' AND category_type = 'movie'_TYPE AND airdate = '2019' AND stars >= ('0' - 0.001) AND stars <= ('0' + 0.001) AND previouslyshown = 'false' AND title_pronounce = 'Tatort'_PRONOUNCE AND audioprop = '0' AND videoprop = '0' AND subtitletypes = '0' AND partnumber = '0' AND parttotal = '0' AND seriesid = '94942868' AND showtype = '' AND colorcode = '' AND syndicatedepisodenumber = '' AND programid = 'MV94942868' AND inetref = '' <<<< Took 2ms, Returned 1 row(s)
2019-05-23 12:24:35.181028 I [4884/4884] CoreContext mythdbcon.cpp:716 (exec) - MSqlQuery::exec(DBManager1) REPLACE INTO program ( chanid, title, subtitle, description, category, category_type, starttime, endtime, closecaptioned, stereo, hdtv, subtitled, subtitletypes, audioprop, videoprop, partnumber, parttotal, syndicatedepisodenumber, airdate, originalairdate,listingsource, seriesid, programid, previouslyshown, stars, showtype, title_pronounce, colorcode, season, episode, totalepisodes, inetref ) VALUES( '10769', 'Tatort', 'Die ewige Welle', '', 'movie', 'movie', '2019-05-27T22:35:00Z', '2019-05-28T00:08:00Z', 'false', 'false', 'false', 'false', '0', '0', '0', '0', '0', '', '2019', '', '4', '94942868', 'MV94942868', 'false', '0', '', 'Tatort'PRON, '', '0', '0', '0', '' ) <<<< Took 1ms
2019-05-23 12:24:36.109067 I [4884/4884] CoreContext mythdbcon.cpp:716 (exec) - MSqlQuery::exec(DBManager1) SELECT count(*) FROM program WHERE chanid = '10769' AND starttime = '2019-06-03T22:35:00Z' AND endtime = '2019-06-04T00:08:00Z' AND title = 'Tatort' AND subtitle = 'Glück allein' AND description = '(Erstsendung 2.6.2019)' AND category = 'movie' AND category_type = 'movie'_TYPE AND airdate = '2018' AND stars >= ('0' - 0.001) AND stars <= ('0' + 0.001) AND previouslyshown = 'false' AND title_pronounce = 'Tatort'_PRONOUNCE AND audioprop = '8' AND videoprop = '0' AND subtitletypes = '0' AND partnumber = '0' AND parttotal = '0' AND seriesid = '94942868' AND showtype = '' AND colorcode = '' AND syndicatedepisodenumber = '' AND programid = 'MV94942868' AND inetref = '' <<<< Took 1ms, Returned 1 row(s)
2019-05-23 12:24:36.117174 I [4884/4884] CoreContext mythdbcon.cpp:716 (exec) - MSqlQuery::exec(DBManager1) REPLACE INTO program ( chanid, title, subtitle, description, category, category_type, starttime, endtime, closecaptioned, stereo, hdtv, subtitled, subtitletypes, audioprop, videoprop, partnumber, parttotal, syndicatedepisodenumber, airdate, originalairdate,listingsource, seriesid, programid, previouslyshown, stars, showtype, title_pronounce, colorcode, season, episode, totalepisodes, inetref ) VALUES( '10769', 'Tatort', 'Glück allein', '(Erstsendung 2.6.2019)', 'movie', 'movie', '2019-06-03T22:35:00Z', '2019-06-04T00:08:00Z', 'false', 'false', 'false', 'false', '0', '8', '0', '0', '0', '', '2018', '', '4', '94942868', 'MV94942868', 'false', '0', '', 'Tatort'PRON, '', '0', '0', '0', '' ) <<<< Took 1ms
2019-05-23 12:24:36.968311 I [4884/4884] CoreContext mythdbcon.cpp:716 (exec) - MSqlQuery::exec(DBManager1) SELECT count(*) FROM program WHERE chanid = '10769' AND starttime = '2019-06-10T18:15:00Z' AND endtime = '2019-06-10T19:45:00Z' AND title = 'Tatort' AND subtitle = 'Kaputt' AND description = 'Eigentlich sollten die Polizisten Melanie Sommer (Anna Brüggemann) und Frank Schneider bei einer lauten Feier in einem Wohnhaus nur für Ruhe sorgen. Doch wenig später wird die junge Kriminalbeamtin verletzt und traumatisiert im Garten des Hauses aufgefunden. Ihr Kollege wurde so brutal zusammengeschlagen, dass für ihn jede Hilfe zu spät kommt. Der Polizistenmord sorgt nicht nur im Präsidium und in der Presse für Aufregung. Auch Frank Schneiders Lebensgefährte Stefan Pohl (Max Simonischek) kann den Verlust nicht fassen: Die beiden hatten sich im Dienst kennengelernt. Die Beziehung sah der Dienststellenleiter Bernd Schäfer (Götz Schubert) nicht gern. Auch, dass die Mordkommission jetzt die eigenen Leute überprüft, passt ihm gar nicht ...' AND category = 'movie' AND category_type = 'movie'_TYPE AND airdate = '2019' AND stars >= ('0' - 0.001) AND stars <= ('0' + 0.001) AND previouslyshown = 'false' AND title_pronounce = 'Tatort'_PRONOUNCE AND audioprop = '8' AND videoprop = '0' AND subtitletypes = '0' AND partnumber = '0' AND parttotal = '0' AND seriesid = '94942868' AND showtype = '' AND colorcode = '' AND syndicatedepisodenumber = '' AND programid = 'MV94942868' AND inetref = '' <<<< Took 2ms, Returned 1 row(s)
2019-05-23 12:24:36.979793 I [4884/4884] CoreContext mythdbcon.cpp:716 (exec) - MSqlQuery::exec(DBManager1) REPLACE INTO program ( chanid, title, subtitle, description, category, category_type, starttime, endtime, closecaptioned, stereo, hdtv, subtitled, subtitletypes, audioprop, videoprop, partnumber, parttotal, syndicatedepisodenumber, airdate, originalairdate,listingsource, seriesid, programid, previouslyshown, stars, showtype, title_pronounce, colorcode, season, episode, totalepisodes, inetref ) VALUES( '10769', 'Tatort', 'Kaputt', 'Eigentlich sollten die Polizisten Melanie Sommer (Anna Brüggemann) und Frank Schneider bei einer lauten Feier in einem Wohnhaus nur für Ruhe sorgen. Doch wenig später wird die junge Kriminalbeamtin verletzt und traumatisiert im Garten des Hauses aufgefunden. Ihr Kollege wurde so brutal zusammengeschlagen, dass für ihn jede Hilfe zu spät kommt. Der Polizistenmord sorgt nicht nur im Präsidium und in der Presse für Aufregung. Auch Frank Schneiders Lebensgefährte Stefan Pohl (Max Simonischek) kann den Verlust nicht fassen: Die beiden hatten sich im Dienst kennengelernt. Die Beziehung sah der Dienststellenleiter Bernd Schäfer (Götz Schubert) nicht gern. Auch, dass die Mordkommission jetzt die eigenen Leute überprüft, passt ihm gar nicht ...', 'movie', 'movie', '2019-06-10T18:15:00Z', '2019-06-10T19:45:00Z', 'false', 'false', 'false', 'false', '0', '8', '0', '0', '0', '', '2019', '', '4', '94942868', 'MV94942868', 'false', '0', '', 'Tatort'PRON, '', '0', '0', '0', '' ) <<<< Took 1ms
2019-05-23 12:24:37.028566 I [4884/4884] CoreContext mythdbcon.cpp:716 (exec) - MSqlQuery::exec(DBManager1) SELECT count(*) FROM program WHERE chanid = '10769' AND starttime = '2019-06-10T23:30:00Z' AND endtime = '2019-06-11T01:00:00Z' AND title = 'Tatort' AND subtitle = 'Kaputt' AND description = '' AND category = 'movie' AND category_type = 'movie'_TYPE AND airdate = '2019' AND stars >= ('0' - 0.001) AND stars <= ('0' + 0.001) AND previouslyshown = 'false' AND title_pronounce = 'Tatort'_PRONOUNCE AND audioprop = '8' AND videoprop = '0' AND subtitletypes = '0' AND partnumber = '0' AND parttotal = '0' AND seriesid = '94942868' AND showtype = '' AND colorcode = '' AND syndicatedepisodenumber = '' AND programid = 'MV94942868' AND inetref = '' <<<< Took 2ms, Returned 1 row(s)
2019-05-23 12:24:37.036602 I [4884/4884] CoreContext mythdbcon.cpp:716 (exec) - MSqlQuery::exec(DBManager1) REPLACE INTO program ( chanid, title, subtitle, description, category, category_type, starttime, endtime, closecaptioned, stereo, hdtv, subtitled, subtitletypes, audioprop, videoprop, partnumber, parttotal, syndicatedepisodenumber, airdate, originalairdate,listingsource, seriesid, programid, previouslyshown, stars, showtype, title_pronounce, colorcode, season, episode, totalepisodes, inetref ) VALUES( '10769', 'Tatort', 'Kaputt', '', 'movie', 'movie', '2019-06-10T23:30:00Z', '2019-06-11T01:00:00Z', 'false', 'false', 'false', 'false', '0', '8', '0', '0', '0', '', '2019', '', '4', '94942868', 'MV94942868', 'false', '0', '', 'Tatort'PRON, '', '0', '0', '0', '' ) <<<< Took 1ms
2019-05-23 12:24:59.463985 I [4884/4884] CoreContext mythdbcon.cpp:716 (exec) - MSqlQuery::exec(DBManager1) SELECT count(*) FROM program WHERE chanid = '10994' AND starttime = '2019-06-05T20:00:00Z' AND endtime = '2019-06-05T21:25:00Z' AND title = 'Tatort' AND subtitle = 'Bienzle und der Tag der Rache' AND description = '10.03.2002 Das Erste' AND category = 'movie' AND category_type = 'movie'_TYPE AND airdate = '2002' AND stars >= ('0' - 0.001) AND stars <= ('0' + 0.001) AND previouslyshown = 'false' AND title_pronounce = 'Tatort'_PRONOUNCE AND audioprop = '0' AND videoprop = '2' AND subtitletypes = '0' AND partnumber = '0' AND parttotal = '0' AND seriesid = '94942868' AND showtype = '' AND colorcode = '' AND syndicatedepisodenumber = '' AND programid = 'MV94942868' AND inetref = '' <<<< Took 2ms, Returned 1 row(s)
2019-05-23 12:24:59.475491 I [4884/4884] CoreContext mythdbcon.cpp:716 (exec) - MSqlQuery::exec(DBManager1) REPLACE INTO program ( chanid, title, subtitle, description, category, category_type, starttime, endtime, closecaptioned, stereo, hdtv, subtitled, subtitletypes, audioprop, videoprop, partnumber, parttotal, syndicatedepisodenumber, airdate, originalairdate,listingsource, seriesid, programid, previouslyshown, stars, showtype, title_pronounce, colorcode, season, episode, totalepisodes, inetref ) VALUES( '10994', 'Tatort', 'Bienzle und der Tag der Rache', '10.03.2002 Das Erste', 'movie', 'movie', '2019-06-05T20:00:00Z', '2019-06-05T21:25:00Z', 'false', 'false', 'false', 'false', '0', '0', '2', '0', '0', '', '2002', '', '4', '94942868', 'MV94942868', 'false', '0', '', 'Tatort'PRON, '', '0', '0', '0', '' ) <<<< Took 1ms
Can anybody help me here or am I on my own? I could of course add an sql call that just eliminates the offending programids to my cron job but I'd prefer a more elegant (and robust) method. I'm at my wit's end for what to search for though.