[mythtv-users] Database issue? Recordings not showing up in frontend

[Paul Stillwell]

I tried both of the commands below and they both returned the empty set. This happened after I ran find_orphans.py and tried to clean things up. I’m guessing that find_orphans.py did something to hose the db up (or at least to change some fields) so that the recordings don’t show up.

Paul

> On Sep 11, 2015, at 5:51 PM, Roger Siddons <dizygotheca at ntlworld.com> wrote:
> 
> On Fri, 11 Sep 2015 22:40:15 +0100, Paul Stillwell <bigboi at wackywombats.com <mailto:bigboi at wackywombats.com>> wrote:
> 
> Roger,
> 
> I saw the answer about issuing the “UPDATE recorded SET subtitle=REPLACE(subtitle, ‘\0’, ‘’);” sql command, but I want to make sure it will not mess things up further. I’m not a db guy, so I want to make sure not to do anything else to screw things up. If I do that command will it:
> 
> a. Potentially fix the problem
> b. Makes things worse and not fix the problem
> c. Do something, but not fix the problem and I’m no worse off than I am now
> 
> 
> You can check the hypothesis using:
> 
> $ mysql -p -u mythtv mythconverg
> Enter password:<yout mythtv mysql password>
> 
> mysql> SELECT title, subtitle FROM recorded WHERE CONCAT(title, subtitle, description) LIKE CONCAT("%", CHAR(0x00 using utf8), "%");
> 
> That will just report any recording that has null characters in it.
> 
> Similarly 
> 
> mysql> SELECT callsign FROM channel WHERE CONCAT(callsign, name) LIKE CONCAT("%", CHAR(0x00 using utf8), "%");
> 
> will report any corrupted channels.
> 
> However, it's puzzling why new recordings show up fine if that really is the cause.
> 
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org <mailto:mythtv-users at mythtv.org>
> http://lists.mythtv.org/mailman/listinfo/mythtv-users <http://lists.mythtv.org/mailman/listinfo/mythtv-users>
> http://wiki.mythtv.org/Mailing_List_etiquette <http://wiki.mythtv.org/Mailing_List_etiquette>
> MythTV Forums: https://forum.mythtv.org <https://forum.mythtv.org/>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20150911/32ae19f2/attachment.html>