[mythtv-users] SQL Tables for recordings.

Mat Mrosko myth.mrosko at gmail.com
Thu May 19 18:13:07 UTC 2005


On 5/19/05, Michael T. Dean <mtdean at thirdcontact.com> wrote:
> >1249_340329428034823098420384_092384283048234820834.nuv.png" or
> OK.  I don't know if you're just making up filenames on your Myth box or
> for this e-mail, but the filename is important and the one you show is
> not of the correct format.  The filename should be:
> 
> SCCC_YYYYMMDDHHmmSS_YYYYMMDDHHmmSS.nuv

Yes, I was making up filenames for the purpose of this e-mail... I
didn't want to spend the time you did explaining it, to remember and
type one up.

> >Is there some other table that I need to get some data from for this
> >to work properly?
> >
> My recommendation is to start over.  Ideally, do the following as the
> mythtv user.  If you do the actions as any other user, make sure that
> your mythtv user owns all the files (and has appropriate permissions on
> them).  I'm making up a filename, but it's one of the appropriate format.

side note: I actually have a cron job that runs every 15 minutes that
will change ownership and permissions on all the files in the relevent
places...

> $ mv 1249_20050516195800_20050516210000.nuv MyShow
> $ touch 1249_20050516195800_20050516210000.nuv
> 
> $ mv MyShow 1249_20050516195800_20050516210000.nuv
> $ myth.rebuilddatabase.pl --dbhost=localhost

I've never used that rebuilddatabase.pl because I didn't know exactly
what it did.  I don't know where it gets the guide data from... does
the myth database actually keep ALL old stuff?  Some of these
recordings are from 3 or 4 weeks ago at least.

> (where myth.rebuilddatabase.pl is a script in the contrib directory of
> the source distribution of MythTV)  Type in the appropriate title,
> subtitle, and description for the show once the script finds it (if you
> had the right name before, the script may find the appropriate
> information automatically since you just deleted a recording with that
> info).

don't mind my last statement... I should have read this first!

> $ mythcommflag -f 1249_20050516195800_20050516210000.nuv
 
> Once mythcommflag completes its run, MythTV (directly or via MythWeb)
> will be able create the preview image.
> 
> Although this is probably similar to what you may have already done, the
> key points are:
>   a. make sure you start this process from a clean database (don't do
> any manual insertions and if you make a mistake or start down one path
> to find you were not using the right process, start over as described above)

Although you're right, it is similar, I did do manual insertions of
the data.   I didn't think that it would do anything screwey.

>   b. use the correct format for the filename (if you don't, the
> myth.rebuilddatabase.pl script will let you know)

Planned on it!

>   c. use the tools to do the work for you (they won't make mistakes).

Duh.... I should have realized I needed to work "smart" not "hard"...
somebody slap me!

> >P.S. If I don't get an answer within a couple of days, I'll probably
> >post this on the dev list!
> >
> No need.  This is not a bug in Myth.  It's bad data in your database.  :)

Right, but I figure people that pay closer attention to the dev list
might know the database schema a little better

Thank you very much Mike, I'll let you know how it goes!


More information about the mythtv-users mailing list