[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