[mythtv-users] [mythtv] Database design documentation?
stan
stanb at panix.com
Sun Jan 14 14:17:47 UTC 2007
On Fri, Dec 29, 2006 at 03:46:23PM +1100, Nigel Pearson wrote:
> >>I think this change:
> >>
> >>http://cvs.mythtv.org/trac/browser/trunk/mythtv/libs/libmythtv/
> >>dbcheck.cpp#L2412
> >>
> >>was probably the one you are wrestling with.
> >>Doing mythcommflag --rebuild should recreate
> >>the recordedmarkup values that were deleted.
> >
> >Indeed, running that command seems to have solved the problem,
> >howeer, the
> >link did not lead me to anything but the top of the CVS tree
>
> You need the bits that wrapped over to the next line.
> File dbcheck.cpp, line 2412.
>
>
> >Mind giving me a short synopsis of what this change was?
>
> Sure. Database schema change 1153 created a new table
> called "recordedseek" and moved all the seek data from
> the table "recordedmarkup" to the new table.
> This was basically a performance improvement.
>
> Your frontend only knows to look in the old table,
> hence anything to do with the length of, or seeking
> through the recording, was broken.
>
>
> Here is the code changeset:
> http://cvs.mythtv.org/trac/changeset/10536
>
> and here is the change ticket:
>
>
Good news.
A simple "insert into recordedseek select * from recordedmarkup;" seems to
have fixed this problem!
Thanks for the help on this!
--
Unix is very simple, but it takes a genius to understand the simplicity.
(Dennis Ritchie)
More information about the mythtv-users
mailing list