[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