Re: UK Atlas load/usage warning email

Neil Bird <[email protected]> Thu, 19 May 2016 19:29:15 +0100
Newsgroups gmane.comp.tv.xmltv.general
Message-ID <[email protected]>
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.

-- 
[phoenix@fnx ~]# rm -f .signature
[phoenix@fnx ~]# ls -l .signature
ls: .signature: No such file or directory
[phoenix@fnx ~]# exit

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