[mythtv-users] Myth is now recording when I exit Live TV

[Mark Perkins]

> Output of first command...
> 
> 
> +------------+----------+-------------+---------+
> | recgroupid | recgroup | displayname | special |
> +------------+----------+-------------+---------+
> |          1 | Default  |             |       1 |
> |          3 | LiveTV   |             |       1 |
> |          5 | Deleted  |             |       1 |
> |          7 | Other    | Other       |       0 |
> |          9 | AO       | AO          |       0 |
> |         11 | Movies   | Movies      |       0 |
> +------------+----------+-------------+---------+
> 
> Second command yields no output.
> 
> 
> 
> 
> _______________________________________________

Ok. At this point I think you have two options:
1) Wait for someone to chime in who understands the detail of the recgroups
table and 0.28 and who can guide you on whether there is a problem in what
you have or what may have caused all your recgroupid's to be odd numbers -
and if there is a problem what the endorsed / sanctioned fix might be. There
could be deeper problems that this is just one symptom of.

2) Go with my gut feel that recgroupid's for Default, LiveTV and Deleted are
supposed to be numbered 1,2,3 respectively in the recgroups table (mine are,
sample size = 1) and undertake some direct fiddling to make it so. I am not
experienced in the mythtv database and I am genuine when I say it is gut
feel - I don't know for sure that mythtv cares which group is numbered what.
In my opinion this could be a bit more complicated than it otherwise seems
so approach with caution. I would not recommend you do this, instead wait
for someone suitably qualified to step in.

However if you decide to live dangerously you could try running the
following commands (after running a database backup / stopping the backend).
Please watch for lines that have been broken into pieces by mail clients:

First check what is in your database against recgroupid's 2,3,4,5.

Any results from this first command in my mind are currently errors as you
have no recgroupid=2 in the recgroups table. If you have results here don't
do the updates below without seeking input.
mysql -umythtv -p mythconverg -e "SELECT
chanid,starttime,title,subtitle,recgroup FROM recorded WHERE recgroupid=2"

Any results from this second command are LiveTV recordings. If they are not
updated when the recgroups table is updated they may be spontaneously
deleted on next system startup.
mysql -umythtv -p mythconverg -e "SELECT
chanid,starttime,title,subtitle,recgroup FROM recorded WHERE recgroupid=3"

Any results from this third command in my mind are currently errors as you
have no recgroupid=4 in the recgroups table. If you have results here don't
do the updates below without seeking input.
mysql -umythtv -p mythconverg -e "SELECT
chanid,starttime,title,subtitle,recgroup FROM recorded WHERE recgroupid=4"

Any results from this fourth command are available for deletion and should
be updated when the recgroups table is updated.
mysql -umythtv -p mythconverg -e "SELECT
chanid,starttime,title,subtitle,recgroup FROM recorded WHERE recgroupid=5"

Also some sanity checking rather than making assumptions. Any results from
these two commands would appear to be inconsistent (in my opinion) having a
recgroup that does not align with recgroupid. If you have any results from
these two commands stop and seek input on how to handle them for consistency
/ correctness:
mysql -umythtv -p mythconverg -e "SELECT
chanid,starttime,title,subtitle,recgroup,recgroupid FROM recorded WHERE
recgroup='LiveTV' and recgroupid!=3"
mysql -umythtv -p mythconverg -e "SELECT
chanid,starttime,title,subtitle,recgroup,recgroupid FROM recorded WHERE
recgroup='Deleted' and recgroupid!=5"

Otherwise make the updates. Please double check the commands for quoting, I
did make a mistake a few days ago and I haven't tested these commands. The
order to execute them in is important:
mysql -umythtv -p mythconverg -e "UPDATE recorded SET recgroupid=2 WHERE
recgroupid=3"
mysql -umythtv -p mythconverg -e "UPDATE recgroups SET recgroupid=2 WHERE
recgroupid=3"
mysql -umythtv -p mythconverg -e "UPDATE recorded SET recgroupid=3 WHERE
recgroupid=5"
mysql -umythtv -p mythconverg -e "UPDATE recgroups SET recgroupid=3 WHERE
recgroupid=5"

If all went well you should be able restart the backend and see if made any
improvement.