[mythtv] Re: [mythtv-commits] Re: Ticket #602: Add ability to

[Wendy Seltzer]

On 11/23/05, Chris Pinkham <cpinkham at bc2va.org> wrote:
>
> I see the same here.  I think that section of code needs to be
> modified no matter what the MySQL version because we're
> duplicating the recordmatch schema when we shouldn't be (here
> and in dbquery).  My MySQL version is
> "mysql  Ver 11.18 Distrib 3.23.58".   My MySQL also barfed
> on the "drop temporary table" command, it doesn't like the word
> temporary in there.
>
> Here's what I did to get the code working on my system and it's
> futureproof if we ever add fields to recordmatch.


This patch works for me.

(mysqld  Ver 4.0.22-log had no problem with the "drop temporary table," but
seemed happy to drop the non-temp table when given that command, if the temp
table hadn't been created)

Thanks,
--Wendy

--
Wendy Seltzer
http://wendy.seltzer.org/blog/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-dev/attachments/20051123/6bb5841a/attachment.htm