[mythtv] [PATCH] Internal DataDirect grabberfunctionality REVISEDVERSION USE THIS ONE!

[John Patrick Poet]

David, thanks for taking the time to add this DataDirect functionality
to Myth.

I have spent some time trying to get this to work via the latest CVS.

Like Jared, I was getting a "All parts of a PRIMARY KEY must be NOT
NULL" error, but in my case it was for the programgenres table.  Using
Jared's example, I was able to get by this error by doing:

CREATE TABLE programgenres (chanid int unsigned NOT NULL, starttime 
timestamp NOT NULL, relevance char(1) NOT NULL,  genre char(30), PRIMARY

KEY (chanid, starttime, relevance) );

Unfortunately, I am also getting another error, which I have not been
able to figure out.  It has been about 7 years since I did anything with
SQL, and I have no idea what is wrong with this:

=======================================================================
Main temp tables populated.  Updating myth channels...
DB Error (Updating channel table):
Query was:
UPDATE channel,dd_v_station SET channel.callsign = dd_v_station.callsign

, channel.name = dd_v_station.stationname WHERE ( (channel.xmltvid = 
dd_v_station.stationid) AND (channel.sourceid = "1"));
Driver error was [2/1064]:
QMYSQL3: Unable to execute query
Database error was:
You have an error in your SQL syntax near 'dd_v_station SET 
channel.callsign = dd_v_station.callsign , channel.name = dd_v_' at line
1

=======================================================================

I get this message when mythfilldatabase tries to run.

This is with version 3.23.58 of mysql.

Does this make sense to anyone?

John