[mythtv-users] Problem after upgrading MythTV and recorded programs.

[Jean-Yves Avenard]

On 2/21/06, Bruce Markey <bjm at lvcm.com> wrote:
>
> Don't do something drastic for the sake of doing something drastic.


I only try what people suggest, i've missed recordings because of this
issue.

if I do:
select subtitle, seriesid, syndicatedepisodenumber, programid from program
where title="Desperate Housewives";

I get:
+-------------------------------+-----------+-------------------------+-----------+
| subtitle                      | seriesid  | syndicatedepisodenumber |
programid |
+-------------------------------+-----------+-------------------------+-----------+
| My Heart Belongs to Daddy     | 253769251 |
|           |
| My Heart Belongs to Daddy     | 253769251 |
|           |
| You'll Never Get Away from Me | 253769251 |
|           |
| You'll Never Get Away from Me | 253769251 |
|           |
| You'll Never Get Away from Me | 253769251 |
|           |
|                               |           |
|           |
|                               |           |
|           |
|                               |           |
|           |
|                               |           |
|           |
| My Heart Belongs to Daddy     | 253769251 |
|           |
+-------------------------------+-----------+-------------------------+-----------+
10 rows in set (0.00 sec)

Note that I have assign the same XMLTVID to two channels, one broadcast in
SD, one in HD, so I can select the quality.

Not knowing how to extract specific field, I dump the whole database, and I
found the following relevant bits:
CREATE TABLE `recordedprogram` (
`chanid` int(10) unsigned NOT NULL default '0',
`starttime` datetime NOT NULL default '0000-00-00 00:00:00',
`endtime` datetime NOT NULL default '0000-00-00 00:00:00',
`title` varchar(128) NOT NULL default '',
`subtitle` varchar(128) NOT NULL default '',
`description` text NOT NULL,
`category` varchar(64) NOT NULL default '',
`category_type` varchar(64) NOT NULL default '',
`airdate` year(4) NOT NULL default '0000',
`stars` float unsigned NOT NULL default '0',
`previouslyshown` tinyint(4) NOT NULL default '0',
`title_pronounce` varchar(128) NOT NULL default '',
`stereo` tinyint(1) NOT NULL default '0',
`subtitled` tinyint(1) NOT NULL default '0',
`hdtv` tinyint(1) NOT NULL default '0',
`closecaptioned` tinyint(1) NOT NULL default '0',
`partnumber` int(11) NOT NULL default '0',
`parttotal` int(11) NOT NULL default '0',
`seriesid` varchar(12) NOT NULL default '',
`originalairdate` date default NULL
`showtype` varchar(30) NOT NULL default '',
`colorcode` varchar(20) NOT NULL default '',
`syndicatedepisodenumber` varchar(20) NOT NULL default '',
`programid` varchar(20) NOT NULL default '',
`manualid` int(10) unsigned NOT NULL default '0',
`generic` tinyint(1) default '0',

So if I udnerstand properly, the field mentioned earlier have the correct
length

thanks for your time and patience.

JY
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20060221/26e11595/attachment.htm