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

[Paul]

On 5/09/2009 4:05 AM, Michael T. Dean wrote:
> On 09/04/2009 01:16 AM, Michael T. Dean wrote:
>> Do a full backup of your broken database ( 
>> http://www.mythtv.org/wiki/Database_Backup_and_Restore ), then drop 
>> the database and then run mc.sql ( 
>> http://www.mythtv.org/wiki/Database_Backup_and_Restore#Database_Restore 
>> ), then start mythtv-setup and exit and do a partial restore of the 
>> database ( 
>> http://www.mythtv.org/wiki/Database_Backup_and_Restore#Partial_restore_of_a_backup 
>> ).  Then, erase all your broken oldrecorded.programid values:
>>
>> mysql -umythtv -p mythconverg -e "UPDATE oldrecorded "\
>> "SET programid = '' WHERE REGEXP('..[[:digit:]]{1,13}');"
> 
> Just realized I didn't copy correctly from my test run...
> 
> mysql -umythtv -p mythconverg -e "UPDATE oldrecorded "\
> "SET programid = '' WHERE programid REGEXP('..[[:digit:]]{1,13}');"
> 
> Mike
> 

Thanks again for your reply.

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..


XML eg
   <programme start="20090907203000 +1000" stop="20090907213000 +1000" channel="Prime-Can">
     <title>City Homicide</title>
     <sub-title>The Confession</sub-title>
     <desc>Has Stanley Wolfe always been a good cop? Somehow, this by-the-book senior 
sergeant is connected to the deaths of three people. The team wants to stand by their 
Sarge, but what isn&apos;t he telling them?</desc>
     <credits>
       <actor>Shane Bourne</actor>
       <actor>John Adam</actor>
       <actor>Daniel MacPherson</actor>
       <actor>Nadia Townsend</actor>
       <actor>Damien Richardson</actor>
     </credits>
     <date>2009</date>
     <category>Crime Drama</category>
     <category>Drama Group</category>
     <episode-num system="xmltv_ns">2.5.</episode-num>
     <rating><value>M</value></rating>
     <star-rating><value>0/10</value></star-rating>
   </programme>


Thanks
Paul