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

[John Patrick Poet]

On Mon, 19 Apr 2004, Isaac Richards wrote:

> On Monday 19 April 2004 12:13 am, John Patrick Poet wrote:
> > 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:
>
> Fixed this in CVS.
>
> > 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:
>
> It's another mysql 4.x vs 3.x thing.  3.x doesn't do multi-table updates.
> Anyone want to rewrite that statement?  It _shouldn't_ prevent things from
> working, though.
>
> Isaac

I can upgrade to mysql 4 easy enough.  Just didn't realize there was a need.

Thanks,

John