habe gerade mit epgd-tool alles gelöscht (drop-all, del-all), epg.data gelöscht und epgd neu gestartet. Nun bekomme ich nach kurzer Zeit folgende Fehlermeldung:
May 24 19:00:40 macmini epgd: Loading '/etc/epgd/channelmap.conf'
May 24 19:00:40 macmini epgd: 144 channel mappings read.
May 24 19:00:40 macmini epgd: Creating view 'eventsview' using definition in '/etc/epgd/eventsview-maz.sql'
May 24 19:00:40 macmini epgd: SQL-Error in 'CREATE VIEW eventsview as select cnt_useid useid, cnt_eventid eventid, cnt_channelid channelid, cnt_source source, all_updsp updsp, cnt_updflg updflg, cnt_delflg delflg, cnt_fileref fileref, cnt_tableid tableid, cnt_version version, sub_title title,$case$ when sub_shorttext is null or sub_title=sub_shorttext or (substring(sub_shorttext,1,1)='S' and substring(sub_shorttext,2,1) REGEXP ('[0-9]') ) 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 starttime, cnt_duration duration, cnt_parentalrating parentalrating, cnt_vps vps, cnt_contents contents, 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 (INSTR(lower(sub_genre), 'nachrichten') > 0 or INSTR(lower(sub_genre), 'magazin') > 0 or INSTR(lower(sub_genre), 'diskussion') > 0 or INSTR(lower(sub_genre), 'gespräch') > 0 or INSTR(lower(sub_genre), 'show') > 0) or sub_genre in ('Ansprache','Aktuelle Berichte','Eishockey','Formel 1','Fußball','Fussball','Fun- u. Extremsport','Golf','Leichtathletik','Motor + Verkehr','Motor+Verkehr','Motorrad','Motorsport','NASCAR','Radsport','Reitsport','Sammelsendung','Tennis','Tischtennis','Wintersport') and cnt_source <> sub_source$ then concat('||', cnt_longdescription) $ else case when sub_longdescription is Null then '' else concat('||',sub_longdescription) end $ 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_parts 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$ useevents;$' - Unknown column 'sub_info' in 'field list' (1054)
May 24 19:00:40 macmini epgd: SQL-Error in 'executeSqlFile()' - Unknown column 'sub_info' in 'field list' (1054)
May 24 19:00:40 macmini epgd: Using scraping language de
May 24 19:00:40 macmini epgd: TVDB scraper connected
May 24 19:00:40 macmini epgd: MOVIEDB scraper connected
May 24 19:00:40 macmini epgd: Info: No external events on database, force initial check!
May 24 19:00:40 macmini epgd: Retry #42 failed, retrying in 60 seconds!
Irgendwas habe ich wohl falsch gemacht, habe aber eiglt. alles wie auf S.1 beschrieben durchgeführt. Die ALTER-Befehle führen zu: