[mythtv] Re: mythfilldatabase --file complains on old data

Scott RoLanD shroland at mac.com
Thu Jan 27 09:49:53 EST 2005


I forgot to attach my XML file. I did it this time.

Scott RoLanD wrote: (Thu, Jan 27, 2005 at  3:29 PM +0100)
> 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
-- 
Scott Roland
-------------- next part --------------
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE tv SYSTEM "xmltv.dtd">

<tv source-info-url="http://satellite.it/" source-data-url="http://www.satellite.it/canali.asp" generator-info-name="XMLTV" generator-info-url="http://membled.com/work/apps/xmltv/">
  <channel id="www.videoitalia.it">
    <display-name>Video Italia</display-name>
    <icon src="http://www.satellite.it/loghi/67_big.gif" />
  </channel>
  <programme start="20050126174500 +0100" channel="www.videoitalia.it">
    <title lang="it">Videiamo</title>
    <desc lang="it">Fascia di programmazione di video musicali.</desc>
    <category lang="it">Musica</category>
    <category lang="it">Videoclip</category>
    <country lang="it">Italia</country>
    <rating>
      <value>Per tutti</value>
    </rating>
  </programme>
</tv>


More information about the mythtv-dev mailing list