[mythtv-users] Scheduled Recordings Vanished

Michael T. Dean mtdean at thirdcontact.com
Tue Mar 7 04:34:04 UTC 2006


On 03/06/2006 11:04 PM, Michael Halcrow wrote:
> On Thu, Mar 02, 2006 at 11:01:18PM -0500, Michael T. Dean wrote:
>   
>> On 03/02/2006 08:45 PM, Michael Halcrow wrote:
>>     
>>> My Scheduled Records list mysteriously vanished earlier today. It
>>> restored itself after I manually ran mythfilldatabase (I am using
>>> Zap2It). I suspect that there was a glitch w/ Zap2It that wound up
>>> blowing away the lineup information in the local MythTV database
>>> on the update this morning. Some shows I wanted to record didn't
>>> get recorded. Anyone else ever have this issue?
>>>       
>> If your program listings disappeared, I'd guess you're using 0.18.x 
>> because 0.19 will not delete listings when no data is received.  If your 
>> program listings did not disappear and only your scheduled recordings 
>> did, I'd guess you're using 0.19 and MySQL 5.0 ( 
>> http://www.gossamer-threads.com/lists/mythtv/users/186471#186471 )
>>     
> So what's the recommended workaround for now?
>   

http://www.gossamer-threads.com/lists/mythtv/users/188320#188320

> If it involves downgrading to a prior version of MySQL, which version
> is recommended? If it's around version 4.0, what to do about
> CURRENT_TIMESTAMP, DEFAULT CHARSET, and so forth in the resulting
> mysqldump file that version 5.0 generates?
>   

Downgrading MySQL may not be a bad idea, though.  Unfortunately, I don't
know how to deal with the SQL.  Would the mysqldump argument
"--compatible=mysql323" break things?

Mike



More information about the mythtv-users mailing list