[mythtv-users] mythfilldatabase not updating?

j2 spamfilter2 at mupp.net
Sun Jan 9 11:41:00 EST 2005


Hello!

I can not get mythfilldatabase to update changes in scheduling. I am using 
tv_grab_se_swedb And when using --update i get stuff like below:

(Also, is --refresh-today and --refresh-second valid for this grabber?)


Basically, how can i "rewrite" the program guide, with the update data, and 
not loose the already scheduled programs?


[root at mythbox root]# mythfilldatabase --update
Refreshing Tomorrow's data
----------------- Start of XMLTV output -----------------
downloading listings: 100% 
[===================================================]------------------ End 
of XMLTV output ------------------
Updating icons for sourceid: 1
DB Error (program insert):
Query was:
INSERT INTO program 
(chanid,starttime,endtime,title,title_pronounce,subtitle,description,category,category_type,airdate,stars,previouslyshown) 
VALUES(:CHANID,:STARTTIME,:ENDTIME,:TITLE,:TITLE_PRONOUNCE,:SUBTITLE,:DESCRIPTION,:CATEGORY,:CATEGORY_TYPE,:AIRDATE,:STARS,:PREVIOUSLYSHOWN);
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '5-2005-01-10 01:25:00' for key 1

DB Error (program insert):
Query was:
INSERT INTO program 
(chanid,starttime,endtime,title,title_pronounce,subtitle,description,category,category_type,airdate,stars,previouslyshown) 
VALUES(:CHANID,:STARTTIME,:ENDTIME,:TITLE,:TITLE_PRONOUNCE,:SUBTITLE,:DESCRIPTION,:CATEGORY,:CATEGORY_TYPE,:AIRDATE,:STARS,:PREVIOUSLYSHOWN);
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '5-2005-01-10 02:15:00' for key 1

DB Error (program insert):
Query was:
INSERT INTO program 
(chanid,starttime,endtime,title,title_pronounce,subtitle,description,category,category_type,airdate,stars,previouslyshown) 
VALUES(:CHANID,:STARTTIME,:ENDTIME,:TITLE,:TITLE_PRONOUNCE,:SUBTITLE,:DESCRIPTION,:CATEGORY,:CATEGORY_TYPE,:AIRDATE,:STARS,:PREVIOUSLYSHOWN);
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '5-2005-01-10 03:00:00' for key 1

DB Error (program insert):
Query was:
INSERT INTO program 
(chanid,starttime,endtime,title,title_pronounce,subtitle,description,category,category_type,airdate,stars,previouslyshown) 
VALUES(:CHANID,:STARTTIME,:ENDTIME,:TITLE,:TITLE_PRONOUNCE,:SUBTITLE,:DESCRIPTION,:CATEGORY,:CATEGORY_TYPE,:AIRDATE,:STARS,:PREVIOUSLYSHOWN);
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '3-2005-01-10 01:45:00' for key 1

DB Error (program insert):
Query was:
INSERT INTO program 
(chanid,starttime,endtime,title,title_pronounce,subtitle,description,category,category_type,airdate,stars,previouslyshown) 
VALUES(:CHANID,:STARTTIME,:ENDTIME,:TITLE,:TITLE_PRONOUNCE,:SUBTITLE,:DESCRIPTION,:CATEGORY,:CATEGORY_TYPE,:AIRDATE,:STARS,:PREVIOUSLYSHOWN);
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '3-2005-01-10 03:45:00' for key 1

DB Error (program insert):
Query was:
INSERT INTO program 
(chanid,starttime,endtime,title,title_pronounce,subtitle,description,category,category_type,airdate,stars,previouslyshown) 
VALUES(:CHANID,:STARTTIME,:ENDTIME,:TITLE,:TITLE_PRONOUNCE,:SUBTITLE,:DESCRIPTION,:CATEGORY,:CATEGORY_TYPE,:AIRDATE,:STARS,:PREVIOUSLYSHOWN);
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '3-2005-01-10 04:35:00' for key 1

DB Error (program insert):
Query was:
INSERT INTO program 
(chanid,starttime,endtime,title,title_pronounce,subtitle,description,category,category_type,airdate,stars,previouslyshown) 
VALUES(:CHANID,:STARTTIME,:ENDTIME,:TITLE,:TITLE_PRONOUNCE,:SUBTITLE,:DESCRIPTION,:CATEGORY,:CATEGORY_TYPE,:AIRDATE,:STARS,:PREVIOUSLYSHOWN);
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '3-2005-01-10 05:25:00' for key 1

