[mythtv-users] Mythfilldatabase - please help

[Jakub Velimsky]

Hi all,

After upgrading to MythTV 0.19, the mythfilldatabase ceased to update the 
program schedule. The source is a file tv_grab_cz.xml with four channels:

*****
<?xml version="1.0" encoding="iso-8859-2"?>
<!DOCTYPE tv SYSTEM "xmltv.dtd">
<tv>
<channel id="CT1">
<display-name>ČT1</display-name>
</channel>
<channel id="CT2">
<display-name>ČT2</display-name>
</channel>
<channel id="Nova">
<display-name>Nova</display-name>
</channel>
<channel id="Prima">
<display-name>Prima</display-name>
</channel>
        <programme channel='CT1' start='20060513050000 +0200'>
                <title>Diagnóza</title>
                <desc>Léčba akné O kožním onemocnění, které trápí mladé 
lidi</desc>
                <category>Dokument</category>
        </programme>
etc.
*****

After running:

*****
mythfilldatabase --file Antenna 0 ./tv_grab_cz.xml
*****

I get on stdout:

*****
### bypassing grabbers, reading directly from file
2006-05-13 23:53:58.479 Using runtime prefix = /usr/local
2006-05-13 23:53:58.516 New DB connection, total: 1
2006-05-13 23:53:58.533 Connected to database 'mythconverg' at host: 
localhost
2006-05-13 23:53:58.729 New DB connection, total: 2
2006-05-13 23:53:58.730 Connected to database 'mythconverg' at host: 
localhost
2006-05-13 23:53:58.990 New DB DataDirect connection
2006-05-13 23:53:58.991 Connected to database 'mythconverg' at host: 
localhost
2006-05-13 23:53:58.994 New DB connection, total: 3
2006-05-13 23:53:58.996 Connected to database 'mythconverg' at host: 
localhost
2006-05-13 23:53:58.999 DB Error (Adding Service):
Query was:
INSERT INTO channel   (chanid,        channum,    sourceid,   callsign,
name,          mplexid,    serviceid,  atscsrcid,    useonairguide, 
visible,    freqid,     tvformat,     icon,          xmltvid) VALUES   (1,       
'',   0,  'CT1',     'CT1',         NULL,   0, 0,    0,       1,   NULL,    
'Default',     '',         'CT1')
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '1' for key 1

(and similarly for other three channels)
*****

and on stderr:

*****
Unknown xmltv channel identifier: CT1
Skipping channel.
Unknown xmltv channel identifier: CT2
Skipping channel.
Unknown xmltv channel identifier: Nova
Skipping channel.
Unknown xmltv channel identifier: Prima
Skipping channel.
Updated programs: 0  Unchanged programs: 0
*****

All channels were loaded into Mythtv through mythfilldatabase --manual and 
can be watched and recorded directly in mythfrontend. It seems to me that 
the xml file is OK. Any ideas, what might be wrong? Thanks.

Jakub

--------- Jakub VELIMSKY --------- 
http://geo.mff.cuni.cz/~velimsky/