[mythtv] Can't use MythTV after svn Help

[George Nassas]

On 5-Nov-05, at 4:42 PM, Steve & Laurie Sanders wrote:

> You don't happen to have any ideas about my database
> seeming to be messed up do you? do you think the earlier version might 
> fix
> it? Or am I looking at starting over with a new database?

This query appeared when the problem first surfaced:

>> UPDATE recorded SET basename =
>>           CONCAT(chanid, '_', DATE_FORMAT(starttime,
>>                  '%Y%m%d%H%i00'), '_',
>>                  DATE_FORMAT(endtime, '%Y%m%d%H%i00'), '.nuv');

I would add a "WHERE basename IS NULL clause at the end to protect any 
new recordings you've created since the upgrade. Oh, it might have to 
be WHERE basename = '', I forget which worked for me but there seemed 
to be a difference.

- George