[mythtv-users] new recordings missing basename field in recorded table

Leo Kliger lkliger at bigpond.net.au
Thu Apr 6 02:55:23 UTC 2006


On Wed, 2006-04-05 at 21:08 -0400, Michael T. Dean wrote:
> On 04/05/2006 08:19 PM, Leo Kliger wrote:
> 
> >On Tue, 2006-04-04 at 22:28 +1000, Leo Kliger wrote:
> >  
> >
> >>All new recordings are missing the basename entry in the recorded table,
> >>
> >This according to the wiki means that I am running a 0.19 schema on an
> >0.18 backend.... how did this come about?
> >
> >The only thing that I can think of is that when I setup my second
> >frontend yum downloaded version 0.19. When it couldn't connect I
> >downgraded it to version 0.18 and everything was seemed fine. Except
> >that I increasingly couldn't use nuvexport on new recordings.
> >
> >Could this have caused my my problem?
> >  
> >
> I'll ignore the "Could this have?" question as its answer is apparent 
> from the answer to the question you're really trying to ask:  "Did 
> this?"  The answer to that question is, "Yes!"  :)
> 
> >If so, why? Why does a later frontend prompt a mysql schema upgrade?
> >  
> >
> Because a 0.19 frontend needs a 0.19 database.  A 0.19 backend needs a 
> 0.19 database.  Do you need more examples to see the pattern?  ;)
> 
I would have thought that the 0.19 frontend needs access to a 0.19
backend - rather than requiring an 0.19 database in thereof itself.

This behaviour is quite disappointing, especially since the symptoms are
so subtle that I have continued to run for several weeks before noticing
a problem.

> >Does anyone know how I can fix this?
> >
> How long ago did you upgrade and downgrade?  Just restore the backup (I 
> know you made a backup, right?) and import the new shows with 
> myth.rebuilddatabase.pl...
> 

Yes I do backup the database - but I only keep the dailies for seven
days:(
I didn't make a specific longterm backup prior to adding the frontend:(

What to do? (Rhetorical question as I now see the rock and the hard
place!)

Regards,

Leo




More information about the mythtv-users mailing list