[gelöst] epgd + eigene eventsview

TheChief · 14. November 2015

Ich meinte eigentlich, dass du das Statement aus deiner sql datei mal auf der mysql kommandozeile ausführst. Dann sollten ja eventuelle Fehler ausgegeben werden.

Perlbo · 14. November 2015

Zitat von TheChief

Ich meinte eigentlich, dass du das Statement aus deiner sql datei mal auf der mysql kommandozeile ausführst. Dann sollten ja eventuelle Fehler ausgegeben werden.

Ähm... mysql Neuland ... da brauch in kurz Definition Statement und vielleicht ein Beispiel .. oh ich weiß ich bin anstrengend ... sorry ...

TheChief · 14. November 2015

Na der Inhalt der SQL-Datei, die du hier anhängst, beihaltet ein SQL-Statement. Quasi Datenbanksprache.

Perlbo · 14. November 2015

Zitat von TheChief

Na der Inhalt der SQL-Datei, die du hier anhängst, beihaltet ein SQL-Statement. Quasi Datenbanksprache.

so ?

Code

mysql> CREATE VIEW eventsview as select sub.masterid as useid, cnt.eventid, cnt.channelid, cnt.source, GREATEST(cnt.updsp,sub.updsp,IFNULL(epi.updsp,0)) updsp, cnt.updflg, cnt.delflg, cnt.fileref, cnt.tableid, cnt.version, sub.title,
    -> case
    ->  when sub.shorttext is null then
    ->   case when sub.genre is null then '' else concat(sub.genre,' (', sub.country, ' ',sub.year, ')') end
    ->   else
    ->   case when epi.season is null then
    ->     sub.shorttext
    ->   else
    ->     concat('(S', lpad(format(epi.season, 0), 2, '0'), 'E', lpad(format(epi.part, 0), 2, '0'), ') ', epi.partname)
    ->   end
    -> end shorttext,
    -> cnt.starttime, cnt.duration, cnt.parentalrating, cnt.vps, replace(
    -> concat(
    ->   TRIM(LEADING '|' FROM
    ->    concat(
    ->     case when sub.genre is Null then '' else concat('|','Genre: ',sub.genre) end,
    ->     case when sub.category is Null then '' else concat('|','Kategorie: ',sub.category) end,
    ->     case when sub.country is Null then '' else concat('|','Land: ',sub.country) end,
    ->     case when sub.year is Null then '' else concat('|','Jahr: ',substring(sub.year,1,4)) end
    ->    )
    ->   ),
    ->   concat(
    ->     case when sub.shortdescription is Null then '' else concat('||',sub.shortdescription) end,
    ->     case when sub.shortreview is Null then '' else concat('||','Kurzkritik: ',sub.shortreview) end,
    ->     case when sub.tipp is Null and sub.rating is Null then '' else '||' end,
    ->     case when sub.tipp is Null then '' else concat('|',sub.tipp) end,
    ->     case when sub.rating is Null then '' else concat('|',sub.rating) end,
    ->     case when sub.topic is Null then '' else concat('||','Thema: ',sub.topic) end,
    ->     case when sub.longdescription is Null then '' else concat('||',sub.longdescription) end,
    ->     case when sub.info is Null then '' else concat('||','Info: ',sub.info) end,
    ->     case when sub.moderator is Null then '' else concat('||','Moderator: ',sub.moderator) end,
    ->     case when sub.guest is Null then '' else concat('|','Gäste: ',sub.guest) end,
    ->     case when cnt.parentalrating is Null or cnt.parentalrating = 0 then '' else concat('||','Altersempfehlung: ab ',cnt.parentalrating) end,
    ->     case when sub.actor is Null and sub.producer is Null and sub.other is Null then '' else '|' end,
    ->     case when sub.actor is Null then '' else concat('|','Darsteller: ',sub.actor) end,
    ->     case when sub.producer is Null then '' else concat('|','Produzent: ',sub.producer) end,
    ->     case when sub.other is Null then '' else concat('|','Sonstige: ',sub.other) end,
    ->     case when sub.director is Null and sub.screenplay is Null  and sub.camera is Null and sub.music is Null and sub.audio is Null and sub.flags is Null then '' else '|' end,
    ->     case when sub.director is Null then '' else concat('|','Regie: ',sub.director) end,
    ->     case when sub.screenplay is Null then '' else concat('|','Drehbuch: ',sub.screenplay) end,
    ->     case when sub.camera is Null then '' else concat('|','Kamera: ',sub.camera) end,
    ->     case when sub.music is Null then '' else concat('|','Musik: ',sub.music) end,
    ->     case when sub.audio is Null then '' else concat('|','Audio: ',sub.audio) end,
    ->     case when sub.flags is Null then '' else concat('|','Flags: ',sub.flags) end,
    ->     case when epi.episodename is Null then '' else concat('||','Serie: ',epi.episodename) end,
    ->     case when epi.shortname is Null then '' else concat('|','Kurzname: ',epi.shortname) end,
    ->     case when epi.partname is Null then '' else concat('|','Episode: ',epi.partname) end,
    ->     case when epi.extracol1 is Null then '' else concat('|',epi.extracol1) end,
    ->     case when epi.extracol2 is Null then '' else concat('|',epi.extracol2) end,
    ->     case when epi.extracol3 is Null then '' else concat('|',epi.extracol3) end,
    ->     case when epi.season is Null then '' else concat('|','Staffel: ',cast(epi.season as char)) end,
    ->     case when epi.part is Null then '' else concat('|','Staffelfolge: ',cast(epi.part as char)) end,
    ->     case when epi.part is Null then '' else concat('|','Staffelfolgen: ',cast(epi.parts as char)) end,
    ->     case when epi.number is Null then '' else concat('|','Folge: ',cast(epi.number as char)) end,
    ->     case when cnt.source <> sub.source then concat('||','Quelle: ',upper(replace(cnt.source,'vdr','dvb')),'/',upper(sub.source)) else concat('||','Quelle: ',upper(replace(cnt.source,'vdr','dvb'))) end
    ->   )
    -> )
    -> ,'|', '
    '> ') as description
    -> from
    ->  events cnt
    ->  inner join events sub on (case when cnt.useid = 0 then cnt.masterid else cnt.useid end = sub.masterid)
    ->  left outer join episodes epi on (sub.episodecompname = epi.compname and sub.episodecomppartname = epi.comppartname and sub.episodelang = epi.lang);
