Danke
aber ich brauch es für Openelec 6.0, hast du es da auch?
Gruss Willi
Danke
aber ich brauch es für Openelec 6.0, hast du es da auch?
Gruss Willi
schade
dann eben notgedrungen VNSI
moin
gibt es für Kodi 15.2 ein funktionierendes XVDR PVR Addon. Leider finde ich nur VNSI.
In der 14.x gabs das noch, nun scheinbar nicht?
Gruss Willi
Vorteil gegenüber dem Atric: sehr preisgünstig, Nachteil: man sollte keine Abneigung vor kleinen Basteleien haben: https://www.mikrocontroller.net/articles…fahrene_Bastler
Man braucht nicht unbedingt eine Platine, wenn man sie aber will, gibt es sie von Martin: http://www.vdr-portal.de/board18-vdr-har…er/#post1254992
Diese Lösung funktioniert bei den Leuten, die sie einsetzen, sehr zuverlässig.
Nun, nicht jeder ist Willens oder technisch in der Lage, als "erfahrener Bastler" das Teil aufzubauen. Deshalb fand ich die Atriclösung sehr charmant, zumal 25 Euro wirklich nicht zu teuer sind.
die Harmony funktioniert nur mit dem Hub, der ist zwingend erforderlich und sozusagen das Herzstück deines Fernbedienungs Konzepts.
Von der FB geht's per Bluetooth zum Hub. Der Hub selber plus seine beiden Satellit IR Augen senden Infrarotsignale.
Der Hub ist zusätzlich per WLAN in das Homenetz integriert und kann alternativ via Handy/Tablett App gesteuert werden.
Ich steuere so zum Beispiel meine komplette TV/HIFI Anlage:
TV ein/aus
VDR ein/aus
ONKYO ein/aus
Minify LED Beleuchtung ein/aus
Das alles mit einem Tastendruck. Zusätzlich dann die komplette VDR Steuerung und Lautstärke über den Onkyo
Die Harmony Ultimate hat nen Akku, der steckt in der Ladeschale.
Die Harmony Smart Control hat soone 3V Knopfzelle, hab sie jetzt ca 1 Jahr in Betrieb ohne zu wechseln.
ZitatEinschalten ist dann ja auch nicht. Das wäre nämlich ein "no-go".
Wer sagt das. Ich schalte mit der Logitech Hub Lösung (FB sendet per Bluetooth, der Hub setzt das in IR um) und schalte damit meinen VDR ein/aus.
Als IR Empfänger wird der Atric IR-WakeupUSB verwendet, einfach im VDR an einen vorhandenen internen USB Anschluss anschliessen. Der Schaltausgang wird an den
Powerknopf des PC angeschlossen. So ist problemloses Ein/Auschalten möglich.
wenn sie nur nicht so verdammt teuer wären..
aber Frodo hat Recht, ich hab seit nem Jahr auch die Ultimate in Nutzung. Wer die "teure" Lösung scheut, hier noch eine etwas günstigere.
Zusätzlich kann man mit der zugehörigen App auch sein Handy/Tablett als Fernbedienung nutzen.
Wie ich finde, eine elegante Lösung, hier getestet.
Ich hatte die Harmony 900, die hat ein RF System, an das kann man 2 IR Blaster anschliessen.
Damit gabs keinerlei Probleme, zumal sie alle Geräte gesteuert hat.
Frage: warum nutzt du nicht eine Nvidia Karte, z.B. GT730 oder GT720. Damit wirst du keinerlei Probleme bei der Grafikausgabe gaben.
Dein Board hat doch 3x PCIe.
Gruss
hier geht's seit heute wieder, gestern noch nicht
Soweit läuft jetzt wieder alles.Danke schon mal für die Hilfe. Ein Problem tauchte im Log noch auf:
ep 1 20:02:55 VDRServer epgd: SQL-Error in 'execute(stmt_execute)' - Duplicate entry '81977-0-0-0-7' for key 'PRIMARY' (1062) 'Duplicate entry '81977-0-0-0-7' for key 'PRIMARY'' [insert into series_media set series_id = ?, season_number = ?, episode_id = ?, actor_id = ?, media_type = ?, media_url = ?, media_width = ?, media_height = ?, media_rating = ?, media_content = ?;]
Sep 1 20:02:56 VDRServer epgd: SQL-Error in 'execute(stmt_execute)' - Duplicate entry '81977-0-0-0-8' for key 'PRIMARY' (1062) 'Duplicate entry '81977-0-0-0-8' for key 'PRIMARY'' [insert into series_media set series_id = ?, season_number = ?, episode_id = ?, actor_id = ?, media_type = ?, media_url = ?, media_width = ?, media_height = ?, media_rating = ?, media_content = ?;]
Sep 1 20:02:59 VDRServer epgd: SQL-Error in 'execute(stmt_execute)' - Duplicate entry '81977-0-0-0-3' for key 'PRIMARY' (1062) 'Duplicate entry '81977-0-0-0-3' for key 'PRIMARY'' [insert into series_media set series_id = ?, season_number = ?, episode_id = ?, actor_id = ?, media_type = ?, media_url = ?, media_width = ?, media_height = ?, media_rating = ?, media_content = ?;]
Sep 1 20:03:00 VDRServer epgd: SQL-Error in 'execute(stmt_execute)' - Duplicate entry '81977-0-0-0-4' for key 'PRIMARY' (1062) 'Duplicate entry '81977-0-0-0-4' for key 'PRIMARY'' [insert into series_media set series_id = ?, season_number = ?, episode_id = ?, actor_id = ?, media_type = ?, media_url = ?, media_width = ?, media_height = ?, media_rating = ?, media_content = ?;]
Sep 1 20:03:01 VDRServer epgd: SQL-Error in 'execute(stmt_execute)' - Duplicate entry '81977-0-0-0-5' for key 'PRIMARY' (1062) 'Duplicate entry '81977-0-0-0-5' for key 'PRIMARY'' [insert into series_media set series_id = ?, season_number = ?, episode_id = ?, actor_id = ?, media_type = ?, media_url = ?, media_width = ?, media_height = ?, media_rating = ?, media_content = ?;]
Sep 1 20:03:01 VDRServer epgd: SQL-Error in 'execute(stmt_execute)' - Duplicate entry '81977-0-0-0-0' for key 'PRIMARY' (1062) 'Duplicate entry '81977-0-0-0-0' for key 'PRIMARY'' [insert into series_media set series_id = ?, season_number = ?, episode_id = ?, actor_id = ?, media_type = ?, media_url = ?, media_width = ?, media_height = ?, media_rating = ?, media_content = ?;]
Sep 1 20:03:01 VDRServer epgd: SQL-Error in 'execute(stmt_execute)' - Duplicate entry '2025811' for key 'PRIMARY' (1062) 'Duplicate entry '2025811' for key 'PRIMARY'' [insert into series_episode set episode_id = ?, episode_number = ?, season_number = ?, episode_name = ?, episode_overview = ?, episode_firstaired = ?, episode_gueststars = ?, episode_rating = ?, episode_last_updated = ?, series_id = ?;]
Sep 1 20:03:01 VDRServer epgd: SQL-Error in 'execute(stmt_execute)' - Duplicate entry '4488360' for key 'PRIMARY' (1062) 'Duplicate entry '4488360' for key 'PRIMARY'' [insert into series_episode set episode_id = ?, episode_number = ?, season_number = ?, episode_name = ?, episode_overview = ?, episode_firstaired = ?, episode_gueststars = ?, episode_rating = ?, episode_last_updated = ?, series_id = ?;]
Sep 1 20:03:01 VDRServer epgd: SQL-Error in 'execute(stmt_execute)' - Duplicate entry '81977-0-4488360-0-10' for key 'PRIMARY' (1062) 'Duplicate entry '81977-0-4488360-0-10' for key 'PRIMARY'' [insert into series_media set series_id = ?, season_number = ?, episode_id = ?, actor_id = ?, media_type = ?, media_url = ?, media_width = ?, media_height = ?, media_rating = ?, media_content = ?;]
Sep 1 20:03:01 VDRServer epgd: SQL-Error in 'execute(stmt_execute)' - Duplicate entry '2025831' for key 'PRIMARY' (1062) 'Duplicate entry '2025831' for key 'PRIMARY'' [insert into series_episode set episode_id = ?, episode_number = ?, season_number = ?, episode_name = ?, episode_overview = ?, episode_firstaired = ?, episode_gueststars = ?, episode_rating = ?, episode_last_updated = ?, series_id = ?;]
Sep 1 20:03:01 VDRServer epgd: SQL-Error in 'execute(stmt_execute)' - Duplicate entry '4231588' for key 'PRIMARY' (1062) 'Duplicate entry '4231588' for key 'PRIMARY'' [insert into series_episode set episode_id = ?, episode_number = ?, season_number = ?, episode_name = ?, episode_overview = ?, episode_firstaired = ?, episode_gueststars = ?, episode_rating = ?, episode_last_updated = ?, series_id = ?;]
Sep 1 20:03:01 VDRServer epgd: SQL-Error in 'execute(stmt_execute)' - Duplicate entry '81977-0-4231588-0-10' for key 'PRIMARY' (1062) 'Duplicate entry '81977-0-4231588-0-10' for key 'PRIMARY'' [insert into series_media set series_id = ?, season_number = ?, episode_id = ?, actor_id = ?, media_type = ?, media_url = ?, media_width = ?, media_height = ?, media_rating = ?, media_content = ?;]
Sep 1 20:03:01 VDRServer epgd: SQL-Error in 'execute(stmt_execute)' - Duplicate entry '3449811' for key 'PRIMARY' (1062) 'Duplicate entry '3449811' for key 'PRIMARY'' [insert into series_episode set episode_id = ?, episode_number = ?, season_number = ?, episode_name = ?, episode_overview = ?, episode_firstaired = ?, episode_gueststars = ?, episode_rating = ?, episode_last_updated = ?, series_id = ?;]
Sep 1 20:03:01 VDRServer epgd: SQL-Error in 'execute(stmt_execute)' - Duplicate entry '81977-0-3449811-0-10' for key 'PRIMARY' (1062) 'Duplicate entry '81977-0-3449811-0-10' for key 'PRIMARY'' [insert into series_media set series_id = ?, season_number = ?, episode_id = ?, actor_id = ?, media_type = ?, media_url = ?, media_width = ?, media_height = ?, media_rating = ?, media_content = ?;]
Sep 1 20:03:01 VDRServer epgd: SQL-Error in 'execute(stmt_execute)' - Duplicate entry '3449821' for key 'PRIMARY' (1062) 'Duplicate entry '3449821' for key 'PRIMARY'' [insert into series_episode set episode_id = ?, episode_number = ?, season_number = ?, episode_name = ?, episode_overview = ?, episode_firstaired = ?, episode_gueststars = ?, episode_rating = ?, episode_last_updated = ?, series_id = ?;]
Sep 1 20:03:01 VDRServer epgd: SQL-Error in 'execute(stmt_execute)' - Duplicate entry '81977-0-3449821-0-10' for key 'PRIMARY' (1062) 'Duplicate entry '81977-0-3449821-0-10' for key 'PRIMARY'' [insert into series_media set series_id = ?, season_number = ?, episode_id = ?, actor_id = ?, media_type = ?, media_url = ?, media_width = ?, media_height = ?, media_rating = ?, media_content = ?;]
Sep 1 20:03:01 VDRServer epgd: SQL-Error in 'execute(stmt_execute)' - Duplicate entry '4229918' for key 'PRIMARY' (1062) 'Duplicate entry '4229918' for key 'PRIMARY'' [insert into series_episode set episode_id = ?, episode_number = ?, season_number = ?, episode_name = ?, episode_overview = ?, episode_firstaired = ?, episode_gueststars = ?, episode_rating = ?, episode_last_updated = ?, series_id = ?;]
Sep 1 20:03:01 VDRServer epgd: SQL-Error in 'execute(stmt_execute)' - Duplicate entry '81977-0-4229918-0-10' for key 'PRIMARY' (1062) 'Duplicate entry '81977-0-4229918-0-10' for key 'PRIMARY'' [insert into series_media set series_id = ?, season_number = ?, episode_id = ?, actor_id = ?, media_type = ?, media_url = ?, media_width = ?, media_height = ?, media_rating = ?, media_content = ?;]
Sep 1 20:03:01 VDRServer epgd: SQL-Error in 'execute(stmt_execute)' - Duplicate entry '4229919' for key 'PRIMARY' (1062) 'Duplicate entry '4229919' for key 'PRIMARY'' [insert into series_episode set episode_id = ?, episode_number = ?, season_number = ?, epi
Alles anzeigen
Diese SQL-Errormeldungen fluteten das Log, nachdem EPGD fertig mit dem Neuaufbau war. Hat das was zu bedeuten? Irgendwann hörten sie auch wieder auf.
es sieht schon besser aus, showmerge liefert wieder vernünftige Ausgaben:
root@VDRServer:~# epgd-showmerge
+---------------+---------+
| count(source) | source |
+---------------+---------+
| 104836 | epgdata |
| 90682 | tvm |
| 963 | vdr |
+---------------+---------+
+----------+---------+--------+
| count(*) | source | updflg |
+----------+---------+--------+
| 4489 | epgdata | A |
| 97220 | epgdata | S |
| 78230 | tvm | A |
| 900 | vdr | I |
+----------+---------+--------+
root@VDRServer:~#
Alles anzeigen
hab jetzt nochmal dropall gemacht und alles gelöscht (vorher hatte ich die Bilder behalten) und nach dem Tip vom Chief scheint sich etwas zu tun.
EPGD holt sich Daten. Mal schauen, wie es weitergeht.
Hier die EPGD Version:
root@VDRServer:~# apt-cache policy vdr-epg-daemon
vdr-epg-daemon:
Installiert: 1:0.2.1.git20140529.1626-0yavdr0~preciseubuntu1
Kandidat: 1:0.2.2.git20150827-0ppa0~precise
Versionstabelle:
1:0.2.2.git20150810.1431-0yavdr0~precise 0
500 http://ppa.launchpad.net/yavdr/main/ubuntu/ precise/main amd64 Packages
*** 1:0.2.1.git20140529.1626-0yavdr0~preciseubuntu1 0
100 /var/lib/dpkg/status
root@VDRServer:~#
Kann mir keiner weiterhelfen? Ich weiss leider nicht weiter. Hier mal das Syslog nach dem Neustart des Servers:
Sep 1 13:02:43 VDRServer epgd: Set locale to 'de_DE.UTF-8'
Sep 1 13:02:43 VDRServer epgd: detected UTF-8
Sep 1 13:02:43 VDRServer epgd: Loading uuid from '/etc/epgd/uuid' succeeded [C76A76EB-E62F-4FF8-B488-A3D157BF977C]
Sep 1 13:02:43 VDRServer epgd: Loading plugin: /usr/lib/epgd/plugins/libepgd-epgdata.so
Sep 1 13:02:43 VDRServer epgd: Loading plugin: /usr/lib/epgd/plugins/libepgd-tvm.so
Sep 1 13:02:43 VDRServer epgd: Read 26 option from /etc/epgd/epgd.conf
Sep 1 13:02:43 VDRServer rpc.mountd[1774]: authenticated mount request from 192.168.1.107:692 for /srv/audio (/srv/audio)
Sep 1 13:02:43 VDRServer epgd: Info: Stylesheet '/etc/epgd/epgdata-utf-8.xsl' loaded
Sep 1 13:02:43 VDRServer /etc/mysql/debian-start[1900]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
Sep 1 13:02:43 VDRServer /etc/mysql/debian-start[1900]: Looking for 'mysql' as: /usr/bin/mysql
Sep 1 13:02:43 VDRServer /etc/mysql/debian-start[1900]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Sep 1 13:02:43 VDRServer /etc/mysql/debian-start[1900]: This installation of MySQL is already upgraded to 5.5.41, use --force if you still need to run mysql_upgrade
Sep 1 13:02:43 VDRServer /etc/mysql/debian-start[1912]: Checking for insecure root accounts.
Sep 1 13:02:43 VDRServer epgd: Info: Stylesheet '/etc/epgd/tvmovie-utf-8.xsl' loaded
Sep 1 13:02:43 VDRServer epgd: SQL client character now 'utf8'
Sep 1 13:02:43 VDRServer epgd: Statement 'select uuid, inssp, updsp, name, version, dbapi, lastupd, nextupd, state, master, ip from vdrs where uuid = ?;' with (1) in parameters and (11) out bindings prepared
Sep 1 13:02:43 VDRServer epgd: Statement 'insert into vdrs set uuid = ?, inssp = ?, updsp = ?, name = ?, version = ?, dbapi = ?, lastupd = ?, nextupd = ?, state = ?, master = ?, ip = ?;' with (11) in parameters and (0) out bindings prepared
Sep 1 13:02:43 VDRServer epgd: Statement 'update vdrs set updsp = ?, name = ?, version = ?, dbapi = ?, lastupd = ?, nextupd = ?, state = ?, master = ?, ip = ? where uuid = ?;' with (10) in parameters and (0) out bindings prepared
Sep 1 13:02:43 VDRServer /etc/mysql/debian-start[1918]: Triggering myisam-recover for all MyISAM tables
Sep 1 13:02:43 VDRServer epgd: State now 'init'
Sep 1 13:02:43 VDRServer epgd: Statement 'select extid, channelid, source, channelname, vps, merge, mergesp, inssp, updsp, updflg from channelmap where extid = ? and channelid = ? and source = ?;' with (3) in parameters and (10) out bindings prepared
Sep 1 13:02:43 VDRServer epgd: Statement 'insert into channelmap set extid = ?, channelid = ?, source = ?, channelname = ?, vps = ?, merge = ?, mergesp = ?, inssp = ?, updsp = ?, updflg = ?;' with (10) in parameters and (0) out bindings prepared
Sep 1 13:02:43 VDRServer epgd: Statement 'update channelmap set channelname = ?, vps = ?, merge = ?, mergesp = ?, updsp = ?, updflg = ? where extid = ? and channelid = ? and source = ?;' with (9) in parameters and (0) out bindings prepared
Sep 1 13:02:43 VDRServer epgd: Statement 'select name, source, inssp, updsp, extid, fileref, tag from fileref where name = ? and source = ?;' with (2) in parameters and (7) out bindings prepared
Sep 1 13:02:43 VDRServer epgd: Statement 'insert into fileref set name = ?, source = ?, inssp = ?, updsp = ?, extid = ?, fileref = ?, tag = ?;' with (7) in parameters and (0) out bindings prepared
Sep 1 13:02:43 VDRServer epgd: Statement 'update fileref set updsp = ?, extid = ?, fileref = ?, tag = ? where name = ? and source = ?;' with (6) in parameters and (0) out bindings prepared
Sep 1 13:02:43 VDRServer epgd: Statement 'select imagename, inssp, updsp, image from images where imagename = ?;' with (1) in parameters and (4) out bindings prepared
Sep 1 13:02:43 VDRServer epgd: Statement 'insert into images set imagename = ?, inssp = ?, updsp = ?, image = ?;' with (4) in parameters and (0) out bindings prepared
Sep 1 13:02:43 VDRServer epgd: Statement 'update images set updsp = ?, image = ? where imagename = ?;' with (3) in parameters and (0) out bindings prepared
Sep 1 13:02:43 VDRServer epgd: Statement 'select eventid, lfn, inssp, updsp, source, fileref, imagename from imagerefs where eventid = ? and lfn = ?;' with (2) in parameters and (7) out bindings prepared
Sep 1 13:02:43 VDRServer epgd: Statement 'insert into imagerefs set eventid = ?, lfn = ?, inssp = ?, updsp = ?, source = ?, fileref = ?, imagename = ?;' with (7) in parameters and (0) out bindings prepared
Sep 1 13:02:43 VDRServer epgd: Statement 'update imagerefs set updsp = ?, source = ?, fileref = ?, imagename = ? where eventid = ? and lfn = ?;' with (6) in parameters and (0) out bindings prepared
Sep 1 13:02:43 VDRServer epgd: Statement 'select compname, comppartname, lang, inssp, updsp, link, shortname, episodename, partname, season, part, parts, number, extracol1, extracol2, extracol3, comment from episodes where compname = ? and comppartname = ? and lang = ?;' with (3) in parameters and (17) out bindings prepared
Sep 1 13:02:43 VDRServer epgd: Statement 'insert into episodes set compname = ?, comppartname = ?, lang = ?, inssp = ?, updsp = ?, link = ?, shortname = ?, episodename = ?, partname = ?, season = ?, part = ?, parts = ?, number = ?, extracol1 = ?, extracol2 = ?, extracol3 = ?, comment = ?;' with (17) in parameters and (0) out bindings prepared
Sep 1 13:02:43 VDRServer epgd: Statement 'update episodes set updsp = ?, link = ?, shortname = ?, episodename = ?, partname = ?, season = ?, part = ?, parts = ?, number = ?, extracol1 = ?, extracol2 = ?, extracol3 = ?, comment = ? where compname = ? and comppartname = ? and lang = ?;' with (16) in parameters and (0) out bindings prepared
Sep 1 13:02:43 VDRServer epgd: SQL-Error in 'prepare(stmt_prepare)' - Unknown column 'episode' in 'field list' (1054) 'Unknown column 'episode' in 'field list'' [select eventid, channelid, masterid, useid, source, fileref, inssp, updsp, updflg, delflg, tableid, version, title, comptitle, shorttext, compshorttext, longdescription, starttime, duration, parentalrating, vps, shortdescription, actor, audio, category, country, director, flags, genre, info, music, producer, screenplay, shortreview, tipp, topic, year, rating, fsk, movieid, moderator, other, guest, camera, extepnum, imagecount, episode, episodepart, episodelang, scrseriesid, scrseriesepisode, scrmovieid, scrsp from events where eventid = ? and channelid = ?;]
Sep 1 13:02:43 VDRServer kernel: [ 15.758101] epgd[1897]: segfault at 8 ip 000000000043c2dc sp 00007fff18b65cb0 error 4 in epgd[400000+8d000]
Alles anzeigen
epg2vdr bekommt dann auch keine Verbindung mehr. Was mich wundert, bis gestern lief alles perfekt seit der Erstinstallation im Februar. Dann kamen gestern unv ollständiges EPG hinzu.
Sep 1 11:54:36 VDRServer vdr: [13958] closing SVDRP connection
Sep 1 11:54:43 VDRServer vdr: epg2vdr: Trying to re-connect to database!
Sep 1 11:54:43 VDRServer vdr: epg2vdr: SQL-Error in 'prepare(stmt_prepare)' - Unknown column 'episode' in 'field list' (1054) 'Unknown column 'episode' in 'field list'' [select eventid, channelid, masterid, useid, source, fileref, inssp, updsp, updflg, delflg, tableid, version, title, comptitle, shorttext, compshorttext, longdescription, starttime, duration, parentalrating, vps, shortdescription, actor, audio, category, country, director, flags, genre, info, music, producer, screenplay, shortreview, tipp, topic, year, rating, fsk, movieid, moderator, other, guest, camera, extepnum, imagecount, episode, episodepart, episodelang, scrseriesid, scrseriesepisode, scrmovieid, scrsp from events where eventid = ? and channelid = ?;]
Sep 1 11:54:43 VDRServer vdr: epg2vdr: Retry #5374 failed, retrying in 60 seconds!
Sep 1 11:54:53 VDRServer vdr: epg2vdr: Trying to re-connect to database!
Sep 1 11:54:53 VDRServer vdr: epg2vdr: SQL-Error in 'prepare(stmt_prepare)' - Unknown column 'episode' in 'field list' (1054) 'Unknown column 'episode' in 'field list'' [select eventid, channelid, masterid, useid, source, fileref, inssp, updsp, updflg, delflg, tableid, version, title, comptitle, shorttext, compshorttext, longdescription, starttime, duration, parentalrating, vps, shortdescription, actor, audio, category, country, director, flags, genre, info, music, producer, screenplay, shortreview, tipp, topic, year, rating, fsk, movieid, moderator, other, guest, camera, extepnum, imagecount, episode, episodepart, episodelang, scrseriesid, scrseriesepisode, scrmovieid, scrsp from events where eventid = ? and channelid = ?;]
Sep 1 11:54:53 VDRServer vdr: epg2vdr: Retry #5375 failed, retrying in 60 seconds!
Sep 1 11:55:03 VDRServer vdr: epg2vdr: Trying to re-connect to database!
Sep 1 11:55:03 VDRServer vdr: epg2vdr: SQL-Error in 'prepare(stmt_prepare)' - Unknown column 'episode' in 'field list' (1054) 'Unknown column 'episode' in 'field list'' [select eventid, channelid, masterid, useid, source, fileref, inssp, updsp, updflg, delflg, tableid, version, title, comptitle, shorttext, compshorttext, longdescription, starttime, duration, parentalrating, vps, shortdescription, actor, audio, category, country, director, flags, genre, info, music, producer, screenplay, shortreview, tipp, topic, year, rating, fsk, movieid, moderator, other, guest, camera, extepnum, imagecount, episode, episodepart, episodelang, scrseriesid, scrseriesepisode, scrmovieid, scrsp from events where eventid = ? and channelid = ?;]
Sep 1 11:55:03 VDRServer vdr: epg2vdr: Retry #5376 failed, retrying in 60 seconds!
Sep 1 11:55:06 VDRServer vdr: [13958] connect from 192.168.1.107, port 60011 - accepted
Sep 1 11:55:06 VDRServer vdr: [13958] closing SVDRP connection
Sep 1 11:55:13 VDRServer vdr: epg2vdr: Trying to re-connect to database!
Sep 1 11:55:13 VDRServer vdr: epg2vdr: SQL-Error in 'prepare(stmt_prepare)' - Unknown column 'episode' in 'field list' (1054) 'Unknown column 'episode' in 'field list'' [select eventid, channelid, masterid, useid, source, fileref, inssp, updsp, updflg, delflg, tableid, version, title, comptitle, shorttext, compshorttext, longdescription, starttime, duration, parentalrating, vps, shortdescription, actor, audio, category, country, director, flags, genre, info, music, producer, screenplay, shortreview, tipp, topic, year, rating, fsk, movieid, moderator, other, guest, camera, extepnum, imagecount, episode, episodepart, episodelang, scrseriesid, scrseriesepisode, scrmovieid, scrsp from events where eventid = ? and channelid = ?;]
Sep 1 11:55:13 VDRServer vdr: epg2vdr: Retry #5377 failed, retrying in 60 seconds!
Sep 1 11:55:23 VDRServer vdr: epg2vdr: Trying to re-connect to database!
Sep 1 11:55:23 VDRServer vdr: epg2vdr: SQL-Error in 'prepare(stmt_prepare)' - Unknown column 'episode' in 'field list' (1054) 'Unknown column 'episode' in 'field list'' [select eventid, channelid, masterid, useid, source, fileref, inssp, updsp, updflg, delflg, tableid, version, title, comptitle, shorttext, compshorttext, longdescription, starttime, duration, parentalrating, vps, shortdescription, actor, audio, category, country, director, flags, genre, info, music, producer, screenplay, shortreview, tipp, topic, year, rating, fsk, movieid, moderator, other, guest, camera, extepnum, imagecount, episode, episodepart, episodelang, scrseriesid, scrseriesepisode, scrmovieid, scrsp from events where eventid = ? and channelid = ?;]
Sep 1 11:55:23 VDRServer vdr: epg2vdr: Retry #5378 failed, retrying in 60 seconds!
Alles anzeigen
Ständige SQL Errors, anscheinend fehlt eine Columne "Episode" ? Ich hab leider zuwenig Verständnis.
Gruss Willi
Moin
irgendwie hat mein EPG nicht mehr richtig funktioniert. Fehlende Timer, EPG nicht vollständig, und noch so einiges.
Dank eines Hinweises habe ich Dropall ausgeführt in der Hoffnung, es baut sich neu auf.
Leider nicht, Fehler im Syslog:
ug 31 13:35:10 VDRServer vdr: epg2vdr: Trying to re-connect to database!
Aug 31 13:35:10 VDRServer vdr: epg2vdr: Can't lookup epgd information, start epgd to create the tables first! Aborting now.
Aug 31 13:35:10 VDRServer vdr: epg2vdr: Retry #2 failed, retrying in 10 seconds!
Aug 31 13:35:10 VDRServer vdr: [26392] Streamdev: Accepted new client (VTP) 192.168.1.107:47878
Aug 31 13:35:10 VDRServer epgd: Statement statistic of last 1 seconds from 'merge/rec-scrap':
Aug 31 13:35:17 epgd: last message repeated 6 times
Irgendwie weiss ich nicht weiter.
Im Log tauchen auch andere Fehler auf:
Aug 31 14:02:46 VDRServer vdr: epg2vdr: Trying to re-connect to database!
Aug 31 14:02:46 VDRServer vdr: epg2vdr: SQL-Error in 'prepare(stmt_prepare)' - Unknown column 'episode' in 'field list' (1054) 'Unknown column 'episode' in 'field list'' [select eventid, channelid, masterid, useid, source, fileref, inssp, updsp, updflg, delflg, tableid, version, title, comptitle, shorttext, compshorttext, longdescription, starttime, duration, parentalrating, vps, shortdescription, actor, audio, category, country, director, flags, genre, info, music, producer, screenplay, shortreview, tipp, topic, year, rating, fsk, movieid, moderator, other, guest, camera, extepnum, imagecount, episode, episodepart, episodelang, scrseriesid, scrseriesepisode, scrmovieid, scrsp from events where eventid = ? and channelid = ?;]
Aug 31 14:02:46 VDRServer vdr: epg2vdr: Retry #116 failed, retrying in 60 seconds!
Aug 31 14:02:56 VDRServer vdr: epg2vdr: Trying to re-connect to database!
Aug 31 14:02:56 VDRServer vdr: epg2vdr: SQL-Error in 'prepare(stmt_prepare)' - Unknown column 'episode' in 'field list' (1054) 'Unknown column 'episode' in 'field list'' [select eventid, channelid, masterid, useid, source, fileref, inssp, updsp, updflg, delflg, tableid, version, title, comptitle, shorttext, compshorttext, longdescription, starttime, duration, parentalrating, vps, shortdescription, actor, audio, category, country, director, flags, genre, info, music, producer, screenplay, shortreview, tipp, topic, year, rating, fsk, movieid, moderator, other, guest, camera, extepnum, imagecount, episode, episodepart, episodelang, scrseriesid, scrseriesepisode, scrmovieid, scrsp from events where eventid = ? and channelid = ?;]
Aug 31 14:02:56 VDRServer vdr: epg2vdr: Retry #117 failed, retrying in 60 seconds!
Kann mir jemand auf die Sprünge helfen?
Gruss Willi
zum Thema Lüfter, ich nutze einen Cooltek ITX30, im Wohnzimmer VDR unhörbar.
danke hepi, ich habs mal geändert.
Gruss Willi