[mythtv-users] Mythfilldatabase Error

[SoVeryWrong]

Without digging through the code, I was wondering if mythfilldatabase
goes back to update entries based on the program id?  Or does it just do
a whole bunch of INSERTS and if the data is crap, oh well?  

Do those programs at the end of the day just get thrown out?

--Eric

-----Original Message-----
From: mythtv-users-bounces at snowman.net
[mailto:mythtv-users-bounces at snowman.net] On Behalf Of Cliff Draper
Sent: Sunday, February 16, 2003 6:25 PM
To: mythtv-users at snowman.net
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