[mythtv-users] mythfilldatabase and XMLTV Grabber tv_grab_eu_epgdata in Version 0.5.51
Wolfgang Trexler
wt-lists at trexler.at
Fri Feb 22 16:34:02 UTC 2008
Hi,
I updated tv_grab_eu_epgdata from 0.5.50 to 0.5.51
a few days ago and since then experience the following problems in the
regular mythtv-backend (mythtv version Debian 0.20.20070821-1) run:
...
Error inserting person
Error inserting person
2008-02-19 06:59:53.883 DB Error (person insert):
Query was:
INSERT INTO people (name) VALUES ('Martin Mull (Mr. Kraft) - Melissa
Joan Hart (Sabrina) - Lindsay Sloane (Valerie) - Beth Broderick (Zelda)
- Caroline Rhea (Hilda)');
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry 'Martin Mull (Mr. Kraft) - Melissa Joan Ha' for key 2
...
Has anyone else experienced the same problems with mythtv and XMLTV?
btw: I get tons of "Ignoring empty timestamp." messages...
br
Wolfgang
enclosed a more detailed output:
/etc/cron.daily/mythtv-backend:
2008-02-19 06:57:39.409 Using runtime prefix = /usr
2008-02-19 06:57:39.586 New DB connection, total: 1
2008-02-19 06:57:39.603 Connected to database 'mythconverg' at host:
localhost
2008-02-19 06:57:39.624 New DB connection, total: 2
2008-02-19 06:57:39.625 Connected to database 'mythconverg' at host:
localhost
2008-02-19 06:57:39.853 Updating source #1 (KabelTV) with grabber
tv_grab_eu_epgdata
2008-02-19 06:57:39.855 Found 3 channels for source 1 which use grabber
2008-02-19 06:57:41.052 Grabber has capabilities: baseline manualconfig
tkconfig apiconfig cache
2008-02-19 06:57:41.054
2008-02-19 06:57:41.054 Checking day @ offset 0, date: Die Feb 19 2008
2008-02-19 06:57:41.062 Data is already present for Die Feb 19 2008,
skipping
2008-02-19 06:57:41.063
2008-02-19 06:57:41.063 Checking day @ offset 1, date: Mit Feb 20 2008
2008-02-19 06:57:41.063 Data Refresh always needed for tomorrow
2008-02-19 06:57:41.063 Refreshing data for Mit Feb 20 2008
2008-02-19 06:57:41.065 New DB connection, total: 3
2008-02-19 06:57:41.066 Connected to database 'mythconverg' at host:
localhost
2008-02-19 06:57:41.070 Grabber Command: nice tv_grab_eu_epgdata
--config-file '/home/mythtv/.mythtv/KabelTV.xmltv' --output
/tmp/mythMJ1SEd --days 1 --offset 1
2008-02-19 06:57:41.071 ----------------- Start of XMLTV output
-----------------
2008-02-19 06:58:51.883 ------------------ End of XMLTV output
------------------
2008-02-19 06:58:51.958 New DB connection, total: 4
2008-02-19 06:58:51.959 Connected to database 'mythconverg' at host:
localhost
Ignoring empty timestamp.
[deleted several lines]
Ignoring empty timestamp.
2008-02-19 06:58:52.016 Updating icons for sourceid: 1
2008-02-19 06:58:52.020 New DB connection, total: 5
2008-02-19 06:58:52.021 Connected to database 'mythconverg' at host:
localhost
removing existing program: 1.orf.at Sabrina - Total verhext!
2008-02-20T08:25:00 - 2008-02-20T08:45:00
inserting new program : 1.orf.at Sabrina - Total verhext! Mit Feb 20
08:25:00 2008 - Mit Feb 20 08:45:00 2008
2008-02-19 06:58:52.085 New DB connection, total: 6
2008-02-19 06:58:52.086 Connected to database 'mythconverg' at host:
localhost
removing existing program: 1.orf.at Zwillinge auf Zack
2008-02-20T14:35:00 - 2008-02-20T15:00:00
inserting new program : 1.orf.at Zwillinge auf Zack Mit Feb 20
14:35:00 2008 - Mit Feb 20 15:00:00 2008
removing existing program: 1.orf.at Sabrina - Total verhext!
2008-02-20T15:05:00 - 2008-02-20T15:30:00
inserting new program : 1.orf.at Sabrina - Total verhext! Mit Feb 20
15:05:00 2008 - Mit Feb 20 15:30:00 2008
removing existing program: 1.orf.at Anatomie 2 2008-02-21T00:45:00 -
2008-02-21T02:20:00
inserting new program : 1.orf.at Anatomie 2 Don Feb 21 00:45:00 2008
- Don Feb 21 02:20:00 2008
Error inserting person
removing existing program: 1.orf.at Tödliche Freiheit
2008-02-21T02:20:00 - 2008-02-21T03:45:00
inserting new program : 1.orf.at Tödliche Freiheit Don Feb 21
02:20:00 2008 - Don Feb 21 03:45:00 2008
Error inserting person
removing existing program: 1.orf.at Morgen ist die Ewigkeit
2008-02-21T03:45:00 - 2008-02-21T06:00:00
removing existing program: 1.orf.at Eine schrecklich nette Familie
2008-02-21T05:25:00 - 2008-02-21T06:00:00
inserting new program : 1.orf.at Morgen ist die Ewigkeit Don Feb 21
03:45:00 2008 - Don Feb 21 06:00:00 2008
Error inserting person
removing existing program: 2.orf.at Konkret: Das Servicemagazin
2008-02-20T05:50:00 - 2008-02-20T06:10:00
removing existing program: 2.orf.at Text aktuell 2008-02-20T06:10:00 -
2008-02-20T07:00:00
inserting new program : 2.orf.at Konkret: Das Servicemagazin Mit Feb
20 05:50:00 2008 - Mit Feb 20 06:15:00 2008
removing existing program: 2.orf.at Report 2008-02-20T12:00:00 -
2008-02-20T12:55:00
inserting new program : 2.orf.at Report Mit Feb 20 12:00:00 2008 -
Mit Feb 20 12:55:00 2008
removing existing program: 2.orf.at Club 2 2008-02-20T23:00:00 -
2008-02-21T00:00:00
inserting new program : 2.orf.at Club 2 Mit Feb 20 23:00:00 2008 -
Don Feb 21 00:00:00 2008
Updated programs: 10 Unchanged programs: 109
2008-02-19 06:58:52.892
2008-02-19 06:58:52.892 Checking day @ offset 2, date: Don Feb 21 2008
2008-02-19 06:58:52.901 Data is already present for Don Feb 21 2008,
skipping
2008-02-19 06:58:52.901
2008-02-19 06:58:52.902 Checking day @ offset 3, date: Fre Feb 22 2008
2008-02-19 06:58:52.910 Data is already present for Fre Feb 22 2008,
skipping
2008-02-19 06:58:52.911
2008-02-19 06:58:52.911 Checking day @ offset 4, date: Sam Feb 23 2008
2008-02-19 06:58:52.919 Data is already present for Sam Feb 23 2008,
skipping
2008-02-19 06:58:52.919
2008-02-19 06:58:52.919 Checking day @ offset 5, date: Son Feb 24 2008
2008-02-19 06:58:52.928 Data is already present for Son Feb 24 2008,
skipping
2008-02-19 06:58:52.928
2008-02-19 06:58:52.932 Checking day @ offset 6, date: Mon Feb 25 2008
2008-02-19 06:58:52.940 Data refresh needed because no data exists for
day @ offset 6 from 6PM - midnight.
2008-02-19 06:58:52.941 Refreshing data for Mon Feb 25 2008
2008-02-19 06:58:52.943 Grabber Command: nice tv_grab_eu_epgdata
--config-file '/home/mythtv/.mythtv/KabelTV.xmltv' --output
/tmp/mythpj3DMh --days 1 --offset 6
2008-02-19 06:58:52.944 ----------------- Start of XMLTV output
-----------------
2008-02-19 06:59:53.462 ------------------ End of XMLTV output
------------------
Ignoring empty timestamp.
[deleted several lines]
Ignoring empty timestamp.
2008-02-19 06:59:53.580 Updating icons for sourceid: 1
Error inserting person
Error inserting person
2008-02-19 06:59:53.883 DB Error (person insert):
Query was:
INSERT INTO people (name) VALUES ('Martin Mull (Mr. Kraft) - Melissa
Joan Hart (Sabrina) - Lindsay Sloane (Valerie) - Beth Broderick (Zelda)
- Caroline Rhea (Hilda)');
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry 'Martin Mull (Mr. Kraft) - Melissa Joan Ha' for key 2
Error inserting person
Error inserting person
Error inserting person
Error inserting person
Error inserting person
2008-02-19 06:59:54.129 DB Error (person insert):
Query was:
INSERT INTO people (name) VALUES ('Katherine Heigl (Dr. Isobel "Izzie"
Stevens) - Patrick Dempsey (Dr. Derek Shepherd) - Sandra Oh (Dr.
Cristina Yang) - Ellen Pompeo (Dr. Meredith Grey) - Justin Chambers (Dr.
Alex Karev)');
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry 'Katherine Heigl (Dr. Isobel "Izzie" Steve' for key 2
Error inserting person
Error inserting person
Error inserting person
2008-02-19 06:59:54.198 DB Error (person insert):
Query was:
INSERT INTO people (name) VALUES ('Teri Hatcher (Susan Delfino) -
Nicollette Sheridan (Edie Britt) - Felicity Huffman (Lynette Scavo) -
Eva Longoria (Gabrielle Lang)');
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry 'Teri Hatcher (Susan Delfino) - Nicollette' for key 2
Error inserting person
2008-02-19 06:59:54.212 DB Error (person insert):
Query was:
INSERT INTO people (name) VALUES ('Katherine Heigl (Dr. Isobel "Izzie"
Stevens) - Patrick Dempsey (Dr. Derek Shepherd) - Sandra Oh (Dr.
Cristina Yang) - Ellen Pompeo (Dr. Meredith Grey) - Justin Chambers (Dr.
Alex Karev)');
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry 'Katherine Heigl (Dr. Isobel "Izzie" Steve' for key 2
Error inserting person
2008-02-19 06:59:54.227 DB Error (person insert):
Query was:
INSERT INTO people (name) VALUES ('Taye Diggs (Dr. Sam Bennett) - Tim
Daly (Dr. Pete Wilder) - Kate Walsh (Dr. Addison Forbes Montgomery) -
Paul Adelstein (Dr. Cooper Freedman) - Amy Brenneman (Dr. Violet Turner)');
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry 'Taye Diggs (Dr. Sam Bennett) - Tim Daly (' for key 2
Error inserting person
Error inserting person
Error inserting person
2008-02-19 06:59:54.428 DB Error (person insert):
Query was:
INSERT INTO people (name) VALUES ('Tanja Wedhorn (Bianca Berger) -
Patrik Fichte (Oliver Wellinghoff) - Michael Rotschopf (Pascal
Wellinghoff) - Eva Klemt (Tina Rüger) - Peter Hladik (Alexander
Wellinghoff)');
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry 'Tanja Wedhorn (Bianca Berger) - Patrik Fi' for key 2
Error inserting person
2008-02-19 06:59:54.443 DB Error (person insert):
Query was:
INSERT INTO people (name) VALUES ('Ralph Schicha (Tobias Becker) - Karin
Ugowski (Eva Landmann) - Silke Matthias (Helena Bernstein) - Peter
Zimmermann (Richard van Weyden) - Heike Schroetter (Marianne Becker) -
Anja Boche (Nora van Weyden)');
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry 'Ralph Schicha (Tobias Becker) - Karin Ugo' for key 2
Error inserting person
Error inserting person
Error inserting person
2008-02-19 06:59:54.700 DB Error (person insert):
Query was:
INSERT INTO people (name) VALUES ('Tanja Wedhorn (Bianca Berger) -
Patrik Fichte (Oliver Wellinghoff) - Michael Rotschopf (Pascal
Wellinghoff) - Eva Klemt (Tina Rüger) - Peter Hladik (Alexander
Wellinghoff)');
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry 'Tanja Wedhorn (Bianca Berger) - Patrik Fi' for key 2
Error inserting person
Error inserting person
2008-02-19 06:59:55.136 DB Error (person insert):
Query was:
INSERT INTO people (name) VALUES ('John Candy - John Candy (Irving "Irv"
Blitzer) - Peter Outerbridge (Josef Grool) - Leon - Paul Coeur (Roger)
- Raymond J. Barry - Raymond J. Barry (Kurt Hemphill) - Malik Yoba (Yul
Brenner) - Malik Yoba - Doug E. Doug - Doug E. Doug (Sanka Coffie) -
Leon Robinson (Derice Bannock) - Larry Gilman (Larry) - Rawle D. Lewis -
Rawle D. Lewis (Junior Bevil) - Charles Hyatt (Whitby Bevil sen.) -
Winston Stona (Coolidge) - Bertina MacAuley (Joy Bannock)');
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry 'John Candy - John Candy (Irving "Irv" Bli' for key 2
Error inserting person
Updated programs: 115 Unchanged programs: 0
More information about the mythtv-users
mailing list