[mythtv-users] problems with zap2it

[Ian Truelsen]

I think this is the proper solution to the problem.. I have worked on it a
little bit.  I just edited the code in finddata.cpp and changed the string
to pipe the output from tv_grab_na to tv_sort before outputting it.  I did
run into the same problem again, even after piping it to sort, because the
default action for the mythfilldatabase is to just grab one day's worth of
listings.  I also changed it to grab 2 days worth and then pipe it to
tv_sort which then properly adds the end times onto the data.  This does add
a little overhead by downloading two days worth of listings, and the program
also generates errors when it comes around to inserting the same entry the
next time through, but despite the error messages, the data gets inserted
properly.  As mentioned below, another script or something that would chop
off the extra data after the sort has done his job would fix up the errors,
but I think i'll just live with them..

Dave Madsen

----- Original Message -----
From: "Cliff Draper" <Cliff.Draper at sun.com>
To: <mythtv-users at snowman.net>
Sent: Sunday, February 16, 2003 4:25 PM
Subject: Re: [mythtv-users] Mythfilldatabase Error


> From: Chris Black <black at comet.n-polk.k12.ia.us>
> Date: 16 Feb 2003 16:41:40 -0600
> > When I run mythfilldatabase, I get this error:
> >
> > DB ERror: Program insertion failed, SQL query was:
> > INSERT INTO program
(chanid,starttime,endtime,title,subtitle,description,category) VALUES(1009,
20030223230000, , "The X-Files", "Release", "An FBI trainee connects recent
murders to the killing of Doggett's son many years ago.", "Drama")
> >
> > I've changed the filldata.cpp that was suggested by Neil McCurdy, but
that doesn't seem to change anything. However when I change the insert to:
> > INSERT INTO program
(chanid,starttime,endtime,title,subtitle,description,category) VALUES(1009,
20030223230000, "", "The X-Files", "Release", "An FBI trainee connects
recent murders to the killing of Doggett's son many years ago.", "Drama")
> > ^^
> > Everything seems to work fine. Is there a way to get mythfilldatabase to
add those two quotes??
>
> I don't think you want to add the two quotes.  It's trying to insert
> an endtime into the database.  The endtime of "" is invalid.  This
> always happens for shows around midnight and it's due to zap2it now
> leaving out the endtime info for shows at the end of the day.
>
> My understanding is that the tv_sort program will automatically put
> that data into the XML.  Without having tried this yet, we need to run
> `tv_grab_xx | tv_sort` and then pass that data into mythfilldatabase.
> I know in the settings file, you can specify what program to run.  You
> can probably put in the name of a script that runs the right stuff....
>
> Cliff Draper    Sun Microsystems, Forte Tools
> My opinions may or may not reflect those of my employer.
> ---------------------------- food for thought ---------------------------
> "Don't get suckered in by the comments -- they can be terribly
> misleading.  Debug only code."                -- Dave Storer
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at snowman.net
> http://www.snowman.net/mailman/listinfo/mythtv-users
>