[mythtv] [PATCH] MythWeb "record" table SQL error patch.

Colin Guthrie myth at colin.guthr.ie
Sat Nov 27 18:57:23 UTC 2004

Chris Petersen wrote:
> Could you tell me what the error is?  No one else that I know of has had 
> trouble with this code.

Sure. It was a fatal SQL error. I should have been more specific, but I
figured a quick look at the patch would be enough, as I think it's just
a field that was slapped into the SQL statement for testing/development,
but never moved to the "right" place in the code (i.e. a few lines above).

The "record" table was not joined on in the SQL statement, but a field
called record.recgroup was always included in the field selection part
of the SQL regardless of whether or not the record table was joined.

All this patch does is move the recgroup field selection into the place
where all the other record table fields are selected.

Looking at the code, I think this is where it should go.

I think the problem was highlighted because I don't have any of the TV
stuff setup in Myth at all.

Hope this helps.



|     Colin Guthrie      |
|   myth at colin.guthr.ie  |
| http://colin.guthr.ie/ |

More information about the mythtv-dev mailing list