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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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
_______________________________________________ mythtv-dev mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
