[mythtv] Can't use MythTV after svn Help

[Isaac Richards]

On Saturday 05 November 2005 08:30 pm, Bruce Markey wrote:
> Isaac Richards wrote:
> > On Saturday 05 November 2005 06:14 pm, Bruce Markey wrote:
> >> Steve & Laurie Sanders wrote:
> >>> 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.
> >>
> >> Run the command:
> >>
> >> $ mysql -u mythtv -pmythtv mythconverg
> >>
> >> mysql> UPDATE recorded SET basename = CONCAT(chanid, '_',
> >>     -> DATE_FORMAT(starttime, '%Y%m%d%H%i00'), '_',
> >>     -> DATE_FORMAT(endtime, '%Y%m%d%H%i00'), '.nuv')
> >>     -> WHERE basename = '';
> >>
> >> Cut'n'paste the parts after the "> " of the "mysql> " prompt.
> >
> > Should we just do this at every backend start?
>
> I don't know if that is really necessary. If there is a impromptu
> vote, I'll say 'no' ;-).

Well, unless/until someone can figure out why the database update isn't 
working..

Isaac