[mythtv-users] Mythfilldatabase Error

[Cliff Draper]

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