[mythtv-users] how do I list previously recorded shows?

[Michael T. Dean]

On 09/04/2009 05:25 PM, Paul wrote:
> On 5/09/2009 7:14 AM, Michael T. Dean wrote:
>> On 09/04/2009 05:07 PM, Paul wrote:
>>> I checked my database schema and it has VARCHAR(40) so db is ok.
>>> My Grabber is the Oztvio (australia) and therefor doesn't contain 
>>> any "programid" so I'm unsure where this data is coming from...(see 
>>> example below)
>>> So perhaps where ever its been generated some how its no fully 
>>> unique or they changed the generation code etc..  
>> If that's the case, then:
>>
>> mysql -umythtv -p mythconverg \
>> -e "UPDATE oldrecorded SET programid = ''; "\
>> "UPDATE program SET programid = '';"
>>
>> and keep watching to see if you get new programid's in program.  Myth 
>> doesn't generate it--it only takes whatever the grabber/EIT gives 
>> it--so if you continue to get it, it's coming from your grabber. 
> What does it look like in the XML file? ie have you an example of what 
> I should scan for?
> is it: <programid> </programid>??? 

OK, it looks like we build a programid for xmltv data using other 
information.  It starts with MV for movies, EP for series, SP for 
sports, or SH for other shows (based on category); followed by the 
seriesid (or the hash of the title if the seriesid is empty); then, if 
neither is empty, followed by episode then season; then, if neither is 
empty, followed by partnumber and parttotal.

If there's no episode or season info, the programid is erased (so normal 
dup checking rules apply).

With this approach, it's impossible to have a programid without a 
seriesid, episode, and season at minimum.

Your episode-num for, "The Confession," posted in an earlier response 
(<episode-num system="xmltv_ns">2.5.</episode-num>) contains the season 
and episode values 2 and 5, respectively, meaning the episode's 
programid should end in 63 (as it's a 0-based season, episode and part 
num/total in xmltv_ns episode-num and we increment it to it's 
"natural-counting" form).  Therefore, the programid value EP341898163 
for that episode, as shown in an earlier response, is correct, too.  
Looking at some other values:

seriesid seems to be 3418981

Thicker than Water, S2E1, is EP341898112
Somersaulting Dogs, S2E2, is EP341898122
In House, S2E3, is EP341898132
Taniwha, S2E4, is EP341898142

These are right.  What this doesn't explain is how, "The Cutting Edge," 
which was S2E20 got put in your database's oldrecorded as EP341898163 
instead of EP3418981192.  Without seeing the XMLTV data from March 15, 
I'll have to guess that either it was invalid data from the listings 
provider or something messed up values in your database.

The only way that Myth might be messing things up is if you're using 
/both/ XMLTV and EIT on the same channels--which is an unsupported 
configuration.  If you're not doing that, we'll always use the data 
provided by the listings provider.  On the bright side, even if the 
listings provider is breaking things, you can always just clear out any 
programid's from either oldrecorded or program when you see bad data.

Mike