[gelöst] epgd + eigene eventsview

Perlbo · 12. November 2015

Hi,

habe seit mehreren Monaten meine eigene eventsview.sql in Betrieb, ohne Probleme. Nachdem ich mein System mal neu installiert habe, scheint sie nicht mehr zu funktionieren (eingespielt aus Backup). Eigentlich sollten Serien im EPG im Format Serienname (S00E00) angezeigt werden (falls Information natürlich verfügbar), was bisher auch super geklappt hat. Vielleicht hat jemand einen Tip wo mein Fehler ist.

epgd.conf habe ich eigenen epgeventsview-perbo eingetragen, Datei ins Verzeichnis kopiert.

EPG wird angezeigt aber eben nicht in "meinem" Format.

Code

/usr/lib/epgd/epgd-showmerge
+---------------+---------+
| count(source) | source  |
+---------------+---------+
|         13674 | epgdata |
|          3913 | vdr     |
+---------------+---------+
+----------+---------+--------+
| count(*) | source  | updflg |
+----------+---------+--------+
|    10904 | epgdata | A      |
|      152 | epgdata | C      |
|        7 | epgdata | I      |
|      145 | epgdata | R      |
|     1934 | epgdata | T      |
|      350 | vdr     | A      |
|       33 | vdr     | D      |
|      738 | vdr     | I      |
|     2086 | vdr     | L      |
|        2 | vdr     | R      |
+----------+---------+--------+

Alles anzeigen

Vielen Dank.

So sollte das eigentlich aussehen:

Perlbo · 12. November 2015

Hat sich irgendwas an epgd / epg2vdr geändert das erklären kann warum es "damals" ging und jetzt nicht. Also damals ist halt von Anfängen bis heute. Bei der Variante wo es nicht geht ist es eine frische Installation.

das sieht doch eigentlich soweit gut aus:

Code

Nov 12 20:00:53 yavdr epgd: Set locale to 'de_DE.UTF-8'
Nov 12 20:00:53 yavdr epgd: detected UTF-8
Nov 12 20:00:53 yavdr epgd: Loading uuid from '/etc/epgd/uuid' succeeded [7A8EE696-DC36-418A-A923-D71CE34F48B9]
Nov 12 20:00:53 yavdr epgd: Loading plugin: /usr/lib/epgd/plugins/libepgd-tvm.so
Nov 12 20:00:53 yavdr epgd: Loading plugin: /usr/lib/epgd/plugins/libepgd-epgdata.so
Nov 12 20:00:53 yavdr epgd: Read 26 option from /etc/epgd/epgd.conf
Nov 12 20:00:53 yavdr epgd: Info: Stylesheet '/etc/epgd/tvmovie-utf-8.xsl' loaded
Nov 12 20:00:53 yavdr epgd: Info: Stylesheet '/etc/epgd/epgdata-utf-8.xsl' loaded
Nov 12 20:00:53 yavdr epgd: SQL client character now 'utf8'
Nov 12 20:00:53 yavdr epgd: State now 'init'
Nov 12 20:00:53 yavdr epgd: Loading '/etc/epgd/channelmap.conf'
Nov 12 20:00:53 yavdr epgd: 544 channel mappings read.
Nov 12 20:00:53 yavdr epgd: Drop view 'eventsview'
Nov 12 20:00:53 yavdr epgd: Creating view 'eventsview' using definition in '/etc/epgd/eventsview-perlbo.sql'
Nov 12 20:00:53 yavdr epgd: using scrapping language de
Nov 12 20:00:53 yavdr epgd: tvdb scraper connected
Nov 12 20:00:54 yavdr epgd: moviedb scraper connected
Nov 12 20:00:54 yavdr epgd: Scheduled next update in 2 hour(s)
Nov 12 20:00:54 yavdr epgd: State now 'standby'

Alles anzeigen

Perlbo · 12. November 2015

Könnte sich vielleicht mal einer der "Cracks" die events-view anschauen, vielleicht ein Syntax Fehler, der irgendwie mir einer neuen Version nicht verarbeitet wird bzw. umbenannt wurde ? Vielleicht fällt jemanden dort auf, warum es nicht mehr läuft. Habe hier noch altes Clonezilla image von der ich sie habe. Dort läuft sie noch immer ohne Probleme ?? Zumal im untren Teil der Beschreibung Staffel und Folge durchaus angezeigt wird. Nur halt nicht im shorttext.

