[mythtv] mythfilldatabase --file complains on old data

Scott RoLanD shroland at mac.com
Thu Jan 27 09:29:10 EST 2005


I am working with the it_lt grabber which is rather slow, especially
when fetching a full weeks worth of program data. The problem comes
when I try to use mythfilldatabase to read in the data:
  mythfilldatabase --file 1 -1 ~/it.small.xml

By sending the -1 to the 'offset' arg of --file I am supposedly
telling it to "replace all data, up to 10 day". But in this mode it
complains about the program entries that are for yesterday. I whittled
down the XML input file to one entry and have enclosed it to make sure
that it is not the file that is corrupt. Here is the ouput from the
above call:
----------------------------------------------------------------------
### bypassing grabbers, reading directly from file
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(1127,'20050126174500','20050127000000','Videiamo','','','Fascia di programmazione di video musicali.','Musica','','2005','0',0);
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '1127-2005-01-26 17:45:00' for key 1

Adjusting program database end times...
0 replacements made.
2005-01-27 15:25:33.773 Connecting to backend server: 192.168.1.104:6543 (try 1 of 5)
2005-01-27 15:25:33.781 Using protocol version 14
Marking repeats...found 0
Unmarking repeats from grabber that fall within our new episode window...found 0
----------------------------------------------------------------------

In the above example note that I ran it 2005-01-27 and the program
information is for 2005-01-26. If I change the program information to
be for one day later or one day earlier then mythfilldatabase doesn't
give me any problems.

I am using the latest version from CVS.
-- 
Scott Roland


More information about the mythtv-dev mailing list