[mythtv-users] Batch editing inetref

[Peter Bennett]

On 6/7/19 3:56 PM, Ian Evans wrote:
> On Fri, Jun 7, 2019, 3:50 PM Jay Harbeston, <jharbestonus at gmail.com 
> <mailto:jharbestonus at gmail.com>> wrote:
>
>
>
>     > On Jun 7, 2019, at 3:45 PM, Ian Evans <dheianevans at gmail.com
>     <mailto:dheianevans at gmail.com>> wrote:
>     >
>     (snip)
>     > I've fixed it going forward by making sure the recording rule
>     has the inetref in it, but I'm wondering what the fastest/safest
>     way is to change the inetref in the older recordings. I could
>     manually do it, but this is Law & Order...there's a lot.
>
>     I have had it happen as well, and haven’t found a fix for it either.
>
>
> I mean it could be done in MySQL, but want to make sure which tables 
> need to be involved.
>
>

The "recorded" table has the season and episode, as well as inetref. If 
you get the correct inetref in the recording rule as well as the 
"recorded" table for episodes, the artwork will be fixed. For season and 
episode info you could try running the metadata lookup again on the 
episodes after the inetref is set up.

Suggestion - use the json version of Schedules direct - that gets season 
and episode information from SD and sets it correctly in the recorded table.

Peter
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20190607/34460833/attachment.html>