TheChief · 12. November 2015

Hast du denn mal die epg.data geleert, nachdem du den View geändert hast?

Ansonsten kannst du ja auf der mysql Kommandozeile mal checken, ob dein View geht: select * from eventsview limit 500

Perlbo · 12. November 2015

Zitat von TheChief

Hast du denn mal die epg.data geleert, nachdem du den View geändert hast?

Ansonsten kannst du ja auf der mysql Kommandozeile mal checken, ob dein View geht: select * from eventsview limit 500

Habe bei gestoppten VDR die epgdata gelöscht. select * from eventsview limit 500 kommt nix ? also mysql --user=epg2vdr --password=epg epg2vdr dann select * from eventsview limit 500

TheChief · 13. November 2015

Wie kommt nix? Kein Fehler? Bei mir gibt es da eben 500 Zeilen aus. Falls Dein View nicht existiert müsste wenigesten etwas wie: ERROR 1146 (42S02): Table 'epg2vdr.eventsview' doesn't exist kommen. Gehe ich aber nicht von aus, sonst hättest Du garkein EPG und im Log müssten Fehler stehen.

Perlbo · 13. November 2015

Zitat von TheChief

Wie kommt nix? Kein Fehler? Bei mir gibt es da eben 500 Zeilen aus. Falls Dein View nicht existiert müsste wenigesten etwas wie: ERROR 1146 (42S02): Table 'epg2vdr.eventsview' doesn't exist kommen. Gehe ich aber nicht von aus, sonst hättest Du garkein EPG und im Log müssten Fehler stehen.

Also Mysql ist noch völlig Neuland für mich. Vielleicht mache ich ja was falsch:

Code

yavdr:~$ mysql --user=epg2vdr --password=epg epg2vdr
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A




Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 54
Server version: 5.5.46-0ubuntu0.14.04.2 (Ubuntu)




Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.




Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.




Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.




mysql> select * from eventsview limit 500
    ->

Alles anzeigen

Ahhh... OK...wer lesen kann ist im Vorteil... so sollte es also heißen

Code

select * from eventsview limit 500;

da bekomme ich dann folgendes:

https://www.dropbox.com/s/j3uqhjmm6vvnn67/epg.txt?dl=0

TheChief · 13. November 2015

Wenn ich das SQL aus deinem eventsview probiere, erhalte ich: ERROR 1054 (42S22): Unknown column 'sub.fsk' in 'field list'

Weiß aber nicht, ob das eventuell an der epgd-Version liegt, die ich nutze. Hab lange nicht mehr aktualisiert. Also kannst Du ja mal probieren:

Code

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 sub.fsk is Null then '' else concat('||','Altersempfehlung: ab ',sub.fsk) 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) limit 500;

Ansonsten auch mal

Code

select shorttext from eventsview where title='Family Guy';

Dann siehst Du mal, ob Deine Abfrage so funktioniert und Staffelinfos ausgibt.

Perlbo · 13. November 2015

falscher post

CKone · 13. November 2015

