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

David Shay david at shay.net
Sun Apr 18 00:50:12 EDT 2004

On Sunday 18 April 2004 12:40 am, Jared Luxenberg wrote:
> 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

Probably a mysql version difference.  What version are you using?  If that 
syntax (UNIQUE) is more downwardly compatible, I will change the code to use 
it instead.

More information about the mythtv-dev mailing list