ERROR 1054 (42S22): Unknown column 'sub.episodecompname' in 'on clause'

Alles anzeigen

TheChief · 14. November 2015

Der Fehler steht ja in der letzten Zeile. Mach mal die Änderung

Code

left outer join episodes epi on (sub.episodecompname = epi.compname and sub.episodecomppartname = epi.comppartname and sub.episodelang = epi.lang)

rückängig und ersetz die zeile mit der aus deinem ersten post.

Code

left outer join episodes epi on (sub.episode = epi.compname and sub.episodepart = epi.comppartname and sub.episodelang = epi.lang);

Perlbo · 14. November 2015

Da bekomme ich das:

Code

mysql> CREATE VIEW eventsview as select sub.masterid as useid, cnt.eventid, cnt.channelid, cnt.source, GREATEST(cnt.updsp,sub.updsp,IFNULL(epi.updsp,0)) updsp, cnt.updflg, cnt.delflg, cnt.fileref, cnt.tableid, cnt.version, sub.title,
    -> case
    ->  when sub.shorttext is null then
    ->   case when sub.genre is null then '' else concat(sub.genre,' (', sub.country, ' ',sub.year, ')') end
    ->   else
    ->   case when epi.season is null then
    ->     sub.shorttext
    ->   else
    ->     concat('(S', lpad(format(epi.season, 0), 2, '0'), 'E', lpad(format(epi.part, 0), 2, '0'), ') ', epi.partname)
    ->   end
    -> end shorttext,
    -> cnt.starttime, cnt.duration, cnt.parentalrating, cnt.vps, replace(
    -> concat(
    ->   TRIM(LEADING '|' FROM
    ->    concat(
    ->     case when sub.genre is Null then '' else concat('|','Genre: ',sub.genre) end,
    ->     case when sub.category is Null then '' else concat('|','Kategorie: ',sub.category) end,
    ->     case when sub.country is Null then '' else concat('|','Land: ',sub.country) end,
    ->     case when sub.year is Null then '' else concat('|','Jahr: ',substring(sub.year,1,4)) end
    ->    )
    ->   ),
    ->   concat(
    ->     case when sub.shortdescription is Null then '' else concat('||',sub.shortdescription) end,
    ->     case when sub.shortreview is Null then '' else concat('||','Kurzkritik: ',sub.shortreview) end,
    ->     case when sub.tipp is Null and sub.rating is Null then '' else '||' end,
    ->     case when sub.tipp is Null then '' else concat('|',sub.tipp) end,
    ->     case when sub.rating is Null then '' else concat('|',sub.rating) end,
    ->     case when sub.topic is Null then '' else concat('||','Thema: ',sub.topic) end,
    ->     case when sub.longdescription is Null then '' else concat('||',sub.longdescription) end,
    ->     case when sub.info is Null then '' else concat('||','Info: ',sub.info) end,
    ->     case when sub.moderator is Null then '' else concat('||','Moderator: ',sub.moderator) end,
    ->     case when sub.guest is Null then '' else concat('|','Gäste: ',sub.guest) end,
    ->     case when cnt.parentalrating is Null or cnt.parentalrating = 0 then '' else concat('||','Altersempfehlung: ab ',cnt.parentalrating) end,
    ->     case when sub.actor is Null and sub.producer is Null and sub.other is Null then '' else '|' end,
    ->     case when sub.actor is Null then '' else concat('|','Darsteller: ',sub.actor) end,
    ->     case when sub.producer is Null then '' else concat('|','Produzent: ',sub.producer) end,
    ->     case when sub.other is Null then '' else concat('|','Sonstige: ',sub.other) end,
    ->     case when sub.director is Null and sub.screenplay is Null  and sub.camera is Null and sub.music is Null and sub.audio is Null and sub.flags is Null then '' else '|' end,
    ->     case when sub.director is Null then '' else concat('|','Regie: ',sub.director) end,
    ->     case when sub.screenplay is Null then '' else concat('|','Drehbuch: ',sub.screenplay) end,
    ->     case when sub.camera is Null then '' else concat('|','Kamera: ',sub.camera) end,
    ->     case when sub.music is Null then '' else concat('|','Musik: ',sub.music) end,
    ->     case when sub.audio is Null then '' else concat('|','Audio: ',sub.audio) end,
    ->     case when sub.flags is Null then '' else concat('|','Flags: ',sub.flags) end,
    ->     case when epi.episodename is Null then '' else concat('||','Serie: ',epi.episodename) end,
    ->     case when epi.shortname is Null then '' else concat('|','Kurzname: ',epi.shortname) end,
    ->     case when epi.partname is Null then '' else concat('|','Episode: ',epi.partname) end,
    ->     case when epi.extracol1 is Null then '' else concat('|',epi.extracol1) end,
    ->     case when epi.extracol2 is Null then '' else concat('|',epi.extracol2) end,
    ->     case when epi.extracol3 is Null then '' else concat('|',epi.extracol3) end,
    ->     case when epi.season is Null then '' else concat('|','Staffel: ',cast(epi.season as char)) end,
    ->     case when epi.part is Null then '' else concat('|','Staffelfolge: ',cast(epi.part as char)) end,
    ->     case when epi.part is Null then '' else concat('|','Staffelfolgen: ',cast(epi.parts as char)) end,
    ->     case when epi.number is Null then '' else concat('|','Folge: ',cast(epi.number as char)) end,
    ->     case when cnt.source <> sub.source then concat('||','Quelle: ',upper(replace(cnt.source,'vdr','dvb')),'/',upper(sub.source)) else concat('||','Quelle: ',upper(replace(cnt.source,'vdr','dvb'))) end
    ->   )
    -> )
    -> ,'|', '
    '> ') as description
    -> from
    ->  events cnt
    ->  inner join events sub on (case when cnt.useid = 0 then cnt.masterid else cnt.useid end = sub.masterid)
    ->  left outer join episodes epi on (sub.episode = epi.compname and sub.episodepart = epi.comppartname and sub.episodelang = epi.lang); 
