I ran into the same problem after viewing live tv when my guide data was incomplete. I fixed it by deleting the record in the recorded table where the title was null (empty string). I don't know if there were any records linked to this entry but it had a primary key of something like 4294967295 which I assume is invalid anyway. Deleting this record removed it from the watch recordings list.<br>
<br>
<div><span class="gmail_quote">On 4/25/08, <b class="gmail_sendername">Bob Sully</b> <<a href="mailto:rcs@malibyte.net">rcs@malibyte.net</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Hi -<br><br>I have an index entry in my database that I can't get rid of. It occurred<br>the other night when I was watching live TV, when one of the tuners<br>
couldn't seem to get a lock on a channel. A "2 minute", 126MB file was<br>generated with the index entry _NO_TITLE_. It did not expire, so I tried<br>to delete it manually - the data file on disk went away but the index<br>
entry didn't and trying to delete it both from mythfrontend and from<br>mythweb did not work. Not only is it still in the list of recordings (on<br>my main Mythbox, a BE/FE) but there's an annoying pause while the frontend<br>
looks for the data file that it's supposed to point to.<br><br>Stranger still - if I fire up mythfrontend on my FE-only machine upstairs,<br>the entry isn't there.<br><br>Running optimize_mythdb.pl did not fix it.<br>
<br>I did a Google search on this and found the following in a post on the dev<br>list (25 Jan '08):<br><br><br>"Log:<br><br>If the title of a recording is empty (ie, ""), then set the displayed title<br>
to _NO_TITLE_ on the Watch Recordings screen. The title is used as a key<br>in several QMaps in PlaybackBox, and an empty string is used as a special<br>case for All Programs, so this was masking recordings with empty titles.<br>
There normally should not be recordings with empty titles, but just in case<br>there is bad data from a grabber or data provider, this mod will let the<br>user see the recordings so they can be edited or deleted."<br>
<br>However, I couldn't find any info on how to get rid of it. Further,<br>there's another post on the dev list from March that contains this:<br><br>"As far as the _NO_TITLE_ is concerned, I'll need to investigate at what<br>
time this happens, but another thing its not (or does not seem to be)<br>possible to delete the _NO_TITLE_ entry using the Delete option."<br><br><br>Does anyone have any new info as to how to clean out this entry? I<br>
suspect it will require a bit of MySQL surgery but only want to do this if<br>there's no other way.<br><br>Thanks<br>Bob<br><br>--<br>________________________________________<br>Bob Sully - Simi Valley, California, USA<br>
<a href="http://www.malibyte.net">http://www.malibyte.net</a><br><a href="http://www.malibyte.com">http://www.malibyte.com</a><br><br>_______________________________________________<br>mythtv-users mailing list<br><a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
<a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br></blockquote></div><br>