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/
_______________________________________________ mythtv-dev mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
