[mythtv-users] recordid not being set in recorded table in Myth v32

[John Pilkington]

Resending to list

On 10/05/2022 11:08, Dave Pearson (Lists) wrote:
> 
> 
>     -----Original message-----
>     *From:* John Pilkington <johnpilk222 at gmail.com>
>     *Sent:* Tuesday 10th May 2022 9:55
>     *To:* Dave Pearson (Lists) <lists at the-pearsons.co.uk>
>     *Subject:* Re: [mythtv-users] recordid not being set in recorded
>     table in Myth v32
> 
>     On 10/05/2022 08:55, Dave Pearson (Lists) wrote:
>     > Hi,
>     > 
>     > 
>     > Since I upgraded to mythtv V32 as a result of upgrading to Ubuntu 22.04, 
>     > I have discovered that the recordid field is not being set in the 
>     > recorded table. This is a problem for me because I use mythpodcaster to 
>     > create podcasts of some recorded radio shows that I can then transfer to 
>     > my iPhone and listen to when I'm out and about.
>     > 
>     > 
>     > Can anyone think of a reason why this is happening (is it by design) or, 
>     > better yet, how I can fix it without manually updating the records for 
>     > the affected recordings?
>     > 
>     > 
>     > Regards,
>     > 
>     > Dave.
> 
>     I haven't used recordid, but the wiki says that it 'references
>     record(recordedid)'
> 
>     I do use recordedid, which is now available after two 'info' keystrokes
>     from the 'Show Recordings' screen.  I use a modified theme that shows it
>     by default.
> 
>     https://github.com/MythTV/mythtv/issues/464
> 
>     John P
> 
> 
> Hi John,
> 
> 
> Thanks for your Input, but recordedid is a different value to recordid:
> 
> mysql> select title, starttime, recordid, recordedid from recorded where 
> recordid = 0 order by starttime asc;
> 
> +---------------------------+---------------------+----------+------------+
> 
> | title                     | starttime           | recordid | recordedid |
> 
> +---------------------------+---------------------+----------+------------+
> 
> | Top Gear                  | 2022-05-09 07:00:00 |        0 |      31108 |
> 
> | This Week's Magic Singles | 2022-05-09 19:55:33 |        0 |      31110 |
> 
> | Non-Stop Magic Hits       | 2022-05-10 05:03:20 |        0 |      31114 |
> 
> | Non-Stop Magic Hits       | 2022-05-10 05:52:58 |        0 |      31116 |
> 
> +---------------------------+---------------------+----------+------------+
> 
> 4 rows in set (0.00 sec)
> 
> 
> 
> In my case, any new recordings seem to have a value of 0 for recordid, 
> the value for recordedid is OK. At the moment I'm updating the field 
> manually, so that my Mythodcaster process will work, but that's not ideal.
> 
> 
> Regards,
> .
> Dave.
> 
OK, here's mine in master.  el7 box, Server version: 5.5.68-MariaDB 
MariaDB Server  !!

Mostly I record single items via the EPG.  Radio recordings have been 
postprocessed to 'mp3' and deleted.

{{{

MariaDB [mythconverg]> select title, starttime, recordid, recordedid 
from recorded where recordedid > 37228 order by starttime asc;
+----------------------------------------+---------------------+----------+------------+
| title                                  | starttime           | 
recordid | recordedid |
+----------------------------------------+---------------------+----------+------------+
| First Britons                          | 2022-04-22 13:13:00 | 34273 | 
      37236 |
| Attenborough and the Mammoth Graveyard | 2022-05-02 18:58:00 | 34334 | 
      37300 |
| Lighthouses                            | 2022-05-06 19:58:00 | 34351 | 
      37324 |
| Spring                                 | 2022-05-07 08:28:00 | 34352 | 
      37326 |
+----------------------------------------+---------------------+----------+------------+

}}}

John