[mythtv] mythfilldatabase error--- AT&T broadband bought out by comcast

Rick Warner rick at sapphire.no-ip.com
Fri Feb 21 20:33:57 EST 2003


Hello all,

My cable service was just switched to Comcast from AT&T Broadband. I live in 
northeast USA. mythfilldatabase picks this up saying: 


checking provider information for postal/zip code 02723, be patient..
recoverable change (provider description changed to (Comcast - Fall River - 
Digital)), think about re-running --configure

I am running mythrv cvs circa a week ago, with xmltv 0.5.7.
It gets the data as normal, and outputs the following error messages besides 
the typical removing conflicting program errors. After the second error 
message is output, mythfilldatabase just stops even though its only gotten 1 
days worth of listings (no segfault like previous problems ppl have had).

DB Error (program insert):
Query was:
INSERT INTO program 
(chanid,starttime,endtime,title,subtitle,description,category) VALUES(1245, 
"20030222220000", "20030222230000", "Jazz Collection", "John Coltrane", 
"Saxophonist John Coltrane.", "Musical");
Driver error was:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '1245-20030222220000' for key 1
............
............
removing conflicting program.. blah blah blah (stupid channels that have 
screwed up schedules usually--ppv, etc)
etc.
................
..............
DB Error (program insert):
Query was:
INSERT INTO program 
(chanid,starttime,endtime,title,subtitle,description,category) VALUES(1253, 
"20030222230000", "29350930228000000", "La Profesión", "El Negocio de 
Siempre", "", "Adult");
Driver error was:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '1253-20030222230000' for key 1tc.
...........
more conflicting program error messages
...........
...........
DB Error (program insert):
Query was:
INSERT INTO program 
(chanid,starttime,endtime,title,subtitle,description,category) VALUES(1056, 
"20030222230000", "29350930228000000", "The Journey Home", "", "", "Talk");
Driver error was:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '1056-20030222230000' for key 1

returns to prompt here with no other output



More information about the mythtv-dev mailing list