ERROR 1050 (42S01): Table 'eventsview' already exists

Alles anzeigen

TheChief · 14. November 2015

Kannst ja vorher ein drop view eventsview; machen und danach das Statement ausführen. Danach mal epgd neustarten und das log beobachen. Wenn da alles guu aussieht, ist auch der View in Ordnung. Dann muss das Problem woanders liegen.

Kannst ja sonst nochmal select shorttext from eventsview where title='Family Guy'; ausführen.

Perlbo · 14. November 2015

So nach einem Drop:

Code

mysql> CREATE VIEW eventsview as select sub.masterid as useid, cnt.eventid, cnt.channelid, cnt.source, GREATEST(cnt.updsp,sub.updsp,IFNULL(epi.updsp,0)) updsp, cnt.updflg, cnt.delflg, cnt.fileref, cnt.tableid, cnt.version, sub.title,
    -> case
    ->  when sub.shorttext is null then
    ->   case when sub.genre is null then '' else concat(sub.genre,' (', sub.country, ' ',sub.year, ')') end
    ->   else
    ->   case when epi.season is null then
    ->     sub.shorttext
    ->   else
    ->     concat('(S', lpad(format(epi.season, 0), 2, '0'), 'E', lpad(format(epi.part, 0), 2, '0'), ') ', epi.partname)
    ->   end
    -> end shorttext,
    -> cnt.starttime, cnt.duration, cnt.parentalrating, cnt.vps, replace(
    -> concat(
    ->   TRIM(LEADING '|' FROM
    ->    concat(
    ->     case when sub.genre is Null then '' else concat('|','Genre: ',sub.genre) end,
    ->     case when sub.category is Null then '' else concat('|','Kategorie: ',sub.category) end,
    ->     case when sub.country is Null then '' else concat('|','Land: ',sub.country) end,
    ->     case when sub.year is Null then '' else concat('|','Jahr: ',substring(sub.year,1,4)) end
    ->    )
    ->   ),
    ->   concat(
    ->     case when sub.shortdescription is Null then '' else concat('||',sub.shortdescription) end,
    ->     case when sub.shortreview is Null then '' else concat('||','Kurzkritik: ',sub.shortreview) end,
    ->     case when sub.tipp is Null and sub.rating is Null then '' else '||' end,
    ->     case when sub.tipp is Null then '' else concat('|',sub.tipp) end,
    ->     case when sub.rating is Null then '' else concat('|',sub.rating) end,
    ->     case when sub.topic is Null then '' else concat('||','Thema: ',sub.topic) end,
    ->     case when sub.longdescription is Null then '' else concat('||',sub.longdescription) end,
    ->     case when sub.info is Null then '' else concat('||','Info: ',sub.info) end,
    ->     case when sub.moderator is Null then '' else concat('||','Moderator: ',sub.moderator) end,
    ->     case when sub.guest is Null then '' else concat('|','Gäste: ',sub.guest) end,
    ->     case when cnt.parentalrating is Null or cnt.parentalrating = 0 then '' else concat('||','Altersempfehlung: ab ',cnt.parentalrating) end,
    ->     case when sub.actor is Null and sub.producer is Null and sub.other is Null then '' else '|' end,
    ->     case when sub.actor is Null then '' else concat('|','Darsteller: ',sub.actor) end,
    ->     case when sub.producer is Null then '' else concat('|','Produzent: ',sub.producer) end,
    ->     case when sub.other is Null then '' else concat('|','Sonstige: ',sub.other) end,
    ->     case when sub.director is Null and sub.screenplay is Null  and sub.camera is Null and sub.music is Null and sub.audio is Null and sub.flags is Null then '' else '|' end,
    ->     case when sub.director is Null then '' else concat('|','Regie: ',sub.director) end,
    ->     case when sub.screenplay is Null then '' else concat('|','Drehbuch: ',sub.screenplay) end,
    ->     case when sub.camera is Null then '' else concat('|','Kamera: ',sub.camera) end,
    ->     case when sub.music is Null then '' else concat('|','Musik: ',sub.music) end,
    ->     case when sub.audio is Null then '' else concat('|','Audio: ',sub.audio) end,
    ->     case when sub.flags is Null then '' else concat('|','Flags: ',sub.flags) end,
    ->     case when epi.episodename is Null then '' else concat('||','Serie: ',epi.episodename) end,
    ->     case when epi.shortname is Null then '' else concat('|','Kurzname: ',epi.shortname) end,
    ->     case when epi.partname is Null then '' else concat('|','Episode: ',epi.partname) end,
    ->     case when epi.extracol1 is Null then '' else concat('|',epi.extracol1) end,
    ->     case when epi.extracol2 is Null then '' else concat('|',epi.extracol2) end,
    ->     case when epi.extracol3 is Null then '' else concat('|',epi.extracol3) end,
    ->     case when epi.season is Null then '' else concat('|','Staffel: ',cast(epi.season as char)) end,
    ->     case when epi.part is Null then '' else concat('|','Staffelfolge: ',cast(epi.part as char)) end,
    ->     case when epi.part is Null then '' else concat('|','Staffelfolgen: ',cast(epi.parts as char)) end,
    ->     case when epi.number is Null then '' else concat('|','Folge: ',cast(epi.number as char)) end,
    ->     case when cnt.source <> sub.source then concat('||','Quelle: ',upper(replace(cnt.source,'vdr','dvb')),'/',upper(sub.source)) else concat('||','Quelle: ',upper(replace(cnt.source,'vdr','dvb'))) end
    ->   )
    -> )
    -> ,'|', '
    '> ') as description
    -> from
    ->  events cnt
    ->  inner join events sub on (case when cnt.useid = 0 then cnt.masterid else cnt.useid end = sub.masterid)
    ->  left outer join episodes epi on (sub.episode = epi.compname and sub.episodepart = epi.comppartname and sub.episodelang = epi.lang); 
Query OK, 0 rows affected (0.01 sec)

Alles anzeigen

Log:

Code

