[mythtv] Can't use MythTV after svn Help

[Steve & Laurie Sanders]

George,

Sorry i guess i am a bit mysql illiterate. I have not a clue what to do with
this, or how I could repair my database with it, or even if my database is
even damaged to start with. mysql is greek to me and I don't understand how
mythtv uses it. I would like to learn if I could find someplace to start.

Steve

-----Original Message-----
From: mythtv-dev-bounces at mythtv.org
[mailto:mythtv-dev-bounces at mythtv.org]On Behalf Of George Nassas
Sent: Saturday, November 05, 2005 2:02 PM
To: Development of mythtv
Subject: Re: [mythtv] Can't use MythTV after svn Help


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