[mythtv-users] Mythfilldatabase Error

[SoVeryWrong]

What I did to fix it was just add a little bit of code before the
querystring was created.

Essentially I check to see if (*i).startts or (*i).endts are empty
strings.  If so I set another set of QStrings (starttime, and endtime)
to NULL, otherwise I set them to the value in quotes.  Then I use those
between the commas in the SQL string.  It seems to work perfectly so
far.

--Eric

-----Original Message-----
From: mythtv-users-bounces at snowman.net
[mailto:mythtv-users-bounces at snowman.net] On Behalf Of Chris Black
Sent: Sunday, February 16, 2003 5:42 PM
To: Discussion about mythtv
Subject: [mythtv-users] Mythfilldatabase Error

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??


Thanks,
Cj B

_______________________________________________
mythtv-users mailing list
mythtv-users at snowman.net
http://www.snowman.net/mailman/listinfo/mythtv-users