Nov 14 21:45:09 yavdr vdr: [32564] epg data writer thread started (pid=1066, tid=32564, prio=low)
Nov 14 21:45:09 yavdr vdr: [32564] epg data writer thread ended (pid=1066, tid=32564)
Nov 14 21:45:28 yavdr epgd: Set locale to 'de_DE.UTF-8'
Nov 14 21:45:28 yavdr epgd: detected UTF-8
Nov 14 21:45:28 yavdr epgd: Loading uuid from '/etc/epgd/uuid' succeeded [A071A7DE-1AAD-4453-AA2E-4B2EA4411832]
Nov 14 21:45:28 yavdr epgd: Loading plugin: /usr/lib/epgd/plugins/libepgd-tvm.so
Nov 14 21:45:28 yavdr epgd: Loading plugin: /usr/lib/epgd/plugins/libepgd-epgdata.so
Nov 14 21:45:28 yavdr epgd: Read 26 option from /etc/epgd/epgd.conf
Nov 14 21:45:28 yavdr epgd: Info: Stylesheet '/etc/epgd/tvmovie-utf-8.xsl' loaded
Nov 14 21:45:28 yavdr epgd: Info: Stylesheet '/etc/epgd/epgdata-utf-8.xsl' loaded
Nov 14 21:45:28 yavdr epgd: SQL client character now 'utf8'
Nov 14 21:45:28 yavdr epgd: State now 'init'
Nov 14 21:45:28 yavdr epgd: Loading '/etc/epgd/channelmap.conf'
Nov 14 21:45:28 yavdr epgd: 56 channel mappings read.
Nov 14 21:45:28 yavdr epgd: using scrapping language de
Nov 14 21:45:29 yavdr epgd: tvdb scraper connected
Nov 14 21:45:29 yavdr epgd: moviedb scraper connected
Nov 14 21:45:29 yavdr epgd: Scheduled next update in 10 second(s)
Nov 14 21:45:29 yavdr epgd: State now 'standby'
Nov 14 21:45:39 yavdr epgd: State now 'busy (events)'
Nov 14 21:45:39 yavdr epgd: Starting cleanup of events
Nov 14 21:45:39 yavdr epgd: Delete fileref [substr(name,1,8) <= '20151113']
Nov 14 21:45:39 yavdr epgd: Delete events [starttime+duration < 1447512339]
Nov 14 21:45:39 yavdr epgd: Cleanup of events finished
Nov 14 21:45:39 yavdr epgd: EPG Update started
Nov 14 21:45:39 yavdr epgd: Updating 'tvm' day today+0 now
Nov 14 21:45:39 yavdr epgd: Checking tvm id 1
Nov 14 21:45:39 yavdr epgd: Checking tvm id 11
Nov 14 21:45:40 yavdr epgd: Checking tvm id 123
Nov 14 21:45:40 yavdr epgd: Checking tvm id 13
Nov 14 21:45:40 yavdr epgd: Checking tvm id 137
Nov 14 21:45:40 yavdr epgd: Checking tvm id 2
Nov 14 21:45:40 yavdr epgd: Checking tvm id 238
Nov 14 21:45:40 yavdr epgd: Checking tvm id 294
Nov 14 21:45:40 yavdr epgd: Checking tvm id 3
Nov 14 21:45:40 yavdr epgd: Checking tvm id 31
Nov 14 21:45:40 yavdr epgd: Checking tvm id 318
Nov 14 21:45:40 yavdr epgd: Checking tvm id 38
Nov 14 21:45:40 yavdr epgd: Checking tvm id 39
Nov 14 21:45:40 yavdr epgd: Checking tvm id 4
Nov 14 21:45:40 yavdr epgd: Checking tvm id 427
Nov 14 21:45:40 yavdr epgd: Checking tvm id 43
Nov 14 21:45:40 yavdr epgd: Checking tvm id 430
Nov 14 21:45:41 yavdr epgd: Checking tvm id 436
Nov 14 21:45:41 yavdr epgd: Checking tvm id 46
Nov 14 21:45:41 yavdr epgd: Checking tvm id 52
Nov 14 21:45:41 yavdr epgd: Checking tvm id 55
Nov 14 21:45:41 yavdr epgd: Checking tvm id 60
Nov 14 21:45:41 yavdr epgd: Checking tvm id 76
Nov 14 21:45:41 yavdr epgd: Checking tvm id 9
Nov 14 21:45:41 yavdr epgd: Updating 'epgdata' day today+0 now
Nov 14 21:45:41 yavdr epgd: Updating 'tvm' day today+1 now
Nov 14 21:45:41 yavdr epgd: Skipping day 1 for TVM plugin, since all days ar performed on day 0
Nov 14 21:45:41 yavdr epgd: Updating 'epgdata' day today+1 now
Nov 14 21:45:41 yavdr epgd: Updating 'tvm' day today+2 now
Nov 14 21:45:41 yavdr epgd: Skipping day 2 for TVM plugin, since all days ar performed on day 0
Nov 14 21:45:41 yavdr epgd: Updating 'epgdata' day today+2 now
Nov 14 21:45:41 yavdr epgd: EPG Update finished, loaded 0 files (0.000 KB), 27 non-updates skipped, 0 rejected due to format error.
Nov 14 21:45:41 yavdr epgd: Starting episode download ...
Nov 14 21:45:42 yavdr epgd: SVDRPCL: Error connecting to eplists.constabel.net:2006: Connection refused
Nov 14 21:45:42 yavdr epgd: Open connection to 'eplists.constabel.net' failed, aborting transfer!
Nov 14 21:45:42 yavdr epgd: Starting episode lookup ...
Nov 14 21:45:42 yavdr epgd: Lookup done for 0 series, matched 0 parts by compare and 0 parts by lv in 0 seconds; Updated 0
Nov 14 21:45:42 yavdr epgd: Calling 'mergeepg'
Nov 14 21:45:42 yavdr epgd: 'mergeepg' suceeded
Nov 14 21:45:42 yavdr epgd: State now 'busy (images)'
Nov 14 21:45:42 yavdr epgd: Starting cleanup of imagerefs
Nov 14 21:45:42 yavdr epgd: Starting cleanup of images
Nov 14 21:45:42 yavdr epgd: Image cleanup finished
Nov 14 21:45:42 yavdr epgd: Start download of new images
Nov 14 21:45:42 yavdr epgd: Still updating images, now 500 of 3805 checked and 0 loaded (0.000 KB)
Nov 14 21:45:42 yavdr epgd: Still updating images, now 1000 of 3805 checked and 0 loaded (0.000 KB)
Nov 14 21:45:42 yavdr epgd: Still updating images, now 1500 of 3805 checked and 0 loaded (0.000 KB)
Nov 14 21:45:43 yavdr epgd: Still updating images, now 2000 of 3805 checked and 0 loaded (0.000 KB)
Nov 14 21:45:43 yavdr epgd: Still updating images, now 2500 of 3805 checked and 0 loaded (0.000 KB)
Nov 14 21:45:43 yavdr epgd: Still updating images, now 3000 of 3805 checked and 0 loaded (0.000 KB)
Nov 14 21:45:43 yavdr epgd: Still updating images, now 3500 of 3805 checked and 0 loaded (0.000 KB)
Nov 14 21:45:43 yavdr epgd: Loaded 0 images (0.000 KB), checked 3805; 10 failed to load in 1 seconds
Nov 14 21:45:43 yavdr epgd: Starting cleanup of epgdata zip's in '/var/cache/epgd/epgdata'
Nov 14 21:45:43 yavdr epgd: Cleanup finished, removed (0) epgdata files
Nov 14 21:45:43 yavdr epgd: State now 'busy (scraping)'
Nov 14 21:45:48 yavdr vdr: scraper2vdr: epgd busy, trying again in 60 seconds ...
Nov 14 21:45:49 yavdr vdr: video: slow down video, duping frame
Nov 14 21:45:49 yavdr vdr: video:  2:33:19.972  +56  319   0/\ms  34+7 v-buf
Nov 14 21:45:54 yavdr epgd: Starting tvscraper scrap process
Nov 14 21:45:54 yavdr epgd: Scraping new series and episodes
Nov 14 21:45:54 yavdr epgd: 13 updated Series, 170 updatedEpisodes
Nov 14 21:45:54 yavdr epgd: 2 series to update in db, 0 episodes to update in db
Nov 14 21:45:58 yavdr epgd: ReScraped 2 series
Nov 14 21:45:58 yavdr epgd: Update of series and episodes done in 4 s, downloaded 0.000 KB
Nov 14 21:45:58 yavdr epgd: 2 new series events to scrap in db
Nov 14 21:46:00 yavdr epgd: 2 series episodes scraped in 2 s, downloaded 93.350 KB
Nov 14 21:46:00 yavdr epgd: Scraping new movies
Nov 14 21:46:00 yavdr epgd: 0 new movies to scrap in db
Nov 14 21:46:00 yavdr epgd: 0 movies scraped in 0 s, downloaded 0.000 KB
Nov 14 21:46:00 yavdr epgd: cleaning up series...
Nov 14 21:46:01 yavdr epgd: 0 outdated series deleted
Nov 14 21:46:01 yavdr epgd: cleaning up movies...
Nov 14 21:46:01 yavdr epgd: 0 outdated movies deleted
Nov 14 21:46:01 yavdr epgd: Scheduled next update in 2 hour(s)
Nov 14 21:46:01 yavdr epgd: State now 'standby'
Nov 14 21:46:09 yavdr vdr: epg2vdr: --- EPG update started ---
Nov 14 21:46:09 yavdr vdr: epg2vdr: Starting cleanup of images in '/var/cache/vdr/epgimages'
Nov 14 21:46:09 yavdr vdr: epg2vdr: Remove old symlinks
Nov 14 21:46:09 yavdr vdr: epg2vdr: Cleanup finished, removed (5) images and (7) symlinks
Nov 14 21:46:09 yavdr vdr: epg2vdr: Update EPG, loading changes since 14.11.2015 21:25:08
Nov 14 21:46:09 yavdr vdr: epg2vdr: Updated changes since '14.11.2015 21:25:08'; 34 channels, 45 events (0 deletions) in 0.136 seconds
Nov 14 21:46:10 yavdr vdr: epg2vdr: Load images from database
Nov 14 21:46:10 yavdr vdr: epg2vdr: Got 0 images from database in 0 seconds (0 updates, 0 new)
Nov 14 21:46:10 yavdr vdr: epg2vdr: --- EPG update finished ---
Nov 14 21:46:39 yavdr vdr: video: slow down video, duping frame
Nov 14 21:46:39 yavdr vdr: video:  2:34:09.972  +56  399   0/\ms  41+7 v-buf
N

