[mythtv-users] a recording is present in mythweb byt not under "watch recordings" of the frontend

[Michael T. Dean]

  On 09/10/2010 04:23 PM, Stefano Pucillo wrote:
> On 10 September 2010 22:00, Michael T. Dean wrote:
>>   On 09/10/2010 02:40 PM, Stefano Pucillo wrote:
>>> it's not this case, I don't have any filter and it's not a new recording,
>>> in mythweb I have two recording "REGENESIS" and "REGENESIS" (same names) the
>>> first with all episodes but one, and the second with the missing episode.
>>> Instead in the frontend interface, I ahve two "REGENESIS" both with all
>>> episodes but one.
>>>
>>> Do you have any idea about the cause?
>> Can you please sent the output of:
...
> I attached the file created with command you suggested. I checked the txt
> file and it contains all recordings, also the one I cannot see in "watch
> recordings".

Thanks.  That's exactly what we needed.  Chris Pinkham should have a 
real fix in MythTV soon enough.  Until then, this will fix the issue for 
you:

cat<< "EOF" | mysql -umythtv -p mythconverg
UPDATE recorded SET title = 'REGENESIS'
  WHERE title = 'REGENESIS ';
EOF

Note that there's a space after "REGENESIS" in the WHERE clause.  Once 
that's done, re-enter the Watch Recordings screen, and all should be there.

Mike