[mythtvnz] MultiRec Turned Off?

[Tortise]

----- Original Message ----- 
From: "Stephen Worthington" <stephen_agent at jsw.gen.nz>
To: "MythTV in NZ" <mythtvnz at lists.linuxnut.co.nz>
Sent: Monday, February 22, 2010 12:34 PM
Subject: Re: [mythtvnz] MultiRec Turned Off?


OK, I guess predictably this has made a significant difference, multirec provisionally now works to expectation, I've tested 
recording all the 50 mux channels simultaneoulsy and they now all come off the first tuner.....  All the Live TV channel icons are 
also now displaying properly!  (Not previoulsy mentioned)

What I did was revise my faulty channel table using the reference data Stephen had kindly provided.

In the end I did it with the backend running but idle, I observed that mythweb saved the sql updates while the backend was running 
so I figured they'd be ok while backend did nothing.  So far seems reasonable as all looks good following a stop and restart of the 
backend and mythfilldatabase.

There were two sets of data, interestingly one of the table fields was  last_record which told me which of my channels had been 
recording.  Running "select *  from channel order by name;" the ones that had recorded all had Null mplexid's and serviceid's of 0 
which presumably might have something to do with how they reduced multirec to unirec tuning!

Essentially I ran

Mythweb:  Add x identifiers into the "name" rows to be deleted - once others updated and noted corrected
Mythweb:  Cut n paste the xmltvid's into mythweb and saved.  (In hindisght it would probably have been quicker to write out some sql 
updates e.g. update channel set xmltvid='tv1.freeviewnz.tv' where channum=1; and paste them en masse)

update channel set tvformat='Default' where tvformat='';

update channel set icon='/home/mythtv/.mythtv/channels/tv_one.jpg' where name='TV One';
update channel set icon='/home/mythtv/.mythtv/channels/tv_2.jpg' where name='TV2';
update channel set icon='/home/mythtv/.mythtv/channels/tv_3.jpg' where name='TV3';
update channel set icon='/home/mythtv/.mythtv/channels/logo-opg-c4-red.png' where name='C4';
update channel set icon='/home/mythtv/.mythtv/channels/maori_tv.jpg' where name='Maori Television';
update channel set icon='/home/mythtv/.mythtv/channels/tvnz_6.jpg' where name='TVNZ 6';
update channel set icon='/home/mythtv/.mythtv/channels/tvnz_7.jpg' where name='TVNZ 7';
update channel set icon='/home/mythtv/.mythtv/channels/freeview_3plus1_logo_107x35.jpg' where name='TV3 PLUS1';
update channel set icon='/home/mythtv/.mythtv/channels/Prime_TV_107x35.jpg' where name='PRIME';
update channel set icon='/home/mythtv/.mythtv/channels/parliament.jpg' where name='Parliament TV';
update channel set icon='/home/mythtv/.mythtv/channels/radio_nz_national.jpg' where name='Radio NZ National';
update channel set icon='/home/mythtv/.mythtv/channels/radio_nz_concert.jpg' where name='Radio NZ Concert';

Following cutting and pasting each sql command into putty I tested pasting multiple rows - which of course processes all n-1 
lines....   I suppose a .sh file could be written to just do all this....but so far thats outside my abilities....

update channel set icon='/home/mythtv/.mythtv/channels/chinese.jpg' where name='ChineseTV';     CUSTOM ICON ADDED
update channel set icon='/home/mythtv/.mythtv/channels/base.jpg' where name='BaseFM';             CUSTOM ICON ADDED
update channel set icon='/home/mythtv/.mythtv/channels/freeview.jpg' where name='Freeview | HD';    CUSTOM ICON ADDED
update channel set icon='/home/mythtv/.mythtv/channels/central.jpg' where name='tvCentral';    ADDED AND DELETED(!)

update channel set icon='/home/mythtv/.mythtv/channels/test.jpg' where name='Test Channel';    ADDDED AND DELETED CHANNEL  (!)

update channel set chanid='1008' where name='1009';  FAILS - presumably 1008 is the index field.

INSERT INTO `channel` VALUES (1008,'8','50',1,'TV3 PLUS1','TV3 
PLUS1','/home/mythtv/.mythtv/channels/freeview_3plus1_logo_107x35.jpg',0,'','tv3-plus1.freeviewnz.tv',-1,32768,32768,32768,32768,'Default',1,'',1,2,1302,0,0,0,'2010-02-01 
21:30:02','crid://tv3.co.nz',-1);

update channel set name='TV3 PLUS 1x ' where chanid='1009';

select *  from channel order by name;

correct recpriority:
update channel set recpriority=0 where chanid='1008';

Select channels to show and hide etc via Mythweb
Delete duplicate "x" rows and irrelevant rows via mythweb settings.

select chanid,channum,freqid,sourceid,callsign,name,icon,xmltvid,mplexid,serviceid,last_record from channel order by chanid;

sudo stop mythtv-backend
sudo start mythtv-backend

mythfilldatabase

Good to go!

HTH someone else!