Re: UK Atlas load/usage warning email

On May 22, 2016 12:02:27 PM GMT+01:00, Ian Campbell <[email protected]> wrote:
>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.

If you have used a mixture of EIT and XMLTV (which you almost certainly will have done in UK for radio at least), you will probably only want to blank the programid for entries which were autogenerated by mythfilldatabase from the xmltv info, in other words, only the ones like EPxxxxxx, MVxxxxxx, SHxxxxxx, SPxxxxxx, not the ones like fp.bbc.co.uk/xxxxxx. I'm not sure how you would do that in SQL.

John

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