[mythtv-users] Recent schema update

[Mario Limonciello]

Yes, thats a little bit less then feasible to manually edit each file.
 I was figuring there would be some way to copy at minimum this
"basename" file information from somwhere else in the database.  I'll
probably have to experiment a little to figure this one.

On 10/4/05, Marc Tousignant <drayson at net1plus.com> wrote:
> > -----Original Message-----
> > From: mythtv-users-bounces at mythtv.org [mailto:mythtv-users-
> > bounces at mythtv.org] On Behalf Of Mario Limonciello
> > Sent: Tuesday, October 04, 2005 5:18 AM
> > To: Discussion about mythtv
> > Subject: [mythtv-users] Recent schema update
> >
> > I just updated to the latest SVN as of tonite, and haven't updated
> > probably for a month or so.
> >
> > A schema update seemed to be going through, and gave no issues.
> >
> > After the update, I tried to launch various recordings and they are all
> > broke.
> >
> > Any new recordings that go in after the schema update seem fine.
> >
> >
> > It seems that after this schema update, recordings from pvr series
> > cards are getting.mpg extensions instead and there is a new column in
> > the recorded table - "basename" for the name of this mpeg file.  Can
> > someone with some really handy SQL skills help with a script or simple
> > resolution to resolve this problem?  I have a good 177gb of recordings
> > that I would like to keep salvaged if possible.
> >
> > Thanks
> >
> > Mario
> > _______________________________________________
> > mythtv-users mailing list
> > mythtv-users at mythtv.org
> > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
> I had a similar problem a few weeks back. All my recordings from one week
> didn't want to play after the update I did on Saturday.
> I blame it on the fact that I updated, had problems with live tv bombing
> after 1 session, then downgraded so myth was usable, then updated again when
> the problem was fixed.
> Fix was simple, I edited the database directly with the file that match the
> channel, start, and end times. I guess it might not be feasible for some
> with a lot of recordings to do it like this.
>
>