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

Leo Kliger lkliger at bigpond.net.au
Sun Apr 9 10:26:50 UTC 2006


On Wed, 2006-04-05 at 23:35 -0400, Michael T. Dean wrote:
> On 04/05/2006 10:55 PM, Leo Kliger wrote:
> 
> >On Wed, 2006-04-05 at 21:08 -0400, Michael T. Dean wrote:
> >  
> >
> >>On 04/05/2006 08:19 PM, Leo Kliger wrote:
> >>
> >>>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!)
> >  
> >
> I would say the best approach is to upgrade to 0.19 (preferrably -fixes).
> 
> The only thing I can suggest if you really want 0.18 is to make a 
> backup, drop the database, start a new database from scratch, and 
> manually work through the important tables in the backup adjusting the 
> SQL statements as necessary to fit the old schema (a good text editor 
> should be able to fix multiple lines with one command--it's probably 
> easiest to copy the backup for each important table and delete the rest 
> so you have a backup script per table to adjust).  See 
> http://mythtv.org/docs/mythtv-HOWTO-23.html#ss23.7 for the important 
> tables.  (That won't bring over settings.  If you import settings, 
> you'll get some settings that aren't used and that may affect your 
> ability to upgrade later.  So, it may be easier to go through and 
> reconfigure the settings through mythtv-setup and mythfrontend's Settings)
> 
> Note that my inability to think of a better way doesn't mean there isn't 
> one.
> 
> Mike
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Hi All,

Thanks to all those who replied.

I upgraded to 0.19-fixes after a planned outage today and my database is
in sync once again. 
I have been running test recording all afternoon and the basename field
in the recorded tables is populating as expected.

My only new issue appears to be that my Program Guide doesn't line up
when displaying greater than 5 channels. I have tried various themes
with no difference.

Regards,

Leo 



More information about the mythtv-users mailing list