[mythtv] [PATCH] Internal DataDirect
grabberfunctionality REVISEDVERSION USE THIS ONE!
John Patrick Poet
john at BlueSkyTours.com
Mon Apr 19 00:13:06 EDT 2004
David, thanks for taking the time to add this DataDirect functionality
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):
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
I get this message when mythfilldatabase tries to run.
This is with version 3.23.58 of mysql.
Does this make sense to anyone?
More information about the mythtv-dev