schock mir mal deinen view dann pass ich den an, und wir legen den auch ins Paket dann können wir den Pflegen wenn es größere Anpassungen gibt. (oder gib mir mal Zugriff auf port 3306 (aber bitte erst ab Montag, bin am WE nicht daheim.), oder schau selber in den anderen views was sich geändert hat.

hier ist nur ein Feld verändert worden, im http branch ändert sich dagegen sehr viel.

TheChief · 13. November 2015

Der View hängt oben an Aber man weiß ja nicht, ob es daran liegt.

CKone · 13. November 2015

ja liegt daran, gibt ja das Feld fsk nicht mehr, ist jetzt für alle Quellen in parentalration zusammengefasst, vorher dvb = fsk und extern = parentalrating, das war aber sinnfrei

das fällt allerdings erst nach nem droppen der eventstabelle auf weil dann das fsk nciht mehr neu angelegt wird

CKone · 13. November 2015

ersetze mal bitte Zeile 33:

Code

case when sub.fsk is Null then '' else concat('||','Altersempfehlung: ab ',sub.fsk) end,

durch:

Code

case when cnt.parentalrating is Null or cnt.parentalrating = 0 then '' else concat('||','Altersempfehlung: ab ',cnt.parentalrating) end,

Christian

Perlbo · 13. November 2015

Zitat von CKone

ersetze mal bitte Zeile 33:

Code

case when sub.fsk is Null then '' else concat('||','Altersempfehlung: ab ',sub.fsk) end,

durch:

Code

case when cnt.parentalrating is Null or cnt.parentalrating = 0 then '' else concat('||','Altersempfehlung: ab ',cnt.parentalrating) end,

Christian

Das war es wohl nicht

Code

mysql> select shorttext from eventsview where title='castle';
+-------------------------------------------------+
| shorttext                                       |
+-------------------------------------------------+
| Fenton O'Connell, Crime-Serie, USA 2013         |
| Das Fenster zum Hof, Crime-Serie, USA 2013      |
| Todesfall in der Familie, Crime-Serie, USA 2009 |
| Die Pizza-Connection, Crime-Serie, USA 2011     |
| Todesfall in der Familie                        |
| Die Pizza-Connection                            |
| Das Fenster zum Hof                             |
| Wachtel oder Täubchen                           |
| Wachtel oder Täubchen, Crime-Serie, USA 2013    |
| Stillstand, Crime-Serie, USA 2013               |
| Fenton O´Connell                                |
| Das Fenster zum Hof                             |
| Todesfall in der Familie                        |
| Die Pizza-Connection                            |
| Todesfall in der Familie                        |
| Die Pizza-Connection                            |
| Das Fenster zum Hof                             |
| Wachtel oder Täubchen                           |
| Wachtel oder Täubchen                           |
| Stillstand                                      |
| 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                        |
| Das Fenster zum Hof                             |
| Fenton O'Connell                                |
| Die Pizza-Connection                            |
| Todesfall in der Familie                        |
+-------------------------------------------------+
48 rows in set (0.12 sec)




mysql> select shorttext from eventsview where title='Family Guy';
+-------------------------------------+
| shorttext                           |
+-------------------------------------+
| Rettet die Bar, Comedy, USA 2013    |
| Farmer Guy, Comedy, USA 2013        |
| Der Aufreiß-Kurs                    |
| Der Aufreiß-Kurs, Comedy, USA 2011  |
| Rettet die Bar                      |
| Farmer Guy                          |
| Rettet die Bar                      |
| Farmer Guy                          |
| Der Aufreiß-Kurs                    |
| Der Aufreiß-Kurs                    |
| 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 Aufreiß-Kurs                    |
+-------------------------------------+
20 rows in set (0.08 sec)

Alles anzeigen

Code

+---------------+---------+
| count(source) | source  |
+---------------+---------+
|          3109 | epgdata |
|         11483 | tvm     |
|          4253 | vdr     |
+---------------+---------+
+----------+---------+--------+
| count(*) | source  | updflg |
+----------+---------+--------+
|      302 | epgdata | A      |
|       32 | epgdata | C      |
|      606 | epgdata | R      |
|     1354 | epgdata | T      |
|      113 | tvm     | A      |
|       13 | tvm     | C      |
|      793 | tvm     | I      |
|        1 | tvm     | R      |
|     8803 | tvm     | S      |
|     1015 | tvm     | T      |
|       99 | vdr     | A      |
|     1149 | vdr     | I      |
|     2415 | vdr     | L      |
|        1 | vdr     | R      |
+----------+---------+--------+

Alles anzeigen

Lasse VDR noch laufen ... vielleicht brauch er noch ein wenig ..

----------------

Lief die Nacht durch:

Code

mysql> select shorttext from eventsview where title='Family Guy';
+-------------------------------------+
| shorttext                           |
+-------------------------------------+
| Jäger des schmutzigen Witzes        |
| Brian und Stewie                    |
| Knastbraut Meg                      |
| 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                 |
| Rettet die Bar, Comedy, USA 2013    |
| Farmer Guy, Comedy, USA 2013        |
| Der Aufreiß-Kurs                    |
| Der Aufreiß-Kurs                    |
| Der Aufreiß-Kurs                    |
| Der Aufreiß-Kurs                    |
| 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                    |
| Der Aufreiß-Kurs                    |
+-------------------------------------+
35 rows in set (0.11 sec)

Alles anzeigen

Code

yavdr:~$ /usr/lib/epgd/epgd-showmerge
+---------------+---------+
| count(source) | source  |
+---------------+---------+
|          3349 | epgdata |
|         11503 | tvm     |
|          4158 | vdr     |
+---------------+---------+
+----------+---------+--------+
| count(*) | source  | updflg |
+----------+---------+--------+
|      449 | epgdata | A      |
|       43 | epgdata | C      |
|      500 | epgdata | I      |
|      585 | epgdata | R      |
|     1486 | epgdata | T      |
|      120 | tvm     | A      |
|       17 | tvm     | C      |
|      757 | tvm     | I      |
|        4 | tvm     | R      |
|     9349 | tvm     | S      |
|     1044 | tvm     | T      |
|       91 | vdr     | A      |
|        5 | vdr     | D      |
|      882 | vdr     | I      |
|     2590 | vdr     | L      |
+----------+---------+--------+

Alles anzeigen

TheChief · 14. November 2015

Führe ich das select aus Deinem View aus, erhalte ich: ERROR 1054 (42S22): Unknown column 'sub.episode' in 'on clause'

Demnach ist da noch irgendwas schräg.

Versuchs mal so:

Code

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);