Alles anzeigen

Code

mysql> select shorttext from eventsview where title='castle';
+-----------------------------------------------+
| shorttext                                     |
+-----------------------------------------------+
| Todesfall in der Familie                      |
| Die Pizza-Connection                          |
| Das Fenster zum Hof                           |
| Wachtel oder Täubchen                         |
| Wachtel oder Täubchen                         |
| Stillstand                                    |
| Stillstand, Crime-Serie, USA 2013             |
| Der menschliche Faktor, Crime-Serie, USA 2013 |
| Todesfall in der Familie                      |
| Die Pizza-Connection                          |
| Das Fenster zum Hof                           |
| Wachtel oder Täubchen                         |
| Wachtel oder Täubchen                         |
| Stillstand, Crime-Serie, USA 2013             |
| Stillstand                                    |
| Der menschliche Faktor                        |
| Der menschliche Faktor                        |
| Für Höheres bestimmt                          |
| Für Höheres bestimmt                          |
| Blumen für dein Grab                          |
| Tödliche Schulden                             |
| Die Late Night Jungs                          |
| Tödliche Schulden                             |
| Die Late Night Jungs                          |
| Blumen für dein Grab                          |
| Die tote Nanny                                |
| Die tote Nanny                                |
| Die Eliten-Clique                             |
| Die Eliten-Clique                             |
| Die Hölle kennt keine Wut                     |
| Die Hölle kennt keine Wut                     |
| Gefrorenes Blut                               |
| Gefrorenes Blut                               |
| Voodoo                                        |
| Mord im Weltall                               |
| Akte X                                        |
| Die Pizza-Connection                          |
| Todesfall in der Familie                      |
| Wachtel oder Täubchen                         |
| Das Fenster zum Hof                           |
+-----------------------------------------------+
40 rows in set (0.10 sec)




