[mythtv-users] Recent schema update

[Marc Tousignant]

> -----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.