[mythtv-users] Mythweb problem

Chris Petersen lists at forevermore.net
Tue Jan 17 20:59:29 UTC 2006


> Well, I think I figured out the reason for the message.
> As both program and oldrecorded has their own chanid the poor MySQL
> doesn't know which one to join the programrating to.
> 
> Now the question is: Why doesn't this happen to everyone?
> Is it my for a long tim updated/upgraded database?

ok, that certainly could be a mysql5 change...  I'll be poking at those 
joins tonight, anyway...  will make them explicit ON rather than USING, 
which should fix your problem, too.

-Chris


More information about the mythtv-users mailing list