mysql> select shorttext from eventsview where title='Family Guy';
+-------------------------------------+
| shorttext                           |
+-------------------------------------+
| Alles vergessen                     |
| Queen Stewie                        |
| Die Leihmutter                      |
| XXL Medium                          |
| Jäger des schmutzigen Witzes        |
| Knastbraut Meg                      |
| XXL Medium                          |
| Die Zeitmaschine                    |
| Der Held von nebenan                |
| Die Leihmutter                      |
| Die Leihmutter                      |
| Jäger des schmutzigen Witzes        |
| Das Leben des Brian                 |
| Das Leben des Brian                 |
| Der Aufreiß-Kurs, Comedy, USA 2011  |
| Der Aufreiß-Kurs                    |
| Der Aufreiß-Kurs, Comedy, USA 2011  |
| Wege nach Vegas                     |
| Peter im Country Club               |
| 200 Episoden später                 |
| Wege nach Vegas                     |
| Peter im Country Club               |
| Zehn Hochzeiten und ein Problemfall |
| Zehn Hochzeiten und ein Problemfall |
| Die Schatzsuche                     |
| Die Schatzsuche                     |
| Der Urknall                         |
| Der Aufreiß-Kurs                    |
+-------------------------------------+
28 rows in set (0.09 sec)




mysql> select shorttext from eventsview where title='NCIS';
Empty set (0.10 sec)




mysql> select shorttext from eventsview where title='Mike & Molly';
+-------------------------------------------------------+
| shorttext                                             |
+-------------------------------------------------------+
| Fast hätte uns der Tod geschieden                     |
| Molly schreibt ein Buch, Comedy, USA 2014             |
| Molly ist enthaltsam, Comedy, USA 2014                |
| Molly schreibt ein Buch                               |
| Molly ist enthaltsam                                  |
| Alle tanzen nach Mollys Pfeife                        |
| Herrenausflug mit Damen                               |
| Alle tanzen nach Mollys Pfeife, Comedy, USA 2014      |
| Herrenausflug mit Damen, Comedy, USA 2014             |
| Mollys unendliche Geschichte, Comedy, USA 2015        |
| Und führe Mike nicht in Versuchung, Comedy, USA 2015  |
| Molly schreibt ein Buch                               |
| Molly ist enthaltsam                                  |
| Fast hätte uns der Tod geschieden                     |
| Molly schreibt ein Buch, Comedy, USA 2014             |
| Molly ist enthaltsam, Comedy, USA 2014                |
| Molly schreibt ein Buch                               |
| Molly ist enthaltsam                                  |
| Alle tanzen nach Mollys Pfeife                        |
| Herrenausflug mit Damen                               |
| Alle tanzen nach Mollys Pfeife                        |
| Herrenausflug mit Damen                               |
| Mollys unendliche Geschichte                          |
| Und führe Mike nicht in Versuchung                    |
| Mollys unendliche Geschichte                          |
| Und führe Mike nicht in Versuchung                    |
| Samuel braucht Geld                                   |
| Der Mike-Check                                        |
| Samuel braucht Geld                                   |
| Der Mike-Check                                        |
| Das Phänomen                                          |
| Joyce sieht rot                                       |
| Joyce sieht rot                                       |
| Der verbitterte Mann und der See                      |
| Molly sprengt die Ketten                              |
| Der verbitterte Mann und der See                      |
| Molly sprengt die Ketten                              |
| Sturmfreie Bude                                       |
| Die Welt der Peggy Biggs                              |
| Sturmfreie Bude                                       |
| Die Welt der Peggy Biggs                              |
| Die Buchpräsentation                                  |
| Peggys Geheimnis                                      |
| Die Buchpräsentation                                  |
| Peggys Geheimnis                                      |
| Kuchenschlacht                                        |
| Cocktails und Peinlichkeiten                          |
| Kuchenschlacht                                        |
| Cocktails und Peinlichkeiten                          |
| Die Reise nach Mudlick                                |
| Die Heldin ist müde                                   |
| Die Reise nach Mudlick                                |
| Die Heldin ist müde                                   |
| Die bessere Mutter aus Mudlick                        |
| Die letzten Zeilen                                    |
| Molly auf Streife                                     |
| Sex und Tod                                           |
| Fast hätte uns der Tod geschieden                     |
| Molly ist enthaltsam                                  |
| Molly schreibt ein Buch                               |
+-------------------------------------------------------+
60 rows in set (0.09 sec)

Alles anzeigen

TheChief · 14. November 2015

Code

-> case
    ->  when sub.shorttext is null then
    ->   case when sub.genre is null then '' else concat(sub.genre,' (', sub.country, ' ',sub.year, ')') end
    ->   else
    ->   case when epi.season is null then
    ->     sub.shorttext
    ->   else
    ->     concat('(S', lpad(format(epi.season, 0), 2, '0'), 'E', lpad(format(epi.part, 0), 2, '0'), ') ', epi.partname)
    ->   end
    -> end shorttext,

Dann funktioniert wohl das hier nicht richtig. Woher stammt das? Eventuell da mal schauen.

Perlbo · 14. November 2015

Zitat von TheChief

Code

-> case
    ->  when sub.shorttext is null then
    ->   case when sub.genre is null then '' else concat(sub.genre,' (', sub.country, ' ',sub.year, ')') end
    ->   else
    ->   case when epi.season is null then
    ->     sub.shorttext
    ->   else
    ->     concat('(S', lpad(format(epi.season, 0), 2, '0'), 'E', lpad(format(epi.part, 0), 2, '0'), ') ', epi.partname)
    ->   end
    -> end shorttext,

Dann funktioniert wohl das hier nicht richtig. Woher stammt das? Eventuell da mal schauen.

Habe hier noch Image mit yavdr wo das genau so läuft ??? Das ist ja das seltsame.

TheChief · 14. November 2015

Keine Ahnung, vielleicht ist die Tabelle leer?

