[mythtv-users] channel id change to mysql

Kevin Kuphal kkuphal at gmail.com
Tue Mar 10 21:27:17 UTC 2009


On Tue, Mar 10, 2009 at 4:19 PM, Ismo Tanskanen <ismot at telemail.fi> wrote:

> Hi,
>
> I had to change few channel id:s to channel-table.
> Ifter that I (of cource) noticed that recorded programs does not show
> channel sign right in "watch recordings".
>
> Now I want to change recordings chanid to match new one
>
> I execute this sql query:
>
> UPDATE
>
> record,record_tmp,recordedcredits,recordedfile,recordedprogram,recordedseek,recordmatch,recordedmarkup,recorded,oldrecorded
> SET chanid=1004 WHERE chanid=1504
>
> And get:
> Error Code : 1052
> Column 'chanid' in field list is ambiguous
> (0 ms taken)


Have you tried making the WHERE clause chanid explicit like:

WHERE record.chanid = 1504?

I think SQL needs to know which chanid to key off of.

Kevin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20090310/293d968e/attachment.htm>


More information about the mythtv-users mailing list