Alles anzeigen

Hab mal das left outer join geändert, da wohl einige Spalten jetzt umbenannt wurden:

Code

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

CKone · 14. November 2015

Da ist was dran, die Namen für die Episodenspalten wurden auch vor vielen Monaten mal aktualisiert, ist aber mindestens n halbes Jahr so, eher länger...

Aber es sind ja genügend Views dabei an denen ich sich die aktuelle Struktur abschauen kann.

Perlbo · 14. November 2015

Zitat von TheChief

Führe ich das select aus Deinem View aus, erhalte ich: ERROR 1054 (42S22): Unknown column 'sub.episode' in 'on clause'

Demnach ist da noch irgendwas schräg.

Versuchs mal so:

Code

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);

Alles anzeigen

Hab mal das left outer join geändert, da wohl einige Spalten jetzt umbenannt wurden:

Code

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

Alles anzeigen

Das führt zu dem Ergebnis:

Code

Nov 14 12:16:59 yavdr epgd: detected UTF-8
Nov 14 12:16:59 yavdr epgd: Loading uuid from '/etc/epgd/uuid' succeeded [A071A7DE-1AAD-4453-AA2E-4B2EA4411832]
Nov 14 12:16:59 yavdr epgd: Loading plugin: /usr/lib/epgd/plugins/libepgd-tvm.so
Nov 14 12:16:59 yavdr epgd: Loading plugin: /usr/lib/epgd/plugins/libepgd-epgdata.so
Nov 14 12:16:59 yavdr epgd: Read 26 option from /etc/epgd/epgd.conf
Nov 14 12:16:59 yavdr epgd: Info: Stylesheet '/etc/epgd/tvmovie-utf-8.xsl' loaded
Nov 14 12:16:59 yavdr epgd: Info: Stylesheet '/etc/epgd/epgdata-utf-8.xsl' loaded
Nov 14 12:16:59 yavdr epgd: SQL client character now 'utf8'
Nov 14 12:16:59 yavdr epgd: State now 'init'
Nov 14 12:16:59 yavdr epgd: Loading '/etc/epgd/channelmap.conf'
Nov 14 12:16:59 yavdr epgd: 56 channel mappings read.
Nov 14 12:16:59 yavdr epgd: Drop view 'eventsview'
Nov 14 12:16:59 yavdr epgd: Creating view 'eventsview' using definition in '/etc/epgd/eventsview-perlbo.sql'
Nov 14 12:16:59 yavdr epgd: SQL-Error in '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,#012case#012 when sub.shorttext is null then#012  case when sub.genre is null then '' else concat(sub.genre,' (', sub.country, ' ',sub.year, ')') end#012  else#012  case when epi.season is null then#012    sub.shorttext#012  else#012    concat('(S', lpad(format(epi.season, 0), 2, '0'), 'E', lpad(format(epi.part, 0), 2, '0'), ') ', epi.partname)#012  end#012end shorttext,#012cnt.starttime, cnt.duration, cnt.parentalrating, cnt.vps, replace(#012concat(#012  TRIM(LEADING '|' FROM#012   concat(#012    case when sub.genre is Null then '' else concat('|','Genre: ',sub.genre) end,#012    case when sub.category is Null then '' else concat('|','Kategorie: ',sub.category) end,#012    case when sub.country is Null then '' else concat('|','Land: ',sub.country) end,#012    case when sub.year is Null then '' else concat('|','Jahr: ',substring(sub.year,1,4)) end#012   )#012  ),#012  concat(#012    case when sub.shortdescription is Null then '' else concat('||',sub.shortdescription) end,#012    case when sub.shortreview is Null then '' else concat('||','Kurzkritik: ',sub.shortreview) end,#012    case when sub.tipp is Null and sub.rating is Null then '' else '||' end,#012    case when sub.tipp is Null then '' else concat('|',sub.tipp) end,#012    case when sub.rating is Null then '' else concat('|',sub.rating) end,#012    case when sub.topic is Null then '' else concat('||','Thema: ',sub.topic) end,#012    case when sub.longdescription is Null then '' else concat('||',sub.longdescription) end,#012    case when sub.info is Null then '' else concat('||','Info: ',sub.info) end,#012    case when sub.moderator is Null then '' else concat('||','Moderator: ',sub.moderator) end,#012    case when sub.guest is Null then '' else concat('|','Gäste: ',sub.guest) end,#012    case when cnt.parentalrating is Null or cnt.parentalrating = 0 then '' else concat('||','Altersempfehlung: ab ',cnt.parentalrating) end,#012    case when sub.actor is Null and sub.producer is Null and sub.other is Null then '' else '|' end,#012    case when sub.actor is Null then '' else concat('|','Darsteller: ',sub.actor) end,#012    case when sub.producer is Null then '' else concat('|','Produzent: ',sub.producer) end,#012    case when sub.other is Null then '' else concat('|','Sonstige: ',sub.other) end,#012    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,#012    case when sub.director is Null then '' else concat('|','Regie: ',sub.director) end,#012    case when sub.screenplay is Null then '' else concat('|','Drehbuch: ',sub.screenplay) end,#012    case when sub.camera is Null then '' else concat('|','Kamera: ',sub.camera) end,#012    case when sub.music is Null then '' else concat('|','Musik: ',sub.music) end,#012    case when sub.audio is Null then '' else concat('|','Audio: ',sub.audio) end,#012    case when sub.flags is Null then '' else concat('|','Flags: ',sub.flags) end,#012    case when epi.episodename is Null then '' else concat('||','Serie: ',epi.episodename) end,#012    case when epi.shortname is Null then '' else concat('|','Kurzname: ',epi.shortname) end,#012    case when epi.partname is Null then '' else concat('|','Episode: ',epi.partname) end,#012    case when epi.extracol1 is Null then '' else concat('|',epi.extracol1) end,#012    case when epi.extracol2 is Null then '' else concat('|',epi.extracol2) end,#012    case when epi.extracol3 is Null then '' else concat('|',epi.extracol3) end,#012    case when epi.season is Null then '' else concat('|','Staffel: ',cast(epi.season as char)) end,#012    case when epi.part is Null then '' else concat('|','Staffelfolge: ',cast(epi.part as char)) end,#012    case when epi.part is Null then '' else concat('|','Staffelfolgen: ',cast(epi.parts as char)) end,#012    case when epi.number is Null then '' else concat('|','Folge: ',cast(epi.number as char)) end,#012    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#012  )#012)#012,'|', '#012') as description#012from#012 events cnt#012 inner join events sub on (case when cnt.useid = 0 then cnt.masterid else cnt.useid end = sub.masterid)#012 left outer join episodes epi on (sub.episodecompname = epi.compname and sub.episodecomppartname = epi.comppartname and sub.episodelang = epi.lang);' - Unknown column 'sub.episodecompname' in 'on clause' (1054) 
Nov 14 12:16:59 yavdr epgd: SQL-Error in 'executeSqlFile()' - Unknown column 'sub.episodecompname' in 'on clause' (1054) 
Nov 14 12:16:59 yavdr kernel: [22000.213894] epgd[30986]: segfault at 8 ip 000000000043cd0c sp 00007ffdcb4e37d0 error 4 in epgd[400000+8f000]
Nov 14 12:16:59 yavdr kernel: [22000.220333] init: epgd main process (30986) killed by SEGV signal
Nov 14 12:17:01 yavdr CRON[30995]: (root) CMD (   cd / && run-parts --report /etc/cron.hourly)
Nov 14 12:16:15 yavdr vdr: scraper2vdr: epgd busy, trying again in 60 seconds ...
Nov 14 12:17:09 yavdr vdr: epg2vdr: --- EPG update started ---
Nov 14 12:17:09 yavdr vdr: epg2vdr: Starting cleanup of images in '/var/cache/vdr/epgimages'
Nov 14 12:17:10 yavdr vdr: epg2vdr: Remove old symlinks
Nov 14 12:17:10 yavdr vdr: epg2vdr: Cleanup finished, removed (44) images and (56) symlinks
Nov 14 12:17:10 yavdr vdr: epg2vdr: Update EPG, loading changes since 14.11.2015 10:14:20
Nov 14 12:17:10 yavdr vdr: epg2vdr: SQL-Error in 'execute(stmt_execute)' - Table 'epg2vdr.eventsview' doesn't exist (1146) 'Table 'epg2vdr.eventsview' doesn't exist' [select useid, eventid, source, delflg, updflg, fileref, tableid, version, title, shorttext, starttime, duration, parentalrating, vps, description from eventsview where channelid = ? and updsp > ? and updflg in ('A','L','P','C','D','R')]
Nov 14 12:17:10 yavdr vdr: message repeated 33 times: [ epg2vdr: SQL-Error in 'execute(stmt_execute)' - Table 'epg2vdr.eventsview' doesn't exist (1146) 'Table 'epg2vdr.eventsview' doesn't exist' [select useid, eventid, source, delflg, updflg, fileref, tableid, version, title, shorttext, starttime, duration, parentalrating, vps, description from eventsview where channelid = ? and updsp > ? and updflg in ('A','L','P','C','D','R')]]
Nov 14 12:17:10 yavdr vdr: epg2vdr: Updated changes since '14.11.2015 10:14:20'; 34 channels, 34 events (0 deletions) in 0.009 seconds
Nov 14 12:17:10 yavdr vdr: epg2vdr: Load images from database
Nov 14 12:17:10 yavdr vdr: epg2vdr: Got 0 images from database in 0 seconds (0 updates, 0 new)
Nov 14 12:17:10 yavdr vdr: epg2vdr: --- EPG update finished ---
Nov 14 12:17:52 yavdr vdr: [1244] read incomplete section - len = 2534, r = 2520