select * from episodes limit 10;

Perlbo · 14. November 2015

Zitat von TheChief

select * from episodes limit 10;

exakt, so sieht es aus ...

mysql> select * from episodes limit 10;

Empty set (0.00 sec)

Aber warum ?

CKone · 14. November 2015

mach mal

Code

drop table episodes ;

dann legt er die Tabelle neu an und füllt sie komplett mit dem nächsten epgd lauf

Perlbo · 14. November 2015

Dann das:

Code

Nov 14 22:52:15 yavdr epgd: Set locale to 'de_DE.UTF-8'
Nov 14 22:52:15 yavdr epgd: detected UTF-8
Nov 14 22:52:15 yavdr epgd: Loading uuid from '/etc/epgd/uuid' succeeded [A071A7DE-1AAD-4453-AA2E-4B2EA4411832]
Nov 14 22:52:15 yavdr epgd: Loading plugin: /usr/lib/epgd/plugins/libepgd-tvm.so
Nov 14 22:52:15 yavdr epgd: Loading plugin: /usr/lib/epgd/plugins/libepgd-epgdata.so
Nov 14 22:52:15 yavdr epgd: Read 26 option from /etc/epgd/epgd.conf
Nov 14 22:52:15 yavdr epgd: Info: Stylesheet '/etc/epgd/tvmovie-utf-8.xsl' loaded
Nov 14 22:52:15 yavdr epgd: Info: Stylesheet '/etc/epgd/epgdata-utf-8.xsl' loaded
Nov 14 22:52:15 yavdr epgd: SQL client character now 'utf8'
Nov 14 22:52:15 yavdr epgd: State now 'init'
Nov 14 22:52:15 yavdr epgd: Initialy creating table 'episodes'
Nov 14 22:52:15 yavdr epgd: create table episodes(compname VARCHAR(100), comppartname VARCHAR(200), lang VARCHAR(10), inssp INT(11), updsp INT(11), link INT(11), shortname VARCHAR(100), episodename VARCHAR(100), partname VARCHAR(300), season INT(11), part INT(11), parts INT(11), number INT(11), extracol1 VARCHAR(250), extracol2 VARCHAR(250), extracol3 VARCHAR(250), comment VARCHAR(250), PRIMARY KEY(compname DESC, comppartname DESC, lang DESC)) ENGINE InnoDB;
Nov 14 22:52:15 yavdr epgd: create index idxupdsp on episodes(updsp);
Nov 14 22:52:15 yavdr epgd: Loading '/etc/epgd/channelmap.conf'
Nov 14 22:52:15 yavdr epgd: 56 channel mappings read.
Nov 14 22:52:15 yavdr epgd: using scrapping language de
Nov 14 22:52:16 yavdr epgd: tvdb scraper connected
Nov 14 22:52:16 yavdr epgd: moviedb scraper connected
Nov 14 22:52:16 yavdr epgd: Scheduled next update in 10 second(s)
Nov 14 22:52:16 yavdr epgd: State now 'standby'
Nov 14 22:52:26 yavdr epgd: State now 'busy (events)'
Nov 14 22:52:26 yavdr epgd: Starting cleanup of events
Nov 14 22:52:26 yavdr epgd: Delete fileref [substr(name,1,8) <= '20151113']
Nov 14 22:52:26 yavdr epgd: Delete events [starttime+duration < 1447516346]
Nov 14 22:52:26 yavdr epgd: Cleanup of events finished
Nov 14 22:52:26 yavdr epgd: EPG Update started
Nov 14 22:52:26 yavdr epgd: Updating 'tvm' day today+0 now
Nov 14 22:52:26 yavdr epgd: Checking tvm id 1
Nov 14 22:52:26 yavdr epgd: Checking tvm id 11
Nov 14 22:52:26 yavdr epgd: Checking tvm id 123
Nov 14 22:52:26 yavdr epgd: Checking tvm id 13
Nov 14 22:52:26 yavdr epgd: Checking tvm id 137
Nov 14 22:52:27 yavdr epgd: Checking tvm id 2
Nov 14 22:52:27 yavdr epgd: Checking tvm id 238
Nov 14 22:52:27 yavdr epgd: Checking tvm id 294
Nov 14 22:52:27 yavdr epgd: Checking tvm id 3
Nov 14 22:52:27 yavdr epgd: Checking tvm id 31
Nov 14 22:52:27 yavdr epgd: Checking tvm id 318
Nov 14 22:52:27 yavdr epgd: Checking tvm id 38
Nov 14 22:52:27 yavdr epgd: Checking tvm id 39
Nov 14 22:52:27 yavdr epgd: Checking tvm id 4
Nov 14 22:52:27 yavdr epgd: Checking tvm id 427
Nov 14 22:52:27 yavdr epgd: Checking tvm id 43
Nov 14 22:52:27 yavdr epgd: Checking tvm id 430
Nov 14 22:52:27 yavdr epgd: Checking tvm id 436
Nov 14 22:52:27 yavdr epgd: Checking tvm id 46
Nov 14 22:52:28 yavdr epgd: Checking tvm id 52
Nov 14 22:52:28 yavdr epgd: Checking tvm id 55
Nov 14 22:52:28 yavdr epgd: Checking tvm id 60
Nov 14 22:52:28 yavdr epgd: Checking tvm id 76
Nov 14 22:52:28 yavdr epgd: Checking tvm id 9
Nov 14 22:52:28 yavdr epgd: Updating 'epgdata' day today+0 now
Nov 14 22:52:28 yavdr epgd: Updating 'tvm' day today+1 now
Nov 14 22:52:28 yavdr epgd: Skipping day 1 for TVM plugin, since all days ar performed on day 0
Nov 14 22:52:28 yavdr epgd: Updating 'epgdata' day today+1 now
Nov 14 22:52:28 yavdr epgd: Updating 'tvm' day today+2 now
Nov 14 22:52:28 yavdr epgd: Skipping day 2 for TVM plugin, since all days ar performed on day 0
Nov 14 22:52:28 yavdr epgd: Updating 'epgdata' day today+2 now
Nov 14 22:52:28 yavdr epgd: EPG Update finished, loaded 0 files (0.000 KB), 27 non-updates skipped, 0 rejected due to format error.
Nov 14 22:52:28 yavdr epgd: Starting episode download ...
Nov 14 22:52:28 yavdr epgd: SVDRPCL: Error connecting to eplists.constabel.net:2006: Connection refused
Nov 14 22:52:28 yavdr epgd: Open connection to 'eplists.constabel.net' failed, aborting transfer!
Nov 14 22:52:28 yavdr epgd: Starting episode lookup ...
Nov 14 22:52:28 yavdr epgd: Lookup done for 0 series, matched 0 parts by compare and 0 parts by lv in 0 seconds; Updated 0
Nov 14 22:52:28 yavdr epgd: Calling 'mergeepg'
Nov 14 22:52:29 yavdr epgd: 'mergeepg' suceeded
Nov 14 22:52:29 yavdr epgd: State now 'busy (images)'
Nov 14 22:52:29 yavdr epgd: Starting cleanup of imagerefs
Nov 14 22:52:29 yavdr epgd: Starting cleanup of images
Nov 14 22:52:29 yavdr epgd: Image cleanup finished
Nov 14 22:52:29 yavdr epgd: Start download of new images
Nov 14 22:52:29 yavdr epgd: Still updating images, now 500 of 3787 checked and 0 loaded (0.000 KB)
Nov 14 22:52:29 yavdr epgd: Still updating images, now 1000 of 3787 checked and 0 loaded (0.000 KB)
Nov 14 22:52:29 yavdr epgd: Still updating images, now 1500 of 3787 checked and 0 loaded (0.000 KB)
Nov 14 22:52:29 yavdr vdr: video: slow down video, duping frame
Nov 14 22:52:29 yavdr vdr: video:  3:39:59.972  +56  319   0/\ms  31+7 v-buf
Nov 14 22:52:29 yavdr epgd: Still updating images, now 2000 of 3787 checked and 0 loaded (0.000 KB)
Nov 14 22:52:29 yavdr epgd: Still updating images, now 2500 of 3787 checked and 0 loaded (0.000 KB)
Nov 14 22:52:29 yavdr epgd: Still updating images, now 3000 of 3787 checked and 0 loaded (0.000 KB)
Nov 14 22:52:29 yavdr epgd: Still updating images, now 3500 of 3787 checked and 0 loaded (0.000 KB)
Nov 14 22:52:30 yavdr epgd: Loaded 0 images (0.000 KB), checked 3787; 10 failed to load in 1 seconds
Nov 14 22:52:30 yavdr epgd: Starting cleanup of epgdata zip's in '/var/cache/epgd/epgdata'
Nov 14 22:52:30 yavdr epgd: Cleanup finished, removed (0) epgdata files
Nov 14 22:52:30 yavdr epgd: State now 'busy (scraping)'
Nov 14 22:52:41 yavdr epgd: Starting tvscraper scrap process
Nov 14 22:52:41 yavdr epgd: Scraping new series and episodes
Nov 14 22:52:41 yavdr epgd: 2 updated Series, 0 updatedEpisodes
Nov 14 22:52:41 yavdr epgd: 1 series to update in db, 0 episodes to update in db
Nov 14 22:52:42 yavdr epgd: ReScraped 1 series
Nov 14 22:52:42 yavdr epgd: Update of series and episodes done in 1 s, downloaded 0.000 KB
Nov 14 22:52:43 yavdr epgd: 0 new series events to scrap in db
Nov 14 22:52:43 yavdr epgd: 0 series episodes scraped in 0 s, downloaded 0.000 KB
Nov 14 22:52:43 yavdr epgd: Scraping new movies
Nov 14 22:52:43 yavdr epgd: 0 new movies to scrap in db
Nov 14 22:52:43 yavdr epgd: 0 movies scraped in 0 s, downloaded 0.000 KB
Nov 14 22:52:43 yavdr epgd: cleaning up series...
Nov 14 22:52:43 yavdr epgd: 0 outdated series deleted
Nov 14 22:52:43 yavdr epgd: cleaning up movies...
Nov 14 22:52:43 yavdr epgd: 0 outdated movies deleted
Nov 14 22:52:43 yavdr epgd: Scheduled next update in 2 hour(s)
Nov 14 22:52:43 yavdr epgd: State now 'standby'
Nov 14 22:52:47 yavdr vdr: epg2vdr: --- EPG update started ---
Nov 14 22:52:47 yavdr vdr: epg2vdr: Starting cleanup of images in '/var/cache/vdr/epgimages'
Nov 14 22:52:47 yavdr vdr: epg2vdr: Remove old symlinks
Nov 14 22:52:47 yavdr vdr: epg2vdr: Cleanup finished, removed (0) images and (0) symlinks
Nov 14 22:52:47 yavdr vdr: epg2vdr: Update EPG, loading changes since 14.11.2015 22:50:57
Nov 14 22:52:47 yavdr vdr: epg2vdr: Updated changes since '14.11.2015 22:50:57'; 34 channels, 24 events (0 deletions) in 0.133 seconds
Nov 14 22:52:48 yavdr vdr: epg2vdr: Load images from database
Nov 14 22:52:48 yavdr vdr: epg2vdr: Got 0 images from database in 0 seconds (0 updates, 0 new)
Nov 14 22:52:48 yavdr vdr: epg2vdr: --- EPG update finished ---

Alles anzeigen

Code

mysql> select * from episodes limit 10;
Empty set (0.00 sec)




mysql>

CKone · 14. November 2015

connection refused: Mike hat deine IP gesperrt weil du zu oft probiert hast.

Perlbo · 14. November 2015

ok, und wird die wieder frei geschaltet ?

CKone · 14. November 2015

du brauchst ne neue IP oder musst bis morgen warten

TheChief · 15. November 2015

Problem erkannt, Problem schon gebannt?

Perlbo · 15. November 2015

Habe feste ip.

CKone · 15. November 2015

scheint auch so zu sein als würde der constabel Server auch uns nicht antworten im Moment: OleS hat Mike schon gemailt

[gelöst] epgd + eigene eventsview

Jetzt mitmachen!

Teilen