DB Error (program insert):
Query was:
INSERT INTO program 
(chanid,starttime,endtime,title,title_pronounce,subtitle,description,category,category_type,airdate,stars,previouslyshown) 
VALUES(:CHANID,:STARTTIME,:ENDTIME,:TITLE,:TITLE_PRONOUNCE,:SUBTITLE,:DESCRIPTION,:CATEGORY,:CATEGORY_TYPE,:AIRDATE,:STARS,:PREVIOUSLYSHOWN);
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '4-2005-01-10 01:35:00' for key 1

DB Error (program insert):
Query was:
INSERT INTO program 
(chanid,starttime,endtime,title,title_pronounce,subtitle,description,category,category_type,airdate,stars,previouslyshown) 
VALUES(:CHANID,:STARTTIME,:ENDTIME,:TITLE,:TITLE_PRONOUNCE,:SUBTITLE,:DESCRIPTION,:CATEGORY,:CATEGORY_TYPE,:AIRDATE,:STARS,:PREVIOUSLYSHOWN);
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '4-2005-01-10 02:15:00' for key 1

DB Error (program insert):
Query was:
INSERT INTO program 
(chanid,starttime,endtime,title,title_pronounce,subtitle,description,category,category_type,airdate,stars,previouslyshown) 
VALUES(:CHANID,:STARTTIME,:ENDTIME,:TITLE,:TITLE_PRONOUNCE,:SUBTITLE,:DESCRIPTION,:CATEGORY,:CATEGORY_TYPE,:AIRDATE,:STARS,:PREVIOUSLYSHOWN);
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '4-2005-01-10 05:59:00' for key 1

DB Error (program insert):
Query was:
INSERT INTO program 
(chanid,starttime,endtime,title,title_pronounce,subtitle,description,category,category_type,airdate,stars,previouslyshown) 
VALUES(:CHANID,:STARTTIME,:ENDTIME,:TITLE,:TITLE_PRONOUNCE,:SUBTITLE,:DESCRIPTION,:CATEGORY,:CATEGORY_TYPE,:AIRDATE,:STARS,:PREVIOUSLYSHOWN);
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '6-2005-01-10 01:05:00' for key 1

DB Error (program insert):
Query was:
INSERT INTO program 
(chanid,starttime,endtime,title,title_pronounce,subtitle,description,category,category_type,airdate,stars,previouslyshown) 
VALUES(:CHANID,:STARTTIME,:ENDTIME,:TITLE,:TITLE_PRONOUNCE,:SUBTITLE,:DESCRIPTION,:CATEGORY,:CATEGORY_TYPE,:AIRDATE,:STARS,:PREVIOUSLYSHOWN);
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '6-2005-01-10 01:10:00' for key 1

DB Error (program insert):
Query was:
INSERT INTO program 
(chanid,starttime,endtime,title,title_pronounce,subtitle,description,category,category_type,airdate,stars,previouslyshown) 
VALUES(:CHANID,:STARTTIME,:ENDTIME,:TITLE,:TITLE_PRONOUNCE,:SUBTITLE,:DESCRIPTION,:CATEGORY,:CATEGORY_TYPE,:AIRDATE,:STARS,:PREVIOUSLYSHOWN);
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '6-2005-01-10 02:05:00' for key 1

DB Error (program insert):
Query was:
INSERT INTO program 
(chanid,starttime,endtime,title,title_pronounce,subtitle,description,category,category_type,airdate,stars,previouslyshown) 
VALUES(:CHANID,:STARTTIME,:ENDTIME,:TITLE,:TITLE_PRONOUNCE,:SUBTITLE,:DESCRIPTION,:CATEGORY,:CATEGORY_TYPE,:AIRDATE,:STARS,:PREVIOUSLYSHOWN);
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '6-2005-01-10 02:10:00' for key 1

DB Error (program insert):
Query was:
INSERT INTO program 
(chanid,starttime,endtime,title,title_pronounce,subtitle,description,category,category_type,airdate,stars,previouslyshown) 
VALUES(:CHANID,:STARTTIME,:ENDTIME,:TITLE,:TITLE_PRONOUNCE,:SUBTITLE,:DESCRIPTION,:CATEGORY,:CATEGORY_TYPE,:AIRDATE,:STARS,:PREVIOUSLYSHOWN);
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '6-2005-01-10 05:00:00' for key 1