Alles anzeigen

Perlbo · 14. November 2015

Zitat von Perlbo

Das führt zu dem Ergebnis:

Code

Nov 14 12:16:59 yavdr epgd: detected UTF-8
Nov 14 12:16:59 yavdr epgd: Loading uuid from '/etc/epgd/uuid' succeeded [A071A7DE-1AAD-4453-AA2E-4B2EA4411832]
Nov 14 12:16:59 yavdr epgd: Loading plugin: /usr/lib/epgd/plugins/libepgd-tvm.so
Nov 14 12:16:59 yavdr epgd: Loading plugin: /usr/lib/epgd/plugins/libepgd-epgdata.so
Nov 14 12:16:59 yavdr epgd: Read 26 option from /etc/epgd/epgd.conf
Nov 14 12:16:59 yavdr epgd: Info: Stylesheet '/etc/epgd/tvmovie-utf-8.xsl' loaded
Nov 14 12:16:59 yavdr epgd: Info: Stylesheet '/etc/epgd/epgdata-utf-8.xsl' loaded
Nov 14 12:16:59 yavdr epgd: SQL client character now 'utf8'
Nov 14 12:16:59 yavdr epgd: State now 'init'
Nov 14 12:16:59 yavdr epgd: Loading '/etc/epgd/channelmap.conf'
Nov 14 12:16:59 yavdr epgd: 56 channel mappings read.
Nov 14 12:16:59 yavdr epgd: Drop view 'eventsview'
Nov 14 12:16:59 yavdr epgd: Creating view 'eventsview' using definition in '/etc/epgd/eventsview-perlbo.sql'
Nov 14 12:16:59 yavdr epgd: SQL-Error in '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,#012case#012 when sub.shorttext is null then#012  case when sub.genre is null then '' else concat(sub.genre,' (', sub.country, ' ',sub.year, ')') end#012  else#012  case when epi.season is null then#012    sub.shorttext#012  else#012    concat('(S', lpad(format(epi.season, 0), 2, '0'), 'E', lpad(format(epi.part, 0), 2, '0'), ') ', epi.partname)#012  end#012end shorttext,#012cnt.starttime, cnt.duration, cnt.parentalrating, cnt.vps, replace(#012concat(#012  TRIM(LEADING '|' FROM#012   concat(#012    case when sub.genre is Null then '' else concat('|','Genre: ',sub.genre) end,#012    case when sub.category is Null then '' else concat('|','Kategorie: ',sub.category) end,#012    case when sub.country is Null then '' else concat('|','Land: ',sub.country) end,#012    case when sub.year is Null then '' else concat('|','Jahr: ',substring(sub.year,1,4)) end#012   )#012  ),#012  concat(#012    case when sub.shortdescription is Null then '' else concat('||',sub.shortdescription) end,#012    case when sub.shortreview is Null then '' else concat('||','Kurzkritik: ',sub.shortreview) end,#012    case when sub.tipp is Null and sub.rating is Null then '' else '||' end,#012    case when sub.tipp is Null then '' else concat('|',sub.tipp) end,#012    case when sub.rating is Null then '' else concat('|',sub.rating) end,#012    case when sub.topic is Null then '' else concat('||','Thema: ',sub.topic) end,#012    case when sub.longdescription is Null then '' else concat('||',sub.longdescription) end,#012    case when sub.info is Null then '' else concat('||','Info: ',sub.info) end,#012    case when sub.moderator is Null then '' else concat('||','Moderator: ',sub.moderator) end,#012    case when sub.guest is Null then '' else concat('|','Gäste: ',sub.guest) end,#012    case when cnt.parentalrating is Null or cnt.parentalrating = 0 then '' else concat('||','Altersempfehlung: ab ',cnt.parentalrating) end,#012    case when sub.actor is Null and sub.producer is Null and sub.other is Null then '' else '|' end,#012    case when sub.actor is Null then '' else concat('|','Darsteller: ',sub.actor) end,#012    case when sub.producer is Null then '' else concat('|','Produzent: ',sub.producer) end,#012    case when sub.other is Null then '' else concat('|','Sonstige: ',sub.other) end,#012    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,#012    case when sub.director is Null then '' else concat('|','Regie: ',sub.director) end,#012    case when sub.screenplay is Null then '' else concat('|','Drehbuch: ',sub.screenplay) end,#012    case when sub.camera is Null then '' else concat('|','Kamera: ',sub.camera) end,#012    case when sub.music is Null then '' else concat('|','Musik: ',sub.music) end,#012    case when sub.audio is Null then '' else concat('|','Audio: ',sub.audio) end,#012    case when sub.flags is Null then '' else concat('|','Flags: ',sub.flags) end,#012    case when epi.episodename is Null then '' else concat('||','Serie: ',epi.episodename) end,#012    case when epi.shortname is Null then '' else concat('|','Kurzname: ',epi.shortname) end,#012    case when epi.partname is Null then '' else concat('|','Episode: ',epi.partname) end,#012    case when epi.extracol1 is Null then '' else concat('|',epi.extracol1) end,#012    case when epi.extracol2 is Null then '' else concat('|',epi.extracol2) end,#012    case when epi.extracol3 is Null then '' else concat('|',epi.extracol3) end,#012    case when epi.season is Null then '' else concat('|','Staffel: ',cast(epi.season as char)) end,#012    case when epi.part is Null then '' else concat('|','Staffelfolge: ',cast(epi.part as char)) end,#012    case when epi.part is Null then '' else concat('|','Staffelfolgen: ',cast(epi.parts as char)) end,#012    case when epi.number is Null then '' else concat('|','Folge: ',cast(epi.number as char)) end,#012    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#012  )#012)#012,'|', '#012') as description#012from#012 events cnt#012 inner join events sub on (case when cnt.useid = 0 then cnt.masterid else cnt.useid end = sub.masterid)#012 left outer join episodes epi on (sub.episodecompname = epi.compname and sub.episodecomppartname = epi.comppartname and sub.episodelang = epi.lang);' - Unknown column 'sub.episodecompname' in 'on clause' (1054) 
Nov 14 12:16:59 yavdr epgd: SQL-Error in 'executeSqlFile()' - Unknown column 'sub.episodecompname' in 'on clause' (1054) 
Nov 14 12:16:59 yavdr kernel: [22000.213894] epgd[30986]: segfault at 8 ip 000000000043cd0c sp 00007ffdcb4e37d0 error 4 in epgd[400000+8f000]
Nov 14 12:16:59 yavdr kernel: [22000.220333] init: epgd main process (30986) killed by SEGV signal
Nov 14 12:17:01 yavdr CRON[30995]: (root) CMD (   cd / && run-parts --report /etc/cron.hourly)
Nov 14 12:16:15 yavdr vdr: scraper2vdr: epgd busy, trying again in 60 seconds ...
Nov 14 12:17:09 yavdr vdr: epg2vdr: --- EPG update started ---
Nov 14 12:17:09 yavdr vdr: epg2vdr: Starting cleanup of images in '/var/cache/vdr/epgimages'
Nov 14 12:17:10 yavdr vdr: epg2vdr: Remove old symlinks
Nov 14 12:17:10 yavdr vdr: epg2vdr: Cleanup finished, removed (44) images and (56) symlinks
Nov 14 12:17:10 yavdr vdr: epg2vdr: Update EPG, loading changes since 14.11.2015 10:14:20
Nov 14 12:17:10 yavdr vdr: epg2vdr: SQL-Error in 'execute(stmt_execute)' - Table 'epg2vdr.eventsview' doesn't exist (1146) 'Table 'epg2vdr.eventsview' doesn't exist' [select useid, eventid, source, delflg, updflg, fileref, tableid, version, title, shorttext, starttime, duration, parentalrating, vps, description from eventsview where channelid = ? and updsp > ? and updflg in ('A','L','P','C','D','R')]
Nov 14 12:17:10 yavdr vdr: message repeated 33 times: [ epg2vdr: SQL-Error in 'execute(stmt_execute)' - Table 'epg2vdr.eventsview' doesn't exist (1146) 'Table 'epg2vdr.eventsview' doesn't exist' [select useid, eventid, source, delflg, updflg, fileref, tableid, version, title, shorttext, starttime, duration, parentalrating, vps, description from eventsview where channelid = ? and updsp > ? and updflg in ('A','L','P','C','D','R')]]
Nov 14 12:17:10 yavdr vdr: epg2vdr: Updated changes since '14.11.2015 10:14:20'; 34 channels, 34 events (0 deletions) in 0.009 seconds
Nov 14 12:17:10 yavdr vdr: epg2vdr: Load images from database
Nov 14 12:17:10 yavdr vdr: epg2vdr: Got 0 images from database in 0 seconds (0 updates, 0 new)
Nov 14 12:17:10 yavdr vdr: epg2vdr: --- EPG update finished ---
Nov 14 12:17:52 yavdr vdr: [1244] read incomplete section - len = 2534, r = 2520

