[mythtv] [PATCH] Internal DataDirect grabber functionality REVISEDVERSION USE THIS ONE!

[Jared Luxenberg]

Hmm, I recompiled and re-ran setup, and after I put in my DataDirect info
and clicked Finish, I got this in the console window:

DB Error (error creating temporary table):
Query was:
CREATE TEMPORARY TABLE IF NOT EXISTS dd_program ( programid char(12),
seriesid
char(12), title varchar(120), subtitle varchar(150), programdescription
varchar(255), mpaarating char(5), starrating char(5), runtime time, year
char(4), showtype char(30), colorcode char(20), originalairdate date,
syndicatedepisodenumber char(20), stars float unsigned, PRIMARY KEY
(programid));
Driver error was [2/1171]:
QMYSQL3: Unable to execute query
Database error was:
All parts of a PRIMARY KEY must be NOT NULL;  If you need NULL in a key, use
UNIQUE instead

DB Error (error truncating temporary table):
Query was:
TRUNCATE TABLE dd_program;
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.dd_program' doesn't exist

Any ideas why?

- Jared

-----Original Message-----
From: mythtv-dev-bounces at mythtv.org
[mailto:mythtv-dev-bounces at mythtv.org]On Behalf Of David Shay
Sent: Saturday, April 17, 2004 10:43 PM
To: Development of mythtv
Subject: [mythtv] [PATCH] Internal DataDirect grabber functionality
REVISEDVERSION USE THIS ONE!


On Saturday 17 April 2004 05:19 pm, David Shay wrote:
> Here's the patch.  Please try it out and let me know if there are issues.
> A couple of key points:

Well, I accidentally generated the patch from the wrong place.  Here's the
(hopefully) correct patch.  Same as before, patch to existing files +
datadirect.h & datadirect.cpp go in libs/libmyth
mythtv_grab_dd goes in programs/mythfilldatbase.  mythtv_grab_dd needs to be
chmod 755.