<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html>
<head>
<meta name="Generator" content="Kopano WebApp v-5.0.0.223+1986.1">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>RE: [mythtv-users] recordid not being set in recorded table in Myth v32</title>
</head>
<body>
<p style="padding: 0; margin: 0; min-height: 11pt; font-family: arial,helvetica,sans-serif; font-size: 11pt;"><br /></p>
<p style="padding: 0; margin: 0; min-height: 11pt; font-family: arial,helvetica,sans-serif; font-size: 11pt;"><br /></p>
<blockquote style="border-left-width: 2px; border-left-style: solid; border-left-color: #325fba; padding-left: 5px; margin: 0px 5px 1em;"><span style="font-family: tahoma,arial,helvetica,sans-serif; font-size: 10pt;">-----Original message-----<br /><span><strong>From:</strong> Peter Bennett <pb.mythtv@gmail.com></span><br /><span><strong>Sent:</strong> Tuesday 10th May 2022 15:15</span><br /><span><strong>To:</strong> mythtv-users@mythtv.org</span><br /><span><strong>Subject:</strong> Re: [mythtv-users] recordid not being set in recorded table in Myth v32</span><br /><br /></span>
<div>
<pre style="white-space: pre-wrap; word-wrap: break-word;"><br />On 5/10/22 08:24, John Pilkington wrote:<br />> On 10/05/2022 12:58, John Pilkington wrote:<br />><br />>>><br />>> OK, here's mine in master. el7 box, Server version: 5.5.68-MariaDB <br />>> MariaDB Server !!<br />><br />> I just tried it on the fedora 34 box, MariaDB 10.5.15. The results <br />> were similar to those below, with both recordid and recordedid having <br />> numerical values increasing with date.<br />>><br />>> Mostly I record single items via the EPG. Radio recordings have been <br />>> postprocessed to 'mp3' and deleted.<br />>><br />>> {{{<br />>><br />>> MariaDB [mythconverg]> select title, starttime, recordid, recordedid <br />>> from recorded where recordedid > 37228 order by starttime asc;<br />>> +----------------------------------------+---------------------+----------+------------+ <br />>><br />>> | title | starttime | <br />>> recordid | recordedid |<br />>> +----------------------------------------+---------------------+----------+------------+ <br />>><br />>> | First Britons | 2022-04-22 13:13:00 | <br />>> 34273 | 37236 |<br />>> | Attenborough and the Mammoth Graveyard | 2022-05-02 18:58:00 | <br />>> 34334 | 37300 |<br />>> | Lighthouses | 2022-05-06 19:58:00 | <br />>> 34351 | 37324 |<br />>> | Spring | 2022-05-07 08:28:00 | <br />>> 34352 | 37326 |<br />>> +----------------------------------------+---------------------+----------+------------+ <br />>><br />>><br />>> }}}<br />>><br />>> John<br />><br />><br />The recordid is required to associate the recording with a recording <br />rule. If it is zero that will affect the setting of metadata on the <br />recording and use of the frontend to update the recording rule from the <br />recording.<br /><br />There may be a few unusual cases where it is not set (e.g. recordings <br />from Live TV) but it should be set in all normal cases.<br /><br />There does not seem to be any change in the latest master. recordid is <br />still being set on tests I have done.<br /><br />Peter<br /><br />_______________________________________________<br />mythtv-users mailing list<br />mythtv-users@mythtv.org<br />http://lists.mythtv.org/mailman/listinfo/mythtv-users<br />http://wiki.mythtv.org/Mailing_List_etiquette<br />MythTV Forums: https://forum.mythtv.org</pre>
</div>
</blockquote>
<p style="padding: 0; margin: 0; "><br /></p>
<p style="padding: 0; margin: 0; "><span style="font-size: 11pt; font-family: arial, helvetica, sans-serif;">Hi Peter,<br /></span></p>
<p style="padding: 0; margin: 0; "><span style="font-size: 11pt; font-family: arial, helvetica, sans-serif;"><br /></span></p>
<p style="padding: 0; margin: 0; "><span style="font-size: 11pt; font-family: arial, helvetica, sans-serif;">Yes, setting up a new recording rule resulted in a recordid being set, so I should be able to fix my problem by deleting the existing rules and re-creating them</span></p>
<p style="padding: 0; margin: 0; "><span style="font-size: 11pt; font-family: arial, helvetica, sans-serif;"><br /></span></p>
<p style="padding: 0; margin: 0; "><span style="font-size: 11pt; font-family: arial, helvetica, sans-serif;">Thanks to everyone, John Pilkington, Stephen Worthington etc. for your input - as usual great support from this mailing list.</span></p>
<p style="padding: 0; margin: 0; "><span style="font-size: 11pt; font-family: arial, helvetica, sans-serif;"><br /></span></p>
<p style="padding: 0; margin: 0; "><span style="font-size: 11pt; font-family: arial, helvetica, sans-serif;">Regards,</span></p>
<p style="padding: 0; margin: 0; "><span style="font-size: 11pt; font-family: arial, helvetica, sans-serif;">Dave.</span></p>
<blockquote style="border-left-width: 2px; border-left-style: solid; border-left-color: #325fba; padding-left: 5px; margin: 1em 5px 0px;">
<div>
<pre style="white-space: pre-wrap; word-wrap: break-word;"><br /></pre>
</div>
</blockquote>
</body>
</html>