Alles anzeigen

Nur zur Sicherheit. Primär wichtig ist mir nur im Titel / subtext das Format Family guy (S01E12) tolle Folge.
Siehe Screenshot oben. Das wären dann ja die ersten 12 Zeilen die wichtig wären. Oder haben die unten dann trotzdem Einfluss auf den oberen Teil ?

Danke für eure Hilfe. Vielleicht bekommen wir das ja hin ??

TheChief · 14. November 2015

Dann musst Du mal das select von deinem View selbst ausführen auf der Kommandozeile und dann schauen, wo es klemmt. Ich weiß nicht, weiche Version yaVDR verwendet

Perlbo · 14. November 2015

Zitat von TheChief

Dann musst Du mal das select von deinem View selbst ausführen auf der Kommandozeile und dann schauen, wo es klemmt. Ich weiß nicht, weiche Version yaVDR verwendet

Also ich stoppe epgd, ändere eventsview-perlbo.sql. Speichere und starte EPGD neu.

Dann kommst das:

neben der Fehlermeldung oben:

Code

SQL-Error in 'prepare(stmt_prepare)' - Table 'epg2vdr.eventsview' doesn't exist (1146) 'Table 'epg2vdr.eventsview' doesn't exist' [select useid, eventid, source, delflg, updflg, fileref, tableid, version, title, shorttext, starttime, duration, parentalrating, vps, description from eventsview where channelid = ? and updsp > ? and updflg in ('A','L','P','C','D','R')]

und:

Code

mysql> select * from eventsview limit 500;
ERROR 1146 (42S02): Table 'epg2vdr.eventsview' doesn't exist
mysql>

[gelöst] epgd + eigene eventsview

Jetzt mitmachen!

Teilen

Benutzer online in diesem Thema