Re: UK Atlas load/usage warning email

On Thu, 2016-05-19 at 19:29 +0100, Neil Bird wrote:
> On 19/05/16 18:36, Neil Bird wrote:
> > On 19/05/16 11:57, Ian Campbell wrote:
> > > I'm not sure if what was being suggested was something like:
> > > 	UPDATE oldrecorded SET programid='';
> >    That's what I'm expecting to work.  I think we will need to do it to
> > the recorded table as well (the progs. still available to watch).
> 
>    I got an answer off the ever-helpful Michael Dean on the MythTV list:
> 
> > Blank it (set it equal to '' (empty single or double quotes)), don't
> > NULL it (the column is a NOT NULL column), in recorded and
> > oldrecorded.  You should probably also blank it from recordedprogram
> > (which is just the program information for your existing
> > recordings).
> 
>    The field is programid in, I think, all three tables.

FWIW I experimented with this for a single program and it seems to have
worked as expected:
    update oldrecorded set programid='' where title='Hey Duggee';
    update recorded set programid='' where title='Hey Duggee';
    update recordedprogram set programid='' where title='Hey Duggee';

Has changed all of the upcoming duplicated recordings into 'Currently
Recorded'.

Ian.

------------------------------------------------------------------------------
Mobile security can be enabling, not merely restricting. Employees who
bring their own devices (BYOD) to work are irked by the imposition of MDM
restrictions. Mobile Device Manager Plus allows you to control only the
apps on BYO-devices by containerizing them, leaving personal data untouched!
https://ad.doubleclick.net/ddm/clk/304595813;131938128;j
_______________________________________________
xmltv-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/xmltv-users