[mythtv-users] My mythweb shows me only new, mythfrontend only old recordings :-(

[Christoph Paul]

Am 10.04.2011 um 18:12 schrieb Christoph Paul:
> Am 10.04.2011 um 17:16 schrieb Kenni Lund:
>> 2011/4/10 Christoph Paul <chx at cvmx.net>:
>>> Am 10.04.2011 um 14:08 schrieb Michael T. Dean:
>>>> On 04/10/2011 05:46 AM, Christoph Paul wrote:
>>>>> Hi all,
>>>>> 
>>>>> since 7th of April, I see new recordings only on my mythweb and recordings up to this date only on the frontend.
>>>>> I see  +/- all files in the filesystem storage and +/- all entries in the mythconverg recorded table.
>>>>> Any ideas how to get things working again would be highly appreciated.
>> 
>> Using EIT? On around the same day - the 7th of April (depending on
>> timezone), a Danish DVB-C provider started sending invalid characters
>> ...
>> Try to check for NULL characters in your recorded table, something
>> like the following should do it:
>> SELECT chanid,starttime,title FROM recorded WHERE title LIKE '%\0%' OR
>> subtitle LIKE '%\0%' OR description LIKE '%\0%' LIMIT 10;
> Kenni, the select returned an empty set. So I also cleaned up all channels from the channel
> or program table, that I set invisible - but no luck :-(
Yesterday I restored my database to a date before the 7th and voila - everything fine again!
So I re-inserted the missing recorded lines: Strange behavior again!
Did that two times, as I first did not trust my eyes. Then I remembered your post ...

There are about 50 lines. At least one seems to trigger this behavior.
So maybe it is not the \0 but something similar!

Never thought of such strangeness, so many thanks for the tip!

Best regards, Christoph