DB Error (program insert):
Query was:
INSERT INTO program 
(chanid,starttime,endtime,title,title_pronounce,subtitle,description,category,category_type,airdate,stars,previouslyshown) 
VALUES(:CHANID,:STARTTIME,:ENDTIME,:TITLE,:TITLE_PRONOUNCE,:SUBTITLE,:DESCRIPTION,:CATEGORY,:CATEGORY_TYPE,:AIRDATE,:STARS,:PREVIOUSLYSHOWN);
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '6-2005-01-10 05:55:00' for key 1

Data is already present for Sun Jan 9 2005, skipping
Data is already present for Tue Jan 11 2005, skipping
Data is already present for Wed Jan 12 2005, skipping
Data is already present for Thu Jan 13 2005, skipping
Data is already present for Fri Jan 14 2005, skipping
Data is already present for Sat Jan 15 2005, skipping
Data is already present for Sun Jan 16 2005, skipping
Data is already present for Mon Jan 17 2005, skipping
Data is already present for Tue Jan 18 2005, skipping
Data is already present for Wed Jan 19 2005, skipping
Data is already present for Thu Jan 20 2005, skipping
Data is already present for Fri Jan 21 2005, skipping
Data is already present for Sat Jan 22 2005, skipping
Refreshing Tomorrow's data
----------------- Start of XMLTV output -----------------
downloading listings: (nothing to do)------------------ End of XMLTV 
output ------------------
Updating icons for sourceid: 2
Fetching data for Sun Jan 9 2005
----------------- Start of XMLTV output -----------------
downloading listings: (nothing to do)------------------ End of XMLTV 
output ------------------
Updating icons for sourceid: 2
Fetching data for Tue Jan 11 2005
----------------- Start of XMLTV output -----------------
downloading listings: (nothing to do)------------------ End of XMLTV 
output ------------------
Updating icons for sourceid: 2
Fetching data for Wed Jan 12 2005
----------------- Start of XMLTV output -----------------
downloading listings: (nothing to do)------------------ End of XMLTV 
output ------------------
Updating icons for sourceid: 2
Fetching data for Thu Jan 13 2005
----------------- Start of XMLTV output -----------------
downloading listings: (nothing to do)------------------ End of XMLTV 
output ------------------
Updating icons for sourceid: 2
Fetching data for Fri Jan 14 2005
----------------- Start of XMLTV output -----------------
downloading listings: (nothing to do)------------------ End of XMLTV 
output ------------------
Updating icons for sourceid: 2
Fetching data for Sat Jan 15 2005
----------------- Start of XMLTV output -----------------
downloading listings: (nothing to do)------------------ End of XMLTV 
output ------------------
Updating icons for sourceid: 2
Fetching data for Sun Jan 16 2005
----------------- Start of XMLTV output -----------------
downloading listings: (nothing to do)------------------ End of XMLTV 
output ------------------
Updating icons for sourceid: 2
Fetching data for Mon Jan 17 2005
----------------- Start of XMLTV output -----------------
downloading listings: (nothing to do)------------------ End of XMLTV 
output ------------------
Updating icons for sourceid: 2
Fetching data for Tue Jan 18 2005
----------------- Start of XMLTV output -----------------
downloading listings: (nothing to do)------------------ End of XMLTV 
output ------------------
Updating icons for sourceid: 2
Fetching data for Wed Jan 19 2005
----------------- Start of XMLTV output -----------------
downloading listings: (nothing to do)------------------ End of XMLTV 
output ------------------
Updating icons for sourceid: 2
Fetching data for Thu Jan 20 2005
----------------- Start of XMLTV output -----------------
downloading listings: (nothing to do)------------------ End of XMLTV 
output ------------------
Updating icons for sourceid: 2
Fetching data for Fri Jan 21 2005
----------------- Start of XMLTV output -----------------
downloading listings: (nothing to do)------------------ End of XMLTV 
output ------------------
Updating icons for sourceid: 2
Fetching data for Sat Jan 22 2005
----------------- Start of XMLTV output -----------------
downloading listings: (nothing to do)------------------ End of XMLTV 
output ------------------
Updating icons for sourceid: 2
Adjusting program database end times...
0 replacements made.



More information about the mythtv-users mailing list